日期 时间 异常信息 执行时间（ms） SQL 20200922 11:02:41 3 select * from xt_xtcs00 where name00='ZS_BRLBSFXSYSZ' 20200922 11:02:41 2 update XT_XTCS00 set VALUE0=:value where NAME00=:name 20200922 11:02:41 2 parameters :value= :name=ZS_BRLBSFXSYSZ 20200922 11:02:41 0 select BH0000 from BM_BMBM00 where BMBH00=:DeptId 20200922 11:02:41 0 parameters DeptId=26 20200922 11:02:41 2 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 '001202%' and b.bmxz00='0' and a.YSZZT0 in ('1','2') order by a.XSXH00,a.yszid0 20200922 11:02:43 283 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 20200922 11:02:43 9 select * from VW_ZS_WCJBL0 where yszid0=2 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35052119301127051X')a 20200922 11:02:43 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35052119301127051X' 20200922 11:02:43 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350322193502010056')a 20200922 11:02:43 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350322193502010056' 20200922 11:02:43 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='359002196208162518')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='359002196208162518' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013' 20200922 11:02:43 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194108293542')a 20200922 11:02:43 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194108293542' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522194706071024')a 20200922 11:02:43 8 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522194706071024' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195904036028')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195904036028' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195008253733')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195008253733' 20200922 11:02:43 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194806251016')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194806251016' 20200922 11:02:43 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35058319340521312X')a 20200922 11:02:43 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35058319340521312X' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194608303516')a 20200922 11:02:43 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194608303516' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194605151048')a 20200922 11:02:43 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194605151048' 20200922 11:02:43 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194703181537')a 20200922 11:02:43 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194703181537' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195605273520')a 20200922 11:02:43 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195605273520' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500197303306525')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500197303306525' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352626194707281122')a 20200922 11:02:43 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352626194707281122' 20200922 11:02:43 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352626194611251113')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352626194611251113' 20200922 11:02:43 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582193901192026')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582193901192026' 20200922 11:02:43 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196301300592')a 20200922 11:02:43 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196301300592' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195106163511')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195106163511' 20200922 11:02:43 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195409073513')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195409073513' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195610263511')a 20200922 11:02:43 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195610263511' 20200922 11:02:43 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582197207130552')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582197207130552' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352127195512210010')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352127195512210010' 20200922 11:02:43 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525194411261014')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525194411261014' 20200922 11:02:43 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522193902047035')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522193902047035' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350629460209451')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350629460209451' 20200922 11:02:43 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195102050514')a 20200922 11:02:43 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195102050514' 20200922 11:02:44 156 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 20200922 11:02:45 86 select * from VW_ZS_WCJBL0 where yszid0=1 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:45 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194004251022')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194004251022' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521197810211071')a 20200922 11:02:45 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521197810211071' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196912110536')a 20200922 11:02:45 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196912110536' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35050019730307201X')a 20200922 11:02:45 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35050019730307201X' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001301513')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001301513' 20200922 11:02:45 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196911013510')a 20200922 11:02:45 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196911013510' 20200922 11:02:45 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525197008206262')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525197008206262' 20200922 11:02:45 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350402194603120013')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350402194603120013' 20200922 11:02:45 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:45 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522510127201')a 20200922 11:02:45 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522510127201' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194808033020')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194808033020' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193507132020')a 20200922 11:02:45 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193507132020' 20200922 11:02:45 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='52262619680818084X')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='52262619680818084X' 20200922 11:02:45 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194102020017')a 20200922 11:02:45 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194102020017' 20200922 11:02:45 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521196901192553')a 20200922 11:02:45 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521196901192553' 20200922 11:02:46 26 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 20200922 11:02:46 12 select * from VW_ZS_WCJBL0 where yszid0=7 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:46 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195611191024')a 20200922 11:02:46 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195611191024' 20200922 11:02:46 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194704222032')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194704222032' 20200922 11:02:46 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194809202011')a 20200922 11:02:46 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194809202011' 20200922 11:02:46 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195111282069')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195111282069' 20200922 11:02:46 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196910151043')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196910151043' 20200922 11:02:46 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195701103805')a 20200922 11:02:46 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195701103805' 20200922 11:02:46 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521193706011039')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521193706011039' 20200922 11:02:46 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193810103521')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193810103521' 20200922 11:02:46 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350524196605081049')a 20200922 11:02:46 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350524196605081049' 20200922 11:02:46 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194306270018')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194306270018' 20200922 11:02:46 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352624194311251418')a 20200922 11:02:46 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352624194311251418' 20200922 11:02:46 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195202034517')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195202034517' 20200922 11:02:46 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195903075419')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195903075419' 20200922 11:02:46 86 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 20200922 11:02:46 12 select * from VW_ZS_WCJBL0 where yszid0=21 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:46 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194702143520')a 20200922 11:02:46 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194702143520' 20200922 11:02:46 2 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 20200922 11:02:46 9 select * from VW_ZS_WCJBL0 where yszid0=25 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:46 3 select * from xt_xtcs00 where name00='ZS_BRLBSFXSYSZ' 20200922 11:02:46 2 update XT_XTCS00 set VALUE0=:value where NAME00=:name 20200922 11:02:46 2 parameters :value= :name=ZS_BRLBSFXSYSZ 20200922 11:02:46 1 select BH0000 from BM_BMBM00 where BMBH00=:DeptId 20200922 11:02:46 1 parameters DeptId=26 20200922 11:02:46 3 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 '001202%' and b.bmxz00='0' and a.YSZZT0 in ('1','2') order by a.XSXH00,a.yszid0 20200922 11:02:49 437 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 20200922 11:02:49 8 select * from VW_ZS_WCJBL0 where yszid0=2 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:49 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35052119301127051X')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35052119301127051X' 20200922 11:02:49 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350322193502010056')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350322193502010056' 20200922 11:02:49 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='359002196208162518')a 20200922 11:02:49 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='359002196208162518' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194108293542')a 20200922 11:02:49 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194108293542' 20200922 11:02:49 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522194706071024')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522194706071024' 20200922 11:02:49 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195904036028')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195904036028' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195008253733')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195008253733' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194806251016')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194806251016' 20200922 11:02:49 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35058319340521312X')a 20200922 11:02:49 4 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35058319340521312X' 20200922 11:02:49 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194608303516')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194608303516' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194605151048')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194605151048' 20200922 11:02:49 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194703181537')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194703181537' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195605273520')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195605273520' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500197303306525')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500197303306525' 20200922 11:02:49 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352626194707281122')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352626194707281122' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352626194611251113')a 20200922 11:02:49 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352626194611251113' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582193901192026')a 20200922 11:02:49 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582193901192026' 20200922 11:02:49 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196301300592')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196301300592' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195106163511')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195106163511' 20200922 11:02:49 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195409073513')a 20200922 11:02:49 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195409073513' 20200922 11:02:49 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195610263511')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195610263511' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582197207130552')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582197207130552' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352127195512210010')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352127195512210010' 20200922 11:02:49 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525194411261014')a 20200922 11:02:49 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525194411261014' 20200922 11:02:49 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522193902047035')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522193902047035' 20200922 11:02:49 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350629460209451')a 20200922 11:02:49 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350629460209451' 20200922 11:02:49 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195102050514')a 20200922 11:02:49 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195102050514' 20200922 11:02:50 77 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 20200922 11:02:50 72 select * from VW_ZS_WCJBL0 where yszid0=1 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:50 5 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:50 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:50 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194004251022')a 20200922 11:02:50 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194004251022' 20200922 11:02:50 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521197810211071')a 20200922 11:02:50 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521197810211071' 20200922 11:02:50 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196912110536')a 20200922 11:02:50 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196912110536' 20200922 11:02:50 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35050019730307201X')a 20200922 11:02:50 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35050019730307201X' 20200922 11:02:50 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001301513')a 20200922 11:02:50 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001301513' 20200922 11:02:50 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196911013510')a 20200922 11:02:50 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196911013510' 20200922 11:02:50 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525197008206262')a 20200922 11:02:50 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525197008206262' 20200922 11:02:50 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350402194603120013')a 20200922 11:02:50 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350402194603120013' 20200922 11:02:50 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:50 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:50 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522510127201')a 20200922 11:02:50 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522510127201' 20200922 11:02:50 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194808033020')a 20200922 11:02:50 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194808033020' 20200922 11:02:50 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193507132020')a 20200922 11:02:50 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193507132020' 20200922 11:02:50 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='52262619680818084X')a 20200922 11:02:50 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='52262619680818084X' 20200922 11:02:50 8 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194102020017')a 20200922 11:02:50 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194102020017' 20200922 11:02:50 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521196901192553')a 20200922 11:02:50 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521196901192553' 20200922 11:02:51 976 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 20200922 11:02:51 9 select * from VW_ZS_WCJBL0 where yszid0=7 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:51 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195611191024')a 20200922 11:02:51 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195611191024' 20200922 11:02:51 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194704222032')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194704222032' 20200922 11:02:51 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194809202011')a 20200922 11:02:51 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194809202011' 20200922 11:02:51 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195111282069')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195111282069' 20200922 11:02:51 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196910151043')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196910151043' 20200922 11:02:51 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195701103805')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195701103805' 20200922 11:02:51 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521193706011039')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521193706011039' 20200922 11:02:51 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193810103521')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193810103521' 20200922 11:02:51 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350524196605081049')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350524196605081049' 20200922 11:02:51 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194306270018')a 20200922 11:02:51 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194306270018' 20200922 11:02:51 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352624194311251418')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352624194311251418' 20200922 11:02:51 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195202034517')a 20200922 11:02:51 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195202034517' 20200922 11:02:51 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195903075419')a 20200922 11:02:51 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195903075419' 20200922 11:02:51 85 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 20200922 11:02:52 9 select * from VW_ZS_WCJBL0 where yszid0=21 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:52 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194702143520')a 20200922 11:02:52 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194702143520' 20200922 11:02:52 4 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 20200922 11:02:52 9 select * from VW_ZS_WCJBL0 where yszid0=25 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:52 3 select * from xt_xtcs00 where name00='ZS_BRLBSFXSYSZ' 20200922 11:02:52 1 update XT_XTCS00 set VALUE0=:value where NAME00=:name 20200922 11:02:52 1 parameters :value= :name=ZS_BRLBSFXSYSZ 20200922 11:02:52 2 select BH0000 from BM_BMBM00 where BMBH00=:DeptId 20200922 11:02:52 2 parameters DeptId=26 20200922 11:02:52 4 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 '001202%' and b.bmxz00='0' and a.YSZZT0 in ('1','2') order by a.XSXH00,a.yszid0 20200922 11:02:54 257 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 20200922 11:02:54 8 select * from VW_ZS_WCJBL0 where yszid0=2 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35052119301127051X')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35052119301127051X' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350322193502010056')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350322193502010056' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='359002196208162518')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='359002196208162518' 20200922 11:02:54 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193801271013' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:54 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194108293542')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194108293542' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522194706071024')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522194706071024' 20200922 11:02:54 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195904036028')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195904036028' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195008253733')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195008253733' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194806251016')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194806251016' 20200922 11:02:54 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35058319340521312X')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35058319340521312X' 20200922 11:02:54 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194608303516')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194608303516' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194605151048')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194605151048' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194703181537')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194703181537' 20200922 11:02:54 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195605273520')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195605273520' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500197303306525')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500197303306525' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352626194707281122')a 20200922 11:02:54 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352626194707281122' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352626194611251113')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352626194611251113' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582193901192026')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582193901192026' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196301300592')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196301300592' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195106163511')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195106163511' 20200922 11:02:54 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195409073513')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195409073513' 20200922 11:02:54 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195610263511')a 20200922 11:02:54 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195610263511' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582197207130552')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582197207130552' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352127195512210010')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352127195512210010' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525194411261014')a 20200922 11:02:54 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525194411261014' 20200922 11:02:54 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522193902047035')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522193902047035' 20200922 11:02:54 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350629460209451')a 20200922 11:02:54 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350629460209451' 20200922 11:02:54 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195102050514')a 20200922 11:02:54 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195102050514' 20200922 11:02:55 100 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 20200922 11:02:55 73 select * from VW_ZS_WCJBL0 where yszid0=1 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:55 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:55 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:55 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194004251022')a 20200922 11:02:55 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194004251022' 20200922 11:02:55 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521197810211071')a 20200922 11:02:55 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521197810211071' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196912110536')a 20200922 11:02:56 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196912110536' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='35050019730307201X')a 20200922 11:02:56 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='35050019730307201X' 20200922 11:02:56 4 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001301513')a 20200922 11:02:56 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195001301513' 20200922 11:02:56 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500196911013510')a 20200922 11:02:56 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500196911013510' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350525197008206262')a 20200922 11:02:56 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350525197008206262' 20200922 11:02:56 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350402194603120013')a 20200922 11:02:56 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350402194603120013' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='')a 20200922 11:02:56 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350522510127201')a 20200922 11:02:56 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350522510127201' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194808033020')a 20200922 11:02:56 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194808033020' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193507132020')a 20200922 11:02:56 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193507132020' 20200922 11:02:56 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='52262619680818084X')a 20200922 11:02:56 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='52262619680818084X' 20200922 11:02:56 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194102020017')a 20200922 11:02:56 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194102020017' 20200922 11:02:56 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521196901192553')a 20200922 11:02:56 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521196901192553' 20200922 11:02:57 973 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 20200922 11:02:57 8 select * from VW_ZS_WCJBL0 where yszid0=7 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195611191024')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195611191024' 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194704222032')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194704222032' 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582194809202011')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582194809202011' 20200922 11:02:57 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582195111282069')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582195111282069' 20200922 11:02:57 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350582196910151043')a 20200922 11:02:57 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350582196910151043' 20200922 11:02:57 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195701103805')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195701103805' 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350521193706011039')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350521193706011039' 20200922 11:02:57 1 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500193810103521')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500193810103521' 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350524196605081049')a 20200922 11:02:57 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350524196605081049' 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194306270018')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194306270018' 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='352624194311251418')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='352624194311251418' 20200922 11:02:57 2 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500195202034517')a 20200922 11:02:57 2 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500195202034517' 20200922 11:02:57 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350583195903075419')a 20200922 11:02:57 3 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350583195903075419' 20200922 11:02:57 80 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 20200922 11:02:57 8 select * from VW_ZS_WCJBL0 where yszid0=21 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:57 3 select a.* ,rownum rn from (select * from BM_MZJZBR t where 1=1 and BRSFZH ='350500194702143520')a 20200922 11:02:57 1 select count(1) from BM_MZJZBR t where 1=1 and BRSFZH ='350500194702143520' 20200922 11:02:57 3 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 20200922 11:02:57 8 select * from VW_ZS_WCJBL0 where yszid0=25 and ( CYDJRQ is null) order by CYDJRQ,RYCWH0 20200922 11:02:57 4 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,JSKSBH,BRID00 FROM VW_HT_XTTSXX_DZBL a where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD') and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'V ')) or (XXXZ00 = '0' and xtdm00 = 'V ')) and (JSKSBH IS NULL OR instr(',' || jsksbh || ',', decode(fsdx00,'2',',537,','0',',26,')) > 0 ) and not exists (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 537 ) order by a.XH0000 desc