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, 62123, 29986, 60914) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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,62123,29986,60914) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
29986	wall mount plate, backing plate, gooseneck holder, wall bracket, wall mount for gooseneck, wall mount for goosenecks, farm light wall mount, wall light mount, barn lighting hardware,	Looking for durable and industrial barn style wall mounting? This gooseneck wall mount bracket comes in 1/2" and 1/4" options with a variety of finishes.	Barn Light - Gooseneck Backing Plates, wall mount bracket, wall bracket, backing plate
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,
60914	hang straight, ceiling canopy, light canopy kit, canopy kit, hang straight canopy, sloped ceiling, vaulted ceiling, light canopy parts, ceiling canopy, slope, vaulted, pitch, ceiling, Lighting Hardware, Lighting Hardware Accessories, Light Hardware Acc	This light canopy kit includes a hang straight canopy for mounting a stem fixture on a sloped or vaulted ceiling. Shop parts needed to hang lighting in your home.	wall mount bracket, wall bracket, backing plate, Hang Straight Ceiling Canopy, slope, vaulted, pitch, ceiling, Light Hardware Accessories, accessory, hang straight, straight hang, hang straight canopy, ceiling canopy, sloped ceiling, vaulted ceiling, ceiling hang straight canopy, mount for sloped ceiling, mounting for slope ceiling, mounting for sloped ceiling, sloped ceiling mount, hang right, hang right canopy,
62123	vintage barn light pendant kit, socket and cord kit, pendant cords, replacement cords, pendant light restoration.	For refurbishing or repairing vintage barn light pendants. This socket and light cord kit includes 8 feet of customized cord, porcelain socket, and hex coupler.	BLE-SKA-5101, Replacement Socket & Cord for Pendants, replacement socket, replacement cord, replacement socket for pendant, socket, cord, socket and cord, cord replacement, light socket, barn light parts, cord hung pendant without shade, cord and socket, socket and cord,