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 (65085, 65081, 64733, 64687) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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 (65085,65081,64733,64687) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64687 wall sconce, barn sconce, interior wall sconce lighting, warehouse shade style wall sconce, barn wall sconce, industrial farmhouse wall light, plug-in sconce light, plug in lighting Inspired by traditional barn lights, The Original™ Wall Sconce is a classic. Its vintage style warehouse shade comes in a variety of finishes to match your home. Original Wall sconce, original sconce, sconce, outdoor sconce, indoor sconce, BLE-W-WHS-PC, original, barn wall sconce, BLE-W-WHS12-PC, BLE-W-WHS14-PC, wall lighting, wall lights, exterior wall lights, exterior wall sconces, outdoor wall lights, outdoor lighting, porch lighting, porch lights, plug in wall lights, plug-in wall lights, plug in lighting, plug-in lighting, plug in scones, plug-in sconces, plug in wall sconces, plug-in wall sconces, new listing, Wheeler Sky Chief, Sky Chief Sconce, Sky Chief Wall Sconce, skychief, sky cheif, BLE-W-WHS, BLE-W-WHS12, BLE-W-WHS14, Wheeler™ Sky Chief Wall Sconce, plug-in light, plug-in sconce, plug-in wall sconce, plug-in wall light, plug in light, plug in sconce, plug in wall sconce, plug in wall light, wheeler sconce, skychief sconce, new sconce, new rlm, BLE-W-WHS12-N, BLE-W-WHS12, BLE-W-WHS14-N, BLE-W-WHS14, original warehouse, original warehouse shade, original warehouse shades, original ware house, original ware house shade, original ware house shades, sconce outdoor wet rated, sconce outdoor wet-rated, Light with photocell, outdoor light light with photocell, whs, 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, Wall sconce outdoor, Outdoor wall sconces, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, Wall mount outdoor lights, Wall mount outdoor light, Wall mount outdoor lighting, Wall mount outdoor light fixture, Wall mount outdoor light fixtures, Wall mount outdoor lighting fixture, Wall mount outdoor lighting fixtures, wall light sconce, wall light sconces, original warehouse sconce, original warehouse sconces, original warehouse wall sconce, original warehouse wall sconces, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, Wall sconce outdoor, outdoor Wall sconce, outdoor Wall sconces, Wall sconces outdoor, sconce outdoor, outdoor sconce, outdoor sconces, sconces outdoor, Wall mount sconce, wall mount sconces, sconce wall mount, sconce wall mounted, wall mount light, wall mount lights, wall mount lighting, wall mounted light, wall mounted lights, wall mounted lighting, wall mount sconce light, wall mount sconce lights, wall mount sconce lighting, wall mounted sconce light, wall mounted sconce lights, wall mounted sconce lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, classic barn sconce, plug in barn light, plug-in barn light, plug-in light, jadeite, jadite, jadeite light, jadite light, H-15312-B, H-15314-B, H-15316-B, classic warehouse shade wall light, classic warehouse shade,
64733 bathroom warehouse shade sconce, barn wall sconce, decorative rlm sconce, barn shade sconce, colorful wall sconce, barn light wall sconce, vintage inspired shade sconce, factory light wall sconce, plug-in sconce Featuring a large handspun metal warehouse shade and compact arm, this industrial wall sconce is American made. Sconce lighting for indoors and outdoors! The Ashland Wall Sconce, Ashland, Wall sconce, Warehouse Shade, Large Sconce, Wall Lighting, BLE-W-WHA-PC, BLE-W-WHA12-PC, BLE-W-WHA14-PC, BLE-W-WHA16-PC, wall sconce light, sconce lighting, sconce, wall light, exterior wall light, exterior sconce, exterior sconce light, exterior wall sconce, outdoor wall light, outdoor light, outdoor sconce, outdoor wall sconce, industrial lighting, industrial wall light, industrial sconce, industrial wall sconce, industrial sconce lighting, industrial wall sconce lighting, outdoor lighting, exterior lighting, warehouse shade, warehouse shade lighting, rlm warehouse shade, rlm shade lighting, rlm warehouse lighting, Ashland lighting, Ashland wall light, Ashland wall sconce, Ashland sconce, Ashland sconce light, Ashland sconce lighting, Ashland lighting, Ashland shade, Ashland wall light, Ashland wall lighting, Ashland light, plug-in lighting, plug in lighting, plug in sconces, plug-in sconces, plug in wall lights, plug-in wall lights, wall lights plug in, wall lights plug-in, new listing, new avalon, new rlm, The Ashland Wall Sconce, Ashland, Wall sconce, Warehouse Shade, Large Sconce, Wall Lighting, Wheeler Avalon, Avalon Wall sconce, avalon sconce, warehouse sconce, warehouse wall light, BLE-W-WHA, BLE-W-WHA12, BLE-W-WHA14, BLE-W-WHA16, Wheeler™ Avalon Wall Sconce, wall light, industrial wall lights, industrial wall lighting, industrial lighting, wall lights, porch lights, porch lighting, plug in wall light, plug-in wall light, plug in lighting, plug-in lighting, plug-in, plug in, apartment lighting, apartment lights, avalon, BLE-W-WHA12, BLE-W-WHA14, BLE-W-WHA16, SPS-0108, SPS0108, SPS 0108, avalon collection, avalon series, the avalon collection, the avalon series, Wall mount outdoor lights, Wall mount outdoor light, Wall mount outdoor lighting, Wall mount outdoor light fixture, Wall mount outdoor light fixtures, Wall mount outdoor lighting fixture, Wall mount outdoor lighting fixtures, wall light sconce, wall light sconces, Wheeler Avalon wall sconce, Wheeler Avalon sconce, Wall sconce outdoor, outdoor Wall sconce, outdoor Wall sconces, Wall sconces outdoor, sconce outdoor, outdoor sconce, outdoor sconces, sconces outdoor, Wall mount sconce, wall mount sconces, sconce wall mount, sconce wall mounted, wall mount light, wall mount lights, wall mount lighting, wall mounted light, wall mounted lights, wall mounted lighting, wall mount sconce light, wall mount sconce lights, wall mount sconce lighting, wall mounted sconce light, wall mounted sconce lights, wall mounted sconce lighting, plug in barn light, plug-in barn light, plug-in light,
65081 wall led light, led wall lamp, led task light, barn light led fixture, led warehouse shade wall sconce, led wall sconce, lighting fixture, exterior lighting, environmentally friendly lighting We've updated RLM-inspired lighting with the Bomber! LED components are now integrated into this eye-catching design--perfect for areas with strict energy codes! Old Dixie, Old Dixie Sconce, Warehouse sconce, barn sconce, BLE-W-WHB-PC-LED, LED sconce, led wall sconce, led light, BLE-W-WHB11-PC-LED, BLE-W-WHB13-PC-LED, old Dixie sconce lighting, old Dixie warehouse sconce, barn light sconces, barn light lighting, barn light wall light, led barn light, led barn lighting, led warehouse sconce, led warehouse lighting, led rlm warehouse lights, industrial wall lights, industrial wall lighting, industrial wall sconces, sconce lighting, sconce lights, led sconce lights, outdoor lighting, outdoor lights, exterior lighting, exterior lights, outdoor led lighting, outdoor led lights, exterior led lighting, exterior led lighting, BLE-W-WHB-LED, Wheeler™ Bomber LED Wall Sconce, LED wall sconce, bomber led wall light, BLE-W-WHB11-LED, BLE-W-WHB13-LED, bomber sconce, bomber led sconce, led bomber sconce, wheeler bomber, bomber led, led bomber, bomber wall sconce, bomber sconce, bomber wall light, The old Dixie wall sconce, the dixie, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, bomber led series, bomber led collection, SPS-0452, SPS0452, SPS 0452, Wall sconce outdoor, outdoor Wall sconce, outdoor Wall sconces, Wall sconces outdoor, sconce outdoor, outdoor sconce, outdoor sconces, sconces outdoor, LED Wall sconce outdoor, outdoor LED Wall sconce, outdoor LED Wall sconces, LED Wall sconces outdoor, LED sconce outdoor, outdoor LED sconce, outdoor LED sconces, LED sconces outdoor, bomber wall sconces, H-15111, H-15113, H-15115, curved warehouse shade,
65085 led wall light, led sconce, barn light sconce led, warehouse shade led light, led sconce barn lighting, american made energy efficient lighting, dark sky led wall sconce The Dino LED Wall Sconce combines barn-style lighting with the latest LED tech! Bring handcrafted, highly efficient lighting in your home or business today! Drake LED Wall Sconce, LED Barn Light Sconce, led, led sconce, drake led, led drake, barn sconce, BLE-W-WHD12-PC-LED, BLE-W-WHD14-PC-LED, The Drake LED Wall Sconce, led wall sconce, led barn sconce, barn lighting, led barn lighting, wall lights, led wall lights, led sconce lighting, drake sconce, drake led sconce, sconce, outdoor sconce, outdoor led sconce, outdoor wall light, outdoor led wall light, warehouse lighting, warehouse led lighting, warehouse shades, warehouse led shades, barn lighting, led barn lighting, led barn lights, drake led wall lights, industrial wall lights, industrial wall lighting, industrial led wall lights, industrial led wall sconces, Wheeler Dino, Dino sconce, Dino wall sconce, warehouse sconce, BLE-W-WHD, BLE-W-WHD12-LED, BLE-W-WHD14-LED, dino led sconce, dino sconce, dino led sconce, led dino sconce, wheeler dino, dino led, led dino, dino led sconce, dino sconce, BLE-W-WHD12-N, BLE-W-WHD12, BLE-W-WHD14-N, BLE-W-WHD14, SPS-0218, SPS 0218, SPS0218, Dino Wall Sconce Series, Dino Sconce Series, The Dino Wall Sconce Series, The Dino Sconce Series, Dino Wall Sconce Collection, Dino Sconce Collection, The Dino Wall Sconce Collection, The Dino Sconce Collection, Wall sconce outdoor, outdoor Wall sconce, outdoor Wall sconces, Wall sconces outdoor, sconce outdoor, outdoor sconce, outdoor sconces, sconces outdoor, LED Wall sconce outdoor, outdoor LED Wall sconce, outdoor LED Wall sconces, LED Wall sconces outdoor, LED sconce outdoor, outdoor LED sconce, outdoor LED sconces, LED sconces outdoor,