-------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:14 select 0 XZBZ00,ZYID00, BRID00, trim(MRN000) MRN000, trim(ZYH000) ZYH000, XM0000, XB0000, CSRQ00, RYRQSJ,RYSQK0, RYBQ00, DQBQ00, DQBQMC, RZKS00, RYCWH0, CYDJSJ, SJCYRQ, ZZYSXM,FBBH00,ZRYSXM, SXYSXM, BRRYCS, BRZT00, DQKSMC, SHBZ00, BAZT00, YBMC00,decode(FSRQ00,'20991231','',FSRQ00) FSRQ00,ZYCS00,BAHCS0, SHRXM0, SHSJ00, YBKH00, YBZYH0,QSRQSJ,QSRXM0,HTRQ00,HTRXM0,LRRQ00,(select dpbz00 from BA_BASYDP b where b.LSH000=a.zyid00 and rownum<=1 ) HTYY00,LXRDH0,HJJE00,SCSHR0,SCSHRQ,decode(bawcbz,'1','已完成','2','审核完成','未完成') BAWCBZ, decode(dbzmc0,null,'否','是') SFDBZ0,ZZZT00,GDGDSJ,decode(nvl(QSRQSJ,'0'),'0','',decode(nvl(GDGDSJ,'0'),'0','',ASGD00)) ASGD00,SCTJRQ,ZYTS00,SJH000 ,(select to_char(to_date(B.CZRQ00||B.CZSJ00,'YYYYMMDD HH24:MI:SS'),'YYYY.MM.DD HH24:MI:SS') RKRQ00 from BA_ZZBAGL B where A.ZYID00=B.LSH000 and B.ZZZT00='3' and rownum=1) RKRQ00 FROM vw_ba_cybaxx a where SJCYRQ between '2' and '2' and exists(select 1 from bm_bmbm00 where bmbh00=A.DQKS00 and yyid00='222142')order by CYDJSJ :BeginData=['2'] :EndData=['2'] Elapsed time: 0.020 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:18 (select DM0000,MC0000 from XT_ZLXG00 union all select '' DM0000,'' MC0000 from dual) order by DM0000 nulls first Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:18 select * from (select DM0000,VALUE0 from XT_ZD0000 where ZDBM00 = 'MZFJ00' union all select '' DM0000,'' VALUE0 from dual) order by DM0000 nulls first Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'RYBQ00%' Elapsed time: 0.002 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select DM0000,VALUE0 from XT_ZD0000 where ZDBM00='RYTJ00' order by DM0000 Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'XX0000%' Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'YY0000%' Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'CYQX00%' Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'JFFS01%' Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select MC0000,BH0000 from BM_TYZD00 where ZDMC00='证件名称' order by BH0000 asc Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select MC0000,BH0000 from BM_TYZD00 where ZDMC00='自制中药制剂' order by BH0000 asc Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'ZLLB00%' Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'SFSJ00%' Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'BAZL00%' Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select A.JTDZ00,A.GZDW00,A.BAH000,a.zyh000,BRXM00,XX0000,SFZH00,RH0000,BRCSRQ,HYZK00,ZY0000,MZ0000,GJ0000,A.SWRQ00,A.SWSJ00,A.BRXB00,A.LSH000,A.YBID00,RYKB00, BRNL00,RYRQ00,RYSJ00,CYRQ00,CYKBMC,JTDZ00,XZZDH0 ,CYSJ00,YBKH00,YBMC00,YBZYH0,ZZYSMC,SXYS00,CYKB00,RYKB00 from BA_BRZYXX A where a.lsh000=922569 Elapsed time: 0.002 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select lsh000 ZYID00,JFFS00,ZYCS00,BAH000,ZYH000,BRXM00,BRXB00,BRCSRQ,BRNL00,HYZK00,ZY0000,CSSF00,CSXS00,MZ0000,GJ0000,SFZH00,GZDW00,GZDH00,GZYB00,JTYB00,LXRXM0,LXRDZ0,LXRDH0,LXRGX0,RYQK00,RYRQ00,RYSJ00,RYKB00,RYKBMC,RYBF00,ZKKB00,ZKKBMC,CYRQ00,CYSJ00,CYKB00,CYKBMC,CYBF00,ZYTS00,QZRQ00,QZSJ00,GMYW00,HBSAG0,HCVAB0,HIVAB0,MZCYFH,RYCYFH,SQSHFH,LCBLFH,FSBLFH,QJCS00,CGCS00,BAZL00,ZKRQ00,SFSJ00,DYBL00,SZQX00,XX0000,RH0000,HXB000,XXB000,XJ0000,QX0000,SXQT00,LRRY00,LRRYMC,LRRQ00,LRSJ00,ZJE000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0,YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,BLZD00,SSZDWY,brly00,RYTJ00,RYQZL0,MZYS00,ZLLB00,ZZZYZJ,QJFF00,SFWZ00,SFJZ00,SFYNQK,SFCRB0,CRBFL0,SFBG00,ZCDYL0,YBKH00,JTDH00,YBID00,YBMC00,YBZYH0,CYFS00,SHBZ00,BRNLMM,YECSTZ,YERYTZ,CSDS00,XZZSF0,XZZDQ0,XZZXS0,XZZDH0,XZZYB0,BLZDBM,SFYWGM,LYFS00,ZYYLJG,ZZYJH0,ZZYMD0,HMRYQD,HMRYQH,HMRYQM,HMRYHD,HMRYHH,HMRYHM,JTDZ00,SSZDBM,JGSF00,JGXS00,JKDAH0,ZRHS00,ZRHSMC,LXRDZ1,SXFY01,BLH000,ZZZT00,XZZXC0,SHRXM0,QSRQ00,QSSJ00,QSR000,BRNLDD,SCSHR0,SCSHRQ,SCSHSJ,BRZJLX,JGQX00 from vw_ba_basyxx where LSH000=922569 Elapsed time: 0.002 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select * from BA_BRFJXX where lsh000=922569 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select * from ba_syfyb0 where zyid00=922569 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select ZYID00,ZDLB00,ZDM000 as ZDBM00,ZDMC00,ZLXG00 as ZLXGDM,ZDFS00, ZDFSMC,ZDLBMC, RYBQ00,FWMC00,BWMC00,ZDBZ00 from VW_BQ_BRZDXX_DZBL where ZYID00=922569 order by ZDLB00,PLXH00,ZDPLXH,ID0000 Elapsed time: 0.005 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select ZYID00,ZDLB00,ZDM000 as ZDBM00,ZDMC00,ZLXG00 as ZLXGDM,ZDFS00, ZDFSMC,ZDLBMC,RYBQ00 from VW_BQ_BRZDXX_DZBL where ZYID00=922569 order by ZDLB00,PLXH00,ZDPLXH,ID0000 Elapsed time: 0.004 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select SSSFTB from BA_BRZYXX where lsh000 = 922569 Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 SELECT a.LSH000,a.SSXH00, a.SSM000,decode(a.SSZL00,'特大','四级','大','三级','中','二级','小','一级',a.SSZL00) SSDJMC, a.SSMC00,a.SSRQ00,a.SSSJ00, a.SSYS00,a.SSYSMC,a.IYS000,a.IYSMC0,a.IIYS00,a.IIYSMC,a.MZFS00,a.MZYS00, a.MZYSMC,a.QKYHDJ,a.SSCXSJ,a.SSMZFJ FROM BA_BRSSXX a WHERE a.LSH000=922569 order by SSLB00 desc, SSXH00 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select * from BA_BRJSXX where lsh000=922569 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select DM0000,MC0000 from XT_ZLXG00 order by JKBH00 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'SXFY00%' Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select ZYID00,ZDLB00,ZDM000,ZDMC00,ZLXG00,RYBQ00,ZDRQ00 from VW_MR_BRZDXX where ZYID00='922569' order by PLXH00 Elapsed time: 0.003 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select * from BA_BRZYFY where ZYID00=922569 and rownum = 1 Elapsed time: 0.003 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select * from BA_BRZYFY where zyid00=922569 Elapsed time: 0.002 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select LCD000,SYFY00,SXFY00,HXB000,XXB000,XJ0000,QX0000,ZTXHS0,RYQK00,RYRQ00 from ba_brzyxx where lsh000=922569 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select sqzyts from ba_brzyfy where zyid00=922569 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select BH0000,MC0000 from bm_tyzd00 where ZDMC00='重症监护室' order by BH0000 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select VALUE0,DM0000 from XT_ZD0000 where ZDBM00 LIKE 'SXFY00%' Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select lsh000 ZYID00,JFFS00,ZYCS00,BAH000,ZYH000,BRXM00,BRXB00,BRCSRQ,BRNL00,HYZK00,ZY0000,CSSF00,CSXS00,HBSAG0,HCVAB0,HIVAB0,NLNYR0,QSR000,QSRQ00,QSSJ00,SCTJRQ,SCTJSJ,HTR000,HTRQ00,HTSJ00,BLFX00,ZLBM00,ZLMC00,ZZZT00,Ryqzrq,Tjhlts,Yjhlts,Ejhlts,Sjhlts,Ztxhs0,RJSS00,HXJSJ0,FZHXSJ,PSHXSJ,LCD000,SXFY01,SXFY00,HXB000,XXB000,XJ0000,QX0000 from VW_ZS_BASYXX_DZBL where LSH000=922569 Elapsed time: 0.002 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select ZYID00,ICUBH0,to_date(JRRQ00||JRSJ00,'yyyyMMddHH24:mi:ss') JRRQSJ,to_date(TCRQ00||TCSJ00,'yyyyMMddHH24:mi:ss') TCRQSJ,JRYY00 from BA_ICUJL0 where zyid00=922569 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select b.bmmc00,a.qsrq00,a.qssj00,a.jsrq00,a.jssj00 from bq_brldxx a,bm_bmbm00 b where a.ksh000=b.bmbh00 and b.bmmc00 like '重症医学科%' and QSZT00='转入' and zyid00=922569 order by qsrq00||QSSJ00 desc Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2023/9/18 17:07:19 select ID0000,ZYID00,ZYZFBM,ZYZFMC,BZ0000 from BA_ZYZFXX where zyid00=922569 Elapsed time: 0.001