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 (
    1928, 1929, 1911, 1925, 1926, 1901, 1908, 
    1923, 1922, 1921, 1909, 1920, 1919, 
    1918, 1917, 1916, 1915, 1914, 1883, 
    1913, 1912, 1910, 1903, 1902, 1905, 
    1904, 1872, 1899, 1898, 1897, 1896, 
    1873, 1895, 1894, 1893, 1891, 1659, 
    1890, 1889, 1888, 1887, 1871, 1885, 
    1886, 1884, 1869, 1882, 1881
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00150

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 (1928,1929,1911,1925,1926,1901,1908,1923,1922,1921,1909,1920,1919,1918,1917,1916,1915,1914,1883,1913,1912,1910,1903,1902,1905,1904,1872,1899,1898,1897,1896,1873,1895,1894,1893,1891,1659,1890,1889,1888,1887,1871,1885,1886,1884,1869,1882,1881) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
1659
1869
1871
1872
1873
1881
1882
1883
1884
1885
1886
1887
1888
1889
1890
1891
1893
1894
1895
1896
1897
1898
1899
1901
1902
1903
1904
1905
1908
1909
1910
1911
1912
1913
1914
1915
1916
1917
1918
1919
1920
1921
1922
1923
1925
1926
1928
1929