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 (61413, 60978, 60980, 61621) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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 (61413,60978,60980,61621) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
60978	2 light vanity sconce, vanity light, bathroom wall light, bathroom wall light, double barn sconce, double vanity, bathroom vanity light, bathroom barn lighting, shabby chic bathroom lighting, shabby chic bathroom lighting	With plenty of curves and shabby chic styling, the Union 2-Light Vanity Sconce adds ample illumination with refined, barn light fixtures. Elevate any bathroom or powder room!	Universal Vanity Light, Vanity Light, 2 light, vanity sconce, Bathroom Light, double sconce, Vanity, BLE-W-WHUVL10-PC, 2 light vanity sconce, vanity light, bathroom wall light, bathroom wall light, double barn sconce, double vanity, bathroom vanity light, bathroom barn lighting, shabby chic bathroom lighting, shabby chic bathroom lighting, BLE-WVS2-WHU10, wall vanity, wall vanity light, 2-light vanity, 2 light vanity, two light vanity, 2-light vanity sconce, 2 light vanity sconce, two light vanity sconce, 2-light vanity light, 2 light vanity light, two light vanity light, two light vanity wall sconce, two light vanity, vanity, Vanity lightdouble sconce, Vanity light double sconce, 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, union series, union collection, the union series, the union collection, SPS-0410, SPS 0410, SPS0410, Vintage green farmhouse vanity, Vintage green farm house vanity, 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, 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, 10 inch, 10 inch shade, 10" shade, Union 2 light Vanity, Union 2 light Vanity sconce, double light wall sconces, vanity plates, vanity double sconce,
60980	double goosneck vanity light, double vanity light, deep bowl wall sconce, deep bowl bathroom wall light	Looking for bathroom lighting? This double sconce vanity light showcases 40s style deep bowl shades with modern gooseneck arms for ample mirror lighting.	wesco lighting, deep bowl lighting, Wesco Gooseneck Double Vanity Light, Wesco, Gooseneck, double gooseneck, double vanity light, Vanity Light, Vanity, Bathroom Light, Bathroom, Wall light, double sconce, BLE-WVG2-DBW-PC, BLE-WVG2-DBW8-PC, BLE-WVG2-DBW10-PC, wall vanity, wall vanity light, wilcox vanity, BLE-WVG2-DBW8, BLE-WVG2-DBW10, 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-0285, SPS0285, SPS 0285, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, Vintage green farmhouse vanity, Vintage green farm house vanity, bathroom gooseneck, bathroom goosenecks, bath room gooseneck, bath room goosenecks, 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, double light wall sconces, vanity plates, vanity double sconce, H-16008, H-16110, H-16112, H-16114, H-16116, H-16118, H-17124, classic deep bowl shade,
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,
61621	three light vanity lighting, 3-light schoolhouse sconce, glass globe vanity light, american made lighting, light fixture for bathroom, mirror lighting, vintage inspired lighting, schoolhouse mirror light	The Primary lights up your bathroom and powder room with schoolhouse flair! Three glass globes with painted bands hang from curved arms!	Graduate 3-Light Schoolhouse Vanity Light, BLE-W-SCH10-36VAN, Graduate, schoolhouse sconce, schoolhouse vanity light, Sophomore, sophomore schoolhouse, sophomore vanity light, sophomore schoolhouse light, the sophomore schoolhouse, the sophomore vanity light, the sophomore schoolhouse light, Primary Schoolhouse Sconce, Primary Schoolhouse Wall Sconce, Primary School house Sconce, Primary School house Wall Sconce, Primary Schoolhouse Sconce Light, Primary School house Sconce Light, Primary Sconce, Primary Sconces, Primary Sconce Light, Primary 3-Light Schoolhouse Vanity Light, Primary 3 Light Schoolhouse Vanity Light, Primary three Light Schoolhouse Vanity Light, Primary 3-Light Schoolhouse Vanity sconce, Primary 3-Light Schoolhouse Vanity Wall Sconce, Primary Schoolhouse Vanity Light, Primary Schoolhouse Vanity Sconce, Primary Schoolhouse Vanity Wall Sconce, Primary Vanity Light, Primary Vanity Sconce, Primary Vanity Wall Sconce, wall vanity, wall vanity light, glass wall lighting, glass wall lighting fixture, glass wall lighting fixtures, glass shade wall light, glass shade wall lights, glass shade wall lighting, glass globe wall light, glass globe wall lighting, glass globe wall lights, glass globe shade wall light, glass globe shade wall lights, glass globe shade wall lighting, glass wall light fixture, glass wall light fixtures, glass sconce, glass sconce fixture, glass sconce fixtures, glass wall sconce, glass wall sconce fixture, glass wall sconce fixtures, glass shade sconce, glass shade wall sconce, glass sconce light, glass shade sconce light, glass globe sconce, glass globe wall sconce, glass globe wall sconces, glass globe sconce light, glass shade sconce, glass shade sconces, glass shade wall sconce, glass shade wall sconces, glass shade sconce light, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, BLE-W-SCH10-36VAN, BLE-W-SCHCL10-36VAN, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, primary Schoolhouse collection, primary schoolhouse series, the primary schoolhouse collection, the primary schoolhouse series, primary School house collection, primary school house series, the primary school house collection, the primary school house series, primary collection, primary series, the primary collection, the primary series, SPS-0324, SPS 0324, SPS0324, 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, vanity plates, striped schoolhouse, striped schoolhouse light,