修改了
所属模块 ,旧值为 "0",新值为 "1874"。
修改了
业务部门 ,旧值为 "0",新值为 "2"。
修改了
开发责任人,旧值为 "",新值为 "wangjinfeng"。
修改了
测试责任人,旧值为 "",新值为 "wangjinfeng"。
修改了
解决时效 ,旧值为 "0",新值为 "1.91"。
修改了
重现步骤 ,区别为:
001- 反馈人:王凯
001+ 反馈人:王凯 数据库:zhcxkj_center_strategy_comprehensive 查询时间:35.9112 执行次数: 34 扫描行数:571201 发送行数:0 指纹SQL: UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = ? , update_by = ? , update_name = ? , update_time = ? where source_id = ? and site_id = ? and promotion_id = ? and is_deleted = ? and version != ? ; 真实SQL:UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = 1, update_by = 1, update_name = 系统管理员, update_time = 2025-09-23 12:00:36 where source_id = 20514 and site_id = MCO and promotion_id = P-MCO15385004 and is_deleted = 0 and version != 2025092311; 王凯,人工修改过 AISQL修改建议: explain表: 额外建议: 索引建议:
002- 数据库:zhcxkj_center_strategy_comprehensive
003- 查询时间:35.9112
004- 执行次数: 34
005- 扫描行数:571201
006- 发送行数:0
007- 指纹SQL: UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = ? , update_by = ? , update_name = ? , update_time = ? where source_id = ? and site_id = ? and promotion_id = ? and is_deleted = ? and version != ? ;
008- 真实SQL:UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = 1, update_by = 1, update_name = 系统管理员, update_time = 2025-09-23 12:00:36 where source_id = 20514 and site_id = MCO and promotion_id = P-MCO15385004 and is_deleted = 0 and version != 2025092311;
009- 王凯,人工修改过
010- AISQL修改建议:
011- explain表:
012- 额外建议:
013- 索引建议:
014-
001- 反馈人:王凯<br />
001+ 反馈人:王凯<br /> 数据库:zhcxkj_center_strategy_comprehensive<br /> 查询时间:35.9112<br /> 执行次数: 34<br /> 扫描行数:571201<br /> 发送行数:0<br /> 指纹SQL: UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = ? , update_by = ? , update_name = ? , update_time = ? where source_id = ? and site_id = ? and promotion_id = ? and is_deleted = ? and version != ? ;<br /> 真实SQL:UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = 1, update_by = 1, update_name = 系统管理员, update_time = 2025-09-23 12:00:36 where source_id = 20514 and site_id = MCO and promotion_id = P-MCO15385004 and is_deleted = 0 and version != 2025092311;<br /> 王凯,人工修改过<br /> AISQL修改建议:<br /> explain表:<br /> 额外建议:<br /> 索引建议:<br /><br />
002- 数据库:zhcxkj_center_strategy_comprehensive<br />
003- 查询时间:35.9112<br />
004- 执行次数: 34<br />
005- 扫描行数:571201<br />
006- 发送行数:0<br />
007- 指纹SQL: UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = ? , update_by = ? , update_name = ? , update_time = ? where source_id = ? and site_id = ? and promotion_id = ? and is_deleted = ? and version != ? ;<br />
008- 真实SQL:UPDATE t_promotion_candidate_detail_mercadolibre_3 set is_deleted = 1, update_by = 1, update_name = 系统管理员, update_time = 2025-09-23 12:00:36 where source_id = 20514 and site_id = MCO and promotion_id = P-MCO15385004 and is_deleted = 0 and version != 2025092311;<br />
009- 王凯,人工修改过<br />
010- AISQL修改建议:<br />
011- explain表:<br />
012- 额外建议:<br />
013- 索引建议:<br />
014- <br />