SELECT
s.*
FROM
`M_AliExpress_Listing` s
LEFT JOIN `M_AliExpress_Listing_Market_Image` l ON ((
`s`.`CustomerId` = `l`.`CustomerId`
)
AND ( `s`.`ProductId` = `l`.`ProductId` ))
WHERE
((
`s`.`Id` < 2370662368
)
AND (((
`s`.`CustomerId` = 1
)
AND ( `s`.`Status` = 'onSelling' ))
AND ( `l`.`Type` <> 1 )))
ORDER BY
`s`.`Id` DESC
LIMIT 0,
10000;
任务描述
需求描述
业务背景
1)业务方临时数据处理、统计、导出等无法得到及时帮助
2)生产问题排查排期周期过长
业务文档
https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSZX5MzAlWgk9rpMq?utm_scene=team_space
验收标准
及时响应业务问题并处理妥善,保持系统稳定性
调整只返回使用的字段sku,执行时间为:0.27秒 如下