Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java
===================================================================
diff -u -r36780 -r36796
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java	(.../TousseInstance.java)	(revision 36780)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java	(.../TousseInstance.java)	(revision 36796)
@@ -115,6 +115,8 @@
 ,@Index(columnList = "sterilizationRecord_id,invoice_id,reviewBasket_id,tousseDefinition_id,materialAmount,invoice2_id", name = "tis_sirtmi_index")
 //加速包件混合的发货物品查询
 ,@Index(columnList = "invoice_id,id,tousseDefinition_id,invoice2_id,materialAmount", name = "tis_iitim_index")
+//系统告警查询优化
+,@Index(columnList = "location,comboTousseInstanceId,invoice2_id,status,validUntil", name = "tis_lcisv_index")
 })
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 @JsonFilter("fieldFilter")