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, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    1206, 1384, 1389, 1393, 1404, 1403, 1402, 
    1401, 1398, 1400, 1394, 1399, 1397, 
    1396, 1395, 1340, 1337, 1338, 1339, 
    1347, 1390, 1342, 1341, 1016, 1381, 
    25, 1392, 1391, 1166, 1388, 1380, 1330, 
    1387, 1386, 1385, 1383, 1382, 1369, 
    1379, 1378, 1377, 1376, 1375, 1374, 
    1373, 1372, 1371, 1370
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00154

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 48,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (1206,1384,1389,1393,1404,1403,1402,1401,1398,1400,1394,1399,1397,1396,1395,1340,1337,1338,1339,1347,1390,1342,1341,1016,1381,25,1392,1391,1166,1388,1380,1330,1387,1386,1385,1383,1382,1369,1379,1378,1377,1376,1375,1374,1373,1372,1371,1370) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
25
1016
1166
1206
1330
1337
1338
1339
1340
1341
1342
1347
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404