001-
001+ 反馈人：吴荣发
002- 反馈人：吴荣发
002+ 严重，产品库sql执行时间上千s，影响数据库
003-
003+ select rp.id, rp.sku, rp.product_name, rp.product_name_cn, rp.product_state, rp.last_buy_price, rp.is_group, rp.length, rp.width, rp.height, rp.gross_weight, rp.pack_weight, rpa.check_time, (select count(*) from t_product_sku_gtin tpsg where tpsg.sku = rp.sku ) as sku_export_num from rb_product as rp join rb_product_admin rpa on rp.sku = rpa.sku and rp.customer_id = rpa.customer_id and rpa.check_status = 1 and rp.delete_status = 0 WHERE rp.customer_id = 1 and rp.sku in ( '10303867' , '18843414' , '16768635' , '19532863' , '13998640' , '16542525' , '16518599' , '17700295' , '15927502' , '17506020' , '17425428' , '20850535' , '17338609' , '7974269' , '16215489' , '17255516' , '13194735' , '2536578' , '13667538' , '15999463' , '6251957' , '15807662' , '17284353' , '12603037' , '9924239' , '2241958' , '7543876' , '12091895' , '6573573' , '8489459' , '19673536' , '2488894' , '19481456' , '18051546' , '4528427' , '8081999' , '6752745' , '5770401' , '9980642' , '17374414' , '4871890' , '19379937' , '7554976' , '17941797' , '10340746' , '3501622' , '17822926' , '5746857' , '7066993' , '3972613' , '2431860' , '18744570' , '5065151' , '5946218' , '10989583' , '6567075' , '15587608' , '17313814' , '19196489' , '17742703' , '16171465' , '7340523' , '19150368' , '15968792' , '19493956' , '17098236' , '1730690' , '14999135' , '17482804' , '16556374' , '16867852' , '17071961' , '6971775' , '18997730' , '17293003' , '19392374' , '1857096' ,
004-
005- 严重，产品库sql执行时间上千s，影响数据库
006-
007- select rp.id, rp.sku, rp.product_name, rp.product_name_cn, rp.product_state, rp.last_buy_price, rp.is_group, rp.length, rp.width, rp.height, rp.gross_weight, rp.pack_weight, rpa.check_time, (select count(*) from t_product_sku_gtin tpsg where tpsg.sku = rp.sku ) as sku_export_num from rb_product as rp join rb_product_admin rpa on rp.sku = rpa.sku and rp.customer_id = rpa.customer_id and rpa.check_status = 1 and rp.delete_status = 0 WHERE rp.customer_id = 1 and rp.sku in ( '10303867' , '18843414' , '16768635' , '19532863' , '13998640' , '16542525' , '16518599' , '17700295' , '15927502' , '17506020' , '17425428' , '20850535' , '17338609' , '7974269' , '16215489' , '17255516' , '13194735' , '2536578' , '13667538' , '15999463' , '6251957' , '15807662' , '17284353' , '12603037' , '9924239' , '2241958' , '7543876' , '12091895' , '6573573' , '8489459' , '19673536' , '2488894' , '19481456' , '18051546' , '4528427' , '8081999' , '6752745' , '5770401' , '9980642' , '17374414' , '4871890' , '19379937' , '7554976' , '17941797' , '10340746' , '3501622' , '17822926' , '5746857' , '7066993' , '3972613' , '2431860' , '18744570' , '5065151' , '5946218' , '10989583' , '6567075' , '15587608' , '17313814' , '19196489' , '17742703' , '16171465' , '7340523' , '19150368' , '15968792' , '19493956' , '17098236' , '1730690' , '14999135' , '17482804' , '16556374' , '16867852' , '17071961' , '6971775' , '18997730' , '17293003' , '19392374' , '1857096' ,

001- <p>
001+ <p>反馈人：吴荣发</p>
002- 反馈人：吴荣发
002+ <p>严重，产品库sql执行时间上千s，影响数据库</p>
003- </p>
003+ select rp.id, rp.sku, rp.product_name, rp.product_name_cn, rp.product_state, rp.last_buy_price, rp.is_group, rp.length, rp.width, rp.height, rp.gross_weight, rp.pack_weight, rpa.check_time, (select count(*) from t_product_sku_gtin tpsg where tpsg.sku = rp.sku ) as sku_export_num from rb_product as rp join rb_product_admin rpa on rp.sku = rpa.sku and rp.customer_id = rpa.customer_id and rpa.check_status = 1 and rp.delete_status = 0 WHERE rp.customer_id = 1 and rp.sku in ( '10303867' , '18843414' , '16768635' , '19532863' , '13998640' , '16542525' , '16518599' , '17700295' , '15927502' , '17506020' , '17425428' , '20850535' , '17338609' , '7974269' , '16215489' , '17255516' , '13194735' , '2536578' , '13667538' , '15999463' , '6251957' , '15807662' , '17284353' , '12603037' , '9924239' , '2241958' , '7543876' , '12091895' , '6573573' , '8489459' , '19673536' , '2488894' , '19481456' , '18051546' , '4528427' , '8081999' , '6752745' , '5770401' , '9980642' , '17374414' , '4871890' , '19379937' , '7554976' , '17941797' , '10340746' , '3501622' , '17822926' , '5746857' , '7066993' , '3972613' , '2431860' , '18744570' , '5065151' , '5946218' , '10989583' , '6567075' , '15587608' , '17313814' , '19196489' , '17742703' , '16171465' , '7340523' , '19150368' , '15968792' , '19493956' , '17098236' , '1730690' , '14999135' , '17482804' , '16556374' , '16867852' , '17071961' , '6971775' , '18997730' , '17293003' , '19392374' , '1857096' ,
004- <p>
005- 严重，产品库sql执行时间上千s，影响数据库
006- </p>
007- select rp.id, rp.sku, rp.product_name, rp.product_name_cn, rp.product_state, rp.last_buy_price, rp.is_group, rp.length, rp.width, rp.height, rp.gross_weight, rp.pack_weight, rpa.check_time, (select count(*) from t_product_sku_gtin tpsg where tpsg.sku = rp.sku ) as sku_export_num from rb_product as rp join rb_product_admin rpa on rp.sku = rpa.sku and rp.customer_id = rpa.customer_id and rpa.check_status = 1 and rp.delete_status = 0 WHERE rp.customer_id = 1 and rp.sku in ( '10303867' , '18843414' , '16768635' , '19532863' , '13998640' , '16542525' , '16518599' , '17700295' , '15927502' , '17506020' , '17425428' , '20850535' , '17338609' , '7974269' , '16215489' , '17255516' , '13194735' , '2536578' , '13667538' , '15999463' , '6251957' , '15807662' , '17284353' , '12603037' , '9924239' , '2241958' , '7543876' , '12091895' , '6573573' , '8489459' , '19673536' , '2488894' , '19481456' , '18051546' , '4528427' , '8081999' , '6752745' , '5770401' , '9980642' , '17374414' , '4871890' , '19379937' , '7554976' , '17941797' , '10340746' , '3501622' , '17822926' , '5746857' , '7066993' , '3972613' , '2431860' , '18744570' , '5065151' , '5946218' , '10989583' , '6567075' , '15587608' , '17313814' , '19196489' , '17742703' , '16171465' , '7340523' , '19150368' , '15968792' , '19493956' , '17098236' , '1730690' , '14999135' , '17482804' , '16556374' , '16867852' , '17071961' , '6971775' , '18997730' , '17293003' , '19392374' , '1857096' ,