001- 反馈人：李冠
001+ 反馈人：李冠 严重级别：一般 所属项目：java产品库（麒麟模型未成形产品指标得分） 问题原因：慢SQL、执行了20秒左右，全表扫，截断SQL为：（ SELECT id,product_link,development_success_sku,site_code,current_status,current_status_description,first_level_audit_id,first_level_audit_id2,create_time,ori_update_time,asin,sku_array,collect_sku,jp_ave_month_sales_rev,jp_mid_month_sales_rev,jp_ave_month_sales_num,jp_mid_month_sales_num,jp_ave_position,jp_mid_position,jp_ave_comment_num,jp_mid_comment_num,jp_ave_score,jp_mid_score,jp_ave_month_sales_rev_per,jp_ave_month_sales_num_per,jp_ave_month_sales_rev_mom,jp_ave_month_sales_num_mom,jp_som_mom,jp_ave_postion_mom,jp_ave_comment_num_mom,jp_ave_score_mom,jp_num,jp_stores_num,jp_sales_num_stores_per,jp_sales_rev_stores_per,jp_publish_stores_num,competitive_quality_score,competitive_quality_score_update,clean_status,clean_time,collect_status,collect_time,ai_score_status,update_time,product_name,product_art_work_url FROM t_kylin_sku_develop_indicator_score WHERE (id > 0 AND clean_status = 0) ORDER BY id ASC limit 500; ） 解决方案：使用合适的索引
002- 严重级别：一般
003- 所属项目：java产品库（麒麟模型未成形产品指标得分）
004- 问题原因：慢SQL、执行了20秒左右，全表扫，截断SQL为：（
005- SELECT id,product_link,development_success_sku,site_code,current_status,current_status_description,first_level_audit_id,first_level_audit_id2,create_time,ori_update_time,asin,sku_array,collect_sku,jp_ave_month_sales_rev,jp_mid_month_sales_rev,jp_ave_month_sales_num,jp_mid_month_sales_num,jp_ave_position,jp_mid_position,jp_ave_comment_num,jp_mid_comment_num,jp_ave_score,jp_mid_score,jp_ave_month_sales_rev_per,jp_ave_month_sales_num_per,jp_ave_month_sales_rev_mom,jp_ave_month_sales_num_mom,jp_som_mom,jp_ave_postion_mom,jp_ave_comment_num_mom,jp_ave_score_mom,jp_num,jp_stores_num,jp_sales_num_stores_per,jp_sales_rev_stores_per,jp_publish_stores_num,competitive_quality_score,competitive_quality_score_update,clean_status,clean_time,collect_status,collect_time,ai_score_status,update_time,product_name,product_art_work_url FROM t_kylin_sku_develop_indicator_score WHERE (id > 0 AND clean_status = 0) ORDER BY id ASC limit 500;
006-
007- ）
008- 解决方案：使用合适的索引

001- 反馈人：李冠<br />
001+ 反馈人：李冠<br /> 严重级别：一般<br /> 所属项目：java产品库（麒麟模型未成形产品指标得分）<br /> 问题原因：慢SQL、执行了20秒左右，全表扫，截断SQL为：（<br /> SELECT id,product_link,development_success_sku,site_code,current_status,current_status_description,first_level_audit_id,first_level_audit_id2,create_time,ori_update_time,asin,sku_array,collect_sku,jp_ave_month_sales_rev,jp_mid_month_sales_rev,jp_ave_month_sales_num,jp_mid_month_sales_num,jp_ave_position,jp_mid_position,jp_ave_comment_num,jp_mid_comment_num,jp_ave_score,jp_mid_score,jp_ave_month_sales_rev_per,jp_ave_month_sales_num_per,jp_ave_month_sales_rev_mom,jp_ave_month_sales_num_mom,jp_som_mom,jp_ave_postion_mom,jp_ave_comment_num_mom,jp_ave_score_mom,jp_num,jp_stores_num,jp_sales_num_stores_per,jp_sales_rev_stores_per,jp_publish_stores_num,competitive_quality_score,competitive_quality_score_update,clean_status,clean_time,collect_status,collect_time,ai_score_status,update_time,product_name,product_art_work_url FROM t_kylin_sku_develop_indicator_score WHERE (id &gt; 0 AND clean_status = 0) ORDER BY id ASC limit 500;<br /><br /> ）<br /> 解决方案：使用合适的索引
002- 严重级别：一般<br />
003- 所属项目：java产品库（麒麟模型未成形产品指标得分）<br />
004- 问题原因：慢SQL、执行了20秒左右，全表扫，截断SQL为：（<br />
005- SELECT id,product_link,development_success_sku,site_code,current_status,current_status_description,first_level_audit_id,first_level_audit_id2,create_time,ori_update_time,asin,sku_array,collect_sku,jp_ave_month_sales_rev,jp_mid_month_sales_rev,jp_ave_month_sales_num,jp_mid_month_sales_num,jp_ave_position,jp_mid_position,jp_ave_comment_num,jp_mid_comment_num,jp_ave_score,jp_mid_score,jp_ave_month_sales_rev_per,jp_ave_month_sales_num_per,jp_ave_month_sales_rev_mom,jp_ave_month_sales_num_mom,jp_som_mom,jp_ave_postion_mom,jp_ave_comment_num_mom,jp_ave_score_mom,jp_num,jp_stores_num,jp_sales_num_stores_per,jp_sales_rev_stores_per,jp_publish_stores_num,competitive_quality_score,competitive_quality_score_update,clean_status,clean_time,collect_status,collect_time,ai_score_status,update_time,product_name,product_art_work_url FROM t_kylin_sku_develop_indicator_score WHERE (id &gt; 0 AND clean_status = 0) ORDER BY id ASC limit 500;<br />
006- <br />
007- ）<br />
008- 解决方案：使用合适的索引