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 (62350, 61413, 63237, 61416) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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 (62350,61413,63237,61416) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61413	double cast guard light fixture, double cast guard and glass wall light, industrial wall sconce, nautical vanity light, industrial bathroom wall light, cast guard and glass double sconce	Twice the impact of standard jelly jar and glass fixtures, this industrial Atomic Topless Double Industrial Guard Wall Sconce makes a bold and rustic bathroom and powder room light.	wall sconce, cast guard, CGU, CGG, TGG, rustic sconce, Atomic Topless Double Industrial Guard Sconce, BLE-G-CGG2H/G39, wall vanity, wall vanity light, atomic wall sconce, atomic guard sconce, guard sconce, rugged sconce, atomic industrial wall sconce, atomic wall light, atomic sconce, industrial guard sconce, industrial guard wall sconce, industrial guard, industrial guard wall light, industrial guard light, industrial wall sconce, industrial wall light, 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 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, 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, topless industrial guard sconce, SPS-0198, SPS0198, SPS 0198, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Bathroom vanity light fixture, Bathroom vanity light fixtures, Bathroom vanity fixture, Bathroom vanity fixtures, Bathroom vanity light, Bathroom vanity lights, Bathroom vanity lighting, Bath vanity light, Bath vanity lights, Bath vanity lighting, Bath vanity fixture, Bath vanity fixtures, bathroom light fixtures, bathroom light fixture, bathroom lighting fixtures, bathroom lighting fixture, bath light fixtures, bath light fixture, bath lighting fixtures, bath lighting fixture, 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, nautical cage sconce, double atomic, double cage wall light, vanity double sconce,
61416	industrial vanity lighting, double cast guard wall sconce with flared shade, industrial bathroom light, double cast guard wall lantern, cast guard with mini shade wall mount, industrial vanity light fixture,	Nautical meets industrial with the double cast guard and shade vanity lights. The Double Market is highly customizable for bathroom and powder room lighting.	Double Market Industrial Guard Sconce, BLE-G-CGGFS2/G34, wall sconce, vanity light, double sconce, cast guard, CGU, CGG, TGG, rustic sconce, Atomic Topless Double Market Industrial Guard Sconce, Double Market Industrial Guard Sconce, Atomic Double Market Industrial Guard Sconce, Double industrial sconce, double industrial wall sconce, industrial guard sconce, industrial sconce, industrial wall sconce, rugged wall sconce, 2-light wall sconce, 2-light market industrial guard sconce, 2-light industrial sconce, 2-light industrial wall sconce, two light sconce, two light wall sconce, 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 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, jelly jar light, jelly jar lights, jelly jar light fixture, jelly jar light fixtures, Industrial streamline, Stream industrial guard sconce, industrial guard, industrial guard sconce with cage, Industrial vanity lighting, SPS-0021, SPS 0021, SPS0021, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, teal, Industrial guardsconce, Industrial guardsconces, Caged lights, Caged light, 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, double market sconce, double market wall sconce, double market sconces, double market wall sconces, double light wall sconces, nautical cage sconce, double atomic, double cage wall light, vanity double sconce,
62350	double led light, led pendant light	Energy efficient with a classic style, the Industrial LED Double Pendant offers plenty of industrial charm and very latest LED technology!	Industrial Loft LED Double Pendant, BLE-S-CGG2H-PC-LED, double led light, 2-light led, 2 light led, cgg led, wgg led, tgg let, cast guard and glass led, cast guard and glass pendant led, led pendant, led stem mount, vapor jar pendant, vaporjar pendant led, led vaporjar pendant, industrial led pendant, rustic led pendant, rustic pendant led, led rustic pendant, double loft, loft double, industrial loft, led loft, loft led, 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, rugged guard LED pendant, rugged guard LED pendant lights, rugged guard LED ceiling pendant, rugged guard LED ceiling pendants, rugged guard LED ceiling light, rugged guard LED ceiling lights, rugged guard LED ceiling lighting, LED rugged guard pendant, LED rugged guard pendant lights, LED rugged guard ceiling pendant, LED rugged guard ceiling pendants, LED rugged guard ceiling light, LED rugged guard ceiling lights, LED rugged guard ceiling 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, rugged guard pendant, rugged guard pendant lights, rugged guard ceiling pendant, rugged guard ceiling pendants, rugged guard ceiling light, rugged guard ceiling lights, rugged guard ceiling lighting, rugged guard chandelier, rugged guard chandeliers, LED rugged guard chandelier, LED rugged guard chandeliers, Rugged guard led chandelier, rugged guard LED chandeliers, SPS-0601, SPS 0601, SPS0601, 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 pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, ble-c-gg, nautical cage pendant,
63237		Vintage lighting designs and modern technology meet in this vanity light! A stylish addition to bathrooms and other areas, create a custom look for any space!	Industrial Guard Double Vanity Light, Industrial guard vanity light, industrial vanity light, vanity light, industrial vanity sconce, industrial vanity wall sconce, vanity wall sconce, industrial vanity wall light, vanity wall light, industrial vanity wall lights, vanity wall lights, industrial vanity wall lighting, vanity wall lighting, bathroom lighting, bathroom lights, bathroom light, bathroom, bath room, rest room lighting, restroom lighting, rest room lights, restroom lights, rest room light, restroom light, bath room lights, bath room light, bath room lighting, atomic, vanity sconce light, vanity sconce lighting, bathroom sconce, bath room sconce, bathroom wall sconce, bath room wall sconce, bathroom wall light, bath room wall light, bath room wall lights, bathroom wall lights, bath room wall lighting, bathroom wall lighting, double vanity light, two light vanity, two light vanity light, 2 light vanity light, 2 light vanity, double lighting, double sconce lighting, double sconce light, two light sconce, two light sconce lighting, 2 light, two, double, 2, 2 light, vanity sconce, vanity wall sconce, vanity wall sconces, vanity wall sconce lighting, vanity wall light, vanity wall lights, vanity wall lighting, led vanity sconce, led vanity wall sconce, led vanity wall sconces, led vanity wall sconce lighting, led vanity wall light, led vanity wall lights, led vanity wall lighting, vanity led sconce, vanity led wall sconce, vanity led wall sconces, vanity led wall sconce lighting, vanity led wall light, vanity led wall lights, vanity led wall lighting, LED Industrial Guard Double Vanity Light, LED Industrial Double Vanity Light, LED Double Vanity Light, LED Guard Double Vanity Light, LED Guard Double Vanity Light, LED Industrial Double Vanity Light, LED Industrial Guard Vanity Light, LED Industrial Guard Double Light, LED Industrial Guard Double Vanity, BLE-WV-CGG2/FS-LED, wall vanity, wall vanity light, led vanity, vanity led, industrial vanity, rugged guard, rugged vanity light, 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 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 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, Rugged guard LED sconce, rugged guard LED wall sconce, rugged guard LED sconce light, rugged guard LED sconce lights, rugged guard LED sconce lighting, rugged guard LED wall light, rugged guard LED wall lights, rugged guard LED wall lighting, Vanity lightdouble sconce, Vanity light double sconce, vanity, bath light, bath lights, bath lighting, bath sconce, bath wall sconce, bath sconces, bath sconces, bath wall sconces, bath sconce light, bath sconce lights, bath sconce lighting, bathroom light, bathroom lights, bathroom lighting, bathroom sconce, bathroom wall sconce, bathroom sconces, bathroom sconces, bathroom wall sconces, bathroom sconce light, bathroom sconce lights, bathroom sconce lighting, bath room light, bath room lights, bath room lighting, bath room sconce, bath room wall sconce, bath room sconces, bath room sconces, bath room wall sconces, bath room sconce light, bath room sconce lights, bath room sconce lighting, SPS-0018, SPS 0018, SPS0018, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Bathroom vanity light fixture, Bathroom vanity light fixtures, Bathroom vanity fixture, Bathroom vanity fixtures, Bathroom vanity light, Bathroom vanity lights, Bathroom vanity lighting, Bath vanity light, Bath vanity lights, Bath vanity lighting, Bath vanity fixture, Bath vanity fixtures, bathroom light fixtures, bathroom light fixture, bathroom lighting fixtures, bathroom lighting fixture, bath light fixtures, bath light fixture, bath lighting fixtures, bath lighting fixture, 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, double light wall sconces, vanity plates, nautical cage sconce, double cage wall light, vanity double sconce,