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 (
    12995, 12996, 12997, 12998, 15744, 15745, 
    15746, 15743, 15738, 15739, 15740, 
    15741, 15742, 15736, 15737, 12999, 
    13000, 13001, 13002, 13003, 13004, 
    13005, 13006, 13007, 13008, 13009, 
    13010, 13011, 13012, 12969, 13013, 
    13014, 13015, 13016, 13017, 13018, 
    13019, 13020, 13021, 13022, 13023, 
    13024, 13025, 13026, 13027, 13028, 
    13029, 13030, 13031, 13032, 13033, 
    13034, 13035, 13036, 13037, 13038, 
    13039, 13040, 13041, 13042, 13043, 
    13044
  ) 
  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.00032

JSON explain

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