日期 时间 异常信息 执行时间（ms） SQL 20210302 11:06:39 0 select YYID00 from bm_bmbm00 where bmbh00 = 1067 20210302 11:06:40 0 select YYID00,YYQC00,YYJC00,XKZH00,FLAG00,YYDJ00,YYBZ20 from XT_YYXX00 where YYID00 ='228215' 20210302 11:06:40 1 select sq_xt_xtrz00_lsh000.nextval from dual 20210302 11:06:40 0 Select userenv('SESSIONID') PROCESS from dual where rownum=1 20210302 11:06:40 0 insert into Xt_xtrz00(lsh000,ygbh00,dljsj0,xtdm00,jcid00,dlrq00,dlsj00,bz0000,dlks00) values (?,?,?,?,?,?,?,?,?) 20210302 11:06:40 0 select mc0000 from bm_tyzd00 where zdmc00='门诊ftp地址' and bh0000='228215' 20210302 11:06:40 0 select SF_XT_GETDJBZBYBM(1067) from dual 20210302 11:06:40 16 SELECT t.* FROM pt_jhgnhb t,PT_JHGNPX s where t.jhgnid=s.jhgnid(+) and t.ssxtdm=s.ssxtdm(+) and (exists(select 1 from pt_jsygb0 b,pt_jsgnb0 c where t.jhgnid=c.jhgnid and trim(t.ssxtdm)=trim(c.ssxtdm) and b.jsid00=c.jsid00 and b.ygbh00= ? ) or t.SQSXS0='0' or exists(select 1 from pt_jsygb0 b,pt_jsb000 c where b.jsid00=c.jsid00 and b.ygbh00= ? and c.jslx00='1') or exists(select 1 from pt_yggngl b where t.jhgnid=b.jhgnid and trim(t.ssxtdm)=trim(b.ssxtdm) and b.ygbh00= ? ) ) and (trim(T.SSXTDM) =trim(?) or T.SSXTDM='PT') and T.GNLX00 = ? and T.SFYX00='1' order by decode(s.pxgnbm,null,t.gnbm00,s.pxgnbm),s.plxh00 20210302 11:06:40 84 SELECT t.* FROM pt_jhgnhb t,PT_JHGNPX s where t.jhgnid=s.jhgnid(+) and t.ssxtdm=s.ssxtdm(+) and (exists(select 1 from pt_jsygb0 b,pt_jsgnb0 c where t.jhgnid=c.jhgnid and trim(t.ssxtdm)=trim(c.ssxtdm) and b.jsid00=c.jsid00 and b.ygbh00= ? ) or t.SQSXS0='0' or exists(select 1 from pt_jsygb0 b,pt_jsb000 c where b.jsid00=c.jsid00 and b.ygbh00= ? and c.jslx00='1') or exists(select 1 from pt_yggngl b where t.jhgnid=b.jhgnid and trim(t.ssxtdm)=trim(b.ssxtdm) and b.ygbh00= ? ) ) and (trim(T.SSXTDM) =trim(?) or T.SSXTDM='PT') and T.GNLX00 = ? and T.SFYX00='1' order by decode(s.pxgnbm,null,t.gnbm00,s.pxgnbm),s.plxh00 20210302 11:06:41 15 Select INSTANCE_NAME from V$INSTANCE 20210302 11:06:41 0 select BRID00 displayname, to_char(BRID00) cmbvalue from SF_BRXXB0 where GHKS00 = 1067 and JZYS00 = 1111 and GHRQ00 = '20210302' and THBZ00 != '0' and GHLB00 != '-99999' 20210302 11:06:41 0 select BRID00 displayname, to_char(BRID00) cmbvalue from SF_BRXXB0 where JZKS00 = 1067 and JZYS00 = 1111 and JZRQ00 = '20210302' and THBZ00 != '0' and GHLB00 != '-99999' 20210302 11:06:42 0 select * from xt_xtcs00 where name00='YF_KYYFBMBH' 20210302 11:06:42 7 select BMMC00,YFBMBH,YPLBBH,SLBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where 1=1 order by mrbz00 desc,px0000 20210302 11:06:42 0 SELECT PCMC00,PCID00,PYSM00,WBSM00,SM0000,ZQCD00,ZQDW00,ZQCS00 from VW_BM_PC0000 Order By ORDER0,PCID00,PCMC00 20210302 11:06:42 0 SELECT *FROM BM_YPYF00 20210302 11:06:42 0 SELECT * FROM BM_YPLB00 20210302 11:06:42 0 select a.*,b.ypyfmc from ys_jyfs00 a,bm_ypyf00 b where a.cymryf=b.yfid00(+) order by a.bh0000 20210302 11:06:42 0 select CFSM00 displayname, to_char(BH0000) cmbvalue from ys_cfsm00 20210302 11:06:43 16 select MC0000 displayname, to_char(MC0000) cmbvalue from bm_tyzd00 where zdmc00 like '证件类型' 20210302 11:06:43 1 select CFSM00 displayname, to_char(BH0000) cmbvalue from ys_cfsm00 20210302 11:06:43 0 select MC0000 displayname, to_char(MC0000) cmbvalue from bm_tyzd00 where zdmc00 like '证件类型' 20210302 11:06:43 0 select CFSM00 displayname, to_char(BH0000) cmbvalue from ys_cfsm00 20210302 11:06:43 1 select CFSM00 displayname, to_char(BH0000) cmbvalue from ys_cfsm00 20210302 11:06:43 0 select CFSM00 displayname, to_char(BH0000) cmbvalue from ys_cfsm00 20210302 11:06:43 0 select MC0000 displayname, to_char(MC0000) cmbvalue from bm_tyzd00 where zdmc00 like '证件类型' 20210302 11:06:43 16 select BBMC00 displayname, to_char(BBID00) cmbvalue from bm_bbzd00 20210302 11:06:43 0 select mc0000 from bm_tyzd00 where zdmc00='PACS图文报告网址' and bh0000='228215' 20210302 11:06:43 16 select mc0000 from bm_tyzd00 where zdmc00='PACS图象浏览网址' and bh0000='228215' 20210302 11:06:43 16 select BBMC00 displayname, to_char(BBID00) cmbvalue from bm_bbzd00 20210302 11:06:43 0 select mc0000 from bm_tyzd00 where zdmc00='PACS图文报告网址' and bh0000='228215' 20210302 11:06:43 1 select mc0000 from bm_tyzd00 where zdmc00='PACS图象浏览网址' and bh0000='228215' 20210302 11:06:43 0 select * from YS_MZFTP0 where SFYX00='1' 20210302 11:06:43 0 Select INSTANCE_NAME from V$INSTANCE 20210302 11:06:44 0 select bh0000,mc0000 from bm_tyzd00 where zdmc00='快马合理用药' 20210302 11:06:44 0 select BH0000,MC0000 from BM_TYZD00 where ZDMC00='智康云双向转诊接口' and nvl(BH0001,'228215')='228215' 20210302 11:06:44 0 select BH0000,MC0000 from BM_TYZD00 where ZDMC00='厦门医保接口' and nvl(BH0001,'228215')='228215' 20210302 11:06:44 1 select BH0000,MC0000 from BM_TYZD00 where ZDMC00='卫宁健康双向转诊接口' and nvl(BH0001,'228215')='228215' 20210302 11:06:44 0 select BRID00 displayname, to_char(BRID00) cmbvalue from SF_BRXXB0 where GHKS00 = 1067 and JZYS00 = 1111 and GHRQ00 = '20210302' and THBZ00 != '0' and GHLB00 != '-99999' 20210302 11:06:44 0 select BRID00 displayname, to_char(BRID00) cmbvalue from SF_BRXXB0 where JZKS00 = 1067 and JZYS00 = 1111 and JZRQ00 = '20210302' and THBZ00 != '0' and GHLB00 != '-99999' 20210302 11:06:44 16 select DYZYKS displayname, to_char((select bmmc00 from bm_bmbm00 where bmbh00=a.dyzyks)) cmbvalue from BM_BMBM00 a where BMBH00=1067 20210302 11:06:44 0 select NBBH00,MC0000,BZ0000 from BM_TYZD00 where 1=1 and zdmc00 = ? and yxbz00 = ? order by xsxh00 20210302 11:06:47 0 Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = ? Order by SYBZ00 20210302 11:06:48 0 Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = ? Order by SYBZ00 20210302 11:06:48 1 Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = ? Order by SYBZ00 20210302 11:06:48 0 Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = ? Order by SYBZ00 20210302 11:06:48 0 Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = ? Order by SYBZ00 20210302 11:06:48 0 Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = ? Order by SYBZ00 20210302 11:06:48 0 Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = ? Order by SYBZ00 20210302 11:06:50 0 SELECT * FROM IC_YHXX00 WHERE 1=1AND ICKH00 =? AND ICKNBH =? 20210302 11:06:50 0 select a.*,b.ickh00,b.kmh000 from vw_ys_brxxb0_mzdzbl a,(select * from ic_yhxx00 where zt0000='1') b where a.BRID00 = b.brid00(+) and a.BRID00=? and b.ickh00 =? 20210302 11:06:50 0 select BH0000 displayname, to_char(MC0000) cmbvalue from BM_TYZD00 where zdmc00='福建预交金统一平台' and bh0000='Open_MZ' and MC0000='Y' 20210302 11:06:50 0 select a.*,b.ickh00,b.kmh000 from vw_ys_brxxb0_mzdzbl a,(select * from ic_yhxx00 where zt0000='1') b where a.BRID00 = b.brid00(+) and a.BRID00=? and b.ickh00 =? 20210302 11:06:50 0 select SFJZFP displayname, to_char(SFJZFP) cmbvalue from bm_brxxb0 where brid00=501 20210302 11:06:50 0 select * from VW_YS_BRZZSQ_MZDZBL where LB0000='1' and BRXM00='林香斌' and (BRDH00='18605992159' or BRDH00='18605992159' or SFZH00='352127197410020418') and ZT0000='0' and FZKSBH=1067 and (ynyyid is null or ynyyid='228215') 20210302 11:06:50 94 select * from Vw_ys_yxgh00_mzdzbl a where BRID00+0= ? and ghlb00 <> -99999 and ((JZYS00 = ?) or (JZYS00 = 0)) and ghks00 = ? and ((JZYS00 = ?) or (JZYS00 = 0)) order by ghrq00 desc,ghsj00 desc,ghh000 desc 20210302 11:06:53 0 select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where 1=1 and GHKSBH= ? and GHYSBH= ? and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 20210302 11:06:53 0 select NVL(ZYE000,0) ZYE000, sfdj00 from sf_brzhxx where jflbid = 1 and brid00 = ? 20210302 11:06:53 0 select * from YS_GHJMSZ where KS0000=? and YS0000=? and exists(select 1 from BM_TYZD00 where ZDMC00='免挂号费医保中心' and BH0000=? ) 20210302 11:06:53 16 select * from sf_brxxb0 where ghid00 = (select max(b.ghid00) from sf_brxxb0 b where 1=1 and thbz00<>0 and b.brid00 = ? ) 20210302 11:06:53 0 select DM0000,MC0000 from BM_BRGMXX where JLFL00='4' and SFYX00 = 'Y' AND MZBZ00 = '0' and BRID00 = ? and GHID00 = ? 20210302 11:06:53 0 select ROUND((SYSDATE-TO_DATE(GHRQ00||GHSJ00,'YYYY-MM-DD HH24:MI:SS'))*24,1) SJCZ00 from sf_brxxb0 where GHID00 = (select max(ghid00)ghid00 from sf_brxxb0 b where brid00= ? and thbz00<>0) and rownum=1 20210302 11:06:53 16 {? = call SF_YS_GHXZ00(?,?,?)} 20210302 11:06:53 0 select mc0000 from bm_tyzd00 where zdmc00='默认急诊号时段' and bh0000='228215' 20210302 11:06:53 0 select to_char(sysdate,'D') displayname, to_char(to_char(sysdate,'D')) cmbvalue from dual 20210302 11:06:53 15 select to_char(sysdate,'yyyyMMdd') displayname, to_char(to_char(sysdate,'yyyyMMdd')) cmbvalue from dual 20210302 11:06:53 0 select BZ0000 displayname, to_char(MC0000) cmbvalue from BM_TYZD00 where zdmc00='节假日信息维护' and MC0000>=to_char(sysdate,'yyyyMMdd') 20210302 11:06:53 0 select to_char(SF_YF_JudgeSFLNYD(501)) displayname, to_char('0') cmbvalue from dual 20210302 11:06:53 0 {? = call SF_YS_GHXZ00(?,?,?)} 20210302 11:06:53 0 select * from Vw_ys_yxgh00_mzdzbl a where ghlb00 <> -99999 and jzys00 = ? and ( sfzz00 = '0' or sfzz00 is null) and brid00 = ? and ghrq00 = ? order by ghrq00 desc,ghsj00 desc,ghh000 desc 20210302 11:06:53 0 select * from Vw_ys_yxgh00_mzdzbl a where ghlb00 <> -99999 and jzys00 = ? and ( sfzz00 = '0' or sfzz00 is null) and brid00 = ? and ghrq00 = ? order by ghrq00 desc,ghsj00 desc,ghh000 desc 20210302 11:06:53 3 select YGBH00 displayname, to_char(YGBH00) cmbvalue from BM_BRXXB0 where brid00=501 20210302 11:06:53 0 select MC0000 displayname, to_char(BZ0000) cmbvalue from bm_tyzd00 where zdmc00='科室门诊挂号类别' 20210302 11:06:53 0 select LBMC00 displayname, to_char(LBBH00) cmbvalue from VW_BM_GHLBB0_MZDZBL9 where (lbbh00 in ( 11)) and SFJZLB in('0','2') order by xsxh00 20210302 11:06:53 0 SELECT * FROM BM_GHLBB0 WHERE 1=1 and lbbh00 = ? order by Xsxh00 asc 20210302 11:06:53 0 SELECT * FROM BM_GHLBB0 WHERE 1=1 and ghdj00 = ? order by Xsxh00 asc 20210302 11:06:53 0 select d.xmmc00 czxmmc,sum(c.sfje00) sfje00, sum(c.sfje00 - c.jmje00) zfje00, x.YDJM00, x.JMHJE0 from BM_GHXMDY x,bm_zlzd00 a,xt_zlsfgx b, bm_yysfxm c,bm_fpxm00 d where 1=1 and x.zlxmid=a.zlxmid and a.zlxmid=b.zlxmid and b.sfxmid=c.sfxmid and c.mzfpid=d.fpxmid and x.SYBZ00='1' and x.lbbh00 = ? and (d.xmmc00 = '挂号费' or d.xmmc00 = '诊察费') and ( x.ghks00 = ? or x.ghks00=-1 ) group by d.xmmc00,x.YDJM00,x.JMHJE0 20210302 11:06:53 0 select HZLBMC displayname, to_char(HZLB00) cmbvalue from BM_HZLB00 20210302 11:06:54 15 select to_char(SSY000) displayname, to_char(to_char(SZY000)) cmbvalue from YS_BRBQB0 where GHID00 = (select max(b.ghid00) from sf_brxxb0 b where 1=1 and thbz00<>0 and b.ghlb00<>-99999 and brid00 = 501) 20210302 11:06:56 0 select Id0000,BH0000,ICD000,trim(jblbsm) jblbsm from VW_BM_ICD100_DZBLTree where 1=1 and length(BH0000)=3 order by BH0000 20210302 11:06:56 47 SELECT *FROM ( select a.* from vw_ys_jbzdzd a where 1=1 and upper(a.PYSM00) like '%' order by a.PYSM00) WHERE ROWNUM<=100 20210302 11:06:58 31 SELECT *FROM ( select a.* from vw_ys_jbzdzd a where 1=1 and upper(a.PYSM00) like 'J%' order by a.PYSM00) WHERE ROWNUM<=100 20210302 11:06:58 47 SELECT *FROM ( select a.* from vw_ys_jbzdzd a where 1=1 and upper(a.PYSM00) like 'JX%' order by a.PYSM00) WHERE ROWNUM<=100 20210302 11:06:59 32 SELECT *FROM ( select a.* from vw_ys_jbzdzd a where 1=1 and upper(a.PYSM00) like 'JXW%' order by a.PYSM00) WHERE ROWNUM<=100 20210302 11:06:59 31 SELECT *FROM ( select a.* from vw_ys_jbzdzd a where 1=1 and upper(a.PYSM00) like 'JXWC%' order by a.PYSM00) WHERE ROWNUM<=100 20210302 11:07:04 15 select SQ_SF_BRXXB0_GHID00.nextval from dual 20210302 11:07:04 15 select XM0000, XB0000, CSRQ00, JZRQSJ, GHH000, BMMC00, JZYSXM, LBMC00, THBZ00, GHRQ00, GHID00, GHYXM0, JZRQ00, JZSJ00, BRID00, ZDMC00, JZYS00, BRBLH0, GHLB00, GHKS00, JZKS00, SFCZ00, GHJE00, ZCFJE0, GHFZJE, LBBH00, GHSJ00, SFZZ00, TSBZBH, TSBZMC, WDWID0, FBXX00, BRNL00, BRLXDH, WJSFY0, ZYZDMC, LGH000 from vw_ys_ghh000_mzdzbl where 1=1 and ghlb00 <> -99999 and brid00=? and jzys00=? and ghrq00 >=? and ghrq00 <=? order by ghid00 desc 20210302 11:07:04 0 delete from ys_brbqb0 where ghid00 = 5307509 20210302 11:07:04 16 insert into ys_brbqb0(brbqid,ghid00,ghh000,szy000,ssy000,jzys00,sjys00,czrq00,czsj00,jzysxm,jzrqsj,fbrq00) values (SQ_YS_BRBQB0_BRBQID.NEXTVAL,?,?,?,?,?,?,?,?,?,?,?) 20210302 11:07:04 16 select a.*,b.ickh00,b.kmh000 from vw_ys_brxxb0_mzdzbl a,(select * from ic_yhxx00 where zt0000='1') b where a.BRID00 = b.brid00(+) and a.BRID00=? and b.ickh00 =? 20210302 11:07:04 0 select SFJZFP displayname, to_char(SFJZFP) cmbvalue from bm_brxxb0 where brid00=501 20210302 11:07:04 0 select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where 1=1 and GHKSBH= ? and GHYSBH= ? and PBLX00=? and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 20210302 11:07:04 0 select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where 1=1 and GHKSBH= ? and GHYSBH= ? and PBLX00=? and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 20210302 11:07:04 0 select SQ_YS_BRZDXX_ZDXXID.nextval from dual 20210302 11:07:04 0 insert into YS_BRZDXX(zdxxid,ghid00,ghh000,zzdbz0,icd900,zdmsmc,jzys00,jzysxm,jzks00,sfxyzd,zdmc00,sfyz00,zdrq00,zdsj00) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?) 20210302 11:07:04 16 Update SF_BRZHXX set TYJE00 = TYJE00+ ? where BRID00=? and JFLBID =1 20210302 11:07:04 15 {call SP_SF_BRXXB0_BRGH00_MZDZBL(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 20210302 11:07:04 0 Update SF_BRZHXX set TYJE00 = TYJE00+ ? where BRID00=? and JFLBID =1 20210302 11:07:04 16 select * from sf_brxxb0 where 1 =1 and ghh000=? 20210302 11:07:04 0 Update YS_BRZDXX set ghid00=? where ghid00= ? 20210302 11:07:04 0 Update YS_BRBQB0 set ghid00=? where ghid00= ? 20210302 11:07:04 0 update Sf_brxxb0 set ghid00 = ? , tsbzbh = ? where ghid00 = '5307509' 20210302 11:07:04 0 {call SP_YS_SAVEBSL(?,?,?,?,?,?,?,?,?)} 20210302 11:07:04 0 select sum(a.zje000) ghfzje from yj_yw0000 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and b.lbbh00 in (20,21) and a.zyghid=? and a.mzzybz='0' and a.xmzt00 in ('2','3') and a.sl0000>0 and not exists(select 1 from yj_yw0000 x where a.yjdjh0=x.cxdjh0 and a.zyghid=x.zyghid and a.mzzybz=x.mzzybz) 20210302 11:07:04 16 select NVL(ZYE000,0) ZYE000, sfdj00 from sf_brzhxx where jflbid = 1 and brid00 = ? 20210302 11:07:04 15 Update sf_brxxb0 set thBZ00='2' where GHH000='5307509' 20210302 11:07:04 0 select * from BM_BRXXB0 where 1=1 and brid00 = ? 20210302 11:07:04 16 SELECT * FROM Vw_ys_mzcrdj where 1 = 1 and MZID00 = ? ORDER BY ZDRQ00 DESC 20210302 11:07:05 16 select b.zdmc00 displayname, to_char(b.zdxxid) cmbvalue from sf_brxxb0 a, ys_brzdxx b,xt_icd900 d where a.ghid00 = b.ghid00 and a.ghid00=5307509 and a.brid00 =501 and b.icd900 = d.icd900 and d.sfsyjb = 'Y' 20210302 11:07:05 0 select MC0000 displayname, to_char(BH0000) cmbvalue from BM_TYZD00 where ZDMC00 = '食源性疾病登记-生物标本采集-样本类型' and LBBZ00 = 0 order by xsxh00 asc 20210302 11:07:05 17 select MC0000 displayname, to_char(BH0000) cmbvalue from BM_TYZD00 where ZDMC00 = '食源性疾病登记-暴露信息-食品分类' and LBBZ00 = 0 order by xsxh00 asc 20210302 11:07:05 0 select MC0000 displayname, to_char(BH0000) cmbvalue from BM_TYZD00 where ZDMC00 = '食源性疾病登记-暴露信息-加工或包装方式' and LBBZ00 = 0 order by xsxh00 asc 20210302 11:07:05 0 select MC0000 displayname, to_char(BH0000) cmbvalue from BM_TYZD00 where ZDMC00 = '食源性疾病登记-暴露信息-进食场所类型' and LBBZ00 = 0 order by xsxh00 asc 20210302 11:07:05 15 select MC0000 displayname, to_char(BH0000) cmbvalue from BM_TYZD00 where ZDMC00 = '食源性疾病登记-暴露信息-购买场所类型' and LBBZ00 = 0 order by xsxh00 asc 20210302 11:07:05 16 SELECT * FROM VM_BM_BRXXZD_MZDZBL where 1 = 1 and ZDLB00 = ? 20210302 11:07:05 31 SELECT * FROM VM_BM_BRXXZD_MZDZBL where 1 = 1 and ZDLB00 = ? and FJDID0 = ? 20210302 11:07:05 15 SELECT * FROM VM_BM_BRXXZD_MZDZBL where 1 = 1 and ZDLB00 = ? and FJDID0 = ? 20210302 11:07:05 15 select * from VW_YS_SYJBDJXX A where 1=1 and A.ZYGHID=? and MZZYBZ = '0' order by DJID00 20210302 11:07:05 0 select yyid00 displayname, to_char(yyjc00) cmbvalue from xt_yyxx00 20210302 11:07:05 16 select ygbh00 displayname, to_char(zwxm00) cmbvalue from bm_ygbm00 where ygbh00 = 1111 20210302 11:07:05 1 select ygbh00 displayname, to_char(zwxm00) cmbvalue from bm_ygbm00 where ygbh00 = 1111