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 (
    710, 706, 1760, 1844, 1689, 1754, 1755, 
    1840, 1756, 1753, 1792, 1791, 1793, 
    1789, 1472, 1716, 1714, 1715, 1720, 
    1719, 1722, 1713, 1718, 1717, 1867, 
    1721, 1145, 1891, 1202, 247, 296, 1218, 
    1765, 820, 1816, 1651, 1661, 255, 65, 
    1959, 1011, 1685, 1207, 1210, 1203, 
    1389, 1188, 1190
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00168

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 (710,706,1760,1844,1689,1754,1755,1840,1756,1753,1792,1791,1793,1789,1472,1716,1714,1715,1720,1719,1722,1713,1718,1717,1867,1721,1145,1891,1202,247,296,1218,1765,820,1816,1651,1661,255,65,1959,1011,1685,1207,1210,1203,1389,1188,1190) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65
247
255
296
706
710
820
1011
1145
1188
1190
1202
1203
1207
1210
1218
1389
1472
1651
1661
1685
1689
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1753
1754
1755
1756
1760
1765
1789
1791
1792
1793
1816
1840
1844
1867
1891
1959