Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/container/service/ReviewedBasketManagerImpl.java
===================================================================
diff -u -r14090 -r14129
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/container/service/ReviewedBasketManagerImpl.java	(.../ReviewedBasketManagerImpl.java)	(revision 14090)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/container/service/ReviewedBasketManagerImpl.java	(.../ReviewedBasketManagerImpl.java)	(revision 14129)
@@ -11,6 +11,7 @@
 
 import org.apache.commons.collections4.CollectionUtils;
 import org.apache.commons.lang.StringUtils;
+import org.apache.log4j.Logger;
 
 import com.forgon.disinfectsystem.entity.basedatamanager.container.Container;
 import com.forgon.disinfectsystem.entity.basedatamanager.toussedefinition.TousseInstance;
@@ -24,6 +25,8 @@
  *
  */
 public class ReviewedBasketManagerImpl implements ReviewedBasketManager {
+	
+	private Logger logger = Logger.getLogger(ReviewedBasketManagerImpl.class);
 
 	private ObjectDao objectDao;
 	
@@ -277,10 +280,16 @@
 	public void deleteEmptyBasket() {
 		objectDao.flush();
 		
-		String containersql = "select distinct b.container_id from container c,ReviewedBasket b "
+		//sql语句的性能太差,改为下面那句
+		/*String containersql = "select distinct b.container_id from container c,ReviewedBasket b "
 				+ "left join tousseInstance t on b.id = t.reviewBasket_id "
-				+ "where c.id = b.container_id and t.id is null";
+				+ "where c.id = b.container_id and t.id is null";*/
 		
+		//将上面性能较差的语句更换为此句
+		String containersql = "select distinct b.container_id from ReviewedBasket b "
+				+ "left join tousseInstance t on b.id = t.reviewBasket_id "
+				+ "where t.id is null";
+		
 		String whereSql = "select distinct b.id from ReviewedBasket b left join tousseInstance t "
 						+ "on b.id = t.reviewBasket_id where t.id is null";