1.问题分析
大量的M_ShopeeV2_Listing这个慢sql， 20秒查询时间
2.解决方案：
这种大表先按条件查询出id,在同步id join 查询其他字段，速度非常快
select a.Id,`CustomerId`,`OrderSourceId`,`OrderSourceCountry`,`IsGlobal`,`PartnerId`,`MerchantId`,`ShopId`,`SiteCode`,`Type`,`Sku`,`CustomSku`,`ProductId`,`ParentSku`,`SellerSku`,`Name`,`MainImage`,`CategoryId`,`HasVariation`,`Currency`,`Price`,`OriginalPrice`,`InflatedPrice`,`InflatedOriginalPrice`,`StockLocationId`,`StockType`,`Inventory`,`CurrentStock`,`ReservedStock`,`StockLocationId1`,`Inventory1`,`CurrentStock1`,`ReservedStock1`,`Weight`,`Length`,`Width`,`Height`,`IsPreOrder`,`ShippingTime`,`Condition`,`SizeChart`,`CreateTime`,`UpdateTime`,`Status`,`Sales`,`Views`,`Likes`,`RatingStar`,`Comments`,`PromotionId`,`PublishTime`,`UnPublishTime`,`AutoPublishStrategyId`,`AutoPublishTime`,`IsAutoPublish`,`RePublishStrategyId`,`RePublishTime`,`AutoUnPublishStrategyId`,`AutoUnPublishTime`,`AutoAdjustPriceStrategyId`,`AutoAdjustPriceTime`,`AutoPromotionStrategyId`,`AutoPromotionTime`,`LastPhoenixPlanStrategyType`,`EditStatus`,`LastModifierId`,`LastModifier`,`LastModificationTime`,`CreatorId`,`Creator`,`CreationTime`
from `M_ShopeeV2_Listing` a join
(
select Id FROM `M_ShopeeV2_Listing`
WHERE ((((( `CustomerId` = 1 ) AND ( `IsGlobal` = 1 )) AND ( 'CN' = `OrderSourceCountry` )) AND ( timestamp('2023-03-25 10:25:37.104125') > `LastModificationTime` )) AND ( `Id` > 162044 )) ORDER BY Id Asc LIMIT 0,200
) b on a.Id=b.Id
3.慢sql
SELECT `Id`,`CustomerId`,`OrderSourceId`,`OrderSourceCountry`,`IsGlobal`,`PartnerId`,`MerchantId`,`ShopId`,`SiteCode`,`Type`,`Sku`,`CustomSku`,`ProductId`,`ParentSku`,`SellerSku`,`Name`,`MainImage`,`CategoryId`,`HasVariation`,`Currency`,`Price`,`OriginalPrice`,`InflatedPrice`,`InflatedOriginalPrice`,`StockLocationId`,`StockType`,`Inventory`,`CurrentStock`,`ReservedStock`,`StockLocationId1`,`Inventory1`,`CurrentStock1`,`ReservedStock1`,`Weight`,`Length`,`Width`,`Height`,`IsPreOrder`,`ShippingTime`,`Condition`,`SizeChart`,`CreateTime`,`UpdateTime`,`Status`,`Sales`,`Views`,`Likes`,`RatingStar`,`Comments`,`PromotionId`,`PublishTime`,`UnPublishTime`,`AutoPublishStrategyId`,`AutoPublishTime`,`IsAutoPublish`,`RePublishStrategyId`,`RePublishTime`,`AutoUnPublishStrategyId`,`AutoUnPublishTime`,`AutoAdjustPriceStrategyId`,`AutoAdjustPriceTime`,`AutoPromotionStrategyId`,`AutoPromotionTime`,`LastPhoenixPlanStrategyType`,`EditStatus`,`LastModifierId`,`LastModifier`,`LastModificationTime`,`CreatorId`,`Creator`,`CreationTime`
FROM `M_ShopeeV2_Listing`
WHERE ((((( `CustomerId` = 1 ) AND ( `IsGlobal` = 1 )) AND ( 'CN' = `OrderSourceCountry` )) AND ( timestamp('2023-03-25 10:25:37.104125') > `LastModificationTime` )) AND ( `Id` > 162044 )) ORDER BY Id Asc LIMIT 0,200;