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 (
    10556, 
    10101, 
    10558, 
    10142, 
    10134, 
    10141, 
    10053, 
    10138, 
    10130, 
    9934, 
    10563, 
    10569, 
    10572, 
    10602, 
    10603, 
    10137, 
    12517, 
    12531, 
    12526, 
    12509, 
    10226, 
    10551, 
    10550, 
    10193, 
    10659, 
    10664, 
    10666, 
    10661, 
    10663, 
    10190, 
    10657, 
    10658, 
    10194, 
    10692, 
    12530, 
    12516, 
    12496, 
    12519, 
    12510, 
    10087, 
    10100, 
    10698, 
    10478, 
    9883, 
    9901, 
    10493, 
    10485, 
    10476, 
    10479, 
    10494, 
    10492, 
    10468, 
    9903, 
    10487, 
    9899, 
    10473, 
    10486, 
    9881, 
    9896, 
    9892, 
    10481, 
    9876, 
    10474, 
    10491, 
    10489, 
    10471, 
    9880, 
    10472, 
    9885, 
    10488, 
    9897, 
    9895, 
    10467, 
    9900, 
    10470, 
    10466, 
    10477, 
    9889, 
    10475, 
    9890, 
    10483, 
    10495, 
    10490, 
    10469, 
    9877, 
    9894, 
    9891, 
    10480, 
    9893, 
    9878, 
    9886, 
    9882, 
    9888, 
    10482, 
    13091, 
    12551, 
    12638, 
    12634, 
    12636, 
    12635, 
    12599, 
    12627, 
    12600, 
    12639, 
    15800, 
    12595, 
    12587, 
    12593, 
    12620, 
    12623, 
    12619, 
    12585, 
    12616, 
    12601, 
    12628, 
    12602, 
    12640, 
    12647, 
    12588, 
    12605, 
    12606, 
    12637, 
    12612, 
    12613, 
    12641, 
    12554, 
    12552, 
    12642
  ) 
  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.00035

JSON explain

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