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 (
    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, 
    1475, 1276, 1569, 1198, 1179, 1281, 
    926, 1258, 1168, 1394, 1259, 1865, 390, 
    1204, 1864, 1863
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00162

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 (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,1475,1276,1569,1198,1179,1281,926,1258,1168,1394,1259,1865,390,1204,1864,1863) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
19
284
344
390
926
974
1168
1179
1198
1204
1258
1259
1276
1281
1394
1469
1475
1507
1551
1569
1574
1575
1811
1812
1813
1814
1850
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
1874
1875
1883
1918
1919
1920
1922
1923