深圳智汇创想科技有限公司

001- 反馈人：袁慧斌
001+ 反馈人：袁慧斌 数据库：zhcxkj-center-product 查询时间：15.8017 扫描行数：270685 发送行数：0.253247 指纹SQL: SELECT id , source_type , info_id , title_cn , title_en , img_url , sku_array , asin_array , collect_img_keyword_status , collect_img_keyword_update , collect_asin_indic_status , collect_asin_indic_update , collect_sku_relation_asin_status , collect_sku_relation_asin_update , sync_title_asin_status , sync_title_asin_update , sync_image_asin_status , sync_image_asin_update , calculate_last_month_asin_status , calculate_last_month_asin_update , 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 , ai_score_status , is_deleted , create_by , create_time , update_by , update_time , jp_indicator_status , jp_indicator_update , simi_indicator_status , simi_indicator_update , ai_composite_score_status , ai_composite_score_update , ai_composite_score , platform_class_id , platform_class_name , simi_indicator_time FROM ? WHERE ( JSON_OVERLAPS ( sku_array -> ? , CAST ( ? AS JSON ) ) AND source_type IN ( ? , ? , ? ) ) limit ? ; 真实SQL：SELECT id,source_type,info_id,title_cn,title_en,img_url,sku_array,asin_array,collect_img_keyword_status,collect_img_keyword_update,collect_asin_indic_status,collect_asin_indic_update,collect_sku_relation_asin_status,collect_sku_relation_asin_update,sync_title_asin_status,sync_title_asin_update,sync_image_asin_status,sync_image_asin_update,calculate_last_month_asin_status,calculate_last_month_asin_update,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,ai_score_status,is_deleted,create_by,create_time,update_by,update_time,jp_indicator_status,jp_indicator_update,simi_indicator_status,simi_indicator_update,ai_composite_score_status,ai_composite_score_update,ai_composite_score,platform_class_id,platform_class_name,simi_indicator_time FROM t_kylin_sku_dev_info WHERE (JSON_OVERLAPS(sku_array->[*], CAST([10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500; 无人工修改 AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500 at line 1") explain表： 额外建议： 索引建议：
002- 数据库：zhcxkj-center-product
003- 查询时间：15.8017
004- 扫描行数：270685
005- 发送行数：0.253247
006- 指纹SQL: SELECT id , source_type , info_id , title_cn , title_en , img_url , sku_array , asin_array , collect_img_keyword_status , collect_img_keyword_update , collect_asin_indic_status , collect_asin_indic_update , collect_sku_relation_asin_status , collect_sku_relation_asin_update , sync_title_asin_status , sync_title_asin_update , sync_image_asin_status , sync_image_asin_update , calculate_last_month_asin_status , calculate_last_month_asin_update , 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 , ai_score_status , is_deleted , create_by , create_time , update_by , update_time , jp_indicator_status , jp_indicator_update , simi_indicator_status , simi_indicator_update , ai_composite_score_status , ai_composite_score_update , ai_composite_score , platform_class_id , platform_class_name , simi_indicator_time FROM ? WHERE ( JSON_OVERLAPS ( sku_array -> ? , CAST ( ? AS JSON ) ) AND source_type IN ( ? , ? , ? ) ) limit ? ;
007- 真实SQL：SELECT id,source_type,info_id,title_cn,title_en,img_url,sku_array,asin_array,collect_img_keyword_status,collect_img_keyword_update,collect_asin_indic_status,collect_asin_indic_update,collect_sku_relation_asin_status,collect_sku_relation_asin_update,sync_title_asin_status,sync_title_asin_update,sync_image_asin_status,sync_image_asin_update,calculate_last_month_asin_status,calculate_last_month_asin_update,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,ai_score_status,is_deleted,create_by,create_time,update_by,update_time,jp_indicator_status,jp_indicator_update,simi_indicator_status,simi_indicator_update,ai_composite_score_status,ai_composite_score_update,ai_composite_score,platform_class_id,platform_class_name,simi_indicator_time FROM t_kylin_sku_dev_info WHERE (JSON_OVERLAPS(sku_array->[*], CAST([10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500;
008- 无人工修改
009- AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500 at line 1")
010- explain表：
011- 额外建议：
012- 索引建议：
013-

001- 反馈人：袁慧斌<br />
001+ 反馈人：袁慧斌<br /> 数据库：zhcxkj-center-product<br /> 查询时间：15.8017<br /> 扫描行数：270685<br /> 发送行数：0.253247<br /> 指纹SQL: SELECT id , source_type , info_id , title_cn , title_en , img_url , sku_array , asin_array , collect_img_keyword_status , collect_img_keyword_update , collect_asin_indic_status , collect_asin_indic_update , collect_sku_relation_asin_status , collect_sku_relation_asin_update , sync_title_asin_status , sync_title_asin_update , sync_image_asin_status , sync_image_asin_update , calculate_last_month_asin_status , calculate_last_month_asin_update , 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 , ai_score_status , is_deleted , create_by , create_time , update_by , update_time , jp_indicator_status , jp_indicator_update , simi_indicator_status , simi_indicator_update , ai_composite_score_status , ai_composite_score_update , ai_composite_score , platform_class_id , platform_class_name , simi_indicator_time FROM ? WHERE ( JSON_OVERLAPS ( sku_array -&gt; ? , CAST ( ? AS JSON ) ) AND source_type IN ( ? , ? , ? ) ) limit ? ;<br /> 真实SQL：SELECT id,source_type,info_id,title_cn,title_en,img_url,sku_array,asin_array,collect_img_keyword_status,collect_img_keyword_update,collect_asin_indic_status,collect_asin_indic_update,collect_sku_relation_asin_status,collect_sku_relation_asin_update,sync_title_asin_status,sync_title_asin_update,sync_image_asin_status,sync_image_asin_update,calculate_last_month_asin_status,calculate_last_month_asin_update,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,ai_score_status,is_deleted,create_by,create_time,update_by,update_time,jp_indicator_status,jp_indicator_update,simi_indicator_status,simi_indicator_update,ai_composite_score_status,ai_composite_score_update,ai_composite_score,platform_class_id,platform_class_name,simi_indicator_time FROM t_kylin_sku_dev_info WHERE (JSON_OVERLAPS(sku_array-&gt;[*], CAST([10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500;<br /> 无人工修改<br /> AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500 at line 1")<br /> explain表：<br /> 额外建议：<br /> 索引建议：<br /><br />
002- 数据库：zhcxkj-center-product<br />
003- 查询时间：15.8017<br />
004- 扫描行数：270685<br />
005- 发送行数：0.253247<br />
006- 指纹SQL: SELECT id , source_type , info_id , title_cn , title_en , img_url , sku_array , asin_array , collect_img_keyword_status , collect_img_keyword_update , collect_asin_indic_status , collect_asin_indic_update , collect_sku_relation_asin_status , collect_sku_relation_asin_update , sync_title_asin_status , sync_title_asin_update , sync_image_asin_status , sync_image_asin_update , calculate_last_month_asin_status , calculate_last_month_asin_update , 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 , ai_score_status , is_deleted , create_by , create_time , update_by , update_time , jp_indicator_status , jp_indicator_update , simi_indicator_status , simi_indicator_update , ai_composite_score_status , ai_composite_score_update , ai_composite_score , platform_class_id , platform_class_name , simi_indicator_time FROM ? WHERE ( JSON_OVERLAPS ( sku_array -&gt; ? , CAST ( ? AS JSON ) ) AND source_type IN ( ? , ? , ? ) ) limit ? ;<br />
007- 真实SQL：SELECT id,source_type,info_id,title_cn,title_en,img_url,sku_array,asin_array,collect_img_keyword_status,collect_img_keyword_update,collect_asin_indic_status,collect_asin_indic_update,collect_sku_relation_asin_status,collect_sku_relation_asin_update,sync_title_asin_status,sync_title_asin_update,sync_image_asin_status,sync_image_asin_update,calculate_last_month_asin_status,calculate_last_month_asin_update,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,ai_score_status,is_deleted,create_by,create_time,update_by,update_time,jp_indicator_status,jp_indicator_update,simi_indicator_status,simi_indicator_update,ai_composite_score_status,ai_composite_score_update,ai_composite_score,platform_class_id,platform_class_name,simi_indicator_time FROM t_kylin_sku_dev_info WHERE (JSON_OVERLAPS(sku_array-&gt;[*], CAST([10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500;<br />
008- 无人工修改<br />
009- AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 10959705] AS JSON)) AND source_type IN (1,2,3)) limit 500 at line 1")<br />
010- explain表：<br />
011- 额外建议：<br />
012- 索引建议：<br />
013- <br />