SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    200, 201, 202, 203, 204, 205, 206, 207, 
    208, 209, 190, 210, 211, 212, 213, 214, 
    215, 216, 217, 218, 219, 191, 220, 221, 
    222, 223, 224, 225, 226, 227, 228, 229, 
    192, 230, 231, 232, 233, 234, 235, 236, 
    237, 238, 239, 193, 240, 241, 242, 243, 
    194, 195, 198, 199, 77, 82, 84, 85, 83, 
    89, 164, 142, 92, 165, 78, 67
  ) 
  AND cscart_product_descriptions.lang_code = 'vi'

Query time 0.00095

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY", "product_id"],
      "rows": 231,
      "filtered": 27.70562744,
      "attached_condition": "cscart_product_descriptions.product_id in (200,201,202,203,204,205,206,207,208,209,190,210,211,212,213,214,215,216,217,218,219,191,220,221,222,223,224,225,226,227,228,229,192,230,231,232,233,234,235,236,237,238,239,193,240,241,242,243,194,195,198,199,77,82,84,85,83,89,164,142,92,165,78,67) and cscart_product_descriptions.lang_code = 'vi'"
    }
  }
}

Result

product_id short_description full_description
67 <p>DORITHRICIN TAB 20'S PRODUCT DESCRIPTION</p>
77 SHORT DESCRIPTION
78 SHORT DESCRIPTION
82 SHORT DESCRIPTION
83 SHORT DESCRIPTION
84 SHORT DESCRIPTION
85 SHORT DESCRIPTION
89 <p>Promo Product</p>
92 SHORT DESCRIPTION
142
164 <p>Imported as VN lang</p>
165 <p>002 has a descriptionImported as VN lang</p>
190
191
192
193
194
195
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243