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

Query time 0.00039

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 (61340,60914,62240,29989) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
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
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,
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,
62240	specialty hex nut, hex nut cover, copper hex nut, copper barn light hex cover, copper lamp parts, copper lighting accessories	Conceal metal hex nuts with our hex nut cover. This hex cover fits snugly on shade mounts, proving a sleek and polished look.	BLE-HEXC-COP, Copper Hex Cover, specialty hex nut, hex nut cover, copper hex nut, copper barn light hex cover, copper lamp parts, copper lighting accessories, hex cover, decorative hex cover, LDCHX, hex coupling