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
  ) 
  AND cscart_product_descriptions.lang_code = 'vi'

Query time 0.00066

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 32,
      "filtered": 100,
      "index_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) and cscart_product_descriptions.lang_code = 'vi'"
    }
  }
}

Result

product_id short_description full_description
190
191
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