Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/tousseitem/TousseItem.java
===================================================================
diff -u -r15734 -r16182
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/tousseitem/TousseItem.java	(.../TousseItem.java)	(revision 15734)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/tousseitem/TousseItem.java	(.../TousseItem.java)	(revision 16182)
@@ -8,6 +8,7 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.JoinColumn;
 import javax.persistence.ManyToOne;
 import javax.persistence.OneToMany;
@@ -32,7 +33,7 @@
 import com.forgon.tools.util.ForgonIntegerUtils;
 
 @Entity
-@Table(name = "TousseItem")
+@Table(name = "TousseItem",indexes={@Index(columnList="recyclingApplication_ID",name="recyclingApplication_ID_index"),@Index(columnList="recyclingApplication_ID",name="recyclingRecord_id_index")})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class TousseItem {
 
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/recyclingapplication/RecyclingApplication.java
===================================================================
diff -u -r15716 -r16182
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/recyclingapplication/RecyclingApplication.java	(.../RecyclingApplication.java)	(revision 15716)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/recyclingapplication/RecyclingApplication.java	(.../RecyclingApplication.java)	(revision 16182)
@@ -6,9 +6,11 @@
 import javax.persistence.Column;
 import javax.persistence.Entity;
 import javax.persistence.FetchType;
+import javax.persistence.Index;
 import javax.persistence.JoinColumn;
 import javax.persistence.ManyToOne;
 import javax.persistence.OneToMany;
+import javax.persistence.Table;
 import javax.persistence.Transient;
 
 import org.hibernate.annotations.Cache;
@@ -28,6 +30,7 @@
  */
 
 @Entity
+@Table(indexes = {@Index(columnList = "id", name = "id_index"),@Index(columnList = "userecord_id", name = "userecord_id_index")})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class RecyclingApplication extends InvoicePlan implements
 		AclFieldsObject {
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/supplyroomconfig/SupplyRoomConfig.java
===================================================================
diff -u -r15736 -r16182
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/supplyroomconfig/SupplyRoomConfig.java	(.../SupplyRoomConfig.java)	(revision 15736)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/supplyroomconfig/SupplyRoomConfig.java	(.../SupplyRoomConfig.java)	(revision 16182)
@@ -8,7 +8,9 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.Table;
+
 import org.hibernate.annotations.Cache;
 import org.hibernate.annotations.CacheConcurrencyStrategy;
 
@@ -20,7 +22,7 @@
  *       供应室配置
  */
 @Entity
-@Table(name = "SupplyRoomConfig")
+@Table(name = "SupplyRoomConfig",indexes={@Index(columnList="orgUnitCoding",name="orgUnitCoding_index"),@Index(columnList="supplyRoomType",name="supplyRoomType_index")})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class SupplyRoomConfig {
 
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/recyclingrecord/RecyclingRecord.java
===================================================================
diff -u -r14407 -r16182
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/recyclingrecord/RecyclingRecord.java	(.../RecyclingRecord.java)	(revision 14407)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/recyclingrecord/RecyclingRecord.java	(.../RecyclingRecord.java)	(revision 16182)
@@ -2,12 +2,14 @@
 
 import java.util.Date;
 import java.util.List;
+
 import javax.persistence.CascadeType;
 import javax.persistence.Entity;
 import javax.persistence.FetchType;
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.JoinColumn;
 import javax.persistence.JoinTable;
 import javax.persistence.ManyToMany;
@@ -16,8 +18,10 @@
 import javax.persistence.OrderBy;
 import javax.persistence.Table;
 import javax.persistence.Transient;
+
 import org.hibernate.annotations.Cache;
 import org.hibernate.annotations.CacheConcurrencyStrategy;
+
 import com.fasterxml.jackson.annotation.JsonIgnore;
 import com.forgon.disinfectsystem.entity.becleanitem.ClassifyBasket;
 import com.forgon.disinfectsystem.entity.invoicemanager.InvoicePlan;
@@ -29,7 +33,8 @@
  *         2012-3-23 下午15:12:34
  */
 @Entity
-@Table(name = "RecyclingRecord")
+@Table(name = "RecyclingRecord",indexes = {@Index(columnList = "orgUnitCoding", name = "orgUnitCoding_index"),@Index(columnList = "departCode", name = "departCode_index")
+		,@Index(columnList = "recyclingApplication_id", name = "recyclingApplication_id_index")})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class RecyclingRecord {
 
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/invoicemanager/InvoicePlan.java
===================================================================
diff -u -r15703 -r16182
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/invoicemanager/InvoicePlan.java	(.../InvoicePlan.java)	(revision 15703)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/invoicemanager/InvoicePlan.java	(.../InvoicePlan.java)	(revision 16182)
@@ -13,6 +13,7 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.Inheritance;
 import javax.persistence.InheritanceType;
 import javax.persistence.Lob;
@@ -37,7 +38,11 @@
  * @date 2012-04-24 发货计划单
  */
 @Entity
-@Table(name = "invoicePlan")
+@Table(name = "invoicePlan",indexes={@Index(columnList="applicationTime",name="applicationTime_index"),@Index(columnList="departCoding",name="departCoding_index"),@Index(columnList="handleDepartCoding",name="handleDepartCoding_index")
+,@Index(columnList="returnStatus",name="returnStatus_index"),@Index(columnList="deliverStatus",name="deliverStatus_index"),@Index(columnList="recyclingStatus",name="recyclingStatus_index")
+,@Index(columnList="committedStatus",name="committedStatus_index"),@Index(columnList="type",name="type_index"),@Index(columnList="lastInvoiceTime",name="lastInvoiceTime_index"),@Index(columnList="applicant",name="applicant_index")
+,@Index(columnList="endStatus",name="endStatus_index"),@Index(columnList="sequence",name="sequence_index")
+})
 @Inheritance(strategy = InheritanceType.JOINED)
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class InvoicePlan {
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java
===================================================================
diff -u -r15983 -r16182
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java	(.../TousseInstance.java)	(revision 15983)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java	(.../TousseInstance.java)	(revision 16182)
@@ -32,7 +32,19 @@
  */
 
 @Entity
-@Table(indexes = {@Index(columnList = "status", name = "status_index"),@Index(columnList = "tousseName", name = "tousseName_index")})
+@Table(indexes = {@Index(columnList = "status", name = "status_index"),@Index(columnList = "tousseName", name = "tousseName_index")
+,@Index(columnList = "id", name = "id_index"),@Index(columnList = "location", name = "location_index"),@Index(columnList = "sterileFrequency", name = "sterileFrequency_index")
+,@Index(columnList = "packageType", name = "packageType_index"),@Index(columnList = "wareHouseId", name = "wareHouseId_index")
+,@Index(columnList = "sterilizerName", name = "sterilizerName_index"),@Index(columnList = "sterileStartTime", name = "sterileStartTime_index")
+,@Index(columnList = "sterileEndTime", name = "sterileEndTime_index"),@Index(columnList = "foreignProxyItem_id", name = "foreignProxyItem_id_index")
+,@Index(columnList = "tousseDefinition_id", name = "tousseDefinition_id_index"),@Index(columnList = "reviewBasket_id", name = "reviewBasket_id_index")
+,@Index(columnList = "packingRecord_id", name = "packingRecord_id_index"),@Index(columnList = "sterilizationRecord_id", name = "sterilizationRecord_id_index")
+,@Index(columnList = "useRecord_id", name = "useRecord_id_index"),@Index(columnList = "invoice_id", name = "invoice_id_index")
+,@Index(columnList = "invoice_id", name = "invoice_id_index"),@Index(columnList = "foreignTousseApp_id", name = "foreignTousseApp_id_index")
+,@Index(columnList = "foreignTousseApp_id", name = "foreignTousseApp_id_index"),@Index(columnList = "proxyDisinfection_id", name = "proxyDisinfection_id_index")
+,@Index(columnList = "idCardInstanceID", name = "idCardInstanceID_index"),@Index(columnList = "operationTime", name = "operationTime_index")
+,@Index(columnList = "unTraceableTousse", name = "unTraceableTousse_index"),@Index(columnList = "tousseFixedBarcode", name = "tousseFixedBarcode_index")
+})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 @JsonFilter("fieldFilter")
 public class TousseInstance extends BarcodeDevice implements Comparable{
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/message/SystemMessage.java
===================================================================
diff -u -r12331 -r16182
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/message/SystemMessage.java	(.../SystemMessage.java)	(revision 12331)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/message/SystemMessage.java	(.../SystemMessage.java)	(revision 16182)
@@ -8,6 +8,7 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.Table;
 
 import org.hibernate.annotations.Cache;
@@ -19,7 +20,8 @@
  *
  */
 @Entity
-@Table(name = "System_Message")
+@Table(name = "System_Message",indexes={@Index(columnList="startDate",name="startDate_index"),@Index(columnList="endDate",name="endDate_index")
+,@Index(columnList="location",name="location_index"),@Index(columnList="publishTime",name="publishTime_index")})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class SystemMessage implements Serializable {
 	private static final long serialVersionUID = 1L;