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 (64682, 64729, 64687) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00062

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64682,64729,64687) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
64682	exterior barn light, barn light, gooseneck wall light, galvanized warehouse shade, garage light, gooseneck barn light, title 24 compliant exterior lighting, dark sky lighting	Vintage craftsmanship meets modern styles in this handcrafted, American-made gooseneck barn light! Shop customizable gooseneck lighting and revamp any space!	The Original Warehouse Gooseneck Light, Warehouse, warehouse shade, barn light, gooseneck light, H-15116G, The Original, Original, BLE-G-WHS-PC, BLE-G-WHS12, BLE-G-WHS14, BLE-G-WHS16, BLE-G-WHS18, BLE-G-WHS20, gooseneck lighting, gooseneck lights, gooseneck wall light, warehouse gooseneck light, wall light, gooseneck warehouse shade, gooseneck warehouse wall light, original gooseneck, the original gooseneck, The Original™ Warehouse Gooseneck Light, The Original™ gooseneck, The Original™ gooseneck light, The Original™ wall light, The Original™ gooseneck lighting, original gooseneck lighting, the original gooseneck, gooseneck barn light, The Original™ gooseneck barn light, The Original™ barn light, original, original gooseneck, gooseneck original, 20" shade, outdoor light, wet location, new listing, the original light, original light, Sky chief, skychief, warhouse light, gooseneck, BLE-G-WHS, goodrich, goodrich sky chief, BLE-G-WHS, BLE-G-WHS12, BLE-G-WHS14, BLE-G-WHS16, BLE-G-WHS18, BLE-G-WHS20, sky chief gooseneck, skychief gooseneck, new rlm, new gooseneck, new original, BLE-G-WHS16-P/G64, Goodrich Gooseneck Light, Goodrich Gooseneck Lights, Goodrich Gooseneck Lighting, Goodrich Gooseneck Wall Light, Goodrich Gooseneck Wall Lights, Goodrich Gooseneck Wall Lighting, duncan, g64, g65, Goodrich, Skyway, gooseneck light, gooseneck lighting, 16" shade, BLE-WHS16-P/G1916, BLE-WHS16-P/G19, BLE-WHS18-P/G19, BLE-WHS20-P/G19, g19, large gooseneck light, big gooseneck light, Gooseneck Backing plate, Square gooseneck, outdoor goosneck, BLE-G-WHS-PC, BLE-G-WHS16-PC, BLE-G-WHS18-PC, BLE-G-WHS20-PC, outdoor gooseneck, warehouse lighting, warehouse gooseneck lighting, warehouse gooseneck wall light, outdoor gooseneck lighting, outdoor gooseneck light, outdoor warehouse gooseneck, rodeo, rodeo gooseneck, rodeo light, the original gooseneck light, original gooseneck light, BLE-G-WHS18, BLE-G-WHS20, BLE-G-WHS24, BLE-G-WHS28, 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, Light with photocell, outdoor light light with photocell, goodyear, 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, outdoor gooseneck barn lights, outdoor gooseneck barn light, outdoor gooseneck barn lighting, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, Original gooseneck warehouse light, Original gooseneck warehouse lights, Original gooseneck warehouse lighting, Original gooseneck warehouse, Warehouse Gooseneck Lights, Warehouse Gooseneck Light, Warehouse Gooseneck Lighting, Ware house Gooseneck Lights, Ware house Gooseneck Light, Ware house Gooseneck Lighting, Warehouse Goose neck Lights, Warehouse Goose neck Light, Warehouse Goose neck Lighting, Ware house Goose neck Lights, Ware house Goose neck Light, Ware house Goose neck Lighting, Warehouse Gooseneck, Warehouse Goosenecks, Ware house Gooseneck, Ware house Goosenecks, Ware house Goose neck, Ware house Goose necks, Gooseneck Warehouse Lights, Gooseneck Warehouse Light, Gooseneck Warehouse Lighting, Gooseneck Ware house Lights, Gooseneck Ware house Light, Gooseneck Ware house Lighting, Goose neck Warehouse Lights, Goose neck Warehouse Light, Goose neck Warehouse Lighting, Goose neck Ware house Lights, Goose neck Ware house Light, Goose neck Ware house Lighting, Gooseneck Warehouse, Gooseneck Ware house, Goose neck Warehouse, Goose neck Ware house, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside 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 gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, 24" gooseneck, 28" gooseneck, 24" shade, 28" shade, jadeite, jadite, jadeite light, jadite light, H-15112, H-15114, H-15116, H-15118, H-15120, classic warehouse shade gooseneck rlm, classic warehouse shade,
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,
64729	gooseneck outdoor lights, minimalist gooseneck light, industrial farmhouse gooseneck fixture, warehouse shade barn light, dark sky location lighting, commercial barn light, barn light for retail,	It’s a timeless, farmhouse-style gooseneck light that’s perfect indoors and out! Elevate any space with handcrafted, American made, and customizable lighting!	goodrich, avalon, avalon gooseneck, goodrich avalon, porcelian gooseneck, porcelian goodrich, BLE-G-WHA, BLE-G-WHA12, BLE-G-WHA14, BLE-G-WHA16, gooseneck, new listing, new rlm, new avalon,The Ashland, Gooseneck, Ashland gooseneck, warehouse shade, BLE-G-WHA-PC, BLE-G-WHA12-PC, BLE-G-WHA14-PC, BLE-G-WHA16-PC, Ashland wall light, Ashland gooseneck wall lighting, Ashland gooseneck lighting, Ashland gooseneck light, Ashland exterior wall light, wall light, exterior wall light, exterior gooseneck, outdoor gooseneck, outdoor gooseneck lighting, interior wall lighting, warehouse lighting, warehouse gooseneck, warehouse gooseneck lighting, exterior warehouse lighting, BLE-G-WHA8, BLE-G-WHA10, BLE-G-WHA12, BLE-G-WHA14, BLE-G-WHA16, Light with photocell, outdoor light light with photocell, SPS-0108, SPS0108, SPS 0108, avalon collection, avalon series, the avalon collection, the avalon series, green goosneckbarn light, green goosneck barn light, green gooseneckbarn light, green gooseneck barn light, outdoor gooseneck barn lights, outdoor gooseneck barn light, outdoor gooseneck barn lighting, Warehouse Gooseneck Lights, Warehouse Gooseneck Light, Warehouse Gooseneck Lighting, Ware house Gooseneck Lights, Ware house Gooseneck Light, Ware house Gooseneck Lighting, Warehouse Goose neck Lights, Warehouse Goose neck Light, Warehouse Goose neck Lighting, Ware house Goose neck Lights, Ware house Goose neck Light, Ware house Goose neck Lighting, Warehouse Gooseneck, Warehouse Goosenecks, Ware house Gooseneck, Ware house Goosenecks, Ware house Goose neck, Ware house Goose necks, Gooseneck Warehouse Lights, Gooseneck Warehouse Light, Gooseneck Warehouse Lighting, Gooseneck Ware house Lights, Gooseneck Ware house Light, Gooseneck Ware house Lighting, Goose neck Warehouse Lights, Goose neck Warehouse Light, Goose neck Warehouse Lighting, Goose neck Ware house Lights, Goose neck Ware house Light, Goose neck Ware house Lighting, Gooseneck Warehouse, Gooseneck Ware house, Goose neck Warehouse, Goose neck Ware house, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside 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 gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, Avalon series, bleg, jadeite, jadite, jadeite light, jadite light,