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 (257, 259, 287, 280, 350) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 5,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (257,259,287,280,350) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
257 Camera,head, ballhead, tripod, gitzo, Arca Swiss, RRS, KIRK, Wimberley, foba Fine Art Quality, Professional Ball Head Markins Q3iQ-BK Lever Shoe
259 Camera,head, ballhead, tripod, gitzo, Arca Swiss, RRS, KIRK, Wimberley, foba Fine Art Quality, Professional Ball Head Markins Q10i-BK Knob Shoe
280 Hasselblad, H1D, H2D, H3D, H4D, H5D, H6D, rrs, kirk, arca-swiss Markins H3 is an anti-twist style camera plate for Hasselblad H1D H2D H3D H4D H5D H6D cameras.
287 Canon, 5D, 5Ds, 5Ds R, markIII, mark3, mkIII, mk3, Camera, Tripod, Head, Quick, Shoe, Clamp, Plate, Arca-Swiss, rrs, kirk, foba Markins P53U is an anti-twist flange style camera plate for Canon 5D markIII without battery grip.
350