参考:
(1)警惕 MySql 更新 sql 的 WHERE 从句中的 IN() 子查询时出现的性能陷阱:https://blog.csdn.net/defonds/article/details/46745143
我:
UPDATE sn_batch_details SET packing_record = packing_record + 1 WHERE id IN (SELECT sn_id FROM big_box_sn WHERE big_box_id = 4444)
// 以上语句查询极度缓慢,应该拆分为以下两句,分别执行
SELECT sn_id FROM big_box_sn WHERE big_box_id = 4444
UPDATE sn_batch_details SET packing_record = packing_record + 1 WHERE id IN (111,222,333,444,555)