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 (61433, 62403, 64788, 64784) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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 (61433,62403,64788,64784) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61433	industrial farmhouse wall sconce, cast guard shade with mini flared saucer, cast guard wall sconce, industrial nautical wall sconce, lantern style wall light, guard and glass wall light, maritime cage wall sconce	This industrial maritime light combines a protective guard and glass body with a mini shade for rustic flair. Elevate indoor and outdoor spaces with this heavy-duty, fully customizable wall light!	Industrial Guard Sconce, BLE-G-CGGFS-PC-G3, cast guard wall sconce, nautical lantern wall sconce, cgu, cgg, tgg, wgg, wire guard sconce, rustic wall light, industrial wall light, industrial wall lighting, industrial wall sconce, industrial sconce, sconce lighting, wall sconce lighting, sconce, wall sconce, wall light, outdoor wall light, outdoor wall sconce, outdoor light, outdoor, outdoor lighting, exterior wall light, exterior wall sconce, exterior light, exterior, exterior lighting, guard sconce, guard wall sconce, guard light, guard wall light, guard light, guard lighting, industrial guard, industrial guard light, industrial lighting, guard and glass light, cast guard and glass, Atomic Topless Industrial Guard Sconce, Industrial Guard Sconce, Atomic Industrial Guard Sconce, guard light, cage light, Rugged guard sconce, rugged guard wall sconce, rugged guard sconce light, rugged guard sconce lights, rugged guard sconce lighting, rugged guard wall light, rugged guard wall lights, rugged guard wall lighting, Rugged guard light, rugged guard lights, rugged guard lighting, rugged guard light fixture, rugged guard lighting fixture, rugged guard light fixtures, rugged guard lighting fixtures, Ribbed glass sconce, Ribbed glass sconces, Ribbed glass wall sconce, Ribbed glass wall sconces, jelly jar light, jelly jar lights, jelly jar light fixture, jelly jar light fixtures, cgg, cggg, ccg, Industrial streamline, Stream industrial guard sconce, industrial guard, industrial guard sconce with cage, Industrial vanity lighting, SPS-0026, SPS 0026, SPS0026, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg 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, Caged lights, Caged light, 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, ble-c-gg, BLE-G-CCG-PC-G3, nautical wall sconces, nautical cage sconce,
62403	barn light gooseneck bracket, industrial guard led fixture, led wall bracket	Our barn light gooseneck bracket gets the industrial treatment with our new Industrial Guard LED fixture. This energy efficient LED wall bracket is rated for exterior and interior use.	LED Industrial Guard Gooseneck, BLE-G-CGGFS-PC-LED, industrial led gooseneck, rustic led gooseneck, led gooseneck, industrial guard led, cast guard and glass led, cast guard and glass led gooseneck, led guard gooseneck, vapor jar led gooseneck, Rugged guard light, rugged guard lights, rugged guard lighting, rugged guard light fixture, rugged guard lighting fixture, rugged guard light fixtures, rugged guard lighting fixtures, rugged guard wall light, rugged guard wall lights, rugged guard wall lighting, rugged guard gooseneck, Rugged guard goosenecks, rugged guard gooseneck lights, rugged guard gooseneck lighting, rugged guard LED wall light, rugged guard LED wall lights, rugged guard LED wall lighting, rugged guard LED gooseneck, rugged guard gooseneck led, Rugged guard led goosenecks, rugged guard led gooseneck lights, rugged guard led gooseneck lighting, led rugged guard gooseneck light, led rugged guard gooseneck lights, Rugged guard LED light, rugged guard LED lights, rugged guard LED lighting, rugged guard LED light fixture, rugged guard LED lighting fixture, rugged guard LED light fixtures, rugged guard LED lighting fixtures, SPS-0546, SPS0546, SPS 0546, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, 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, ble-c-gg, bleg,
64784		Fashionable, durable, and fully customizable, The Syracuse was designed with homes and businesses in mind! USA-made!	the syracuse gooseneck light, syracuse gooseneck light, gooseneck lighting, vintage gooseneck lighting, garage lighting, sign lighting, outdoor gooseneck lighting, syracuse lighting, explosion proof lighting, BLE-G-CI, BLE-G-CI12, BLE-G-CI14, BLE-G-CI16, BLE-G-CI18, Syracuse, vintage industrial, vintage industrial collection, new listing, new vintage industrial, new syracuse, BLE-G-CI12, BLE-G-CI14, BLE-G-CI16, BLE-G-CI18, 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, vintage industrial gooseneck, vintage industrial goosenecks, vintage industrial goose neck, vintage industrial goose necks, vintage industrial wall light, vintage industrial wall lights, vintage industrial wall lighting, vintage industrial light fixture, vintage industrial light fixtures, vintage industrial gooseneck light, vintage industrial goose neck light, vintage industrial gooseneck lights, vintage industrial goose neck lights, vintage industrial gooseneck lighting, vintage 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, metropolis, metropolis collection, metropolis light, metropolis lights, metropolis lighting, metropolis gooseneck, metropolis goose neck, 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, metropolis, metropolis collection, metropolis light, metropolis lights, metropolis lighting, SPS-0278, SPS 0278, SPS0278, vintage industrial collection, vintage industrial series, the vintage industrial collection, the vintage industrial series, metropolis collection, metropolis series, the metropolis collection, the metropolis series, metropolitan collection, metropolitan series, the metropolitan collection, the metropolitan series, Syracuse collection, Syracuse Series, The Syracuse collection, the Syracuse Series, 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, 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,
64788		Industrial styles with bold finishes like marine grade and a classic gooseneck light! Handcrafted and fully customizable!	the cleveland vintage gooseneck light, cleveland vintage gooseneck light, the cleveland gooseneck light, exterior light fixtures, exterior wall lighting, gooseneck light, gooseneck outdoor light fixture, BLE-G-AI, BLE-G-AI12, BLE-G-AI14, BLE-G-AI16, cleveland, vintage industrial, vintage industrial collection, new listing, new vintage industrial, new cleveland, BLE-G-AI12, BLE-G-AI14, BLE-G-AI16, 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, metropolis, metropolis collection, metropolis light, metropolis lights, metropolis lighting, 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, vintage industrial gooseneck, vintage industrial goosenecks, vintage industrial goose neck, vintage industrial goose necks, vintage industrial wall light, vintage industrial wall lights, vintage industrial wall lighting, vintage industrial light fixture, vintage industrial light fixtures, vintage industrial gooseneck light, vintage industrial goose neck light, vintage industrial gooseneck lights, vintage industrial goose neck lights, vintage industrial gooseneck lighting, vintage 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, metropolis, metropolis collection, metropolis light, metropolis lights, metropolis lighting, metropolis gooseneck, metropolis goose neck, SPS-0279, SPS 0279, SPS0279, vintage industrial collection, vintage industrial series, the vintage industrial collection, the vintage industrial series, metropolis collection, metropolis series, the metropolis collection, the metropolis series, metropolitan collection, metropolitan series, the metropolitan collection, the metropolitan series, Cleveland collection, Cleveland Series, The Cleveland collection, the Cleveland Series, 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, 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,