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

Result

product_id	meta_keywords	meta_description	search_words
58117	Mid-Century light, Industrial light, pendant lighting, mid century lighting, industrial lighting, double ceiling mount, cgg, ceiling light, ship light, ship lights, metal, pendant, rustic, bullet shape, marine pendant, bathroom, vanity, kitchen,	A rugged look for modern spaces! This industrial pendant light offers plenty of style and character to homes and businesses! Fully customizable!	Barn Light, Wall Mount, Double CGU Pendant ,Cast Guard, Atomic Pendant, CGU, CGU Pendant, BLE-S-CGG2H, Industrial Loft Double Pendant, ceiling pendant, industrial ceiling pendant, industrial ceiling pendant, pendant lighting, industrial pendant lighting, industrial ceiling light, loft ceiling light, loft double pendant, cast guard ceiling light, cast guard and glass ceiling light, industrial lighting, outdoor lighting, outdoor ceiling light, exterior ceiling light, exterior ceiling lighting, exterior lighting, loft pendant, double loft pendant, loft double pendant, Industrial Loft Double Pendant Light, Industrial Loft Double Pendant, 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, cgg, cggg, ccg, SPS-0423, SPS0423, SPS 0423, 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, double atomic, double cage wall light,
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,
63757		A fresh take on classic industrial styles, the Atomic Topless Dual Sconce shows off a “v-shaped” design! Perfect for homes and businesses, finish this wall sconce with a vibrant color option!	BLE-G-CGG/V2, Atomic Topless Dual Sconce, Atomic Topless Dual Sconces, Atomic Topless Dual Sconce light, Atomic Topless Dual Sconce lights, Atomic Topless Dual Sconce lighting, Atomic Dual Sconce, Atomic Dual Sconces, Atomic Dual Sconce light, Atomic Dual Sconce lights, atomic dual sconce lighting, Atomic Topless Dual Wall Sconce, Atomic Topless Dual Wall Sconces, Atomic Topless Dual wall Sconce light, Atomic Topless Dual wall Sconce lights, Atomic Topless Dual wall Sconce lighting, Atomic Dual wall Sconce, Atomic Dual wall Sconces, Atomic Dual wall Sconce light, Atomic Dual wall Sconce lights, atomic dual wall sconce lighting, Topless Dual Sconce, Topless Dual Sconces, Topless Dual Sconce light, Topless Dual Sconce lights, Topless Dual Sconce lighting, Dual Sconce, Dual Sconces, Dual Sconce light, Dual Sconce lights, dual sconce lighting, Topless Dual Wall Sconce, Topless Dual Wall Sconces, Topless Dual wall Sconce light, Topless Dual wall Sconce lights, Topless Dual wall Sconce lighting, Dual wall Sconce, Dual wall Sconces, Dual wall Sconce light, Dual wall Sconce lights, dual wall sconce lighting, Atomic Topless Sconce, Atomic Topless Sconces, Atomic Topless Sconce light, Atomic Topless Sconce lights, Atomic Topless Sconce lighting, Atomic Sconce, Atomic Sconces, Atomic Sconce light, Atomic Sconce lights, atomic sconce lighting, Atomic Topless Wall Sconce, Atomic Topless Wall Sconces, Atomic Topless wall Sconce light, Atomic Topless wall Sconce lights, Atomic Topless wall Sconce lighting, Atomic wall Sconce, Atomic wall Sconces, Atomic wall Sconce light, Atomic wall Sconce lights, atomic wall sconce lighting, Topless Sconce, Topless Sconces, Topless Sconce light, Topless Sconce lights, Topless Sconce lighting, Sconce, Sconces, Sconce light, Sconce lights, sconce lighting, Topless Wall Sconce, Topless Wall Sconces, Topless wall Sconce light, Topless wall Sconce lights, Topless wall Sconce lighting, wall Sconce, wall Sconces, wall Sconce light, wall Sconce lights, wall sconce lighting, Atomic Topless Dual wall light, Atomic Topless Dual wall lights, Atomic Topless Dual wall lighting, Atomic Dual wall light, Atomic Dual wall lights, Atomic Dual wall lighting, Dual wall light, Dual wall lights, Dual wall lighting, Dual wall light, Dual wall lights, Dual wall lighting, Atomic duel, atomic duel wall light, atomic duel wall lights, atomic duel wall lighting, atomic duel sconce, atomic duel sconces, atomic duel sconce light, atomic duel sconce lights, atomic duel sconce lighting, atomic, topless, dual, duel, Ribbed glass sconce, Ribbed glass sconces, Ribbed glass wall sconce, Ribbed glass wall sconces, cgg, cggg, ccg, Industrial streamline, Stream industrial guard sconce, industrial guard, industrial guard sconce with cage, Industrial vanity lighting, topless industrial guard sconce, 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 wall sconces, nautical cage sconce, double atomic, dual arm sconces,