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 (61621, 62387, 63231, 63234) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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 (61621,62387,63231,63234) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
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,
62387 modern industrial led pendant, industrial cast guard lighting, industrial led pendant Powerful LED technology with an eye-catching style, the Enterprise’s bold industrial design complements farmhouse, industrial, and nautical looks! Save money with fashionable lights! Enterprise LED 3 Light Chandelier, BLE-C-CGGFS3/VAN36-PC-LED, led vanity, industrial led vanity light, rustic led chandelier, cast guard and glass led, led chandelier, rustic led, industrial led chandelier, vapor jar led chandelier, rustic led chandelier, led chandelier, cast guard and glass chandelier, led cast guard and glass chandelier, vapor jar led chandelier, led cast guard chandelier, 3-light chandelier, led chandelier, three light chandelier, industrial 3-light chandelier, industrial 3-light chandeliers, industrial 3 light chandelier, industrial 3 light chandeliers, industrial three light chandelier, industrial three light chandeliers, nautical chandelier, nautical 3-light chandelier, nautical 3-light chandeliers, 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 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 chandelier, rugged guard chandeliers, LED rugged guard chandelier, LED rugged guard chandeliers, Rugged guard led chandelier, rugged guard LED chandeliers, SPS-0549, SPS 0549, SPS0549, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, enterprise chandelier, enterprise chandeliers,
63231 Hand-built in America! This vanity light uses only commercial grade materials. Fully customizable and made-to-order, let this wall sconce lighting give your bathroom a new style! Industrial Guard Double Vanity Light, BLE-WV-CGG2/FS, 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, Atomic Topless Industrial Guard Double Vanity Light, Industrial Guard Double Vanity Light, Atomic Industrial Guard Double Vanity Light, wall vanity, wall vanity light, industrial guard, 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, 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, Industrial streamline, Stream industrial guard sconce, industrial guard, industrial guard sconce with cage, Industrial vanity lighting, SPS-0018, SPS0018, SPS 0018, 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, double cage wall light, vanity double sconce,
63234 Bold, industrial styles for every bathroom! Built in America, this vanity light is incredibly durable and fully customizable! Perfect for contemporary styles and traditional looks! Industrial Guard Triple 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, triple vanity light, three light vanity, three light vanity light, 3 light vanity light, 3 light vanity, triple lighting, triple sconce lighting, triple sconce light, three light sconce, three light sconce lighting, 3 light, three, triple, 3, 3 light, BLE-WV-CGG3/FS, Atomic Topless Industrial Guard Triple Vanity Light, Industrial Guard Triple Vanity Light, Atomic Industrial Guard Triple Vanity Light, wall vanity, wall vanity light, triple vanity, triple vanity fixture, 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, 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, Industrial streamline, Stream industrial guard sconce, industrial guard, industrial guard sconce with cage, Industrial vanity lighting, SPS-0242, SPS 0242, SPS0242, 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, vanity plates,