慢sql top 10,缺少索引
2.解决方案： 创建索引
索引优化建议：
- 建议在数据表 irobotbox_marketpublish.M_ShopeeV2_Listing 的 OrderSourceCountry,IsGlobal,CustomerId,LastModificationTime 列上添加如下索引，以提高查询性能：
ALTER TABLE `irobotbox_marketpublish`.`M_ShopeeV2_Listing` ADD INDEX `idx_OrderSourceCountry_IsGlobal_CustomerId_LastModificationTime` (`OrderSourceCountry`, `IsGlobal`, `CustomerId`, `LastModificationTime`)
注意：在业务高峰期，变更表结构存在风险，请谨慎操作！
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 '2022-10-17 23:49:16.765115' > `LastModificationTime` ORDER BY Id DESC LIMIT 5600, 200