查询超时问题处理

liusheng

3 天以前 9669ea20c78304d5fbbcbe952c97b3a8a5fe936e

查询超时问题处理

 smartor/src/main/resources/mapper/smartor/PatMedOuthospMapper.xml

@@ -113,11 +113,8 @@
        pmo.hpi,
        pmo.fuflag,
        pmo.patname,
        CONCAT(pa.age,pa.age_unit,pa.age2,pa.age_unit2) AS age,
        pa.telcode,
        pmo.mainsuit,
        pa.idcardno
        from pat_med_outhosp pmo left join pat_archive pa on pmo.patid = pa.id
        pmo.mainsuit
        from pat_med_outhosp pmo
        <where>
            pmo.del_flag=0
            <if test="orgid != null ">and pmo.orgid = #{orgid}</if>