SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    1652, 1309, 1653, 1668, 1634, 1688, 1499, 
    1613, 1648, 1723, 1590, 1510, 1950, 
    1951, 1924, 1949, 1745, 1654, 1501, 
    69, 89, 1643, 1645, 1925, 1666, 1664, 
    1557, 1695, 1559, 1315, 1310, 1471, 
    1502, 86, 1504, 33, 1944, 1942, 1900, 
    1777, 1748, 1679, 1702, 1610, 1706, 
    1683, 1946, 1524, 1562, 1509, 1952, 
    1700, 1589, 1492, 1316, 1690, 1729, 
    1637, 1731, 1636, 1638, 1639, 1629, 
    1631, 1630, 1622, 1615, 1621, 1907, 
    1955, 1663, 1674, 1490, 1746, 1831, 
    1832, 1591, 1737, 1805, 1647, 1774, 
    281, 1617, 282, 1503, 285, 1826, 1646, 
    1580, 1906, 1611, 1166, 67, 1252, 1930, 
    1561
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00252

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 96,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (1652,1309,1653,1668,1634,1688,1499,1613,1648,1723,1590,1510,1950,1951,1924,1949,1745,1654,1501,69,89,1643,1645,1925,1666,1664,1557,1695,1559,1315,1310,1471,1502,86,1504,33,1944,1942,1900,1777,1748,1679,1702,1610,1706,1683,1946,1524,1562,1509,1952,1700,1589,1492,1316,1690,1729,1637,1731,1636,1638,1639,1629,1631,1630,1622,1615,1621,1907,1955,1663,1674,1490,1746,1831,1832,1591,1737,1805,1647,1774,281,1617,282,1503,285,1826,1646,1580,1906,1611,1166,67,1252,1930,1561) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
33
67
69
86
89
281
282
285
1166
1252
1309
1310
1315
1316
1471
1490
1492
1499
1501
1502
1503
1504
1509
1510
1524
1557
1559
1561
1562
1580
1589
1590
1591
1610
1611
1613
1615
1617
1621
1622
1629
1630
1631
1634
1636
1637
1638
1639
1643
1645
1646
1647
1648
1652
1653
1654
1663
1664
1666
1668
1674
1679
1683
1688
1690
1695
1700
1702
1706
1723
1729
1731
1737
1745
1746
1748
1774
1777
1805
1826
1831
1832
1900
1906
1907
1924
1925
1930
1942
1944
1946
1949
1950
1951
1952
1955