反馈人:缪金荣
问题1:
SELECT id,source_id,source_name,shop_level,site_code,sku,pattern,sales_label,risk_level,logistics,holiday,create_time,update_time,is_deleted,model_type,publish_price,publish_formula,publish_title,publish_currency FROM t_publish_sku_allocation_walmart
WHERE (source_id = 31461 AND is_deleted = 0)

优化建议:分页查询,如果是后端跑批任务每页建议1000,如果是前端查询每页建议1000由前端滚动分页,提供复制按钮(点击按钮时每页查5000,前端汇集)
问题2:
SELECT
id,feed_id
FROM t_walmart_update_listing_queue_detail
WHERE (source_id = 21457 AND status = 6 AND is_deleted = 0) GROUP BY feed_id

优化建议:加order by,然后分页,每月建议1000
问题2:
SELECT
id,
customer_id,
source_id,
source_name,
NAME,
name_cn,
spu,
sku,
item_id,
source_sku,
main_image,
platform_category_id,
platform_category_name,
brand_id,
brand,
publish_status,
STATUS,
product_state,
tort,
gtin,
upc,
sale_price,
purchase_price,
original_price,
days_to_ship,
first_publish_time,
primary_variant,
has_variant,
has_new,
description_type,
default_local_warehouse,
currency,
country_code,
remark,
create_by,
create_time,
update_by,
update_time,
is_deleted,
salesman_id,
salesman,
listing_person,
fulfillment_type,
template_id,
template_name,
freight_price,
average_rating,
has_law_firm_agent,
is_no_sale,
transit_time,
is_update,
ship_methods,
fist_online_time,
source_type
FROM
t_walmart_listing_ca
WHERE
( source_id = 27329 AND publish_status = 6 AND STATUS = 1 );

优化建议:查明查询SQL出自什么功能,单次查询数据大,需要滚动分页查询