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 (65694, 65695, 65696) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65694,65695,65696) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
65694 An iconic silhouette that won't break your budget! Our Barn Light Basics Wilcox Gooseneck Light is the heavy duty deep bowl shade you've been looking for! basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, bowl light, bowl shaped gooseneck, deep bowl light, deep bowl gooseneck, modern gooseneck light, discount modern lights, basic modern light, wilcox gooseneck, wilcox light, wilcox basic, wilcox gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, back to basics, H-16112, H-16116, H-16118, classic deep bowl shade, classic deep bowl shade gooseneck,
65695 Crafted from weather resistant aluminum, our Barn Light Basics Wilcox Stem Mount Pendant is a smart and affordable choice suitable for indoor or outdoor use! basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, wilcox stem, wilcox light, wilcox basic, wilcox stem light, discount stem mount light, discount stems, discount stem mounts, basic stems, basic stem mounts, budget stem lights, budget stem mount lights, budget friendly stem lights, wilcox discount light, wilcox sign light, basic sign light, budget sign light, budget friendly sign light, wilcox discount, wilcox discount light, wilcox basic, wilcox basic light, discounted deep bowl light, wilcox basics, basic bowl light, budget bowl light, budget deep bowl, discount deep bowl, budget deep bowl light, discount deep bowl light, wilcox deep bowl, deep bowl stem light, deep bowl stem mount, discount deep bowl stem light, budget discount deep bowl stem light, back to basics, H-16112, H-16116, H-16118, classic deep bowl shade, classic deep bowl shade stem mount,
65696 The deep bowl style you love at a price you'll love even more! Our Barn Light Basics Wilcox Pendant Light is the perfect statement for above a dining room table! basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, wilcox basic, basic wilcox, wilcox basics, bowl light, bowl shaped pendant, wilcox cord, deep bowl light, deep bowl pendant, modern cord light, modern cord pendant, discount modern lights, basic modern light, wilcox light, back to basics, H-16112, H-16116, H-16118, classic deep bowl shade, classic deep bowl shade cord-hung pendant,