001- 反馈人：吴荣发
001+ 反馈人：吴荣发 数据库：zhcxkj-center-product 节点ID：be025fa3101b4053b1dcc78d8e9c210fin01 查询时间：41.019 扫描行数：726743.0 返回行数：0.5 一天执行次数： 40 慢日志时间：2025-07-25 指纹：25744c16972bf991ce340dd4c5560dc7 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 ? WHERE ( JSON_OVERLAPS ( sku_array , CAST ( '?' AS JSON ) ) ) limit ? ; 真实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 (JSON_OVERLAPS(sku_array, CAST('['17893413','19137504','19580032','21488765','21536080','21553013','21558034','21561232','21561761','21568721','21569353','21570620','21577275','21578176','21579003','21579105','21579136','21581714','21585809','21587094','21588231','21589003','21589593','21590268','21590403','21590530','21590605','21595641','21595681','21595843','21597528','21597938','21597998','21597980','21599281','21599344','21599580','21603641','21603877','21604293','21604997','21605436','21605890','21606277','21606827','21607439','21607499','21607640','21607652','21607699','21607761','21607803','21607862','21608343','21608551','21609237','21611133','21612502','21614718','21614851','21614922','21615030','21615157','21615139','21615249','21615413','21615611','21615692','21615831','21615965','21616150','21616216','21616625','21616641','21616655','21616723','21616718','21616774','21616783','21616831','21616787','21616903','21617003','21617053','21617174','21617235','21617227','21617241','21617318','21617353','21617373','21617391','21617437','21617486','21617511','21617534','21617565','21617955','21617979','21617920','21618014','21618037','21618034','21618120','21618141','21618253','21618293','21618341','21618389','21618411','21618442','21618467','21618486','21618525','21618945','21618951','21618943','21619004','21619062','21619071','21619149','21619234','21619175','21619317','21619244','21619513','21619544','21619674','21622110','21622232','21622276','21622263','21622282','21622386','21622372','21622451','21622581','21622608','21622687','21622727','21622778','21622812','21622817','21622795','21622863','21622966','21623116','21623122','21623130','21623214','21623270','21623309','21623333','21623727','21623813','21623686','21624014','21624021','21624060','21624119','21624070','21624111','21624095','21624161','21624155','21624239','21624313','21624329','21624462','21624528','21624549','21624563','21624580','21624604','21624686','21624612','21624620','21624742','21624692','21624808','21624879','21624940','21624947','21625025','21625112','21625133','21625117','21625231','21625234','21625273','21625254','21625363','21625361','21625370','21625434','21625449','21625470','21625392','21625464','21625493']' AS JSON))) limit 1000; 负责人参考：公用 项目参考：java项目
002- 数据库：zhcxkj-center-product
003- 节点ID：be025fa3101b4053b1dcc78d8e9c210fin01
004- 查询时间：41.019
005- 扫描行数：726743.0
006- 返回行数：0.5
007- 一天执行次数： 40
008- 慢日志时间：2025-07-25
009- 指纹：25744c16972bf991ce340dd4c5560dc7
010- 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 ? WHERE ( JSON_OVERLAPS ( sku_array , CAST ( '?' AS JSON ) ) ) limit ? ;
011- 真实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 (JSON_OVERLAPS(sku_array, CAST('['17893413','19137504','19580032','21488765','21536080','21553013','21558034','21561232','21561761','21568721','21569353','21570620','21577275','21578176','21579003','21579105','21579136','21581714','21585809','21587094','21588231','21589003','21589593','21590268','21590403','21590530','21590605','21595641','21595681','21595843','21597528','21597938','21597998','21597980','21599281','21599344','21599580','21603641','21603877','21604293','21604997','21605436','21605890','21606277','21606827','21607439','21607499','21607640','21607652','21607699','21607761','21607803','21607862','21608343','21608551','21609237','21611133','21612502','21614718','21614851','21614922','21615030','21615157','21615139','21615249','21615413','21615611','21615692','21615831','21615965','21616150','21616216','21616625','21616641','21616655','21616723','21616718','21616774','21616783','21616831','21616787','21616903','21617003','21617053','21617174','21617235','21617227','21617241','21617318','21617353','21617373','21617391','21617437','21617486','21617511','21617534','21617565','21617955','21617979','21617920','21618014','21618037','21618034','21618120','21618141','21618253','21618293','21618341','21618389','21618411','21618442','21618467','21618486','21618525','21618945','21618951','21618943','21619004','21619062','21619071','21619149','21619234','21619175','21619317','21619244','21619513','21619544','21619674','21622110','21622232','21622276','21622263','21622282','21622386','21622372','21622451','21622581','21622608','21622687','21622727','21622778','21622812','21622817','21622795','21622863','21622966','21623116','21623122','21623130','21623214','21623270','21623309','21623333','21623727','21623813','21623686','21624014','21624021','21624060','21624119','21624070','21624111','21624095','21624161','21624155','21624239','21624313','21624329','21624462','21624528','21624549','21624563','21624580','21624604','21624686','21624612','21624620','21624742','21624692','21624808','21624879','21624940','21624947','21625025','21625112','21625133','21625117','21625231','21625234','21625273','21625254','21625363','21625361','21625370','21625434','21625449','21625470','21625392','21625464','21625493']' AS JSON))) limit 1000;
012- 负责人参考：公用
013- 项目参考：java项目

