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 (
    403, 1414, 151, 57, 58, 29, 1947, 683, 
    1377, 1166, 358, 1167, 708, 1177, 1195, 
    1208, 1178, 1849, 1846, 1848, 1847, 
    1171, 1322, 1448, 789, 1375, 1230, 1227, 
    1770, 1769, 1420, 77, 1449, 1235, 1442, 
    1958, 67, 1252, 803, 1169, 1712, 1759, 
    1341, 1592, 1474, 1733, 1002, 1930
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00167

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 (403,1414,151,57,58,29,1947,683,1377,1166,358,1167,708,1177,1195,1208,1178,1849,1846,1848,1847,1171,1322,1448,789,1375,1230,1227,1770,1769,1420,77,1449,1235,1442,1958,67,1252,803,1169,1712,1759,1341,1592,1474,1733,1002,1930) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
29
57
58
67
77
151
358
403
683
708
789
803
1002
1166
1167
1169
1171
1177
1178
1195
1208
1227
1230
1235
1252
1322
1341
1375
1377
1414
1420
1442
1448
1449
1474
1592
1712
1733
1759
1769
1770
1846
1847
1848
1849
1930
1947
1958