SELECT
`CustomerId`,
`OrderSourceId`,
`ProductId`,
`Sku`,
`Title`,
`Attribute`,
`Description`,
`Status`,
`FailureLog`,
`Date`,
`Keywords`,
`Remark`,
`SalesDay30`,
`SalesDay60`,
`SalesDay90`,
`SalesTotal`,
`SellerSku`,
`OrderSourceName`,
`UniqueId`,
`LastModifierId`,
`LastModifier`,
`LastModificationTime`,
`CreatorId`,
`Creator`,
`CreationTime`,
`Id`
FROM
`M_Aliexpress_Listing_Keywords_Update`
WHERE
(((
`Status` <> 0
)
AND ( `LastModificationTime` >= TIMESTAMP ( '2023-12-27 04:46:55.843000' ) ))
AND ( `LastModificationTime` <= TIMESTAMP ( '2023-12-27 05:16:55.843000' ) ))
ORDER BY
Id
LIMIT 0,
100;
任务描述
需求描述
业务背景
1)业务方临时数据处理、统计、导出等无法得到及时帮助
2)生产问题排查排期周期过长
业务文档
https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSZX5MzAlWgk9rpMq?utm_scene=team_space
验收标准
及时响应业务问题并处理妥善,保持系统稳定性
添加索引,`idx_status_lastmodificationtime` (`Status`,`LastModificationTime`)
当前SQL执行时间为 0.266