修改了
所属项目 ，旧值为 "51"，新值为 "52"。
修改了
所属模块 ，旧值为 "0"，新值为 "1914"。
修改了
业务部门 ，旧值为 "0"，新值为 "2"。
修改了
开发责任人，旧值为 ""，新值为 "xiaojunjie"。
修改了
测试责任人，旧值为 ""，新值为 "xiaojunjie"。
修改了
解决时效 ，旧值为 "0"，新值为 "116.88"。
修改了
重现步骤 ，区别为：
001- 反馈人：袁慧斌
001+ 反馈人：袁慧斌 数据库：zhcxkj_center_listing_comprehensive 查询时间：492.963 扫描行数：14610000 发送行数：2794610 指纹SQL: SELECT distinct a . company , a . source_id , b . sku FROM ( SELECT a . source_id , a . source_name , a . company FROM ? . t_order_source_config a WHERE a . is_deleted = ? ORDER BY a . company ) a LEFT JOIN ( SELECT a . source_id , a . source_name , a . source_sku , a . sku FROM ? . t_listing_ozon a where a . is_deleted = ? AND a . status in ( ? , ? ) -- 在线的 ) b ON a.source_id = b.source_id; 真实SQL：SELECT distinct a.company, a.source_id, b.sku FROM ( SELECT a.source_id,a.source_name,a.company FROM zhcxkj_center_listing_comprehensive.t_order_source_config a WHERE a.is_deleted = 0 ORDER BY a.company ) a LEFT JOIN ( SELECT a.source_id, a.source_name, a.source_sku, a.sku FROM zhcxkj_center_listing_comprehensive.t_listing_ozon a where a.is_deleted = 0 AND a.status in (3,6) -- 在线的 ) b ON a.source_id = b.source_id; ##袁慧斌,人工修改过## AISQL修改建议：ALTER TABLE 'zhcxkj_center_listing_comprehensive'.'t_listing_ozon' ADD INDEX 'idx_status_isdeleted' ('status', 'is_deleted') explain表： 额外建议： 索引建议：
002- 数据库：zhcxkj_center_listing_comprehensive
003- 查询时间：492.963
004- 扫描行数：14610000
005- 发送行数：2794610
006- 指纹SQL: SELECT distinct a . company , a . source_id , b . sku FROM ( SELECT a . source_id , a . source_name , a . company FROM ? . t_order_source_config a WHERE a . is_deleted = ? ORDER BY a . company ) a LEFT JOIN ( SELECT a . source_id , a . source_name , a . source_sku , a . sku FROM ? . t_listing_ozon a where a . is_deleted = ? AND a . status in ( ? , ? ) -- 在线的 ) b ON a.source_id = b.source_id;
007- 真实SQL：SELECT distinct a.company, a.source_id, b.sku FROM ( SELECT a.source_id,a.source_name,a.company FROM zhcxkj_center_listing_comprehensive.t_order_source_config a WHERE a.is_deleted = 0 ORDER BY a.company ) a LEFT JOIN ( SELECT a.source_id, a.source_name, a.source_sku, a.sku FROM zhcxkj_center_listing_comprehensive.t_listing_ozon a where a.is_deleted = 0 AND a.status in (3,6) -- 在线的 ) b ON a.source_id = b.source_id;
008- ##袁慧斌,人工修改过##
009- AISQL修改建议：ALTER TABLE 'zhcxkj_center_listing_comprehensive'.'t_listing_ozon' ADD INDEX 'idx_status_isdeleted' ('status', 'is_deleted')
010- explain表：
011- 额外建议：
012- 索引建议：
013-
001- 反馈人：袁慧斌<br />
001+ 反馈人：袁慧斌<br /> 数据库：zhcxkj_center_listing_comprehensive<br /> 查询时间：492.963<br /> 扫描行数：14610000<br /> 发送行数：2794610<br /> 指纹SQL: SELECT distinct a . company , a . source_id , b . sku FROM ( SELECT a . source_id , a . source_name , a . company FROM ? . t_order_source_config a WHERE a . is_deleted = ? ORDER BY a . company ) a LEFT JOIN ( SELECT a . source_id , a . source_name , a . source_sku , a . sku FROM ? . t_listing_ozon a where a . is_deleted = ? AND a . status in ( ? , ? ) -- 在线的 ) b ON a.source_id = b.source_id;<br /> 真实SQL：SELECT distinct a.company, a.source_id, b.sku FROM ( SELECT a.source_id,a.source_name,a.company FROM zhcxkj_center_listing_comprehensive.t_order_source_config a WHERE a.is_deleted = 0 ORDER BY a.company ) a LEFT JOIN ( SELECT a.source_id, a.source_name, a.source_sku, a.sku FROM zhcxkj_center_listing_comprehensive.t_listing_ozon a where a.is_deleted = 0 AND a.status in (3,6) -- 在线的 ) b ON a.source_id = b.source_id;<br /> ##袁慧斌,人工修改过##<br /> AISQL修改建议：ALTER TABLE 'zhcxkj_center_listing_comprehensive'.'t_listing_ozon' ADD INDEX 'idx_status_isdeleted' ('status', 'is_deleted')<br /> explain表：<br /> 额外建议：<br /> 索引建议：<br /><br />
002- 数据库：zhcxkj_center_listing_comprehensive<br />
003- 查询时间：492.963<br />
004- 扫描行数：14610000<br />
005- 发送行数：2794610<br />
006- 指纹SQL: SELECT distinct a . company , a . source_id , b . sku FROM ( SELECT a . source_id , a . source_name , a . company FROM ? . t_order_source_config a WHERE a . is_deleted = ? ORDER BY a . company ) a LEFT JOIN ( SELECT a . source_id , a . source_name , a . source_sku , a . sku FROM ? . t_listing_ozon a where a . is_deleted = ? AND a . status in ( ? , ? ) -- 在线的 ) b ON a.source_id = b.source_id;<br />
007- 真实SQL：SELECT distinct a.company, a.source_id, b.sku FROM ( SELECT a.source_id,a.source_name,a.company FROM zhcxkj_center_listing_comprehensive.t_order_source_config a WHERE a.is_deleted = 0 ORDER BY a.company ) a LEFT JOIN ( SELECT a.source_id, a.source_name, a.source_sku, a.sku FROM zhcxkj_center_listing_comprehensive.t_listing_ozon a where a.is_deleted = 0 AND a.status in (3,6) -- 在线的 ) b ON a.source_id = b.source_id;<br />
008- ##袁慧斌,人工修改过##<br />
009- AISQL修改建议：ALTER TABLE 'zhcxkj_center_listing_comprehensive'.'t_listing_ozon' ADD INDEX 'idx_status_isdeleted' ('status', 'is_deleted')<br />
010- explain表：<br />
011- 额外建议：<br />
012- 索引建议：<br />
013- <br />