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 (61337, 29986, 61336, 63034) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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 (61337,29986,61336,63034) 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
61336	heavy duty backing plate, lighting accessories, lighting wall hardware, backing plates, gooseneck lighting hardware, heavy duty lighting hardware, gooseneck wall mount, support for gooseneck light fixtures, heavy duty square backing plate	Browse our lighting accessories, light hardware, and backing plates. This heavy duty backing plate is made for gooseneck lighting in commercial settings and will stand the test of time!	heavy duty backing plate, heavy duty, backing plate, lighting accessories, lighting hardware, backing plates, gooseneck lighting, BLE-HDBP, heavy duty backing plate, lighting accessories, lighting wall hardware, backing plates, gooseneck lighting hardware, heavy duty lighting hardware, gooseneck wall mount, support for gooseneck light fixtures, heavy duty square backing plate, heavy duty baseplate, heavy duty mount, heavy duty bp, heavy duty back plate,
61337	decorative canopy cover, light canopy, canopy parts, light canopy parts, canopy cover, decorative canopy, gooseneck, backing plates, Decorative Backing Plate Cover	Shop for quality gooseneck parts fromt he lighting company you trust! This Decorative Backing Plate Cover made to fit any of our gooseneck backing plates.	decorative canopy cover, light canopy, canopy parts,light canopy parts, canopy cover, decorative canopy, gooseneck, backing plates, BLE-DCC, decorative bp cover,
63034	Gooseneck Hardware, lighting hardware, Swivel knuckle, swivel knuckle joint	The Swivel Knuckle is a piece of hardware that joins the mounting option and warehouse shade, allowing for a greater range of motion.	Swivel Knuckle, swivel, knuckle, knuckel, swivle, hardware, hard ware, hardware fixtures, lighting hardware, barn hardware, barn hard ware, lighting hardware, lighting hard ware, lighting fixture hardware, fixture hardware, knuckle hardware, knuckle hard ware, BLE-SWK, swivel joint, swivel knuckle joint, knuckle joint, adjustable knuckle,