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 (64735, 61082, 64367, 61084) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00063

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 (64735,61082,64367,61084) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61082 american designer pendant light, light pipe design, steampunk style mini pendant, stem mount mini pendant light, commercial factory chic light Our Lafayette pendant juxtaposes a small and chic mini shade with a rustic, industrial stem mount. Ideal for artistic loft lighting and modern homes! The Lafayette Street Soho Stem Mount Pendant, BLE-S-SOH-LAF-PC, lafayette, soho light, stem mount, pendant, industrial pendant, chunky light, small light shade, durable light, outdoor ceiling light, ceiling light, modern lighting, shop light, Lafayette stem mount, Lafayette street stem mount, Lafayette pendant, Lafayette street pendant, stem mount pendant, stem mount pendant lighting, soho stem mount, soho lighting, ceiling pendant, minimalist lighting, galvanized lighting, galvanized, restaurant lighting, kitchen lighting, interior stem mount, Lafayette SoHo Stem Mount Pendant Light, Lafayette Stem Mount Pendant Light, Lafayette SoHo Stem Mount Pendant, Lafayette Stem Mount Pendant, Lafayette soho, Lafayette stem, Lafayette pendant, soho stem mount, Lafayatte, Lafayete, stems, Stem pendant lights, stem light mount, stem light mounts, stem,
61084 american designer pendant light, light pipe design, steampunk style light shade, shallow bowl industrial light, shallow bowl factory light, industrial chic stem mount pendant, upcycled pendant Inspired by artistic and edgy SoHo culture, our Marathon Stem Mount combines a super industrial stem mount fixture with a traditional shallow bowl shade. The Houston Street Soho Stem Mount Pendant, BLE-S-SOH-HOU-PC, houston, soho light, stem mount, pendant, industrial light, industrial light fixture, stem mount, bulky light, factory light, durable light, exterior lights, garage lighting, shop lights, BLE-S-SOH-HOU12-PC, BLE-S-SOH-HOU14-PC, Houston industrial lighting, Houston pendant light, Houston, Houston stem mount, soho stem light, stylish lighting, galvanized pipe lighting, shallow bowl lighting, shallow bowl lights, shallow bowl lighting fixtures, shallow bowl ceiling light, shallow bowl stem mount, shallow bowl lighting, shallow bowl warehouse shade, rlm warehouse lighting, rlm warehouse shade, ceiling light, ceiling pendant, pendant lighting, stem mount ceiling light, outdoor lighting, exterior lighting, soho lighting, soho pendant, soho ceiling pendant, soho industrial lighting, soho industrial pendant lighting, marathon soho stem mount, marathon stem mount, marathon soho, soho stem mount, soho, marathon, soho stem mount light, marathon stem mount light, Marathon SoHo Stem Mount Pendant Light, Marathon SoHo Stem Mount Pendant, BLE-S-SOH-HOU12, BLE-S-SOH-HOU14, SPS-0133, SPS0133, SPS 0133, marathon soho series, marathon soho collection, Houston series, houston collection, houston street soho series, houston street series, houston street collection, soho series, soho collection, stems, Stem pendant lights, stem light mount, stem light mounts, stem, bowl shallow,
64367 Bring the Venice’s uniquely modern style to homes or businesses! Fully customizable and American made! BLE-S-CYLV, BLE-S-CYLM, The Venice Cylinder Stem mount Pendant, The Venice Cylinder Stem mount Pendants, The Venice Cylinder Stem mount Pendant Light, The Venice Cylinder Stem mount Pendant Lights, The Venice Cylinder Stem mount Pendant Lighting, The Venice Cylinder Stem mount Ceiling Pendant, The Venice Cylinder Stem mount Ceiling Pendants, The Venice Cylinder Stem mount Ceiling Light, The Venice Cylinder Stem mount Ceiling Lights, The Venice Cylinder Stem mount Ceiling Lighting, The Venice Cylinder Stem mount Light, The Venice Cylinder Stem mount Lights, The Venice Cylinder Stem mount Lighting, Venice Cylinder Stem mount Pendant, Venice Cylinder Stem mount Pendants, Venice Cylinder Stem mount Pendant Light, Venice Cylinder Stem mount Pendant Lights, Venice Cylinder Stem mount Pendant Lighting, Venice Cylinder Stem mount Ceiling Pendant, Venice Cylinder Stem mount Ceiling Pendants, Venice Cylinder Stem mount Ceiling Light, Venice Cylinder Stem mount Ceiling Lights, Venice Cylinder Stem mount Ceiling Lighting, Venice Cylinder Stem mount Light, Venice Cylinder Stem mount Lights, Venice Cylinder Stem mount Lighting, The Venice Cylinder Pendant, The Venice Cylinder Pendants, The Venice Cylinder Pendant Light, The Venice Cylinder Pendant Lights, The Venice Cylinder Pendant Lighting, The Venice Cylinder Ceiling Pendant, The Venice Cylinder Ceiling Pendants, The Venice Cylinder Ceiling Light, The Venice Cylinder Ceiling Lights, The Venice Cylinder Ceiling Lighting, The Venice Cylinder Light, The Venice Cylinder Lights, The Venice Cylinder Lighting, Venice Cylinder Pendant, Venice Cylinder Pendants, Venice Cylinder Pendant Light, Venice Cylinder Pendant Lights, Venice Cylinder Pendant Lighting, Venice Cylinder Ceiling Pendant, Venice Cylinder Ceiling Pendants, Venice Cylinder Ceiling Light, Venice Cylinder Ceiling Lights, Venice Cylinder Ceiling Lighting, Venice Cylinder Light, Venice Cylinder Lights, Venice Cylinder Lighting, The Venice Cylinder Stem Pendant, The Venice Cylinder Stem Pendants, The Venice Cylinder Stem Pendant Light, The Venice Cylinder Stem Pendant Lights, The Venice Cylinder Stem Pendant Lighting, The Venice Cylinder Stem Ceiling Pendant, The Venice Cylinder Stem Ceiling Pendants, The Venice Cylinder Stem Ceiling Light, The Venice Cylinder Stem Ceiling Lights, The Venice Cylinder Stem Ceiling Lighting, The Venice Cylinder Stem Light, The Venice Cylinder Stem Lights, The Venice Cylinder Stem Lighting, Venice Cylinder Stem Pendant, Venice Cylinder Stem Pendants, Venice Cylinder Stem Pendant Light, Venice Cylinder Stem Pendant Lights, Venice Cylinder Stem Pendant Lighting, Venice Cylinder Stem Ceiling Pendant, Venice Cylinder Stem Ceiling Pendants, Venice Cylinder Stem Ceiling Light, Venice Cylinder Stem Ceiling Lights, Venice Cylinder Stem Ceiling Lighting, Venice Cylinder Stem Light, Venice Cylinder Stem Lights, Venice Cylinder Stem Lighting, The Venice Stem Pendant, The Venice Stem Pendants, The Venice Stem Pendant Light, The Venice Stem Pendant Lights, The Venice Stem Pendant Lighting, The Venice Stem Ceiling Pendant, The Venice Stem Ceiling Pendants, The Venice Stem Ceiling Light, The Venice Stem Ceiling Lights, The Venice Stem Ceiling Lighting, The Venice Stem Light, The Venice Stem Lights, The Venice Stem Lighting, Venice Stem Pendant, Venice Stem Pendants, Venice Stem Pendant Light, Venice Stem Pendant Lights, Venice Stem Pendant Lighting, Venice Stem Ceiling Pendant, Venice Stem Ceiling Pendants, Venice Stem Ceiling Light, Venice Stem Ceiling Lights, Venice Stem Ceiling Lighting, Venice Stem Light, Venice Stem Lights, Venice Stem Lighting, The Venice Stem mount Pendant, The Venice Stem mount Pendants, The Venice Stem mount Pendant Light, The Venice Stem mount Pendant Lights, The Venice Stem mount Pendant Lighting, The Venice Stem mount Ceiling Pendant, The Venice Stem mount Ceiling Pendants, The Venice Stem mount Ceiling Light, The Venice Stem mount Ceiling Lights, The Venice Stem mount Ceiling Lighting, The Venice Stem mount Light, The Venice Stem mount Lights, The Venice Stem mount Lighting, Venice Stem mount Pendant, Venice Stem mount Pendants, Venice Stem mount Pendant Light, Venice Stem mount Pendant Lights, Venice Stem mount Pendant Lighting, Venice Stem mount Ceiling Pendant, Venice Stem mount Ceiling Pendants, Venice Stem mount Ceiling Light, Venice Stem mount Ceiling Lights, Venice Stem mount Ceiling Lighting, Venice Stem mount Light, Venice Stem mount Lights, Venice Stem mount Lighting, The Cylinder Stem mount Pendant, The Cylinder Stem mount Pendants, The Cylinder Stem mount Pendant Light, The Cylinder Stem mount Pendant Lights, The Cylinder Stem mount Pendant Lighting, The Cylinder Stem mount Ceiling Pendant, The Cylinder Stem mount Ceiling Pendants, The Cylinder Stem mount Ceiling Light, The Cylinder Stem mount Ceiling Lights, The Cylinder Stem mount Ceiling Lighting, The Cylinder Stem mount Light, The Cylinder Stem mount Lights, The Cylinder Stem mount Lighting, Cylinder Stem mount Pendant, Cylinder Stem mount Pendants, Cylinder Stem mount Pendant Light, Cylinder Stem mount Pendant Lights, Cylinder Stem mount Pendant Lighting, Cylinder Stem mount Ceiling Pendant, Cylinder Stem mount Ceiling Pendants, Cylinder Stem mount Ceiling Light, Cylinder Stem mount Ceiling Lights, Cylinder Stem mount Ceiling Lighting, Cylinder Stem mount Light, Cylinder Stem mount Lights, Cylinder Stem mount Lighting, The Cylinder Pendant, The Cylinder Pendants, The Cylinder Pendant Light, The Cylinder Pendant Lights, The Cylinder Pendant Lighting, The Cylinder Ceiling Pendant, The Cylinder Ceiling Pendants, The Cylinder Ceiling Light, The Cylinder Ceiling Lights, The Cylinder Ceiling Lighting, The Cylinder Light, The Cylinder Lights, The Cylinder Lighting, Cylinder Pendant, Cylinder Pendants, Cylinder Pendant Light, Cylinder Pendant Lights, Cylinder Pendant Lighting, Cylinder Ceiling Pendant, Cylinder Ceiling Pendants, Cylinder Ceiling Light, Cylinder Ceiling Lights, Cylinder Ceiling Lighting, Cylinder Light, Cylinder Lights, Cylinder Lighting, cylinder, venice, cylinder pendant, cylinder pendants, cylinder collection, venice, cylinder, cylinders, cylinders pendant, BLE-S-CYLV-SML, BLE-S-CYLV-LRG, venice pendant, venice pendants, narrow slot vent, Venice Cylinder Pendant Series, Venice Cylinder Pendant Collection, The Venice Cylinder Pendant Series, The Venice Cylinder Pendant Collection, Venice Pendant Series, Venice Pendant Collection, The Venice Pendant Series, The Venice Pendant Collection, Venice Series, Venice Collection, The Venice Series, The Venice Collection, SPS-0114, SPS 0114, SPS0114, stems, Stem pendant lights, stem light mount, stem light mounts, stem, stems, Stem pendant lights, stem light mount, stem light mounts, stem,
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,