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 (
    69657, 
    66613, 
    66677, 
    64871, 
    66508, 
    67004, 
    69641, 
    64895, 
    69766, 
    69574, 
    65454, 
    65777, 
    65893, 
    65160, 
    65063, 
    65831, 
    66637, 
    66500, 
    64975, 
    65822, 
    67836, 
    65540, 
    65721, 
    66086, 
    67788, 
    66150, 
    67812, 
    65801, 
    66708, 
    64634, 
    69789, 
    65970, 
    69701, 
    64872, 
    65979, 
    64815, 
    65040, 
    69693, 
    66246, 
    66380, 
    69220, 
    69195, 
    69244, 
    69228, 
    69813, 
    69725, 
    69624, 
    65508, 
    68371, 
    65103, 
    69333, 
    67203, 
    65500, 
    68387, 
    67252, 
    66492, 
    65953, 
    67235, 
    67926, 
    66676, 
    69757, 
    65087, 
    69749, 
    65023, 
    65390, 
    65319, 
    65809, 
    68714, 
    69829, 
    67155, 
    66656, 
    66420, 
    64692, 
    69268, 
    67872, 
    65302, 
    67283, 
    67028, 
    64535, 
    64751, 
    67828, 
    66629, 
    67396, 
    64543, 
    64855, 
    65961, 
    67953, 
    65479, 
    65785, 
    67123, 
    67107, 
    67853, 
    65463, 
    64651, 
    67339, 
    66598, 
    64807, 
    67804, 
    67091, 
    65713, 
    65492, 
    66302, 
    67299, 
    69869, 
    66254, 
    69566, 
    66580, 
    64676, 
    69550, 
    69349, 
    65564, 
    69292, 
    67251, 
    68135, 
    66564, 
    69400, 
    69741, 
    64511, 
    67267, 
    65745, 
    67764, 
    67934, 
    67115, 
    68411, 
    66310, 
    65358, 
    66532, 
    65143, 
    69781, 
    65934, 
    64935, 
    65271, 
    64567, 
    68866, 
    65334, 
    65793, 
    65471, 
    67388, 
    69861, 
    65422, 
    69616, 
    66657, 
    69341, 
    65516, 
    69590, 
    67888, 
    69733, 
    64735, 
    64919, 
    67748, 
    66190, 
    66198, 
    69236, 
    66436, 
    67163, 
    67380, 
    69558, 
    69373, 
    64959, 
    65367, 
    68331, 
    68781, 
    65532, 
    69316, 
    64700, 
    69276, 
    69357, 
    66460, 
    68339, 
    67347, 
    69365, 
    69845, 
    64727, 
    64791, 
    65769, 
    66094, 
    69717, 
    69709, 
    69821, 
    66372, 
    65697, 
    65729, 
    64527, 
    68355, 
    64660, 
    68181, 
    67372, 
    64783, 
    67219, 
    68403, 
    66428, 
    66262, 
    66476, 
    67331, 
    64519, 
    68478, 
    66078, 
    65263, 
    67044, 
    64775, 
    67796, 
    65524, 
    67880, 
    64551, 
    65207, 
    66356, 
    67756, 
    65199, 
    69284, 
    65151, 
    65279, 
    67099, 
    66444, 
    65572, 
    66540, 
    67012, 
    64743, 
    67307, 
    65159, 
    64863, 
    67315, 
    69381, 
    67147, 
    67275, 
    67060, 
    65015, 
    66158, 
    67227, 
    66405, 
    64831, 
    64847, 
    66206, 
    65031, 
    66988, 
    67131, 
    69853, 
    66102, 
    66222, 
    65239, 
    68363, 
    68395, 
    67179, 
    69260, 
    64839, 
    68626, 
    64642, 
    66980, 
    67052, 
    68938, 
    67291, 
    67243, 
    66524, 
    69649, 
    68161, 
    69773, 
    66700, 
    67404, 
    65120, 
    67364, 
    67076, 
    66445, 
    65978, 
    69837, 
    65548, 
    64823, 
    66278, 
    66316, 
    64999, 
    67918, 
    66126, 
    66348, 
    65007, 
    65111, 
    66230, 
    64708, 
    68379, 
    67068, 
    64576, 
    67171, 
    64759, 
    69633, 
    66270, 
    67187, 
    67772, 
    64936, 
    65556, 
    65366, 
    64903, 
    65064, 
    65247, 
    66166, 
    67323, 
    65039, 
    65342, 
    66110, 
    66182, 
    69084, 
    64668, 
    66142, 
    65310, 
    66996, 
    64991, 
    64799, 
    69805, 
    66597, 
    67211, 
    64559, 
    66317, 
    65095, 
    65318, 
    67820, 
    66294, 
    65382, 
    64927, 
    66516, 
    64767, 
    66484, 
    68090, 
    69308, 
    66134, 
    66238, 
    68072, 
    67139, 
    69300, 
    65055, 
    66332, 
    66118, 
    65406, 
    66556, 
    65737, 
    67355, 
    69582, 
    65135, 
    66396, 
    65842, 
    64719, 
    66692, 
    66727, 
    69203, 
    66468, 
    67020, 
    67036, 
    65231, 
    67195, 
    67780, 
    64887, 
    66548, 
    64911, 
    64976, 
    68323, 
    65223, 
    66340, 
    65398, 
    65119, 
    66357, 
    65183, 
    65350, 
    64684, 
    65407, 
    69252, 
    66174, 
    69389, 
    69211, 
    65753, 
    64951, 
    69598, 
    66404, 
    69009, 
    65175, 
    65856, 
    66388, 
    66621, 
    65255, 
    65215, 
    69187, 
    65191, 
    64967, 
    69324, 
    67363, 
    68347, 
    65430, 
    65079, 
    65287, 
    66572, 
    65705, 
    66279, 
    65761, 
    65580, 
    69606, 
    65446, 
    65438, 
    66214
  ) 
  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.00350

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "274.41"
    },
    "grouping_operation": {
      "using_filesort": false,
      "table": {
        "table_name": "cscart_product_prices",
        "access_type": "range",
        "possible_keys": [
          "usergroup",
          "product_id",
          "lower_limit",
          "usergroup_id"
        ],
        "key": "product_id",
        "used_key_parts": [
          "product_id"
        ],
        "key_length": "3",
        "rows_examined_per_scan": 392,
        "rows_produced_per_join": 78,
        "filtered": "20.00",
        "index_condition": "(`chocoramo`.`cscart_product_prices`.`product_id` in (69657,66613,66677,64871,66508,67004,69641,64895,69766,69574,65454,65777,65893,65160,65063,65831,66637,66500,64975,65822,67836,65540,65721,66086,67788,66150,67812,65801,66708,64634,69789,65970,69701,64872,65979,64815,65040,69693,66246,66380,69220,69195,69244,69228,69813,69725,69624,65508,68371,65103,69333,67203,65500,68387,67252,66492,65953,67235,67926,66676,69757,65087,69749,65023,65390,65319,65809,68714,69829,67155,66656,66420,64692,69268,67872,65302,67283,67028,64535,64751,67828,66629,67396,64543,64855,65961,67953,65479,65785,67123,67107,67853,65463,64651,67339,66598,64807,67804,67091,65713,65492,66302,67299,69869,66254,69566,66580,64676,69550,69349,65564,69292,67251,68135,66564,69400,69741,64511,67267,65745,67764,67934,67115,68411,66310,65358,66532,65143,69781,65934,64935,65271,64567,68866,65334,65793,65471,67388,69861,65422,69616,66657,69341,65516,69590,67888,69733,64735,64919,67748,66190,66198,69236,66436,67163,67380,69558,69373,64959,65367,68331,68781,65532,69316,64700,69276,69357,66460,68339,67347,69365,69845,64727,64791,65769,66094,69717,69709,69821,66372,65697,65729,64527,68355,64660,68181,67372,64783,67219,68403,66428,66262,66476,67331,64519,68478,66078,65263,67044,64775,67796,65524,67880,64551,65207,66356,67756,65199,69284,65151,65279,67099,66444,65572,66540,67012,64743,67307,65159,64863,67315,69381,67147,67275,67060,65015,66158,67227,66405,64831,64847,66206,65031,66988,67131,69853,66102,66222,65239,68363,68395,67179,69260,64839,68626,64642,66980,67052,68938,67291,67243,66524,69649,68161,69773,66700,67404,65120,67364,67076,66445,65978,69837,65548,64823,66278,66316,64999,67918,66126,66348,65007,65111,66230,64708,68379,67068,64576,67171,64759,69633,66270,67187,67772,64936,65556,65366,64903,65064,65247,66166,67323,65039,65342,66110,66182,69084,64668,66142,65310,66996,64991,64799,69805,66597,67211,64559,66317,65095,65318,67820,66294,65382,64927,66516,64767,66484,68090,69308,66134,66238,68072,67139,69300,65055,66332,66118,65406,66556,65737,67355,69582,65135,66396,65842,64719,66692,66727,69203,66468,67020,67036,65231,67195,67780,64887,66548,64911,64976,68323,65223,66340,65398,65119,66357,65183,65350,64684,65407,69252,66174,69389,69211,65753,64951,69598,66404,69009,65175,65856,66388,66621,65255,65215,69187,65191,64967,69324,67363,68347,65430,65079,65287,66572,65705,66279,65761,65580,69606,65446,65438,66214))",
        "cost_info": {
          "read_cost": "266.57",
          "eval_cost": "7.84",
          "prefix_cost": "274.41",
          "data_read_per_join": "1K"
        },
        "used_columns": [
          "product_id",
          "price",
          "percentage_discount",
          "lower_limit",
          "usergroup_id"
        ],
        "attached_condition": "((`chocoramo`.`cscart_product_prices`.`lower_limit` = 1) and (`chocoramo`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
      }
    }
  }
}

