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

Query time 0.00036

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 (62012,61336,61337,63034) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
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,
62012	outdoor light sensor, dusk to dawn light sensor, outdoor dusk to dawn sensor, photocell light sensor, photo sensor for barn lighting, dusk-to-dawn barn light, weather proof barn light dusk to dawn sensor, dusk to dawn coverplate	Install our dusk-to-dawn sensor to your gooseneck barn light's backing plate for energy efficient light. This photocell turns on at dusk and off at dawn.	BLE-DD, Dusk-to-Dawn Photocell, outdoor light sensor, dusk to dawn light sensor, outdoor dust to dawn sensor, photocell light sensor, photo sensor for barn lighting, dusk-to-dawn barn light, weather proof barn light dust to dawn sensor, dusk to dawn coverplate, solar, photo cell, dawn to dusk, dusk to dawn photocell, dusk to dawn sensor, photo cells, photocell sensor, dusk til dawn, dusk till dawn
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,