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 (
    4890, 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
  ) 
  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.00033

JSON explain

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