Sandbox

SELECT 
  cscart_ult_product_prices.product_id, 
  MIN(
    IF(
      cscart_ult_product_prices.percentage_discount = 0, 
      cscart_ult_product_prices.price, 
      cscart_ult_product_prices.price - (
        cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount
      )/ 100
    )
  ) AS price 
FROM 
  cscart_ult_product_prices 
WHERE 
  cscart_ult_product_prices.product_id IN (
    8761, 9563, 9564, 9565, 9566, 9567, 9568, 
    9569, 9570, 9571, 9572, 9573, 9574, 
    9575, 9576, 9577, 9578, 9579, 9580, 
    9581, 9582, 9583, 9584, 9585, 9586, 
    9587, 9588, 9589, 9590, 9591, 9592, 
    9593, 9594, 9595, 9596, 9597, 9598, 
    9599, 9600, 9601, 9602, 9603, 9604, 
    9605, 9606, 9607, 9608, 9609, 9610, 
    9611, 9612, 9613, 9614, 9615, 9616, 
    9617, 9618, 9619, 9620, 9621, 9622, 
    9623, 9624, 9625, 9626, 9627, 9628, 
    9629, 9630, 9631, 9632, 9633, 9634, 
    9635, 9636, 9637, 9638, 9639, 9640, 
    9641, 10049, 10050, 10051, 10052, 10053, 
    10054, 10055, 10056, 10057, 10058, 
    10059, 10060, 10061, 10062, 10063, 
    10064
  ) 
  AND cscart_ult_product_prices.lower_limit = 1 
  AND cscart_ult_product_prices.company_id = 1 
  AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1) 
GROUP BY 
  cscart_ult_product_prices.product_id

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}