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

Query time 0.00046

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

Result

product_id meta_keywords meta_description search_words promo_text
64735 stem mount light, flared pendant light with stem mount, industrial stem mount pendant, pole mount ceiling light, flared shade rlm light, decorative factory light The stacked neck design and flared base of the Astro Shallow Bowl Stem Mount Light makes this modernized barn light ideal for exterior and interior spaces. Astro Shallow Bowl Stem Mount, Astro pendant, shallow bowl, astro stem mount, stem mount, pendant, barn pendant, ceiling light, BLE-S-SBA-PC, BLE-S-SBA12-PC, BLE-S-SBA14-PC, BLE-S-SBA16-PC, new listing, new aero, new rlm, aero stem mount pendant light, Astro Shallow Bowl Stem Mount, Astro pendant, shallow bowl, astro stem mount, stem mount, pendant, barn pendant, ceiling light, BLE-S-SBA-PC, BLE-S-SBA12-PC, BLE-S-SBA14-PC, BLE-S-SBA16-PC, BLE-S-SBA12, BLE-S-SBA14, BLE-S-SBA16, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, stems, Stem pendant lights, stem light mount, stem light mounts, stem, 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, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, jadeite, jadite, jadeite light, jadite light, bowl shallow,
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,
65689 Our inviting radial wave shade on a durable stem mount is the light you've been looking for! The Barn Light Basics Seaside Stem Mount Pendant offers style at a price you can't beat! 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, seaside stem, seaside light, seaside basic, seaside 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, seaside discount light, seaside discount, seaside discount light, seaside basic, seaside basic light, discounted seaside light, seaside basics, basic radial wave light, budget barn light, budget seaside, budget barn lights, discount seaside, seaside radial wave light, discount seaside light, seaside stem light, seaside stem mount, discount seaside stem light, budget discount seaside 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,