Result

product_id price
64511 6.95000000
64519 6.95000000
64527 6.95000000
64535 6.95000000
64543 6.95000000
64551 6.95000000
64559 6.95000000
64567 6.95000000
64576 6.95000000
64634 6.95000000
64642 6.95000000
64651 6.95000000
64660 6.95000000
64668 6.95000000
64676 6.95000000
64684 6.95000000
64692 6.95000000
64700 6.95000000
64708 6.95000000
64719 6.95000000
64727 6.95000000
64735 6.95000000
64743 6.95000000
64751 6.95000000
64759 6.95000000
64767 6.95000000
64775 6.95000000
64783 6.95000000
64791 6.95000000
64799 6.95000000
64807 6.95000000
64815 6.95000000
64823 6.95000000
64831 6.95000000
64839 6.95000000
64847 6.95000000
64855 6.95000000
64863 6.95000000
64871 6.95000000
64872 6.95000000
64887 6.95000000
64895 6.95000000
64903 6.95000000
64911 6.95000000
64919 6.95000000
64927 6.95000000
64935 6.95000000
64936 6.95000000
64951 6.95000000
64959 6.95000000
64967 6.95000000
64975 6.95000000
64976 6.95000000
64991 6.95000000
64999 6.95000000
65007 6.95000000
65015 6.95000000
65023 6.95000000
65031 6.95000000
65039 6.95000000
65040 6.95000000
65055 6.95000000
65063 6.95000000
65064 6.95000000
65079 6.95000000
65087 6.95000000
65095 6.95000000
65103 6.95000000
65111 6.95000000
65119 6.50000000
65120 6.95000000
65135 6.95000000
65143 6.95000000
65151 6.95000000
65159 6.95000000
65160 6.95000000
65175 6.95000000
65183 6.95000000
65191 6.95000000
65199 6.95000000
65207 6.95000000
65215 6.95000000
65223 6.95000000
65231 6.95000000
65239 6.95000000
65247 6.95000000
65255 6.95000000
65263 6.95000000
65271 6.95000000
65279 6.95000000
65287 6.95000000
65302 6.95000000
65310 6.95000000
65318 6.95000000
65319 6.95000000
65334 6.95000000
65342 6.95000000
65350 6.95000000
65358 6.95000000
65366 6.95000000
65367 6.95000000
65382 6.95000000
65390 6.95000000
65398 6.95000000
65406 6.95000000
65407 6.95000000
65422 6.95000000
65430 6.95000000
65438 6.95000000
65446 6.95000000
65454 6.95000000
65463 6.95000000
65471 6.95000000
65479 6.95000000
65492 6.95000000
65500 6.95000000
65508 6.95000000
65516 6.95000000
65524 6.95000000
65532 6.95000000
65540 6.95000000
65548 6.95000000
65556 6.95000000
65564 6.95000000
65572 6.95000000
65580 6.95000000
65697 6.95000000
65705 6.95000000
65713 6.95000000
65721 6.59000000
65729 6.95000000
65737 6.95000000
65745 6.95000000
65753 6.95000000
65761 6.95000000
65769 6.95000000
65777 6.95000000
65785 6.95000000
65793 6.95000000
65801 6.95000000
65809 6.95000000
65822 6.95000000
65831 6.95000000
65842 6.95000000
65856 6.95000000
65893 6.95000000
65934 6.95000000
65953 6.95000000
65961 6.95000000
65970 6.95000000
65978 6.95000000
65979 6.95000000
66078 6.95000000
66086 6.95000000
66094 6.95000000
66102 6.95000000
66110 6.95000000
66118 6.95000000
66126 6.95000000
66134 6.95000000
66142 6.95000000
66150 6.95000000
66158 6.95000000
66166 6.95000000
66174 6.95000000
66182 6.95000000
66190 6.95000000
66198 6.95000000
66206 6.95000000
66214 6.95000000
66222 6.95000000
66230 6.95000000
66238 6.95000000
66246 6.95000000
66254 6.95000000
66262 6.95000000
66270 6.95000000
66278 6.95000000
66279 6.95000000
66294 6.95000000
66302 6.95000000
66310 6.95000000
66316 6.95000000
66317 6.95000000
66332 6.95000000
66340 6.95000000
66348 6.95000000
66356 6.95000000
66357 6.95000000
66372 6.95000000
66380 6.95000000
66388 6.95000000
66396 6.95000000
66404 6.95000000
66405 6.95000000
66420 6.95000000
66428 6.95000000
66436 6.95000000
66444 6.95000000
66445 6.95000000
66460 6.95000000
66468 6.95000000
66476 6.95000000
66484 6.95000000
66492 6.95000000
66500 6.95000000
66508 6.95000000
66516 6.95000000
66524 6.95000000
66532 6.95000000
66540 6.95000000
66548 6.95000000
66556 6.95000000
66564 6.95000000
66572 6.95000000
66580 6.95000000
66597 6.95000000
66598 6.95000000
66613 6.95000000
66621 6.95000000
66629 6.95000000
66637 6.95000000
66656 6.95000000
66657 6.95000000
66676 6.95000000
66677 6.95000000
66692 6.95000000
66700 6.95000000
66708 6.95000000
66727 6.95000000
66980 6.95000000
66988 6.95000000
66996 6.95000000
67004 6.95000000
67012 6.95000000
67020 6.95000000
67028 6.95000000
67036 6.95000000
67044 6.95000000
67052 6.95000000
67060 6.95000000
67068 6.95000000
67076 6.95000000
67091 6.95000000
67099 6.95000000
67107 6.95000000
67115 6.95000000
67123 6.95000000
67131 6.95000000
67139 6.95000000
67147 6.95000000
67155 6.95000000
67163 6.95000000
67171 6.95000000
67179 6.95000000
67187 6.95000000
67195 6.95000000
67203 6.95000000
67211 6.95000000
67219 6.95000000
67227 6.95000000
67235 6.95000000
67243 6.95000000
67251 6.95000000
67252 6.95000000
67267 6.95000000
67275 6.95000000
67283 6.95000000
67291 6.95000000
67299 6.95000000
67307 6.95000000
67315 6.95000000
67323 6.95000000
67331 6.95000000
67339 6.95000000
67347 6.95000000
67355 6.95000000
67363 6.95000000
67364 6.95000000
67372 6.95000000
67380 6.95000000
67388 6.95000000
67396 6.95000000
67404 6.95000000
67748 6.95000000
67756 6.95000000
67764 6.95000000
67772 6.95000000
67780 6.95000000
67788 6.95000000
67796 6.95000000
67804 6.95000000
67812 6.95000000
67820 6.95000000
67828 6.95000000
67836 6.95000000
67853 6.95000000
67872 6.95000000
67880 6.95000000
67888 6.95000000
67918 6.95000000
67926 6.95000000
67934 6.95000000
67953 6.95000000
68072 6.95000000
68090 6.95000000
68135 6.95000000
68161 6.95000000
68181 6.95000000
68323 6.95000000
68331 6.95000000
68339 6.95000000
68347 6.95000000
68355 6.95000000
68363 6.95000000
68371 6.95000000
68379 6.95000000
68387 6.95000000
68395 6.95000000
68403 6.95000000
68411 6.95000000
68478 6.95000000
68626 6.95000000
68714 6.95000000
68781 6.95000000
68866 6.95000000
68938 6.95000000
69009 6.95000000
69084 6.95000000
69187 6.95000000
69195 6.95000000
69203 6.95000000
69211 6.95000000
69220 6.95000000
69228 6.95000000
69236 6.95000000
69244 6.95000000
69252 6.95000000
69260 6.95000000
69268 6.95000000
69276 6.95000000
69284 6.95000000
69292 6.95000000
69300 6.95000000
69308 6.95000000
69316 6.95000000
69324 6.95000000
69333 6.95000000
69341 6.95000000
69349 6.95000000
69357 6.95000000
69365 6.95000000
69373 6.95000000
69381 6.95000000
69389 6.95000000
69400 6.95000000
69550 6.95000000
69558 6.95000000
69566 6.95000000
69574 6.95000000
69582 6.95000000
69590 6.95000000
69598 6.95000000
69606 6.95000000
69616 6.95000000
69624 6.95000000
69633 6.95000000
69641 6.95000000
69649 6.95000000
69657 6.95000000
69693 6.95000000
69701 6.95000000
69709 6.95000000
69717 6.95000000
69725 6.95000000
69733 6.95000000
69741 6.95000000
69749 6.95000000
69757 6.95000000
69766 12.00000000
69773 6.95000000
69781 6.95000000
69789 6.95000000
69805 6.95000000
69813 6.95000000
69821 6.95000000
69829 6.95000000
69837 6.95000000
69845 6.95000000
69853 6.95000000
69861 6.95000000
69869 6.95000000