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 (
    170, 162, 168, 61, 166, 736, 734, 732, 
    733, 735, 737, 1569, 258, 257, 1783, 
    1779, 1782, 1781, 1676, 1229, 1181, 
    362, 256, 452, 420, 374, 800, 1136, 224, 
    795, 1839, 797, 798, 1409, 367, 1393, 
    484, 445, 157, 388, 585, 241, 629, 590, 
    860, 1790, 230, 413, 681, 393, 41, 1827, 
    1454, 1476, 1473, 1198, 1179, 1281, 
    926, 1258, 1168, 1394, 1259, 1865, 390, 
    1412, 1066, 1399, 1204, 1387, 332, 330, 
    333, 329, 327, 504, 1008, 758, 1817, 
    1819, 1172, 1196, 1908, 1809, 1405, 
    1851, 730, 1481, 382, 453, 425, 1428, 
    1425, 1426, 1430, 1429
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00246

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 (170,162,168,61,166,736,734,732,733,735,737,1569,258,257,1783,1779,1782,1781,1676,1229,1181,362,256,452,420,374,800,1136,224,795,1839,797,798,1409,367,1393,484,445,157,388,585,241,629,590,860,1790,230,413,681,393,41,1827,1454,1476,1473,1198,1179,1281,926,1258,1168,1394,1259,1865,390,1412,1066,1399,1204,1387,332,330,333,329,327,504,1008,758,1817,1819,1172,1196,1908,1809,1405,1851,730,1481,382,453,425,1428,1425,1426,1430,1429) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
41
61
157
162
166
168
170
224
230
241
256
257
258
327
329
330
332
333
362
367
374
382
388
390
393
413
420
425
445
452
453
484
504
585
590
629
681
730
732
733
734
735
736
737
758
795
797
798
800
860
926
1008
1066
1136
1168
1172
1179
1181
1196
1198
1204
1229
1258
1259
1281
1387
1393
1394
1399
1405
1409
1412
1425
1426
1428
1429
1430
1454
1473
1476
1481
1569
1676
1779
1781
1782
1783
1790
1809
1817
1819
1827
1839
1851
1865
1908