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 (
    1451, 1183, 18, 17, 19, 1814, 1813, 1874, 
    1875, 974, 1574, 1575, 1812, 1811, 1507, 
    1853, 1856, 1918, 1919, 1862, 1861, 
    1857, 1883, 1860, 1859, 1854, 1923, 
    1858, 1922, 1855, 1920, 1469, 344, 1850, 
    1551, 284, 1885, 1628, 1625, 1475, 1276, 
    1312, 1303, 74, 1161, 75, 182, 161
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00169

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 (1451,1183,18,17,19,1814,1813,1874,1875,974,1574,1575,1812,1811,1507,1853,1856,1918,1919,1862,1861,1857,1883,1860,1859,1854,1923,1858,1922,1855,1920,1469,344,1850,1551,284,1885,1628,1625,1475,1276,1312,1303,74,1161,75,182,161) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
17
18
19
74
75
161
182
284
344
974
1161
1183
1276
1303
1312
1451
1469
1475
1507
1551
1574
1575
1625
1628
1811
1812
1813
1814
1850
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1874
1875
1883
1885
1918
1919
1920
1922
1923