SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    65806, 65807, 65809, 65810, 65811, 65812, 
    65817, 65818, 65819, 65820, 65821, 
    65822
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 12,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65806,65807,65809,65810,65811,65812,65817,65818,65819,65820,65821,65822) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65806 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30", 30" laramie led, led laramie 30, 30 laramie led, oversized laramie led, 30" led laramie
65807 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30", 30" laramie led, led laramie 30, 30 laramie led, oversized laramie led, 30" led laramie
65809 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30", 30" laramie led, led laramie 30, 30 laramie led, oversized laramie led, 30" led laramie
65810 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30", 30" laramie led, led laramie 30, 30 laramie led, oversized laramie led, 30" led laramie
65811 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30", 30" laramie led, led laramie 30, 30 laramie led, oversized laramie led, 30" led laramie
65812 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30", 30" laramie led, led laramie 30, 30 laramie led, oversized laramie led, 30" led laramie
65817 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30", 30" chestnut led, led chestnut 30, 30 chestnut led, oversized chestnut led, 30" led chestnut
65818 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30", 30" chestnut led, led chestnut 30, 30 chestnut led, oversized chestnut led, 30" led chestnut
65819 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30", 30" chestnut led, led chestnut 30, 30 chestnut led, oversized chestnut led, 30" led chestnut
65820 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30", 30" chestnut led, led chestnut 30, 30 chestnut led, oversized chestnut led, 30" led chestnut
65821 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30", 30" chestnut led, led chestnut 30, 30 chestnut led, oversized chestnut led, 30" led chestnut
65822 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30", 30" chestnut led, led chestnut 30, 30 chestnut led, oversized chestnut led, 30" led chestnut