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 (316, 396, 526, 287, 325) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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 (316,396,526,287,325) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
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.
316 Camera, Tripod, Head, Quick, Shoe, Clamp, Plate, Bracket, Arca-Swiss, rrs, kirk, foba For Sony α7II α7RII. Optional LS-A72 for PS-A72 to convert it to L-Plate（L-Bracket）
325 Camera, Lens, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba Markins PL-55 is a 2.4in (60mm) long anti-twist flange style lens plate.
396 Tripod, Head, Quick, Shoe, Clamp, Panorama, Arca-Swiss, rrs, kirk, foba Markins QR-70P is QuickShoe that rotates 360 degrees which is developed for panoramic photography.
526 Camera,head, ballhead, tripod, gitzo, Arca Swiss, RRS, KIRK, Wimberley, foba Fine Art Quality, Professional Ball Head Markins Q3i-BL Knob Shoe