重现步骤
数据库:zhcxkj-center-strategy
查询时间:11.7982
扫描行数:38406.1
发送行数:0
指纹SQL: update t_amazon_full_custody_discount_msku set status = ? , remark = ? , sync_status = ? where full_custody_strategy_id = ? ;
真实SQL:update t_amazon_full_custody_discount_msku set status = 3 , remark = 亚马逊价格折扣活动msku状态为删除 , sync_status = 0 where full_custody_strategy_id = 789523 ;
袁慧斌,人工修改过
AISQL修改建议:仅支持select分析,检查是否缺少索引
explain表:
额外建议:
索引建议:
ALTER TABLE `t_amazon_full_custody_discount_msku`
ADD INDEX `idx_full_custody_strategy_id`(`full_custody_strategy_id`) USING BTREE;