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

Query time 0.00035

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,62123,29983) 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
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,
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,