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

SELECT COUNT(DISTINCT CASE WHEN `IsFba` = 1
    AND `Status` = 5 THEN `OrderSourceSku` ELSE NULL END) AS `FbaListingCount`, COUNT(DISTINCT CASE WHEN NOT (`IsFba` = 1
    AND `Status` = 5) THEN `OrderSourceSku` ELSE NULL END) AS `ListingCount`, `OrderSourceId` AS `OrderSourceId`, `PlanType` AS `PlanType`, COUNT(`Id`) AS `ExeCount`
    , SUM(CASE WHEN `Status` = 5 THEN 1 ELSE 0 END) AS `ExeSuccessCount`
FROM (SELECT *
    FROM (SELECT `Id` AS `Id`, `IsFba` AS `IsFba`, `Status` AS `Status`, `OrderSourceSku` AS `OrderSourceSku`, `OrderSourceId` AS `OrderSourceId`
            , `PlanType` AS `PlanType`
        FROM `Apx_BasicPlan_LogDetail`
        WHERE `CustomerId` = 1
            AND `OrderSourceId` = 10356
            AND `PlanType` = 1
            AND `CreationTime` < '2023-04-03 00:00:00'
            AND (`ExecuteType` = 5
                AND `PlanType` = 4)
        UNION
        SELECT `Id` AS `Id`, `IsFba` AS `IsFba`, `Status` AS `Status`, `OrderSourceSku` AS `OrderSourceSku`, `OrderSourceId` AS `OrderSourceId`
            , `PlanType` AS `PlanType`
        FROM `Apx_BasicPlan_LogDetail`
        WHERE `CustomerId` = 1
            AND `OrderSourceId` = 10356
            AND `PlanType` = 1
            AND `CreationTime` < '2023-04-03 00:00:00'
            AND `PlanType` <> 4
        ) unionTable

    ) t

执行频率：147.34K

平均时间：209.48

最大时间：30.86M

执行频率太高 ，是否能从业务方面优化，cpu打满。