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 (
    1788, 1697, 1657, 1687, 1921, 1238, 1197, 
    1307, 1306, 1940, 1941, 1660, 1751, 
    1677, 1305, 1588, 1662, 1635, 1747, 
    1587, 1771, 1709, 1957, 1707, 1768, 
    1710, 1954, 1953, 1730, 1686, 1593, 
    1594, 1616, 1773, 1701, 1584, 1585, 
    1868, 1579, 1956, 1495, 1739, 1740, 
    1912, 1913, 1650, 56, 1836, 1336, 1837, 
    1820, 1304, 1738, 1893, 1895, 1894, 
    1641, 1500, 1317, 1670, 1658, 1558, 
    1644, 1262, 1552, 1398, 1595, 1576, 
    1870, 1691, 1776, 1785, 1633, 1563, 
    1564, 1667, 1786, 1945, 1910, 1787, 
    1308, 1642, 1772, 1736, 1277, 1672, 
    1325, 1665, 1778, 1775, 1671, 1649, 
    1909, 1948, 1612, 1267
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00258

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 (1788,1697,1657,1687,1921,1238,1197,1307,1306,1940,1941,1660,1751,1677,1305,1588,1662,1635,1747,1587,1771,1709,1957,1707,1768,1710,1954,1953,1730,1686,1593,1594,1616,1773,1701,1584,1585,1868,1579,1956,1495,1739,1740,1912,1913,1650,56,1836,1336,1837,1820,1304,1738,1893,1895,1894,1641,1500,1317,1670,1658,1558,1644,1262,1552,1398,1595,1576,1870,1691,1776,1785,1633,1563,1564,1667,1786,1945,1910,1787,1308,1642,1772,1736,1277,1672,1325,1665,1778,1775,1671,1649,1909,1948,1612,1267) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
56
1197
1238
1262
1267
1277
1304
1305
1306
1307
1308
1317
1325
1336
1398
1495
1500
1552
1558
1563
1564
1576
1579
1584
1585
1587
1588
1593
1594
1595
1612
1616
1633
1635
1641
1642
1644
1649
1650
1657
1658
1660
1662
1665
1667
1670
1671
1672
1677
1686
1687
1691
1697
1701
1707
1709
1710
1730
1736
1738
1739
1740
1747
1751
1768
1771
1772
1773
1775
1776
1778
1785
1786
1787
1788
1820
1836
1837
1868
1870
1893
1894
1895
1909
1910
1912
1913
1921
1940
1941
1945
1948
1953
1954
1956
1957