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 (64917, 64709, 64696, 64730) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00071

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 (64917,64709,64696,64730) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
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,
64709	large barn light, decorative barn-style ceiling light, large pendant lighting, colorful pendant lighting, mint pendant light, decorative pendant light shade, kitchen pendant, industrial farmhouse style light, grooved shade pendant,	The Bomber Stem Mount Light has a classic barn light look with a deeper, curved bowl. Crafted in the USA, this industrial light is made to last.	BLE-S-WHB, bomber, stem mount, bomber pendant, ceiling light, decorative barn, BLE-S-WHB11, BLE-S-WHB13, BLE-S-WHB15, BLE-S-WHB17, benjamin bomber, bomber stem, stem bomber, Benjamin Bomber, new listing, new rlm, new bomber, Barn Light Warehouse Pendant, stem mounted, Old dixie, stem mount, Old dixie stem mount, ceiling light, BLE-S-WHB11-PC, BLE-S-WHB13-PC, BLE-S-WHB15-PC, BLE-S-WHB17-PC, The Old Dixie Stem Mount Pendant, old Dixie lighting, old Dixie warehouse light, old Dixie ceiling light, old Dixie stem mount pendant, old Dixie pendant, stem mounted light, stem mounted ceiling light, ceiling mounted light, ceiling mount light, ceiling pendant, pendant light, pendant lighting, ceiling pendant, warehouse lighting, warehouse shade, warehouse shade light, industrial warehouse, industrial warehouse shade, stem mount warehouse shade, outdoor lighting, outdoor light, exterior light, exterior lighting, outdoor ceiling light, exterior ceiling light, old dixie, BLE-S-WHB11, BLE-S-WHB13, BLE-S-WHB15, BLE-S-WHB17, whb, whn, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, bomber lighting outdoor, outdoor bomber lighting, bomber light outdoor, bomber lights outdoor, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, 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, 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, jadeite, jadite, jadeite light, jadite light,
64730			Ashland, Stem Mount, Ashland Stem Mount, Ashland Pendant, Warehouse Shade, BLE-S-WHA-PC, BLE-S-WHA12-PC, BLE-S-WHA14-PC, BLE-S-WHA16-PC, new avalon, new listing, new rlm, Ashland, Stem Mount, Ashland Stem Mount, Ashland Pendant, Warehouse Shade, BLE-S-WHA-PC, BLE-S-WHA12-PC, BLE-S-WHA14-PC, BLE-S-WHA16-PC, ashland stem, ashland pendant, BLE-S-WHA8, BLE-S-WHA10, BLE-S-WHA12, BLE-S-WHA14, BLE-S-WHA16, Outdoor farm light, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0108, SPS0108, SPS 0108, avalon collection, avalon series, the avalon collection, the avalon 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, 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, Avalon series, jadeite, jadite, jadeite light, jadite light,
64917	led pendant lighting, led barn lighting, industrial pendant lighting led, led ceiling light, warehouse lighting, led pendant, led fixture	Bright, white, LED light! Light up your ceiling with classic RLM style with the Original™ LED light and its custom finishes and accessories.	The Original Stem Mount LED Pendant, BLE-S-WHS-PC-LED, Original, Original stem mount, original pendant, LED original, LED pendant, LED ceiling light, LED stem mount, LED, BLE-S-WHS12-PC-LED, BLE-S-WHS14-PC-LED, BLE-S-WHS16-PC-LED, BLE-S-WHS18-PC-LED, BLE-S-WHS20-PC-LED, The Original™, The Original™ warehouse shade, The Original™ led warehouse lighting, The Original led lighting, ceiling pendant, ceiling pendant lighting, led ceiling pendant, ceiling lighting, led ceiling lighting, stem mount lighting, led stem mount lighting, stem mount pendant, stem mount led, ceiling light, ceiling led, industrial lighting, industrial led lighting, industrial ceiling light, industrial led ceiling light, Original LED, Original LED stem, Original LED pendant, Original LED stem mount, Original, Original LED stem pendant, Original LED pendants, Sky Chief, Sky Chief LED, Sky Chief LED stem, Sky Chief LED pendant, Sky Chief LED stem mount, LED stem mount, BLE-S-WHS16, BLE-S-WHS18, BLE-S-WHS20, BLE-S-WHS24, BLE-S-WHS28, BLE-S-WHS12, BLE-S-WHS14, BLE-S-WHS16, BLE-S-WHS18, BLE-S-WHS20, BLE-S-WHS24, BLE-S-WHS28, original led warehouse, original led ware house, original led warehouse shade, original led ware house shade, original led warehouse shades, original led ware house shades, 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, SPS-0448, SPS0448, SPS 0448, original led series, original™ led series, originaltm led series, original led collection, original™ led collection, originaltm led collection, the original led series, the original™ led series, the originaltm led series, the original led collection, the original™ led collection, the originaltm led collection, The Original™ Integrated LED Series, The Original™ Integrated LED Collection, Original™ Integrated LED Series, Original™ Integrated LED Collection, The Original Integrated LED Series, The Original Integrated LED Collection, Original Integrated LED Series, Original Integrated LED Collection, The Original™ Integrated LED Series, The Original™ Integrated LED Collection, Original™ Integrated LED Series, Original™ Integrated LED Collection, The Originaltm Integrated LED Series, The Originaltm Integrated LED Collection, Originaltm Integrated LED Series, Originaltm Integrated LED Collection, SPS-0448, SPS 0448, SPS0448, Original led warehouse pendant, Original led warehouse pendants, 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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Original led warehouse light, 24" shade, 28" shade, H-15112, H-15114, H-15116, H-15118, H-15120, classic warehouse shade stem mount pendant rlm, classic warehouse shade,