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

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` = 70 )) AND ( `m`.`CategoryId` IS NULL   OR `m`.`CategoryId`=''))  ORDER BY `p`.`FinalJudgmentTime` DESC LIMIT 20500,500;

执行次数：2563

平均时间：32.490

最大时间：398.570

建议优化：

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` = 70 ))
    AND ( `m`.`CategoryId` IS NULL OR `m`.`CategoryId` = '' ))
ORDER BY
    m.id DESC
    LIMIT 20500,500;