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 (
    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_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 (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_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
25
341
699
701
703
711
718
819
1174
1176
1182
1191
1193
1201
1216
1254
1275
1324
1337
1338
1339
1343
1378
1379
1382
1383
1385
1386
1417
1450
1455
1458
1459
1460
1464
1477
1486
1546
1684
1734
1757
1758
1761
1821
1822
1823
1824
1825