深圳智汇创想科技有限公司

SELECT  `m`.`Id` AS `Id` , `m`.`SiteCode` AS `SiteCode` , `m`.`Sku` AS `Sku`  FROM `P_Market_Product` m Inner JOIN `P_Product` p ON (( `m`.`CustomerId` = `p`.`CustomerId` ) AND ( `m`.`Sku` = `p`.`Sku` ))    WHERE ((((( `m`.`CustomerId` = 1 ) AND ( `m`.`MarketId` = 2 )) AND ( `m`.`CategoryId` IS NULL   OR `m`.`CategoryId`='')) AND ( `m`.`SiteCode` = 'GB' )) AND ( `m`.`SiteCode` <> 'CA' ))  ORDER BY `p`.`FinalJudgmentTime` DESC LIMIT 261000,1000;

执行次数：1560

平均时间：34.486

最大时间：335.010

P_Market_Product 这个表10天超1亿，看一下是否能从业务上优化。