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 (62671, 64815, 65519, 65568) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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 (62671,64815,65519,65568) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62671 led 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 LED Decorative Backing Plate Cover made to fit any of our LED gooseneck backing plates. led decorative canopy cover, light canopy, canopy parts,light canopy parts, canopy cover, decorative canopy, gooseneck, backing plates, BLE-LDBPC, led backing plate cover, led backing plate, led cover, LDCHX, decorative bp cover,
64815 A favorite for practical and decorative applications in commercial settings, this green glass guard gives our fixtures a new purpose! Green Jelly Jar Glass, Green Glass, Green Jelly Jar, replacement green glass, replacement jelly jar, replacement glass, green replacement glass, green replacement glass guard, green glass guard, glass guard, jelly jar, jelly jars, glass guards, BLE-CGG-GLASS-GRN, colored glass, colored glass jelly jar, colored jelly jar,
65519 Change out broken glass shades with these stylish replacements! Available in three sizes and opaque and clear! BLE-GLB-GLASS, replacement glass ball, replacement glass ball shade, replacement glass ball shades, replacement ball, replacement ball shade, replacement ball shades, replacement glass shade, replacement glass shades, Glass ball shade, glass ball shades, ball shade, ball shades, replacement globes, bubble glass, glb, glbcl,
65568 barn light parts, new socket, replacement socket, socket replacement, GU24 socket, socket and cord, socket with cord, cord replacement, replace cord, cord hung pendant without shade, cord and socket, socket and cord,