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 (65043, 64709, 64970, 64685) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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 (65043,64709,64970,64685) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
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,
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,
64970		Integrated LED pendant lighting for homes and businesses! Handcrafted in the USA and fully customizable, create a unique look for your space!	Benjamin Union, Union Stem mount, union, BLE-S-WHU-LED, Union pendant, Benjamin LED, LED Union, LED stem mount, LED ceiling light, LED pendant, BLE-S-WHU10-LED, BLE-S-WHU12-LED, BLE-S-WHU14-LED, BLE-S-WHU16-LED, Benjamin® Union, Benjamin stem mount, Benjamin LED, led lighting, led ceiling light, stem mount led, led stem mount, led ceiling mount, led ceiling lighting, led warehouse light, led warehouse lighting, warehouse lighting, warehouse pendant light, led pendant, union, union led, union led stem, union stem, union stem led, union stem pendant, led union, led union stem, union stem mount, union stem mount led, union, union led, union led stem, union stem, union stem led, union stem pendant, led union, led union stem, union stem mount, union stem mount led, union led, universal led, led union, Universal Stem Mount, stem mount, warehouse light, american made, outdoor pendant, BLE-S-WHU-PC-LED, universal, universal pendant, LED universal, LED stem mount, LED pendant, commercial lighting, LED, LEDs, LED ceiling light, BLE-S-WHU10-PC-LED, BLE-S-WHU12-PC-LED, BLE-S-WHU14-PC-LED, BLE-S-WHU16-PC-LED, universal led pendant, led warehouse light, led American made lighting, American made led lighting, outdoor led pendant, universal led lighting, warehouse shade, warehouse led shade, led warehouse lighting, stem mount pendant, stem mount led pendant, commercial led led lighting, led pendant lighting, industrial led lighting, exterior led lighting, exterior led lights, warehouse lighting, warehouse led lighting, BLE-S-WHU10, BLE-S-WHU12, BLE-S-WHU14, BLE-S-WHU16, union integrated led, union series, union collection, the union series, the union collection, SPS-0159, SPS0159, SPS 0159, union LED series, union LED collection, the union led series, the union led collection, SPS-0454, SPS0454, SPS 0454, union integrated, union integrated LED, 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,
65043		Replacing standard lighting with decorative LED alternatives saves money, helps the environment, and transforms a decor! Customize a unique look for any project!	rustic ceiling pendant, rustic ceiling pendants, rustic ceiling light, rustic ceiling lights, rustic ceiling lighting, rustic led light, rustic led lights, rustic led lighting, led rustic light, led rustic lights, led rustic lighting, cast guard, cast guard and glass, cast guard & glass, cast guard and glass pendant, cast guard and glass pendants, cast guard & glass pendant, cast guard & glass pendants, cast guard and glass pendant light, cast guard & glass pendant light, cast guard and glass pendant lights, cast guard & glass pendant lights, cast guard and glass pendant lighting, cast guard & glass pendant lighting, led cast and guard, led cast & guard, Benjamin® Bomber Rustic LED Stem Mount Pendant, Benjamin Bomber Rustic LED Stem Mount Pendant, Bomber Rustic LED Stem Mount Pendant, Bomber Rustic LED Stem Mount Pendants, Bomber Rustic Stem Mount Pendant, Bomber Rustic Stem Mount Pendants, Bomber Rustic Stem Mount Pendant light, Bomber Rustic Stem Mount Pendant lights. Bomber Rustic Stem Mount Pendant lighting, Bomber LED Stem Mount Pendant, Bomber LED Stem Mount Pendants, Bomber LED Stem Mount Pendant light, Bomber LED Stem Mount Pendant lights, Bomber LED Stem Mount Pendant lighting, Bomber pendant light, Bomber pendant lights, Bomber pendant lighting, BLE-S-WHB-CGG-LED, led cast and guard, led cast & guard, nautical led, nautical stem led, cgg led, cast guard led, nautical, bomber, bomber led, bomber led stem, bomber stem, bomber stem led, bomber stem pendant, led bomber, led bomber stem, bomber stem mount, bomber stem mount led, bomber nautical, bomber nautical led, bomber nautical led stem, bomber nautical stem, bomber nautical stem led, bomber nautical stem hung, led nautical bomber, led nautical bomber stem, bomber nautical stem mount, bomber nautical stem mount led, The Old dixie Rustic LED Stem Mount Pendant, Old dixie Rustic LED Stem Mount Pendant, The Old dixie LED Stem Mount Pendant, The Old dixie Rustic Stem Mount Pendant, Old dixie LED Stem Mount Pendant, Old dixie Rustic Stem Mount Pendant, Old dixie Stem mount pendant, old dixie stem mount, old dixie pendant, old dixie, old dixie pendant light, old dixie pendant lights, old dixie pendant lighting, old dixie ceiling light, old dixie ceiling lights, old dixie ceiling lighting, pendant light, pendant lights, pendant lighting, ceiling light, ceiling lights, ceiling lighting, old dixie, rustic led, rustic led light, rustic led lights, rustic led lighting, rustic pendant, rustic pendant lighting, rustic lights, rustic pendant lights, rustic pendant light, stem mount, stem mount light, stem mount lights, stem mount lighting, led stem mount light, led stem mount lights, led stem mount lighting, rustic stem mount, rustic stem mount light, rustic stem mount lights, rustic stem mount lighting, old, dixie, BLE-S-WHB-PC-CGG-LED, BLE-S-WHB11, BLE-S-WHB13, BLE-S-WHB15, BLE-S-WHB17, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, bomber led series, bomber led collection, SPS-0452, SPS0452, SPS 0452, SPS-0521, SPS0521, SPS 0521, 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, H-15111, H-15113, H-15115, H-15117, curved warehouse shade, curved warehouse shade stem mount,