Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java
===================================================================
diff -u -r37732 -r37734
--- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java	(.../TousseInstanceTableManager.java)	(revision 37732)
+++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java	(.../TousseInstanceTableManager.java)	(revision 37734)
@@ -671,10 +671,9 @@
 			String idHql = String.format("select po.id from %s po %s %s ", TousseInstance.class.getSimpleName(), sql, orderby);
 			List<Object> idList = objectDao.findByHql(idHql, start,pageSize);
 			//根据ID查询
-			String hql = String.format("select po from %s po, %s bd where bd.id = po.id and %s ", 
-					TousseInstance.class.getSimpleName(),
+			String hql = String.format("select po from %s po where %s ",
 					BarcodeDevice.class.getSimpleName(),
-					SqlUtils.getNonStringFieldInLargeCollectionsPredicate("bd.id", idList));
+					SqlUtils.getNonStringFieldInLargeCollectionsPredicate("po.id", idList));
 			List<TousseInstance> dbList = objectDao.findByHql(hql);
 			//再根据id顺序排序
 			if(CollectionUtils.isNotEmpty(idList)){