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 (
    10793, 
    10794, 
    10795, 
    10796, 
    10797, 
    10798, 
    10799, 
    10800, 
    10801, 
    10802, 
    10803, 
    10804, 
    10805, 
    10806, 
    10807, 
    10808, 
    10809, 
    10810, 
    10811, 
    10812, 
    10827, 
    10828, 
    9686, 
    10767, 
    10768, 
    10769, 
    10770, 
    10771, 
    10772, 
    10773, 
    10774, 
    10775, 
    10776, 
    10777, 
    9689, 
    10459, 
    10460, 
    10461, 
    10462, 
    10463, 
    10464, 
    10465, 
    10625, 
    10626, 
    10627, 
    10628, 
    10629, 
    10630, 
    10631, 
    10632, 
    10633, 
    10634, 
    10635, 
    10636, 
    12944, 
    10829, 
    10830, 
    10831, 
    10832, 
    10833, 
    10834, 
    10835, 
    10836, 
    10837, 
    10838, 
    10839, 
    12985, 
    12986, 
    12987, 
    12988, 
    12989, 
    12990, 
    12991, 
    12992, 
    12993, 
    12994, 
    10403, 
    10404, 
    10405, 
    15781, 
    10406, 
    10407, 
    10408, 
    10409, 
    10410, 
    10411, 
    10412, 
    12853, 
    12854, 
    12855, 
    10414, 
    10415, 
    10416, 
    12856, 
    10417, 
    10418, 
    10419, 
    10420, 
    10421, 
    10422, 
    10423, 
    10424, 
    10384, 
    10383, 
    10382, 
    10753, 
    10754, 
    10755, 
    10296, 
    10297, 
    10298, 
    10299, 
    10300, 
    10446, 
    10063, 
    10052, 
    10072, 
    10046, 
    10059, 
    10064, 
    10057, 
    10048, 
    10062, 
    10070, 
    10058, 
    10045, 
    10054, 
    10047
  ) 
  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.00042

JSON explain

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