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 (62123, 29986, 60914, 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 (62123,29986,60914,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
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
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,