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 (65046, 64734, 64928, 64695) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

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 (65046,64734,64928,64695) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
64695	gooseneck barn light, american made wall light, customizable barn light, down light fixture, beautiful commercial light, exterior lighting, GU24 compatible lighting	Hand-spun and fully customizable, the Union Gooseneck Light adds class to your exterior lighting plan! USA-made!	Union, Goodrich Union, gooseneck, BLE-G-WHU, union gooseneck, gooseneck, BLE-G-WHU10, BLE-G-WHU12, BLE-G-WHU14, BLE-G-WHU16, new rlm, new listing, new union, The Universal Gooseneck, outdoor light, american made, gooseneck, powder coat gooseneck, warehouse shade, warehouse light, BLE-G-WHU-PC, BLE-G-WHU-PC10, BLE-G-WHU-PC12, BLE-G-WHU-PC14, BLE-G-WHU-PC16, universal gooseneck, universal gooseneck lighting, universal gooseneck wall light, universal lighting, universal wall light, universal warehouse shade, universal warehouse shade, universal outdoor light, universal outdoor wall light, gooseneck lighting, gooseneck light, gooseneck wall light, outdoor wall light, gooseneck warehouse lighting, gooseneck warehouse wall lighting, industrial wall light, industrial gooseneck, industrial gooseneck lighting, Universal, BLE-G-WHU10, BLE-G-WHU12, BLE-G-WHU14, BLE-G-WHU16, union series, union collection, the union series, the union collection, SPS-0159, SPS0159, SPS 0159, 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, bleg, jadeite, jadite, jadeite light, jadite light,
64734	goodrich gooseneck light, aero wall light, nautical gooseneck light, shallow bowl down light, GU24 compliant exterior fixture	Classic yet modern gooseneck lighting! Entirely handcrafted in the United States and fully customizable with various finishes!	goodrich Aero, aero gooseneck, new listing, new aero, new rlm, Astro, Astro Shallow Bowl Gooseneck, Astro Gooseneck, Shallow bowl, gooseneck, BLE-G-SBA12-PC, BLE-G-SBA14-PC, BLE-G-SBA16-PC, astro gooseneck, astro gooseneck light, BLE-G-SBA16-P/G64, Avara, The Avara, The Avara Gooseneck, Avara Gooseneck, Avara Goosenecks, The Avara Goosenecks, Avara Gooseneck Light, Avara Gooseneck Lights, Avara Gooseneck Lighting, Avara Gooseneck Wall Light, Avara Gooseneck Wall Lights, Avara Gooseneck Wall Lighting, The Avara Gooseneck Wall Light, The Avara Gooseneck Wall Lighting, Avara Light, Avara Lights, Avara Lighting, The Avara Light, The Avara Lights, The Avara Lighting, Avara Wall Light, Avara Wall Lights, Avara Wall Lighting, The Avara Wall Light, The Avara Wall Lights, The Avara Wall Lighting, The Avara Gooseneck Light, The Avara Gooseneck Lights, The Avara Gooseneck Lighting, Goodrich® Avara Gooseneck Light, Goodrich® Avara Gooseneck Lights, Goodrich® Avara Gooseneck Lighting, Goodrich® Avara Gooseneck Wall Light, Goodrich® Avara Gooseneck Wall Lights, Goodrich® Avara Gooseneck Wall Lighting, Goodrich Avara Gooseneck Light, Goodrich Avara Gooseneck Lights, Goodrich Avara Gooseneck Lighting, Goodrich Avara Gooseneck Wall Light, Goodrich Avara Gooseneck Wall Lights, Goodrich Avara Gooseneck Wall Lighting, Goodrich Gooseneck Light, Goodrich Gooseneck Lights, Goodrich Gooseneck Lighting, Goodrich Gooseneck Wall Light, Goodrich Gooseneck Wall Lights, Goodrich Gooseneck Wall Lighting, avara, g64, g65, BLE-G-SBA12, BLE-G-SBA14, BLE-G-SBA16, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, 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, bleg, jadeite, jadite, jadeite light, jadite light, bowl shallow,
64928		American made and fully customizable, cutting-edge LED components are integrated into this gooseneck light! Save money with LED lighting!	The Ashland, Gooseneck, Ashland gooseneck, warehouse shade, BLE-G-WHA-PC-LED, LED, LED light, LED gooseneck, Ashland LED, BLE-G-WHA12-PC-LED, BLE-G-WHA14-PC-LED, BLE-G-WHA16-PC-LED, The Ashland LED Gooseneck Light, Ashland LED Gooseneck Light, The Ashland LED Gooseneck, goodrich, avalon, avalon gooseneck, goodrich avalon, porcelian gooseneck, porcelian goodrich, BLE-G-WHA-LED, LED gooseneck, LED, LED avalon, goodrich LED, LED light, BLE-G-WHA12-LED, BLE-G-WHA14-LED, BLE-G-WHA16-LED, gooseneck arm, goodrich goosneck, goodrich avalon, avalon gooseneck led, led avalon gooseneck, avalon led gooseneck, avalon, gooseneck avalon, goodrich avalon led, led avalon, goodrich avalon led, gooseneck avalon, gooseneck avalon led, goodrich, avalon, avalon gooseneck, goodrich avalon, porcelian gooseneck, porcelian goodrich, BLE-G-WHA-LED, LED gooseneck, LED, LED avalon, goodrich LED, LED light, BLE-G-WHA12-LED, BLE-G-WHA14-LED, BLE-G-WHA16-LED, gooseneck arm, goodrich goosneck, goodrich avalon, avalon gooseneck led, led avalon gooseneck, avalon led gooseneck, avalon, gooseneck avalon, goodrich avalon led, led avalon, goodrich avalon led, gooseneck avalon, gooseneck avalon led, BLE-G-WHA8, BLE-G-WHA10, BLE-G-WHA12, BLE-G-WHA14, BLE-G-WHA16, SPS-0108, SPS0108, SPS 0108, avalon collection, avalon series, the avalon collection, the avalon series, Avalon LED collection, avalon LED series, the avalon led collection, the avalon led series, SPS-0457, SPS0457, SPS 0457, 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, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount lighting, bleg, avalon integrated,
65046		Our LED pendant lights show off a trendy industrial profile that’s perfect for homes and businesses! For maximum efficiency and a unique style, bring the Aero to your space!	The Astro Rustic LED Gooseneck Light, Astro Rustic LED Gooseneck Light, The Astro LED Gooseneck Light, Astro LED Gooseneck Light, The Astro Rustic Gooseneck Light, Astro Rustic Gooseneck Light, Astro gooseneck light, the astro gooseneck light, astro, the astro, rustic led light, rustic led lighting, rustic led lights, rustic light, rustic lights, rustic lighting, led light, led lights, led lighting, led gooseneck light, led, led gooseneck, led goose neck, led gooseneck lights, led gooseneck lighting, gooseneck led light, gooseneck led lights, led gooseneck lighting, gooseneck light, gooseneck lights, gooseneck lighting, led light, led lights, led lighting, BLE-G-WHD-PC-CGG-LED, Goodrich® Aero Rustic LED Gooseneck Light, Goodrich Aero Rustic LED Gooseneck Light, Aero Rustic LED Gooseneck Light, Goodrich Rustic LED Gooseneck Light, Goodrich, good rich, Aero, Goodrich Aero, rustic led gooseneck light, rustic led gooseneck lights, rustic led gooseneck lighting, led gooseneck light, led gooseneck lights, led gooseneck lighting, gooseneck led light, gooseneck led lights, gooseneck led lighting, rustic light, rustic lights, rustic lighting, Aero gooseneck, Aero gooseneck light, Aero gooseneck lights, Aero gooseneck lighting, led, rustic lighting, rustic light, rustic lights, rustic led lighting, rustic led light, rustic led lights, rustic lights, rustic lighting, wall light, wall lights, wall lighting, led wall light, led wall lights, led wall lighting, rustic gooseneck, rustic goosenecks, rustic gooseneck light, rustic gooseneck lights, rustic gooseneck lighting, gooseneck rustic light, gooseneck rustic lights, gooseneck rustic lighting, BLE-G-WHD-CGG-LED, nautical led, cgg led, cast guard led, nautical, Aero nautical, Aero gooseneck, Aero cgg, Aero, Aero led gooseneck, goodrich Aero led, Aero gooseneck led, The Astro Nautical LED Gooseneck Light, Astro Nautical LED Gooseneck Light, The Astro Nautical Gooseneck Light, Astro Nautical Gooseneck Light, Astro gooseneck light, the astro gooseneck light, astro, the astro, nautical led light, nautical led lighting, nautical led lights, nautical light, nautical lights, nautical lighting, Goodrich® Aero Nautical LED Gooseneck Light, Goodrich Aero Nautical LED Gooseneck Light, Aero Nautical LED Gooseneck Light, Goodrich Nautical LED Gooseneck Light, Goodrich, good rich, Aero, Goodrich Aero, nautical led gooseneck light, nautical led gooseneck lights, nautical led gooseneck lighting, nautical light, nautical lights, nautical lighting, nautical lighting, nautical light, nautical lights, nautical led lighting, nautical led light, nautical led lights, nautical lights, nautical lighting, wall light, wall lights, wall lighting, led wall light, led wall lights, led wall lighting, nautical gooseneck, nautical goosenecks, nautical gooseneck light, nautical gooseneck lights, nautical gooseneck lighting, gooseneck nautical light, gooseneck nautical lights, gooseneck nautical lighting, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, aero led series, aero LED collection, SPS-0458, SPS0458, SPS 0458, SPS-0526, SPS0526, SPS 0526, 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, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount lighting, bleg,