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 (65685, 64720, 65692, 65695) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00056

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 (65685,64720,65692,65695) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64720 benjamin stem pendant, radial wave rlm, waved reflector, wavy stem mount pendant, retro gas station lighting, retro restaurant light, decorative porch light, fluted stel pendant, vintage gas station light Infuse retro-seashore style to your outdoor lights with this festive, waved shade. Perfect for decorative lighting! Benjamin Seaside, Benjamin radial wave, Benjamin radial wave reflector, Seaside stem mount, radial wave stem mount, radial wave reflector stem mount, Seaside pendant, radial wave pendant, radial wave reflector pendant, BLE-S-RWS, BLE-S-RWS12, BLE-S-RWS14, BLE-S-RWS16, seaside pendant, radial pendant, seaside stem, stem seaside, reflector stem, seaside radial, sea side stem, sea, new listing, new rlm, new seaside, starfire, star fire, radial wave, starfire pendant, star fire pendant, starfire stem, star fire stem, Starfire pendant, starfire reflector pendant, radial wave stem mount, radial wave pendant, radial wave reflector stem mount, radial wave reflector pendant, radial wave, reflector, The Starfire Radial Wave Reflector Stem Light, BLE-S-RWS-PC, BLE-S-RWS12-PC, BLE-S-RWS14-PC, BLE-S-RWS16-PC, BLE-S-RWS12, BLE-S-RWS14, BLE-S-RWS16, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Seaside nautical barn light, Seaside nautical barn lights, Seaside nautical barn lighting, Sea side nautical barn light, Sea side nautical barn lights, Sea side nautical barn lighting, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, jadeite, jadite, jadeite light, jadite light, H-19112, H-19114, H-19116, classic radial shade, classic radial shade stem mount,
65685 Searching for a durable, weather resistant fixture at a price you can't beat? Our Barn Light Basics The Original™ Stem Mount Pendant is exactly what 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, the original stem, the original light, the original basic, the original stem light, original stem, original light, original basic, original 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, original discount light, the original discount light, the original discount, original discount, original discount light, original basic, original basic light, the original basic light, the original basics, discounted deep bowl light, original basics, basic warehouse light, budget barn light, budget original, budget barn lights, discount original, original light, discount original light, original barn light, the original barn light, the original stem light, the original stem mount, discount the original stem light, original stem light, original stem mount, discount original stem light, budget discount original stem light, back to basics, H-15112, H-15116, classic warehouse shade stem mount pendant rlm, classic warehouse shade, basic original stem,
65692 Weather resistant aluminum makes our Barn Light Basics Aero Stem Mount Pendant a chic and inviting option for your porch lighting! Choose from four stylish finishes! 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, aero stem, aero light, aero basic, aero 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, aero discount light, aero discount, aero discount light, aero basic, aero basic light, discounted aero light, aero basics, basic aero light, budget barn light, budget aero, budget barn lights, discount aero, aero light, discount aero light, aero stem light, aero stem mount, discount aero stem light, budget discount aero stem light, back to basics,
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,