Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java =================================================================== diff -u -r36683 -r36686 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java (.../TousseInstance.java) (revision 36683) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/basedatamanager/toussedefinition/TousseInstance.java (.../TousseInstance.java) (revision 36686) @@ -104,6 +104,7 @@ ,@Index(columnList = "location_2", name = "tis_location_2_index") ,@Index(columnList = "recallRecordItem_id", name = "tis_recallItem_Id_index") ,@Index(columnList = "validUntil", name = "tis_validUntil_index") +,@Index(columnList = "urgentLevel_id", name = "tis_urgentLvId_index") ,@Index(columnList = "lastStorageLocationId", name = "tis_lastStorage_id_index") ,@Index(columnList = "settleAccountsDepartCode", name = "tis_settleAccoDeptCode_index") //效果包含但不限于加速器械包工作量报表查询(提升很大 效果不是很大 以20NFYKDXFSDSYY数据库为例子 查询器械包工作量报表中装配工作量21年到23年8月的数据 从26秒变为1s)