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 (62333, 61433, 60484, 63237) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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 (62333,61433,60484,63237) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
60484 rustic wall sconce, wall sconce, vapor proof wall light, bulkhead wall light, cast guard and glass sconce, marine sconce Rugged, customizable, and stylish: this industrial wall sconce is a versatile lighting option, perfect for indoor and outdoor applications! Create a truly unique look for any space! HB Sconce, Cast Guard, Atomic Sconce, CGU, CGU Sconce, Industrial Static Topless Sconce, Topless Sconce, 10W1CG, BLE-W-CGGT, rustic wall sconce, CGG, static sconce, topless static sconce, Industrial Static Topless Sconce, Atomic Industrial Static Sconce, industrial sconce, static sconce, industrial wall sconce, static wall sconce, staic, static, 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, cgg, cggg, ccg, sconce outdoor wet rated, sconce outdoor wet-rated, Light with photocell, outdoor light light with photocell, SPS-0027, SPS 0027, SPS0027, 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, pastel, 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, ble-c-gg, nautical wall sconces, nautical cage sconce,
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,
62333 led industrial guard sconce, industrial led sconce, 2-light led wall sconce, Industrial farmhouse style with our LED industrial guard sconce! This 2-light LED wall light offers cast guard & glass jars as outdoor energy efficient lighting! Double Market LED Industrial Guard Sconce, led 2-light, 2-light led sconce, led bathroom light, BLE-G-CGGFS2/G43-PC-LED, led sconce, led rustic sconce, rustic led, cast guard and glass led, led vapor proof, vapor proof led, led rustic, led wall light, led array, integrated array led, vaporproof led, led vaporproof, jelly jar and cast guard led sconce, energy efficient lighting, led lighting, led wall sconce, industrial lighting, industrial guard sconce, led industrial guard sconce, industrial guard light, led industrial guard light, led industrial wall light, led industrial wall sconce, led industrial sconce, led industrial wall sconce, led industrial 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 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, 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, Caged lights, Caged light, CGG LED Sconce, CGG LED Sconces, CGG LED Wall Sconce, CGG LED Wall Sconces, CGG LED Sconce Light, CGG LED Sconce Lights, CGG LED Sconce Lighting, ble-c-gg, nautical cage sconce, double cage wall light,
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,