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 (
    12259, 12260, 12261, 12262, 12263, 12264, 
    12265, 12266, 12267, 12268, 12269, 
    12270, 12271, 12272, 12273, 12274, 
    12275, 12276, 12277, 12278, 12279, 
    12280, 12281, 12282, 12283, 12284, 
    12285, 12286, 12287, 12288, 12289, 
    12290, 12291, 12292, 12293, 12294, 
    12295, 12296, 12297, 12298, 12299, 
    12300, 12301, 12302, 12303, 12304, 
    12305, 12306, 12307, 12308, 12309, 
    12310, 12311, 12312, 12313, 12314, 
    12315, 12316, 12317, 12318, 12319, 
    12320, 12321, 12322, 12323, 12324, 
    12325, 12326, 12327, 12328, 12329, 
    12330, 12331, 12332, 12333, 12334, 
    12335, 12336, 12337, 12338, 12339, 
    12340, 12341, 12342, 12343, 12344, 
    12345, 12346, 12347, 12348
  ) 
  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.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}