SELECT
`Id`,
`UniqueId`,
`CustomerId`,
`MarketId`,
`StrategyId`,
`OrderSourceId`,
`StrategyType`,
`ItemId`,
`SellerSku`,
`Sku`,
`PublishTime`,
`PublisherId`,
`Publisher`,
`RePublishOrderSourceId`,
`RePublishItemId`,
`RePublishParentSku`,
`RePublishSellerSku`,
`RePublishTime`,
`OriginalPrice`,
`Price`,
`Date`,
`Time`,
`Content`,
`Status`,
`FailureReason`,
`DelayTime`,
`DelayStatus`,
`StrategySubType`,
`RemoveType`,
`RePublishUpc`,
`TaskStatus`,
`LoadQueueTime`,
`IsVariation`,
`ListingTable`,
`ErrorCode`,
`ParentOrderSourceId`,
`RuleId`,
`LastModifierId`,
`LastModifier`,
`LastModificationTime`,
`CreatorId`,
`Creator`,
`CreationTime`
FROM
`Pp_PhoenixPlan_Allegro_Queue`
WHERE
((((((
`CustomerId` = 1
)
AND ( `MarketId` = 67 ))
AND ( `Time` >= TIMESTAMP ( '2023-11-23 18:00:00' ) ))
AND ( `Status` = 'success' ))
AND ( `LastModificationTime` > TIMESTAMP ( '2023-11-23 18:00:00' ) ))
AND ( `LastModificationTime` < TIMESTAMP ( '2023-11-24 18:00:00' ) ))
ORDER BY
`Id` DESC
LIMIT 0,
500;
任务描述
需求描述
业务背景
1)业务方临时数据处理、统计、导出等无法得到及时帮助
2)生产问题排查排期周期过长
业务文档
https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSZX5MzAlWgk9rpMq?utm_scene=team_space
验收标准
及时响应业务问题并处理妥善,保持系统稳定性
1.现在查询速度不慢,暂时不优化