select `Id`,`CustomerId`,`OrderSourceId`,`SiteId`,`ProductId`,`SellerId`,`OfficialStoreId`,`Type`,`ParentSku`,`Name`,`SubName`,`Tags`,`MainImage`,`CategoryId`,`Price`,`BasePrice`,`OriginalPrice`,`Currency`,`InitialQuantity`,`Quantity`,`SoldQuantity`,`BuyingMode`,`ListingTypeId`,`StartTime`,`StopTime`,`Condition`,`PermaLink`,`AcceptsMercadopago`,`VideoId`,`DescriptionId`,`CatalogProductId`,`DomainId`,`DateCreated`,`LastUpdate`,`Health`,`CatalogListing`,`AutomaticRelist`,`Warranty`,`Status`,`SubStatus`,`SellerSku`,`Inventory`,`Color`,`Size`,`Length`,`Height`,`Width`,`Weight`,`Sku`,`CustomSku`,`CreatorId`,`Creator`,`CreationTime`,`LastModifierId`,`LastModifier`,`LastModificationTime`,`PublishTime`,`UnPublishTime`,`AutoPublishStrategyId`,`AutoPublishTime`,`IsAutoPublish`,`RePublishStrategyId`,`RePublishTime`,`AutoUnPublishStrategyId`,`AutoUnPublishTime`,`AutoAdjustPriceStrategyId`,`AutoAdjustPriceTime`,`AutoPromotionStrategyId`,`AutoPromotionTime`,`LastPhoenixPlanStrategyType`,`OnlineStatus` from m_mercadolibre_listing where (CustomerId = 1 AND LastModificationTime<replace('2024-03-13 12:00:00','%',' ') AND LastModificationTime>= DATE_SUB(replace('2024-03-13 02:00:00','%',' '), interval 48 HOUR));
select `Id`,`CustomerId`,`OrderSourceId`,`ProductId`,`Type`,`Locale`,`ParentSku`,`Name`,`MainImage`,`CategoryId`,`Tags`,`MoreKeywords1`,`MoreKeywords2`,`BrandId`,`Brand`,`Gtin`,`SubProductId`,`SellerSku`,`Price`,`Inventory`,`ShippingFee`,`Color`,`Size`,`Quantity`,`BaseUnit`,`BulkDiscount`,`BulkOrder`,`CouponStartDate`,`CouponEndDate`,`DeliveryTime`,`FreightTemplateId`,`GroupId`,`GroupIds`,`IsImageDynamic`,`IsPackSell`,`AddUnit`,`AddWeight`,`Length`,`Height`,`Width`,`Weight`,`LotNumber`,`OwnerMemberId`,`OwnerMemberSeq`,`MinPrice`,`MaxPrice`,`Src`,`Currency`,`ProductPrice`,`Unit`,`PromiseTemplateId`,`ReduceStrategy`,`SizeChartId`,`ValidNumber`,`PackageType`,`Created`,`Modified`,`Status`,`Summary`,`Display`,`OfflineTime`,`Sku`,`CustomSku`,`CreatorId`,`Creator`,`CreationTime`,`LastModifierId`,`LastModifier`,`LastModificationTime`,`PublishTime`,`UnPublishTime`,`AutoPublishStrategyId`,`AutoPublishTime`,`IsAutoPublish`,`RePublishStrategyId`,`RePublishTime`,`AutoUnPublishStrategyId`,`AutoUnPublishTime`,`AutoAdjustPriceStrategyId`,`AutoAdjustPriceTime`,`AutoPromotionStrategyId`,`AutoPromotionTime`,`LastPhoenixPlanStrategyType`,`OnlineStatus` from m_aliexpress_listing where (CustomerId = 1 and LastModificationTime<replace('2024-03-13 12:00:00','%',' ') AND LastModificationTime>= DATE_SUB(replace('2024-03-12 12:00:00','%',' '), interval 2 day));
select `Id`,`CustomerId`,`OrderSourceId`,`SiteCode`,`ProductId`,`Name`,`MainImage`,`Type`,`IsMain`,`CategoryName`,`Brand`,`Gtin`,`Upc`,`SellerSku`,`Price`,`Msrp`,`Inventory`,`Quantity`,`BuyBoxShippingFee`,`BuyBoxPrice`,`Weight`,`Currency`,`StatusChangeReason`,`LifeCycleStatus`,`PublishStatus`,`LocalStatus`,`ShipMethods`,`Wpid`,`ShelfName`,`PrimaryCatPath`,`OfferStartDate`,`OfferEndDate`,`ItemCreationDate`,`ItemLastUpdated`,`Url`,`ReviewsCount`,`AverageRating`,`IsSearchable`,`CompetitorUrl`,`CompetitorPrice`,`CompetitorShipPrice`,`CompetitorLastDateFetched`,`ProductTaxCode`,`ShippingWeightUnit`,`FulfillmentType`,`Sku`,`CustomSku`,`ProductIdType`,`VariantGroupId`,`FulfillmentLagTime`,`FloorPrice`,`PricePerUnitQuantity`,`PricePerUnitUom`,`ElectronicsIndicator`,`BatteryTechnologyType`,`ChemicalAerosolPesticide`,`MultipackQuantity`,`ShipsInOriginalPackaging`,`StartDate`,`EndDate`,`MustShipAlone`,`ProductIdUpdate`,`SkuUpdate`,`SwatchVariantAttribute`,`SwatchImageUrl`,`FulfillmentLagType`,`IsDeleted`,`ChangeStatus`,`OrignalPrice`,`CreatorId`,`Creator`,`CreationTime`,`LastModifierId`,`LastModifier`,`LastModificationTime`,`PublishTime`,`UnPublishTime`,`AutoPublishStrategyId`,`AutoPublishTime`,`IsAutoPublish`,`RePublishStrategyId`,`RePublishTime`,`AutoUnPublishStrategyId`,`AutoUnPublishTime`,`AutoAdjustPriceStrategyId`,`AutoAdjustPriceTime`,`AutoPromotionStrategyId`,`AutoPromotionTime`,`LastPhoenixPlanStrategyType`,`OnlineStatus` from m_walmart_listing where (CustomerId = 1 AND LastModificationTime<replace('2024-03-13 12:00:00','%',' ') AND LastModificationTime>= DATE_SUB(replace('2024-03-13 02:00:00','%',' '), interval 48 HOUR));
select `Id`,`CustomerId`,`OrderSourceId`,`OfferId`,`ProductId`,`SetId`,`RelationProductId`,`SellerSku`,`Name`,`MainImage`,`PriceFormat`,`Price`,`Currency`,`Inventory`,`Unit`,`Gtin`,`ShippingFee`,`ShippingTime`,`ColorPattern`,`Color`,`Size`,`Quantity`,`Weight`,`SizeTableId`,`PaymentsInvoice`,`Status`,`CreatedAt`,`UpdatedAt`,`ValidatedAt`,`Sku`,`CustomSku`,`CreatorId`,`Creator`,`CreationTime`,`LastModifierId`,`LastModifier`,`LastModificationTime`,`EditStatus`,`OriginalPrice`,`RealProductId` from m_allegro_listing_sub where (CustomerId = 1 AND LastModificationTime<replace('2024-03-13 12:00:00','%',' ') AND LastModificationTime>= DATE_SUB(replace('2024-03-13 02:00:00','%',' '), interval 48 HOUR));
select `Id`,`CustomerId`,`OrderSourceId`,`ProductId`,`Type`,`ParentSku`,`Name`,`MainImage`,`CategoryId`,`Tags`,`Brand`,`OfferId`,`SellerSku`,`Price`,`Inventory`,`Color`,`Size`,`Quantity`,`Sku`,`CustomSku`,`CreatorId`,`Creator`,`CreationTime`,`LastModifierId`,`LastModifier`,`LastModificationTime`,`PublishTime`,`UnPublishTime`,`AutoPublishStrategyId`,`AutoPublishTime`,`IsAutoPublish`,`RePublishStrategyId`,`RePublishTime`,`AutoUnPublishStrategyId`,`AutoUnPublishTime`,`AutoAdjustPriceStrategyId`,`AutoAdjustPriceTime`,`AutoPromotionStrategyId`,`AutoPromotionTime`,`LastPhoenixPlanStrategyType`,`OnlineStatus`,`RealProductId` from m_allegro_listing where (CustomerId = 1 AND LastModificationTime<replace('2024-03-13 12:00:00','%',' ') AND LastModificationTime>= DATE_SUB(replace('2024-03-13 02:00:00','%',' '), interval 48 HOUR));
优化建议：
分页，强制指定LastModificationTime字段开头的索引。