SELECT 
  cscart_product_prices.product_id, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) AS price 
FROM 
  cscart_product_prices 
WHERE 
  cscart_product_prices.product_id IN (
    1732000, 1661266, 1731933, 1658668, 
    1658805, 2539827, 1661450, 1658400, 
    1661340, 2072334, 1659066, 1163013, 
    1663387, 2253671, 1659620, 1658630, 
    1659207, 1658657, 1657931, 1661143, 
    1732317, 1664148, 1732319, 1657915, 
    1659840, 1658338, 1658635, 1658606, 
    1658866, 1658169, 1660818, 1659802, 
    1659293, 1660499, 1658645, 1661096
  ) 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 1) 
GROUP BY 
  cscart_product_prices.product_id

Query time 0.00564

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "81.70"
    },
    "grouping_operation": {
      "using_filesort": false,
      "table": {
        "table_name": "cscart_product_prices",
        "access_type": "range",
        "possible_keys": [
          "usergroup",
          "product_id",
          "lower_limit",
          "usergroup_id"
        ],
        "key": "usergroup",
        "used_key_parts": [
          "product_id",
          "usergroup_id",
          "lower_limit"
        ],
        "key_length": "9",
        "rows_examined_per_scan": 72,
        "rows_produced_per_join": 72,
        "filtered": "100.00",
        "cost_info": {
          "read_cost": "74.50",
          "eval_cost": "7.20",
          "prefix_cost": "81.70",
          "data_read_per_join": "1K"
        },
        "used_columns": [
          "product_id",
          "price",
          "percentage_discount",
          "lower_limit",
          "usergroup_id"
        ],
        "attached_condition": "((`maniamall_cscart`.`cscart_product_prices`.`lower_limit` = 1) and (`maniamall_cscart`.`cscart_product_prices`.`product_id` in (1732000,1661266,1731933,1658668,1658805,2539827,1661450,1658400,1661340,2072334,1659066,1163013,1663387,2253671,1659620,1658630,1659207,1658657,1657931,1661143,1732317,1664148,1732319,1657915,1659840,1658338,1658635,1658606,1658866,1658169,1660818,1659802,1659293,1660499,1658645,1661096)) and (`maniamall_cscart`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
      }
    }
  }
}

Result

product_id price
1163013 25.790000
1657915 43.200000
1657931 125.090000
1658169 44.890000
1658338 36.140000
1658400 9.640000
1658606 6.640000
1658630 13.250000
1658635 35.940000
1658645 100.000000
1658657 83.080000
1658668 29.390000
1658805 78.200000
1658866 87.460000
1659066 42.560000
1659207 25.650000
1659293 96.310000
1659620 20.700000
1659802 17.110000
1659840 45.810000
1660499 113.560000
1660818 175.310000
1661096 1154.680000
1661143 61.800000
1661266 37.440000
1661340 76.980000
1661450 181.930000
1663387 17.980000
1664148 213.810000
1731933 316.250000
1732000 308.130000
1732317 201.250000
1732319 201.250000
2072334 24.990000
2253671 174.990000
2539827 18.740000