SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    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_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00162

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id", "company_id"],
      "key": "PRIMARY",
      "key_length": "13",
      "used_key_parts": ["product_id", "lang_code", "company_id"],
      "rows": 48,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.product_id in (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_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
41
327
329
330
332
333
382
390
393
425
453
504
681
730
758
926
1008
1066
1168
1172
1179
1196
1198
1204
1258
1259
1281
1387
1394
1399
1405
1412
1425
1426
1428
1429
1430
1454
1473
1476
1481
1809
1817
1819
1827
1851
1865
1908