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 (
    712, 693, 691, 1013, 762, 1241, 1264, 
    723, 751, 503, 628, 467, 754, 752, 655, 
    761, 1142, 1141, 1146, 721, 722, 615, 
    524, 1140, 1143, 1144, 293, 924, 750, 
    898, 565, 447, 460, 482, 1408, 1047, 
    463, 824, 521, 54, 292, 351, 343, 384, 
    340, 1139, 825, 672
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00146

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 (712,693,691,1013,762,1241,1264,723,751,503,628,467,754,752,655,761,1142,1141,1146,721,722,615,524,1140,1143,1144,293,924,750,898,565,447,460,482,1408,1047,463,824,521,54,292,351,343,384,340,1139,825,672) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
54
292
293
340
343
351
384
447
460
463
467
482
503
521
524
565
615
628
655
672
691
693
712
721
722
723
750
751
752
754
761
762
824
825
898
924
1013
1047
1139
1140
1141
1142
1143
1144
1146
1241
1264
1408