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 (
    728, 96, 141, 95, 149, 148, 150, 133, 132, 
    131, 94, 385, 138, 137, 139, 127, 128, 
    130, 101, 146, 124, 125, 622, 481, 760, 
    346, 371, 353, 494, 522, 479, 458, 442, 
    432, 441, 439, 480, 440, 364, 338, 383, 
    419, 352, 682, 81, 50, 306, 817, 394, 
    402, 129, 126, 147, 152, 1041, 818, 816, 
    66, 27, 28, 1159, 1160, 1158, 1164, 1165, 
    119, 120, 121, 731, 90, 82, 829, 1007, 
    1006, 1003, 1004, 1005, 108, 109, 110, 
    1318, 92, 80, 55, 140, 134, 350, 21, 91, 
    136, 135, 1228, 933, 1239, 70, 123
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00253

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": 96,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.product_id in (728,96,141,95,149,148,150,133,132,131,94,385,138,137,139,127,128,130,101,146,124,125,622,481,760,346,371,353,494,522,479,458,442,432,441,439,480,440,364,338,383,419,352,682,81,50,306,817,394,402,129,126,147,152,1041,818,816,66,27,28,1159,1160,1158,1164,1165,119,120,121,731,90,82,829,1007,1006,1003,1004,1005,108,109,110,1318,92,80,55,140,134,350,21,91,136,135,1228,933,1239,70,123) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
21
27
28
50
55
66
70
80
81
82
90
91
92
94
95
96
101
108
109
110
119
120
121
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
146
147
148
149
150
152
306
338
346
350
352
353
364
371
383
385
394
402
419
432
439
440
441
442
458
479
480
481
494
522
622
682
728
731
760
816
817
818
829
933
1003
1004
1005
1006
1007
1041
1158
1159
1160
1164
1165
1228
1239
1318