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 (
    1828, 1675, 1931, 1544, 1845, 1540, 1512, 
    1525, 1536, 1538, 1937, 1581, 1582, 
    1838, 1938, 1830, 1514, 1835, 1678, 
    1693, 1711, 1699, 1698, 1869, 1834, 
    1833, 1928, 1537, 1539, 1381, 1320, 
    359, 1892, 1898, 1899, 1436, 1411, 1397, 
    1741, 1270, 1376, 1301, 1330, 1215, 
    1439, 1323, 717, 1217, 1343, 1338, 1337, 
    1174, 1486, 718, 1339, 1417, 341, 1324, 
    1275, 1216, 1458, 819, 1460, 1464, 1455, 
    1450, 1382, 1385, 1383, 1386, 25, 1758, 
    1757, 1734, 1176, 1201, 1191, 1182, 
    1825, 1824, 1821, 1761, 1823, 1822, 
    1459, 1477, 1193, 1546, 1254, 1684, 
    1379, 1378, 701, 699, 711, 703
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00257

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 (1828,1675,1931,1544,1845,1540,1512,1525,1536,1538,1937,1581,1582,1838,1938,1830,1514,1835,1678,1693,1711,1699,1698,1869,1834,1833,1928,1537,1539,1381,1320,359,1892,1898,1899,1436,1411,1397,1741,1270,1376,1301,1330,1215,1439,1323,717,1217,1343,1338,1337,1174,1486,718,1339,1417,341,1324,1275,1216,1458,819,1460,1464,1455,1450,1382,1385,1383,1386,25,1758,1757,1734,1176,1201,1191,1182,1825,1824,1821,1761,1823,1822,1459,1477,1193,1546,1254,1684,1379,1378,701,699,711,703) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
25
341
359
699
701
703
711
717
718
819
1174
1176
1182
1191
1193
1201
1215
1216
1217
1254
1270
1275
1301
1320
1323
1324
1330
1337
1338
1339
1343
1376
1378
1379
1381
1382
1383
1385
1386
1397
1411
1417
1436
1439
1450
1455
1458
1459
1460
1464
1477
1486
1512
1514
1525
1536
1537
1538
1539
1540
1544
1546
1581
1582
1675
1678
1684
1693
1698
1699
1711
1734
1741
1757
1758
1761
1821
1822
1823
1824
1825
1828
1830
1833
1834
1835
1838
1845
1869
1892
1898
1899
1928
1931
1937
1938