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 (
    881, 894, 882, 895, 893, 950, 957, 949, 
    956, 953, 954, 951, 952, 958, 1090, 955, 
    335, 334, 156, 336, 961, 965, 963, 964, 
    962, 966, 219, 270, 1302, 272, 273, 274, 
    973, 223, 222, 160, 194, 164, 174, 158, 
    183, 192, 188, 163, 172, 184, 173, 191
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00157

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 (881,894,882,895,893,950,957,949,956,953,954,951,952,958,1090,955,335,334,156,336,961,965,963,964,962,966,219,270,1302,272,273,274,973,223,222,160,194,164,174,158,183,192,188,163,172,184,173,191) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
156
158
160
163
164
172
173
174
183
184
188
191
192
194
219
222
223
270
272
273
274
334
335
336
881
882
893
894
895
949
950
951
952
953
954
955
956
957
958
961
962
963
964
965
966
973
1090
1302