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 (65700, 65701, 65702) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00068

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 (65700,65701,65702) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
65700	Our sturdy, all-weather Avalon shade is now at a cost your budget will love! Our Barn Light Basics Avalon Gooseneck Light is the perfect balance of efficiency and style!	All Weather, Gooseneck, Warehouse Shade, Warehouse Gooseneck, BLE-G-LCS-PC, wall light, exterior, Discount gooseneck, All Weather Gooseneck 12," 14" and 16" Warehouse Shade, All weather goose neck, all weather warehouse shade, all weather ware house shade, All weather warehouse light, All weather warehouse lights, All weather warehouse lighting, All weather light, All weather lights, All weather lighting, All weather ware house light, All weather ware house lights, All weather ware house lighting, All weather farmhouse, All weather farm house, All weather outdoor lighting, All weather outdoor light, All weather outdoor lights, all weather gooseneck farm light wall mount, all weather gooseneck farm light wall mounts, all weather gooseneck wall mount, all weather gooseneck wall mounts, all weather gooseneck wall mount light, all weather gooseneck wall mount lights, all weather gooseneck wall mount lighting, all weather wall mount, all weather wall mounts, all weather gooseneck wall mount light, all weather gooseneck wall mount lights, all weather gooseneck wall mount lighting, all weather wall mount light, all weather wall mount lights, all weather wall mount lighting, All weather Gooseneck Farm light, All weather Gooseneck Farm lights, All weather Gooseneck Farm lighting, All weather Goose neck Farm light, All weather Goose neck Farm lights, All weather Goose neck Farm lighting, All weather gooseneck light, All weather gooseneck lights, All weather gooseneck lighting, All weather gooseneck, All weather wall mount, All weather wall mounts, All weather wall mount light, All weather wall mount lights, All weather wall mount lighting, 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, discount modern lights, basic modern light, avalon gooseneck, avalon light, avalon basic, avalon gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, avalon gooseneck, avalon discount light, budget lights, farm & barn, farm and barn, all weather, all-weather, all weather gooseneck warehouse light, back to basics,
65701	If you're looking for a true all-weather light at a price you'll love, look no further than our Barn Light Basics Avalon Stem Mount Light! Stress-free customization for a simple shopping experience!	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, avalon stem, avalon light, avalon basic, 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, avalon discount light, avalon sign light, basic sign light, budget sign light, budget friendly sign light, avalon discount, avalon discount light, avalon basic, avalon basic light, discounted deep bowl light, avalon basics, all weather, all-weather, all weather stem light, all weather stem mount, all-weather stem mounted light, all weather pendant, farm & barn, farm and barn, back to basics,
65702	The farm & barn style you love at a price you can't beat! Handspun aluminum makes our Barn Light Basics Avalon Pendant Light a durable yet stylish choice!	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, avalon basic, avalon basics, avalon light, warehouse pendant, avalon warehouse pendant, avalon cord, avalon cord light, avalon cord pendant, discount barn lights, discount warehouse lights, basic barn light, simple barn light, minimal barn light, discount lights, discount fixtures, discount, farm & barn, farm & barn light, farm and barn, farm and barn light, farm & barn pendant, farm and barn pendant, farm & barn cord, farm & barn cord pendant, back to basics,