Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java =================================================================== diff -u -r33817 -r33866 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java (.../PackingManagerImpl.java) (revision 33817) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/service/PackingManagerImpl.java (.../PackingManagerImpl.java) (revision 33866) @@ -6141,8 +6141,7 @@ String barcode = currentPackingTask.getDiscardTiBarcode(); TousseInstance discardTi = tousseInstanceManager.getTousseInstanceByBarcode(barcode); Session session = objectDao.getHibernateSession(); - Query query = session.createQuery(" select distinct qmi from QualityMonitoringInstance qmi inner join qmi.qualityMonitoringGoodsList qmd " - + " where qmd.barcode = :barcode "); + Query query = session.createQuery(" select qmi from QualityMonitoringInstance qmi where qmi.id in (select qmd.qualityMonitoringInstance.id from QualityMonitoringGoods qmd where barcode = :barcode) "); query.setParameter("barcode", barcode); List qmis = query.list(); if( qmis != null && CollectionUtils.isNotEmpty(qmis))