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 (
    19, 1814, 1813, 1874, 1875, 974, 1574, 
    1575, 1812, 1811, 1507, 1853, 1856, 
    1918, 1919, 1862, 1861, 1857, 1883, 
    1860, 1859, 1854, 1923, 1858, 1922, 
    1855, 1920, 1469, 344, 1850, 1551, 284, 
    1475, 1276, 1569, 1198, 1179, 1281, 
    926, 1258, 1168, 1394, 1259, 1865, 390, 
    1204, 1864, 1863
  ) 
  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.00169

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_prices",
      "access_type": "range",
      "possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 52,
      "filtered": 9.795915604,
      "index_condition": "cscart_product_prices.product_id in (19,1814,1813,1874,1875,974,1574,1575,1812,1811,1507,1853,1856,1918,1919,1862,1861,1857,1883,1860,1859,1854,1923,1858,1922,1855,1920,1469,344,1850,1551,284,1475,1276,1569,1198,1179,1281,926,1258,1168,1394,1259,1865,390,1204,1864,1863)",
      "attached_condition": "cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,1)"
    }
  }
}

Result

product_id price
19 22500.00000000
284 70000.00000000
344 34000.00000000
390 7000.00000000
926 235000.00000000
974 56000.00000000
1168 32000.00000000
1179 260000.00000000
1198 30000.00000000
1204 21000.00000000
1258 29000.00000000
1259 30000.00000000
1276 0.00000000
1281 32000.00000000
1394 31000.00000000
1469 28000.00000000
1475 0.00000000
1507 130000.00000000
1551 70000.00000000
1569 68500.00000000
1574 30000.00000000
1575 30000.00000000
1811 24000.00000000
1812 24000.00000000
1813 25000.00000000
1814 25000.00000000
1850 50000.00000000
1853 46000.00000000
1854 46000.00000000
1855 46000.00000000
1856 50000.00000000
1857 50000.00000000
1858 23500.00000000
1859 23500.00000000
1860 23500.00000000
1861 23500.00000000
1862 23500.00000000
1863 33000.00000000
1864 32000.00000000
1865 45000.00000000
1874 65000.00000000
1875 65000.00000000
1883 30000.00000000
1918 13000.00000000
1919 23500.00000000
1920 23500.00000000
1922 22500.00000000
1923 46000.00000000