001- 反馈人：吴荣发<br />
001+ 反馈人：吴荣发<br /> 数据库：zhcxkj-center-product<br /> 节点ID：be025fa3101b4053b1dcc78d8e9c210fin01<br /> 查询时间：41.019<br /> 扫描行数：726743.0<br /> 返回行数：0.5<br /> 一天执行次数： 40<br /> 慢日志时间：2025-07-25<br /> 指纹：25744c16972bf991ce340dd4c5560dc7<br /> 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 ? WHERE ( JSON_OVERLAPS ( sku_array , CAST ( '?' AS JSON ) ) ) limit ? ;<br /> 真实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 (JSON_OVERLAPS(sku_array, CAST('['17893413','19137504','19580032','21488765','21536080','21553013','21558034','21561232','21561761','21568721','21569353','21570620','21577275','21578176','21579003','21579105','21579136','21581714','21585809','21587094','21588231','21589003','21589593','21590268','21590403','21590530','21590605','21595641','21595681','21595843','21597528','21597938','21597998','21597980','21599281','21599344','21599580','21603641','21603877','21604293','21604997','21605436','21605890','21606277','21606827','21607439','21607499','21607640','21607652','21607699','21607761','21607803','21607862','21608343','21608551','21609237','21611133','21612502','21614718','21614851','21614922','21615030','21615157','21615139','21615249','21615413','21615611','21615692','21615831','21615965','21616150','21616216','21616625','21616641','21616655','21616723','21616718','21616774','21616783','21616831','21616787','21616903','21617003','21617053','21617174','21617235','21617227','21617241','21617318','21617353','21617373','21617391','21617437','21617486','21617511','21617534','21617565','21617955','21617979','21617920','21618014','21618037','21618034','21618120','21618141','21618253','21618293','21618341','21618389','21618411','21618442','21618467','21618486','21618525','21618945','21618951','21618943','21619004','21619062','21619071','21619149','21619234','21619175','21619317','21619244','21619513','21619544','21619674','21622110','21622232','21622276','21622263','21622282','21622386','21622372','21622451','21622581','21622608','21622687','21622727','21622778','21622812','21622817','21622795','21622863','21622966','21623116','21623122','21623130','21623214','21623270','21623309','21623333','21623727','21623813','21623686','21624014','21624021','21624060','21624119','21624070','21624111','21624095','21624161','21624155','21624239','21624313','21624329','21624462','21624528','21624549','21624563','21624580','21624604','21624686','21624612','21624620','21624742','21624692','21624808','21624879','21624940','21624947','21625025','21625112','21625133','21625117','21625231','21625234','21625273','21625254','21625363','21625361','21625370','21625434','21625449','21625470','21625392','21625464','21625493']' AS JSON))) limit 1000;<br /> 负责人参考：公用<br /> 项目参考：java项目<br />
002- 数据库：zhcxkj-center-product<br />
003- 节点ID：be025fa3101b4053b1dcc78d8e9c210fin01<br />
004- 查询时间：41.019<br />
005- 扫描行数：726743.0<br />
006- 返回行数：0.5<br />
007- 一天执行次数： 40<br />
008- 慢日志时间：2025-07-25<br />
009- 指纹：25744c16972bf991ce340dd4c5560dc7<br />
010- 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 ? WHERE ( JSON_OVERLAPS ( sku_array , CAST ( '?' AS JSON ) ) ) limit ? ;<br />
011- 真实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 (JSON_OVERLAPS(sku_array, CAST('['17893413','19137504','19580032','21488765','21536080','21553013','21558034','21561232','21561761','21568721','21569353','21570620','21577275','21578176','21579003','21579105','21579136','21581714','21585809','21587094','21588231','21589003','21589593','21590268','21590403','21590530','21590605','21595641','21595681','21595843','21597528','21597938','21597998','21597980','21599281','21599344','21599580','21603641','21603877','21604293','21604997','21605436','21605890','21606277','21606827','21607439','21607499','21607640','21607652','21607699','21607761','21607803','21607862','21608343','21608551','21609237','21611133','21612502','21614718','21614851','21614922','21615030','21615157','21615139','21615249','21615413','21615611','21615692','21615831','21615965','21616150','21616216','21616625','21616641','21616655','21616723','21616718','21616774','21616783','21616831','21616787','21616903','21617003','21617053','21617174','21617235','21617227','21617241','21617318','21617353','21617373','21617391','21617437','21617486','21617511','21617534','21617565','21617955','21617979','21617920','21618014','21618037','21618034','21618120','21618141','21618253','21618293','21618341','21618389','21618411','21618442','21618467','21618486','21618525','21618945','21618951','21618943','21619004','21619062','21619071','21619149','21619234','21619175','21619317','21619244','21619513','21619544','21619674','21622110','21622232','21622276','21622263','21622282','21622386','21622372','21622451','21622581','21622608','21622687','21622727','21622778','21622812','21622817','21622795','21622863','21622966','21623116','21623122','21623130','21623214','21623270','21623309','21623333','21623727','21623813','21623686','21624014','21624021','21624060','21624119','21624070','21624111','21624095','21624161','21624155','21624239','21624313','21624329','21624462','21624528','21624549','21624563','21624580','21624604','21624686','21624612','21624620','21624742','21624692','21624808','21624879','21624940','21624947','21625025','21625112','21625133','21625117','21625231','21625234','21625273','21625254','21625363','21625361','21625370','21625434','21625449','21625470','21625392','21625464','21625493']' AS JSON))) limit 1000;<br />
012- 负责人参考：公用<br />
013- 项目参考：java项目<br />