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 (61694, 61692, 64696, 64685) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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 (61694,61692,64696,64685) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61692 American made lighting, ceiling lighting, pendant lights Cluster the Chateau Cord Hung Pendant for an eye catching lighting display. Hand spun by local artisans, hang these unique pendants in your home or office today! Chateau Modern Cord Hung Pendant, chateau, BLE-C-BIS, modern pendant, minimalist pendant, cord hung pendant, cord hung modern, modern cord hung, modern, ceiling pendant, cord hung pendant, The Chateau Modern Cord Hung Pendant, Chateau Collection, Chateau Series, The Chateau Collection, The Chateau Series, SPS-0371, SPS 0371, SPS0371, BLE-C-BIS, CHEATEAU, SPS-0371, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded,
61694 cone pendant light, stem mount factory light, flared cone barn light, modern barn light, hand crafted lighting, modern pendant light, contemporary modern lighting, commercial and residential lighting, sculptural pendant light, retail cash wrap lighting, Inspired by lighting fixtures discovered in old factories and utilitarian spaces, this flared cone pendant shows modern styling with lots of functionality! Bonsai Stem Mount Pendant, modern pendant light, modern stem mount, bonsai, BLE-S-HIB, Canal Stem Mount Pendant Light, Canal Stem Mount Pendant, Canal Stem Mount, SPS-0370, SPS 0370, SPS0370, Canal Collection, The Canal Collection, Canal Series, The Canal Series, stems, Stem pendant lights, stem light mount, stem light mounts, stem,
64685 warehouse stem mount pendant, vintage barn light stem mount pendant, barn light stem mount, industrial barn lighting, barn light with downrod, galvanized barn light Original™ barn pendants! This industrial original pendant light fixture combines the classic styling of gas station lighting with modern energy efficient lighting. Barn Light Warehouse Pendant, BLE-S-WHS12-PC, BLE-S-WHS14-PC, BLE-S-WHS16-PC, BLE-S-WHS18-PC, BLE-S-WHS20-PC, BLE-S-WHS, BLE-S-WHS-PC, Original, Original Stem, Stem Original, Stem Mount Original, Original Stem Mount, The Original™ Stem Mount Pendant, The Original™ Stem Mount Pendants, The Original Stem Mount Pendant, The Original Stem Mount Pendants, Original™ Stem Mount Pendant, Original™ Stem Mount Pendants, Original Stem Mount Pendant, Original Stem Mount Pendants,Original, Original™, The Original, The Original™, new listing, sky chief lighting, warehouse lighting, pendant lighting, pendant lights, sky chief, stem mount lights, stem mount lighting, sky chief, BLE-S-WHS, BLE-S-WHS12, BLE-S-WHS14, BLE-S-WHS16, BLE-S-WHS18, BLE-S-WHS20, benjamin sky chief, benjamin skychief, sky chief light, sky chief stem, skychief stem, sky chief pendant, new rlm, new stem, BLE-S-WHS16, BLE-S-WHS18, BLE-S-WHS20, BLE-S-WHS24, BLE-S-WHS28, BLE-S-WHS12, BLE-S-WHS14, original warehouse, original warehouse shade, original warehouse shades, original ware house, original ware house shade, original ware house shades, the original barn light, Outdoor farm light, whs, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, Pendent outdoor, pendant outdoor, Pendant light outdoor, pendant shade, pendant wet, pendent wet, pendant hanging lights, outdoor hanging pendant, outdoor hanging light, Outdoor ceiling mount, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, original warehouse stem mount, Original stem pendant, Original stem light, original™ warehouse stem mount, Original™ stem pendant, Original™ stem light, originaltm warehouse stem mount, Originaltm stem pendant, Originaltm stem light, 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, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents, original stem mount pendant light, 24" shade, 28" shade, jadeite, jadite, jadeite light, jadite light, H-15112, H-15114, H-15116, H-15118, H-15120, classic warehouse shade stem mount pendant rlm, classic warehouse shade,
64696 benjamin vintage lighting, stem mount ceiling light, stem pendant, ceiling light, commercial grade ligthing, exterior pendant fixture, industrial stem light, barn light with decorative shades Beautifully hand-crafted with a vintage-inspired shade and durable stem mount, hang our Union barn light in your stylish kitchen or porch! Benjamin Union, Union Stem mount, union, BLE-S-WHU, Union pendant, BLE-S-WHU10, BLE-S-WHU12, BLE-S-WHU14, BLE-S-WHU16, stem mount lighting, Benjamin Stem mount, stem mount ceiling lighting, stem mount, ceiling mounted lighting, ceiling mounted lights, ceiling light, outdoor ceiling light, warehouse lighting, rugged warehouse light, workshop light, barn lighting, workshop lighting, work shop light, work shop lighting, stem mount warehouse light, new rlm, new listing, new union, Universal Stem Mount, stem mount, warehouse light, american made, outdoor pendant, BLE-S-WHU-PC, BLE-S-WHU10-PC, BLE-S-WHU12-PC, BLE-S-WHU14-PC, BLE-S-WHU16-PC, BLE-S-WHU10, BLE-S-WHU12, BLE-S-WHU14, BLE-S-WHU16, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, outside union pendant light, union series, union collection, the union series, the union collection, SPS-0159, SPS0159, SPS 0159, natural metals, natural metal, 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, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, Copper Outdoor light, Copper Shade, copper outdoor, Copper barn lights, Copper outdoor lights, copper outdoor lighting, Outdoor copper, exterior copper, Copper exterior light, Outdoor copper light, copper exterior lights, Copper exterior lighting, Copper exterior barn light, copper exterior, jadeite, jadite, jadeite light, jadite light, union stem pendant light,