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 (
    12551, 
    12544, 
    12546, 
    12547, 
    12548, 
    12549, 
    12550, 
    12555, 
    12556, 
    12557, 
    12558, 
    12559, 
    12576, 
    12577, 
    12578, 
    9683, 
    9685, 
    9686, 
    9687, 
    9688, 
    9689, 
    9690, 
    12560, 
    12561, 
    9775, 
    9776, 
    9777, 
    9778, 
    9779, 
    9780, 
    9781, 
    9782, 
    9783, 
    9784, 
    9785, 
    9786, 
    9787, 
    9788, 
    9790, 
    9791, 
    9792, 
    9795, 
    9797, 
    9798, 
    9799, 
    9800, 
    9801, 
    9802, 
    9803, 
    9804, 
    9805, 
    9806, 
    9807, 
    9808, 
    9809, 
    9810, 
    9811, 
    9812, 
    9814, 
    9815, 
    9816, 
    9817, 
    9818, 
    9820, 
    9821, 
    9822, 
    9823, 
    9824, 
    9825, 
    9826, 
    9827, 
    9828, 
    9829, 
    9830, 
    15732, 
    9838, 
    9839, 
    9840, 
    9841, 
    9842, 
    9843, 
    9844, 
    9845, 
    9846, 
    9847, 
    9848, 
    9849, 
    9850, 
    9851, 
    9852, 
    9853, 
    9854, 
    9855, 
    9856, 
    9857, 
    9858, 
    9859, 
    9860, 
    9861, 
    9862, 
    9863, 
    9876, 
    9877, 
    9878, 
    9880, 
    9881, 
    9882, 
    9883, 
    9885, 
    9886, 
    9888, 
    9889, 
    9890, 
    9891, 
    9892, 
    9893, 
    9894, 
    9895, 
    9896, 
    9897, 
    9899, 
    9900, 
    9901, 
    9903, 
    9972, 
    9973, 
    9975, 
    9976
  ) 
  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.00668

JSON explain

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