1       21:54:06  SQL Execute: ORACLE -  select count(*) RCOUNT from JY_WJYBCX  where TJLB00='1'    and PYRQ00 between '20200831' and '20200910' 
   and  CKRXM0 is null 

2       21:54:06  SQL Execute: ORACLE -  select count(*) RCOUNT from VW_JY_YW0000 J  where  (JGZT00||'A' in ('2A','4A','5A')   or (JGZT00||'A'='1A' and trim(TXM000) is not null))  and ZYZBID in (1,3,2,4,5,8,6,7)  and SQRQ00 >'20200201'    and (SF_JY_GETTATYJTS(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00,                          MZZYBZ,SFTJ00,JGZT00,YXBZ00,ZLXMID,SF_JY_JYTERM(JGZT00,MZZYBZ,'2'),0.5,0.1)<>0) 

3       21:54:06  SQL Execute: ORACLE -  select *  from(select rownum RN, T.*       from(select BRXM00,decode(MZZYBZ,'0','门诊','住院') BRLX00,                ZYHGHH,TXM000,YBH000,ZLXMJC,SQRQ00,SQSJ00,BBSDRQ,BBSDSJ,                BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,PYRQ00,PYSJ00,CBGRQ0,CBGSJ0,JGZT00,                decode(YXBZ00,'Y','是','N','否') SFJZ00,ZYZBID,ZYZBMC,                substrb(SF_JY_GETTATJGSJ(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,                        PYSJ00,CBGRQ0,CBGSJ0,MZZYBZ,SFTJ00,YXBZ00,0,0),1,200) JQZZSJ,                substrb(SF_JY_GETTATJGSJ(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,                        PYSJ00,CBGRQ0,CBGSJ0,MZZYBZ,SFTJ00,YXBZ00,1,0),1,200) SNZZSJ,                SF_JY_GETTATYJTS(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00,                                 MZZYBZ,SFTJ00,JGZT00,YXBZ00,ZLXMID,SF_JY_JYTERM(JGZT00,MZZYBZ,'2'),0.5,0.1) YJTS00            from VW_JY_YW0000 J            where  (JGZT00||'A' in ('2A','4A','5A')   or (JGZT00||'A'='1A' and trim(TXM000) is not null))  and ZYZBID in (1,3,2,4,5,8,6,7)  and SQRQ00 >'20200201'            order by ZYHGHH) T       where (YJTS00<>0) and rownum<=1*10) R  where R.RN>10*(1-1) 

4       21:54:11  SQL Execute: ORACLE -  select count(*) RCOUNT from JY_WJYBCX  where TJLB00='1'    and PYRQ00 between '20200831' and '20200910' 
   and  CKRXM0 is null 

5       21:54:11  SQL Execute: ORACLE -  select count(*) RCOUNT from VW_JY_YW0000 J  where  (JGZT00||'A' in ('2A','4A','5A')   or (JGZT00||'A'='1A' and trim(TXM000) is not null))  and ZYZBID in (1,3,2,4,5,8,6,7)  and SQRQ00 >'20200201'    and (SF_JY_GETTATYJTS(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00,                          MZZYBZ,SFTJ00,JGZT00,YXBZ00,ZLXMID,SF_JY_JYTERM(JGZT00,MZZYBZ,'2'),0.5,0.1)<>0) 

6       21:54:11  SQL Execute: ORACLE -  select *  from(select rownum RN, T.*       from(select BRXM00,decode(MZZYBZ,'0','门诊','住院') BRLX00,                ZYHGHH,TXM000,YBH000,ZLXMJC,SQRQ00,SQSJ00,BBSDRQ,BBSDSJ,                BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,PYRQ00,PYSJ00,CBGRQ0,CBGSJ0,JGZT00,                decode(YXBZ00,'Y','是','N','否') SFJZ00,ZYZBID,ZYZBMC,                substrb(SF_JY_GETTATJGSJ(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,                        PYSJ00,CBGRQ0,CBGSJ0,MZZYBZ,SFTJ00,YXBZ00,0,0),1,200) JQZZSJ,                substrb(SF_JY_GETTATJGSJ(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,                        PYSJ00,CBGRQ0,CBGSJ0,MZZYBZ,SFTJ00,YXBZ00,1,0),1,200) SNZZSJ,                SF_JY_GETTATYJTS(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00,                                 MZZYBZ,SFTJ00,JGZT00,YXBZ00,ZLXMID,SF_JY_JYTERM(JGZT00,MZZYBZ,'2'),0.5,0.1) YJTS00            from VW_JY_YW0000 J            where  (JGZT00||'A' in ('2A','4A','5A')   or (JGZT00||'A'='1A' and trim(TXM000) is not null))  and ZYZBID in (1,3,2,4,5,8,6,7)  and SQRQ00 >'20200201'            order by ZYHGHH) T       where (YJTS00<>0) and rownum<=1*10) R  where R.RN>10*(1-1)