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 (
    1705, 1704, 1609, 1935, 1936, 1929, 1528, 
    1527, 1526, 1508, 1534, 1533, 1841, 
    1531, 1529, 1530, 1843, 1532, 1515, 
    1904, 1873, 1897, 1896, 1728, 1607, 
    1608, 1606, 1703, 1578, 1396, 1605, 
    1206, 1586, 1934, 1932, 1933, 1656, 
    1542, 1640, 1543, 1655, 1927, 1926, 
    1815, 1808, 1541, 1829, 1828
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'ja'

Query time 0.00160

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 (1705,1704,1609,1935,1936,1929,1528,1527,1526,1508,1534,1533,1841,1531,1529,1530,1843,1532,1515,1904,1873,1897,1896,1728,1607,1608,1606,1703,1578,1396,1605,1206,1586,1934,1932,1933,1656,1542,1640,1543,1655,1927,1926,1815,1808,1541,1829,1828) and cscart_ult_product_descriptions.lang_code = 'ja'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
1206
1396
1508
1515
1526
1527
1528
1529
1530
1531
1532
1533
1534
1541
1542
1543
1578
1586
1605
1606
1607
1608
1609
1640
1655
1656
1703
1704
1705
1728
1808
1815
1828
1829
1841
1843
1873
1896
1897
1904
1926
1927
1929
1932
1933
1934
1935
1936