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 (
    1414, 1453, 1452, 1407, 1432, 1451, 1445, 
    1411, 1449, 1406, 1448, 1447, 1413, 
    1439, 1419, 1444, 1443, 1418, 1442, 
    1420, 1441, 1440, 1433, 1438, 1436, 
    1435, 1434, 1415, 1431, 1430, 1429, 
    1428, 1427, 1426, 1425, 1424, 1423, 
    1422, 1421, 1417, 1416, 1412, 1410, 
    153, 1409, 1408, 1405, 297
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00152

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 (1414,1453,1452,1407,1432,1451,1445,1411,1449,1406,1448,1447,1413,1439,1419,1444,1443,1418,1442,1420,1441,1440,1433,1438,1436,1435,1434,1415,1431,1430,1429,1428,1427,1426,1425,1424,1423,1422,1421,1417,1416,1412,1410,153,1409,1408,1405,297) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
153
297
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1438
1439
1440
1441
1442
1443
1444
1445
1447
1448
1449
1451
1452
1453