Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/tousseitem/TousseItem.java
===================================================================
diff -u -r34770 -r36639
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/tousseitem/TousseItem.java	(.../TousseItem.java)	(revision 34770)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/tousseitem/TousseItem.java	(.../TousseItem.java)	(revision 36639)
@@ -46,6 +46,8 @@
 ,@Index(columnList="tousseName",name="TousseItem_tn_index")
 ,@Index(columnList="expressInvoice",name="expressInvoice_index")
 ,@Index(columnList="diposable",name="diposable_index")
+//效果包含但不限于加速器械包工作量报表查询(效果不是很大 以20NFYKDXFSDSYY数据库为例子 查询器械包工作量报表中申请工作量21年到23年8月的数据 从3秒变为1s)
+,@Index(columnList = "tousseType,amount,tousseDefinitionId,recyclingApplication_ID", name = "TousseItem_tatr_index")
 })
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class TousseItem implements IDAble{
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java
===================================================================
diff -u -r36327 -r36639
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java	(.../TousseInstance.java)	(revision 36327)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java	(.../TousseInstance.java)	(revision 36639)
@@ -103,6 +103,8 @@
 ,@Index(columnList = "invoice2_id", name = "tis_invoice2_id_index")
 ,@Index(columnList = "lastStorageLocationId", name = "tis_lastStorage_id_index")
 ,@Index(columnList = "settleAccountsDepartCode", name = "tis_settleAccoDeptCode_index")
+//效果包含但不限于加速器械包工作量报表查询(提升很大 效果不是很大 以20NFYKDXFSDSYY数据库为例子 查询器械包工作量报表中装配工作量21年到23年8月的数据 从26秒变为1s)
+,@Index(columnList = "orgUnitCoding,operationTime,tousseDefinition_id,materialAmount,disposableGoodAmount", name = "tis_ootmd_index")
 })
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 @JsonFilter("fieldFilter")