Sandbox

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 (58884, 29983, 61340, 29989) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (58884,29983,61340,29989) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
29983	Lighting Hardware, Lighting Hardware Accessories, Light Hardware Accessories, Lights Hardware Accessories, Hardware Accessories, Lighting Accessories, Light Hardware Accessories, Stem Mount	1/2 inch or 3/4 inch round aluminum pipe threaded on both ends that connects the ceiling canopy and the shade, can be hung both vertically and horizontally.	Barn Light - 1/2" & 3/4" IP Stem Extensions, stem, stem replacement, lighting hardware, hardware, pipe extension
29989	Lighting Hardware, Lighting Hardware Accessories, Light Hardware Accessories, Lights Hardware Accessories, Hardware Accessories, Lighting Accessories, Light Hardware Accessories		Barn Light - Stem Mount Canopy,BLE-SMC-, standard canopy, canopy, stem canopy, BLE-SC, SC
58884	gooseneck socket replacement, vintage barn light socket replacement, porcelain enamel socket replacement	This socket assembly is often used as a replacement part for vintage porcelain enamel barn lights, and can fit any Barn Light with a hex hole in the neck.	Socket Assembly - Coupler - 7' Wire, socket, coupler, lighting parts, vintage light repair, socket replacement, replacement socket, gooseneck socket, stem socket, light socket,
61340	heavy duty, stem mount, canopy, light canopy, heavy duty mount, heavy duty canopy, commercial, heavy lighting, Lighting Hardware, Lighting Hardware Accessories, Light Hardware Accessories, Lights Hardware Accessories, Hardware Accessories, Heavy Duty, L	This light canopy has a heavy duty mount. Use this heavy duty canopy to secure commercial lighting and heavy lighting.	ceiling bracket, stem canopy, backing plate, heavy duty canopy, ceiling canopy, ceiling mount,