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 (
    12648, 12611, 12596, 12607, 12608, 12610, 
    12643, 12649, 12609, 12644, 12650, 
    12652, 12653, 12654, 12646, 12655, 
    12656, 12645, 12651, 12597, 12615, 
    12603, 12629, 12604, 9776, 9777, 9781, 
    9775, 9778, 9779, 9780, 9782, 9790, 
    9787, 9791, 9792, 9795, 9784, 9785, 
    9783, 9786, 9788, 13031, 13032, 13033, 
    13034, 13035, 13036, 13037, 13038, 
    13039, 13040, 13041, 13042, 13043, 
    13044, 10840, 10841, 10842, 10843, 
    10844, 10845, 10846, 10847
  ) 
  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.00020

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}