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 (
    10705, 
    10706, 
    10707, 
    10708, 
    10709, 
    10710, 
    10711, 
    10712, 
    10668, 
    10669, 
    10670, 
    10671, 
    10672, 
    10673, 
    10674, 
    10675, 
    10676, 
    10677, 
    10678, 
    10679, 
    10680, 
    10681, 
    10682, 
    10683, 
    10684, 
    10685, 
    10686, 
    10725, 
    10724, 
    10701, 
    10699, 
    10698, 
    10696, 
    10695, 
    10693, 
    10692, 
    15958, 
    15957, 
    15956, 
    12600, 
    12602, 
    12604, 
    12606, 
    12608, 
    12603, 
    12615, 
    12597, 
    12609, 
    12610, 
    12607, 
    12596, 
    12611, 
    12613, 
    12612, 
    12605, 
    12601, 
    12616, 
    12599, 
    10666, 
    10664, 
    10663, 
    10661, 
    10659, 
    10658, 
    10657, 
    12619, 
    12620, 
    12593, 
    12595, 
    12585, 
    12587, 
    12623, 
    13091, 
    12588, 
    12590, 
    12591, 
    12592, 
    10497, 
    10498, 
    10499, 
    10500, 
    10501, 
    10502, 
    10503, 
    10504, 
    10505, 
    10506, 
    10507, 
    10508, 
    10509, 
    10510, 
    10511, 
    10512, 
    10513, 
    10514, 
    10515, 
    10516, 
    10517, 
    10518, 
    10519, 
    10520, 
    10521, 
    10641, 
    10640, 
    10639, 
    10638, 
    10637, 
    10636, 
    10635, 
    10634, 
    10633, 
    10632, 
    10631, 
    10630, 
    10629, 
    10628, 
    10627, 
    10626, 
    10625, 
    10624, 
    10623, 
    10622, 
    10621, 
    10620, 
    10619, 
    10618, 
    10617, 
    10616
  ) 
  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"
    }
  }
}