深圳智汇创想科技有限公司

UPDATE Apx_BasicPlan_Log a
	LEFT JOIN (SELECT a.DeleteCheckId, SUM(IF(a.`Status` > 1, 2, 1)) / COUNT(a.Id) AS Status
		FROM apx_basicplan_logdetail a
		WHERE a.DeleteCheckId = 16887469
			AND a.CustomerId = 1
			AND PlanId = 28
		GROUP BY a.DeleteCheckId
		) b ON a.Id = b.DeleteCheckId
SET a.`Status` = IF(b.Status IS NULL, 0, IF(b.Status = 1, 1, IF(b.Status = 2, 2, 3)))
WHERE a.CustomerId = 1
	AND a.Id = 16887469

执行次数：463.35k   平均时间：37.94    最大时间：17.58M

频率太高，主库cpu被打满，是否可以从业务方面优化。