求大神优化这一段SQL

[Rxd123321Lm]

SELECT
COUPON_DEFINITION_ID AS ID,
count(1) AS MEMBER_RECEIVED_COUNT
FROM
ssp_coupon_entity
WHERE
TENANT_ID = 512825572674899968
AND `IS_DELETED` = 0
AND COUPON_DEFINITION_ID IN (
1077012258384646144,
989348700281253888,
1089779469570408448
)
AND (
`IS_VOID` IS NULL
OR `IS_VOID` = 0
)
GROUP BY
COUPON_DEFINITION_ID

[stacksoverflow]

SELECT
  COUPON_DEFINITION_ID AS ID
  , count(1) AS MEMBER_RECEIVED_COUNT 
FROM
  ssp_coupon_entity 
WHERE
  ( 
    COUPON_DEFINITION_ID = 1077012258384646144 
    OR COUPON_DEFINITION_ID = 989348700281253888 
    OR COUPON_DEFINITION_ID = 1089779469570408448
  ) 
  AND TENANT_ID = 512825572674899968 
  AND (`IS_VOID` IS NULL OR `IS_VOID` = 0) 
  AND `IS_DELETED` = 0 
GROUP BY
  COUPON_DEFINITION_ID

[bcsflilong]

SELECT
  COUPON_DEFINITION_ID AS ID
  , count(1) AS MEMBER_RECEIVED_COUNT 
FROM
  ssp_coupon_entity 
WHERE
  ( 
    COUPON_DEFINITION_ID = 1077012258384646144 
    OR COUPON_DEFINITION_ID = 989348700281253888 
    OR COUPON_DEFINITION_ID = 1089779469570408448
  ) 
  AND TENANT_ID = 512825572674899968 
  AND (`IS_VOID` IS NULL OR `IS_VOID` = 0) 
  AND `IS_DELETED` = 0 
GROUP BY
  COUPON_DEFINITION_ID