-------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select count(1) rn from VW_BA_BAICD0 where bb0000 in (1,2) and ICD900 like '%N05.201%' and rownum=1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select count(1) rn from VW_BA_BAICD0 where bb0000 in (1,2) and ICD900 like '%N05.201%' and rownum=1 Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院日期' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院日期' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院西医主要诊断疾病编码(病案室)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院西医其他诊断疾病编码(病案室)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='病人姓名' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='病案号' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院西医主要诊断疾病编码(病案室)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='手术名称(病案室)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='手术等级(临床)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院日期' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='入院日期' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='实际住院' and rownum = 1 Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院科别名称' and rownum = 1 Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='5' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='病人姓名' and rownum = 1 Elapsed time: 0.000 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='4' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='病案号' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='244' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院西医主要诊断疾病编码(病案室)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='206' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='手术名称(病案室)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='154' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='手术等级(临床)' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='29' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院日期' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='23' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='入院日期' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='219' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='实际住院' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where ID0000='298' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select * from BA_CXZDSX where tjmc00='出院科别名称' and rownum = 1 Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:49 select BRXM00,BAH000,BASCYXYZYZDJBBM,cm.SSMC00,ss.SSZL00,CYRQ00,RYRQ00,ZYTS00,CYKBMC from VW_BA_BRZYFY_30 VW left join ba_brssxx ss on VW.LSH000=ss.lsh000 left join (select cm1.cm3000,max(cm1.ssmc00) ssmc00 from ba_cm3000 cm1 group by cm1.cm3000) cm on ss.SSM000 = cm.cm3000 where 1=1 and ( SSXH00= (select min(b1.ssxh00) from ba_brssxx b1 where b1.lsh000=vw.lsh000) or SSXH00 is null) and vw.lsh000 in (select distinct(vw.lsh000) from VW_BA_BRZYFY_30 VW left join ba_brssxx ss on VW.LSH000=ss.lsh000 left join (select cm1.cm3000,max(cm1.ssmc00) ssmc00 from ba_cm3000 cm1 group by cm1.cm3000) cm on ss.SSM000 = cm.cm3000 left join bq_brzdxx zd on VW.LSH000=zd.zyid00 and ZDLB00='4' where 1=1 and CYRQ00>='20190101' and CYRQ00<='20210630' and (BASCYXYZYZDJBBM='N05.201' or zd.ZDM000='N05.201' ) and CYKB00 in ( select bmbh00 from bm_bmbm00 where yyid00='220006')) Elapsed time: 1.909 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:13:58 Logout (0x5d8da24): [@] -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:15:18 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,JSKSBH FROM VW_BA_XTTSXX_DZBL a where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD') and (JSKSBH IS NULL OR instr(',' || jsksbh || ',', decode(fsdx00,'2',',4960,','0',',2102,')) > 0 ) and not exists (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 4960 ) order by a.XH0000 desc Elapsed time: 0.001 -------------------------------------------------------------------------------- Timestamp: 2021-12-07 14:15:57 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,JSKSBH FROM VW_BA_XTTSXX_DZBL a where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD') and (JSKSBH IS NULL OR instr(',' || jsksbh || ',', decode(fsdx00,'2',',4960,','0',',2102,')) > 0 ) and not exists (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 4960 ) order by a.XH0000 desc Elapsed time: 0.001