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 (62274, 64925, 64932, 62422) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00059

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 (62274,64925,64932,62422) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
62274	warehouse shade, outdoor wall light, contemporary wall light, outdoor gooseneck lighting	A modern twist on classic factory lighting, the Cherokee Gooseneck features a flared RLM shade with horizontal slits in the neck for plenty of up-lighting!	Cherokee Uplight Gooseneck Light, shade with jelly jar, cherokee, comanche, vented, flared shade, up light, upight, charokee uplight, charokee, Cherokee Uplight Gooseneck, cherokee gooseneck, uplight gooseneck, uplight wall light, BLE-G-ULC-PC, BLE-G-ULC16-PC, gooseneck lighting, gooseneck light, gooseneck wall light, Cherokee gooseneck lighting, Cherokee gooseneck light, Cherokee gooseneck wall light, uplight gooseneck lighting, uplight gooseneck wall light, uplight gooseneck light, uplight gooseneck lights, warehouse shade gooseneck, warehouse shade gooseneck light, warehouse gooseneck light, warehouse gooseneck lighting, vented warehouse shade, vented warehouse shade light, cherokee, cherokee gooseneck, cherokee goose neck, new listing, BLE-G-ULC12, BLE-G-ULC14, BLE-G-ULC16, BLE-G-ULC18, SPS-0161, SPS 0161, SPS0161, cherokee uplight series, cherokee uplight collection, the cherokee uplight series, the cherokee uplight collection, cherokee up light series, cherokee up light collection, the cherokee up light series, the cherokee up light collection, cherokee up-light series, cherokee up-light collection, the cherokee up-light series, the cherokee up-light collection, cherokee series, cherokee collection, the cherokee series, the cherokee collection, 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, Vented barn light, Vented goose neck light, Vented gooseneck light, Vented goose neck lights, Vented goose neck lighting, Vented gooseneck lights, Vented gooseneck lighting, Vented goose neck, Vented goose necks, Vented gooseneck, Vented goosenecks, Barn light vented, bleg, cherokee wall light, slotted, slotted light,
62422	led gooseneck lgiht, led cast guard and glass, led up/down light	This American-made LED gooseneck light offers both up/down lighting via its contemporary flared shade and LED integrated cast guard and glass design.	Wallaby LED Gooseneck Light, BLE-G-ULA-PC-LED, wallaby gooseneck led, wallaby led, led wallaby, rustic led gooseneck, led rustic gooseneck, led gooseneck, industrial led gooseneck, Wallaby gooseneck light, Wallaby gooseneck, gooseneck, gooseneck light, industrial led, led industrial, rustic gooseneck, gooseneck rustic, LED wallaby, wallaby, BLE-G-ULA12, BLE-G-ULA14, BLE-G-ULA16, Industrial light, industrial lights, industrial lighting, industrial lighting fixture, industrial lighting fixtures, rugged light, rugged lights, rugged lighting, rugged lighting fixture, rugged lighting fixtures, Vintage Industrial light, vintage industrial lights, vintage industrial lighting, vintage industrial lighting fixture, vintage industrial lighting fixtures, cast guard light, cast guard lights, cast guard lighting, cast guard lighting fixture, cast guard lighting fixtures, Queensland collection, queensland lighting, queensland light, queensland lights, queensland lighting, queensland light fixture, queensland light fixtures, Queens land collection, queens land lighting, queens land light, queens land lights, queens land lighting, queens land light fixture, queens land light fixtures, Queensland, industrial gooseneck, industrial goosenecks, industrial goose neck, industrial goose necks, industrial wall light, industrial wall lights, industrial wall lighting, industrial light fixture, industrial light fixtures, industrial gooseneck light, industrial goose neck light, industrial gooseneck lights, industrial goose neck lights, industrial gooseneck lighting, industrial goose neck lighting, rugged gooseneck, rugged goosenecks, rugged goose neck, rugged goose necks, rugged wall light, rugged wall lights, rugged wall lighting, rugged light fixture, rugged light fixtures, rugged gooseneck light, rugged goose neck light, rugged gooseneck lights, rugged goose neck lights, rugged gooseneck lighting, rugged goose neck lighting, cast guard gooseneck, cast guard goosenecks, cast guard goose neck, cast guard goose necks, cast guard wall light, cast guard wall lights, cast guard wall lighting, cast guard light fixture, cast guard light fixtures, cast guard gooseneck light, cast guard goose neck light, cast guard gooseneck lights, cast guard goose neck lights, cast guard gooseneck lighting, cast guard goose neck lighting, Queensland wall light, Queensland wall lights, Queensland wall lighting, Queensland Wall Fixture, Queensland wall fixtures, Queens land wall light, Queens land wall lights, Queens land wall lighting, Queens land Wall Fixture, Queens land wall fixtures, Queensland Gooseneck, Queensland goose neck, queensland goose necks, Queensland gooseneck light, Queensland gooseneck lights, Queensland gooseneck lighting, Queensland goose neck light, Queensland goose neck lights, Queensland goose neck lighting, Queens land Gooseneck, Queens land goose neck, queens land goose necks, Queens land gooseneck light, Queens land gooseneck lights, Queens land gooseneck lighting, Queens land goose neck light, Queens land goose neck lights, Queens land goose neck lighting, LED Industrial light, LED industrial lights, LED industrial lighting, LED industrial lighting fixture, LED industrial lighting fixtures, LED rugged light, LED rugged lights, LED rugged lighting, LED rugged lighting fixture, LED rugged lighting fixtures, LED Vintage Industrial light, LED vintage industrial lights, LED vintage industrial lighting, LED vintage industrial lighting fixture, LED vintage industrial lighting fixtures, LED cast guard light, LED cast guard lights, LED cast guard lighting, LED cast guard lighting fixture, LED cast guard lighting fixtures, LED metropolis, LED metropolis collection, LED metropolis light, LED metropolis lights, LED metropolis lighting, Industrial LED light, industrial LED lights, industrial LED lighting, industrial LED lighting fixture, industrial LED lighting fixtures, rugged LED light, rugged LED lights, rugged LED lighting, rugged LED lighting fixture, rugged LED lighting fixtures, Vintage Industrial LED light, vintage industrial LED lights, vintage industrial LED lighting, vintage industrial LED lighting fixture, vintage industrial LED lighting fixtures, cast guard LED light, cast guard LED lights, cast guard LED lighting, cast guard LED lighting fixture, cast guard LED lighting fixtures, Queensland LED, Queens Land LED, LED Queensland, LED Queens Land, LED industrial gooseneck, LED industrial goosenecks, LED industrial goose neck, LED industrial goose necks, LED industrial wall light, LED industrial wall lights, LED industrial wall lighting, LED industrial light fixture, LED industrial light fixtures, LED industrial gooseneck light, LED industrial goose neck light, LED industrial gooseneck lights, LED industrial goose neck lights, LED industrial gooseneck lighting, LED industrial goose neck lighting, industrial LED gooseneck, industrial LED goosenecks, industrial LED goose neck, industrial LED goose necks, industrial LED wall light, industrial LED wall lights, industrial LED wall lighting, industrial LED light fixture, industrial LED light fixtures, industrial LED gooseneck light, industrial LED goose neck light, industrial LED gooseneck lights, industrial LED goose neck lights, industrial LED gooseneck lighting, industrial LED goose neck lighting, LED rugged gooseneck, LED rugged goosenecks, LED rugged goose neck, LED rugged goose necks, LED rugged wall light, LED rugged wall lights, LED rugged wall lighting, LED rugged light fixture, LED rugged light fixtures, LED rugged gooseneck light, LED rugged goose neck light, LED rugged gooseneck lights, LED rugged goose neck lights, LED rugged gooseneck lighting, LED rugged goose neck lighting, rugged LED gooseneck, rugged LED goosenecks, rugged LED goose neck, rugged LED goose necks, rugged LED wall light, rugged LED wall lights, rugged LED wall lighting, rugged LED light fixture, rugged LED light fixtures, rugged LED gooseneck light, rugged LED goose neck light, rugged LED gooseneck lights, rugged LED goose neck lights, rugged LED gooseneck lighting, rugged LED goose neck lighting, LED cast guard gooseneck, LED cast guard goosenecks, LED cast guard goose neck, LED cast guard goose necks, LED cast guard wall light, LED cast guard wall lights, LED cast guard wall lighting, LED cast guard light fixture, LED cast guard light fixtures, LED cast guard gooseneck light, LED cast guard goose neck light, LED cast guard gooseneck lights, LED cast guard goose neck lights, LED cast guard gooseneck lighting, LED cast guard goose neck lighting, cast guard LED gooseneck, cast guard LED goosenecks, cast guard LED goose neck, cast guard LED goose necks, cast guard LED wall light, cast guard LED wall lights, cast guard LED wall lighting, cast guard LED light fixture, cast guard LED light fixtures, cast guard LED gooseneck light, cast guard LED goose neck light, cast guard LED gooseneck lights, cast guard LED goose neck lights, cast guard LED gooseneck lighting, cast guard LED goose neck lighting, Wallaby Series, Wallaby Collection, The Wallaby Series, The Wallaby Collection, Australia collection, Australia Series, the Australia collection, the Australia Series, Queensland Collection, Queensland Series, The Queensland Collection, the Queensland Series, Queens land Collection, Queens land Series, The Queens land Collection, the Queens land Series, SPS-0322, SPS 0322, SPS0322, The wallaby gooseneck, the wallaby gooseneck light, The wallaby goose neck, The wallaby goose, wallaby gooseneck light, wallaby goose neck, wallaby goose, the wallby gooseneck light, The wallby goose neck, The wallby goose, wallby gooseneck light, wallby goose neck, wallby goose, 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, wallaby series,
64925		Add touches of style indoors or out and reduce power costs with this LED gooseneck light! American made, hand-crafted, and fully customizable!	Astro, Astro Shallow Bowl Gooseneck, Astro Gooseneck, Shallow bowl, gooseneck, powder coat, BLE-G-SBA-PC-LED, Astro LED, LED light, LED lighting, LED gooseneck, led, BLE-G-SBA12-PC-LED, BLE-G-SBA14-PC-LED, BLE-G-SBA16-PC-LED, goodrich Aero, aero gooseneck, BLE-G-SBA12, BLE-G-SBA14, BLE-G-SBA16, aero led series, aero LED collection, SPS-0458, SPS0458, SPS 0458, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, 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, aero integrated led, bowl shallow,
64932		Integrating efficient LED lighting into the designs of industrial lights, the Dominion becomes a cost-effective addition to businesses and homes. USA-made!	xterior, outdoor, exterior light, outdoor light, exterior lights, outdoor lights, exterior lighting, outdoor lighting, led exterior, led outdoor, led exterior light, led outdoor light, led exterior lights, led outdoor lights, led exterior lighting, led outdoor lighting, exterior led, outdoor led, exterior led light, outdoor led light, exterior led lights, outdoor led lights, exterior led lighting, outdoor led lighting, gooseneck, gooseneck arm, gooseneck lighting, gooseneck lights, BLE-G-SBD-LED, dominion led, goodrich dominion, dominion gooseneck led, led dominion gooseneck, warehouse led gooseneck, gooseneck dominion, goodrich dominion led, goodrich dominion, shallow bowl led, led dominion, dominion, district, The District LED Gooseneck Light, District LED Gooseneck Light, The District Gooseneck Light, District Gooseneck Light, District, District light, led gooseneck light, gooseneck led light, gooseneck lighting, gooseneck leds, leds, led, district lighting, district, the district, wall lighting, wall lights, led wall lights, led wall lighting, wall light, shallow bowl, shallow bowl lighting, shallow bowl shade, shallow bowl warehouse shade, warehouse shade, led lighting, led lights, exterior lighting, exterior lights, outdoor lighting, outdoor lights, exterior light, outdoor light, led exterior lighting, led exterior lights, led outdoor lighting, led outdoor lights, led exterior light, led outdoor light, exterior led lighting, exterior led lights, outdoor led lighting, outdoor led lights, exterior led light, outdoor led light, BLE-G-SBD-PC-LED, led warehouse shade, led warehouse shades, warehouse led shade, warehouse led shades, industrial wall light, industrial wall lights, industrial wall lighting, led industrial wall light, led industrial wall lights, industrial led wall light, industrial led wall lights, industrial led wall lighting, industrial gooseneck light, industrial gooseneck lights, industrial gooseneck lighting, industrial LED gooseneck light, industrial LED gooseneck lights, industrial LED gooseneck lighting, LED industrial gooseneck light, LED industrial gooseneck lights, LED industrial gooseneck lighting, district led, led district, BLE-G-SBD12, BLE-G-SBD14, BLE-G-SBD16, SPS-0489, SPS 0489, SPS0489, dominion integrated LED series, dominion integrated LED collection, the dominion integrated LED series, the dominion integrated LED collection, dominion LED series, dominion LED collection, the dominion LED series, the dominion LED collection, 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, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse gooseneck,