SELECT
`Id` AS `Id`,
`Name` AS `Name`,
`ProductId` AS `ProductId`,
`Type` AS `Type`,
`MainImage` AS `MainImage`,
`Sku` AS `Sku`,
`SellerSku` AS `SellerSku`,
`CustomSku` AS `CustomSku`,
`OrderSourceId` AS `OrderSourceId`,
`Quantity` AS `Quantity`,
`Price` AS `Price`,
`OnlineStatus` AS `State`,
`LastPhoenixPlanStrategyType` AS `LastPhoenixPlanStrategyType`,
`PublishTime` AS `PublishTime`,
`UnPublishTime` AS `UnPublishTime`,
`IsAutoPublish` AS `IsAutoPublish`,
`Creator` AS `Creator`
FROM
`M_AliExpress_Listing`
WHERE
(( NOT ( `Sku` IS NULL OR `Sku` = '' ) AND ( `OnlineStatus` IN ( 1 )) ) AND ( `ProductId` IN ( 1005006097808986 )) )
ORDER BY
Id DESC
LIMIT 0,
20;
任务描述
需求描述
业务背景
1)业务方临时数据处理、统计、导出等无法得到及时帮助
2)生产问题排查排期周期过长
业务文档
https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSZX5MzAlWgk9rpMq?utm_scene=team_space
验收标准
及时响应业务问题并处理妥善,保持系统稳定性
查询条件 添加CustomerId=1,执行时间0.21秒,如下 :