mysql语法优化,需要此语句在2秒内处理完数据,表数据有50w条

Question

update temp_trend_Reason1 AS M set M.MovementCodePre2=(select A.MovementCode from hr_equipment_trend AS A WHERE A.EquipmentNo=M.EquipmentNo AND A.ISDISABLED=0 AND A.ActivityDate<M.ActivityDatePre1 and A.MovementCode not in ('SNTR','RCVR') ORDER BY A.ActivityDate DESC LIMIT 1 ),
M.DepotPre2=(select A.Depot from hr_equipment_trend AS A WHERE A.EquipmentNo=M.EquipmentNo AND A.ISDISABLED=0 AND A.ActivityDate<M.ActivityDatePre1
and A.MovementCode not in ('SNTR','RCVR') ORDER BY A.ActivityDate DESC LIMIT 1 ),
M.ActivityDatePre2=(select A.ActivityDate from hr_equipment_trend AS A WHERE A.EquipmentNo=M.EquipmentNo AND A.ISDISABLED=0 AND A.ActivityDate<M.ActivityDatePre1 and A.MovementCode not in ('SNTR','RCVR') ORDER BY A.ActivityDate DESC LIMIT 1 );

Answer 1

需要远程指导下处理成功,处理成功后可额外加费用