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 (64744, 64723, 61490, 64756) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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 (64744,64723,61490,64756) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61490	wavy shade wall lighting, wavy reflector shade barn lighting, exterior fluted shade light, decorative gooseneck lighting, decorative vintage wall light, embellished gooseneck lighting, fancy barn light,	Add a decorative touch with a vintage-inspired Fluted Shade wall light. Its wavy shade paired with a rustic gooseneck is all you need for a modern barn style.	The Fluted Shade Gooseneck Light, BLE-G-FLT-PC, wavy shade, decorative gooseneck, fluted shade, wave shade, fluted, BLE-G-FLT10-PC, BLE-G-FLT12-PC, flluted gooseneck, fluted gooseneck, Fluted Shade Gooseneck Light, Fluted Shade Gooseneck, fluted gooseneck light, fluted shade, BLE-G-FLT10, BLE-G-FLT12, FLK, Goose neck with fluted shade, Gooseneck with fluted shade, Goose neck with fluted shades, Gooseneck with fluted shades, Fluted Collection, Fluted Series, SPS-0197, SPS 0197, SPS0197, 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 gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, fluted light, fluted lights,
64723	gas station lighting, retro style sconce, vintage wall sconce, waved shade wall light, festive wall lighting, plug-in sconce, plug-in industrial lighting, Plug-in warehouse li	Inspired by vintage gas station fixtures, the Seaside Radial Wave Sconce showcases a unique flared cone shade on a hand-crafted wall mount.	Wheeler Seaside, Wheeler Radial Wave reflector, Wheeler Radial wave, seaside sconce, radial wave reflector sconce, radial wave sconce, BLE-W-RWS, BLE-W-RWS12, BLE-W-RWS14, Wheeler™ Seaside Radial Wave Reflector Wall Sconce, Wheeler Seaside Radial Wave Reflector Wall Sconce, industrial wall lights, industrial sconce, plug-in lighting, plug-in wall light, plug in, plug in lighting, plug in wall sconce, plug in sconce, plug in sconce lighting, radial sconce, wheeler seaside, wheeler radial wave, seaside sconce, radial sconce, new listing, new rlm, new seaside, The Starfire Radial Wave Reflector Wall Sconce, BLE-W-RWSPC, radial wave sconce, starfire sconce, reflector sconce, radial wave, radial wave wall light, starfire wall light, reflector wall light, BLE-W-RWS12-PC, BLE-W-RWS14-PC, BLE-W-RWS16-PC, radial wave sconce, radial wave reflector wall sconce, radial wave wall light, Starfire wall light, Starfire wall sconce, exterior wall lighting, exterior wall light, exterior sconce, exterior lighting, outdoor wall lighting, outdoor wall light, outdoor sconce, outdoor lighting, Starfire outdoor light, Starfire outdoor, Starfire lighting, plug-in sconce light, plug in sconce light, plug-in wall sconce, plug in wall sconce, plug-in lighting, plug in lighting, plug-in, plug in, apartment lights, apartment lighting, starfire, star fire, star fire sconce, starfire sconce, radial wave wall sconce, radial wave sconce, radial wave, BLE-W-RWS12-N, BLE-W-RWS12, BLE-W-RWS14-N, BLE-W-RWS14, BLE-W-RWS16-N, BLE-W-RWS16, sconce outdoor wet rated, sconce outdoor wet-rated, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, Wall sconce outdoor, Outdoor wall sconces, Wall sconce outdoor, outdoor Wall sconce, outdoor Wall sconces, Wall sconces outdoor, sconce outdoor, outdoor sconce, outdoor sconces, sconces outdoor, 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, Seaside nautical barn light, Seaside nautical barn lights, Seaside nautical barn lighting, Sea side nautical barn light, Sea side nautical barn lights, Sea side nautical barn 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, 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, radial wave light sconce, plug in barn light, plug-in barn light, plug-in light, seaside wall sconces, jadeite, jadite, jadeite light, jadite light, H-19112, H-19114, H-19116, classic radial shade,
64744	gooseneck lights for signs, gooseneck warehouse light, gooseneck down lighting, shallow bowl gooseneck fixture, exterior gooseneck lighting, residential exterior lighting, outside lighting, american made outdoor lighting, home exterior barn lighting	The Dominion's shallow bowl reflector mounted to our iconic gooseneck arm makes the perfect down light your home exteriors, garages, and barn lighting!	BLE-G-SBD12, dominion, shallow bowl gooseneck light, BLE-G-SBD12, BLE-G-SBD14, BLE-G-SBD16, BLE-G-SBD, dominion gooseneck, shallow gooseneck, new dominion, new rlm, new listing, District Gooseneck Light, BLE-G-SBD12, district, gooseneck light, shallow bowl gooseneck light, BLE-G-SBD12-PC, BLE-G-SBD14-PC, BLE-G-SBD16-PC, interior gooseneck, interior gooseneck lighting, exterior lighting, exterior gooseneck lighting, exterior wall light, exterior wall lighting, The District Gooseneck Light, district gooseneck, district gooseneck lighting, district wall light, district exterior wall light, distinct wall mount, exterior wall mount, outdoor wall mount, interior wall mount, gooseneck lighting, outdoor gooseneck lighting, exterior gooseneck, shallow bowl gooseneck, shallow bowl shade, shallow bowl gooseneck lighting, dominion gooseneck light, district gooseneck light, SPS-0152, SPS0152, SPS0152, Dominion Series, Dominion Collection, The Dominion Series, The Dominion Collection, outdoor gooseneck barn lights, outdoor gooseneck barn light, outdoor gooseneck barn lighting, Warehouse Gooseneck Lights, Warehouse Gooseneck Light, Warehouse Gooseneck Lighting, Ware house Gooseneck Lights, Ware house Gooseneck Light, Ware house Gooseneck Lighting, Warehouse Goose neck Lights, Warehouse Goose neck Light, Warehouse Goose neck Lighting, Ware house Goose neck Lights, Ware house Goose neck Light, Ware house Goose neck Lighting, Warehouse Gooseneck, Warehouse Goosenecks, Ware house Gooseneck, Ware house Goosenecks, Ware house Goose neck, Ware house Goose necks, Gooseneck Warehouse Lights, Gooseneck Warehouse Light, Gooseneck Warehouse Lighting, Gooseneck Ware house Lights, Gooseneck Ware house Light, Gooseneck Ware house Lighting, Goose neck Warehouse Lights, Goose neck Warehouse Light, Goose neck Warehouse Lighting, Goose neck Ware house Lights, Goose neck Ware house Light, Goose neck Ware house Lighting, Gooseneck Warehouse, Gooseneck Ware house, Goose neck Warehouse, Goose neck Ware house, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, bleg, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse gooseneck,
64756			conoco, goodrich conoco, conoco gooseneck, flat cone, shallow cone, goodrich, gooseneck, BLE-G-FCC10, BLE-G-FCC12, BLE-G-FCC15, shallow gooseneck, shallow goodrich conoco, new listing, new conoco, new rlm,, conoco gooseneck, conoco gooseneck light, Conoco Goosenecks, Conoco light, shallow bowl gooseneck, shallow gooseneck light, conoco, conoco shade, BLE-G-FCC10, BLE-G-FCC12, BLE-G-FCC15, SPS-0151, SPS 0151, SPS0151, Conoco series, Conoco collection, the Conoco series, the Conoco collection, bleg, jadeite, jadite, jadeite light, jadite light, bowl shallow,