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 (64738, 62167, 62273, 62062) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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 (64738,62167,62273,62062) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
62062	gooseneck barn lighting, vented barn light, uplight gooseneck light, exterior shade light, industrial barn reflector	For gooseneck lighting with subtle vents for extra up light, try the Astro Vented Gooseneck! This shallow bowl shade is perfect for retro exterior lighting!	vented, vented shade, vintage warehouse, BLE-G-VSBA-PC, Astro Shallow Bowl Vented Gooseneck Light, astro, vinted, shallow bowl, BLE-G-VSBA12-PC, BLE-G-VSBA14-PC, BLE-G-VSBA16-PC, vintage wall lighting, warehouse lighting, warehouse gooseneck light, warehouse gooseneck, industrial wall light, industrial wall lighting, industrial gooseneck light, outdoor gooseneck lighting, outdoor lighting, outdoor wall light, outdoor industrial wall light, exterior wall light, exterior industrial wall lighting, BLE-G-VSBA12, BLE-G-VSBA14, BLE-G-VSBA16, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, aero vented series, aero vented collection, SPS-0169, SPS0169, SPS 0169, 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, Vented barn light, Vented goose neck light, Vented gooseneck light, Vented goose neck lights, Vented goose neck lighting, Vented gooseneck lights, Vented gooseneck lighting, Vented goose neck, Vented goose necks, Vented gooseneck, Vented goosenecks, Barn light vented, original vented gooseneck light, bleg, slotted, slotted light, bowl shallow,
62167	warehouse shade with guard, outdoor gooseneck light, industrial gooseneck light fixtures, wall-mounted warehouse light	This vintage-industrial wall light provides both up-and-down light for home and commercial exteriors. Customize this contemporary gooseneck light's guard and flared shade.	Wallaby Gooseneck Light, BLE-G-ULA-PC, gooseneck, wallaby, wallaby wall light, wallabee, BLE-G-ULA12-PC, BLE-G-ULA14-PC, BLE-G-ULA16-PC, wallaby gooseneck, wallaby gooseneck light, wallaby gooseneck lighting, wallaby wall lighting, outdoor gooseneck, outdoor gooseneck wall lighting, exterior wall light, exterior gooseneck, exterior gooseneck lighting, exterior gooseneck wall light, exterior wall lighting, wallaby exterior gooseneck, wallaby exterior wall light, exterior wallaby gooseneck, exterior wallaby wall light, BLE-G-ULA12, BLE-G-ULA14, BLE-G-ULA16, Industrial light, industrial lights, industrial lighting, industrial lighting fixture, industrial lighting fixtures, rugged light, rugged lights, rugged lighting, rugged lighting fixture, rugged lighting fixtures, Vintage Industrial light, vintage industrial lights, vintage industrial lighting, vintage industrial lighting fixture, vintage industrial lighting fixtures, cast guard light, cast guard lights, cast guard lighting, cast guard lighting fixture, cast guard lighting fixtures, Queensland collection, queensland lighting, queensland light, queensland lights, queensland lighting, queensland light fixture, queensland light fixtures, Queens land collection, queens land lighting, queens land light, queens land lights, queens land lighting, queens land light fixture, queens land light fixtures, Queensland, industrial gooseneck, industrial goosenecks, industrial goose neck, industrial goose necks, industrial wall light, industrial wall lights, industrial wall lighting, industrial light fixture, industrial light fixtures, industrial gooseneck light, industrial goose neck light, industrial gooseneck lights, industrial goose neck lights, industrial gooseneck lighting, industrial goose neck lighting, rugged gooseneck, rugged goosenecks, rugged goose neck, rugged goose necks, rugged wall light, rugged wall lights, rugged wall lighting, rugged light fixture, rugged light fixtures, rugged gooseneck light, rugged goose neck light, rugged gooseneck lights, rugged goose neck lights, rugged gooseneck lighting, rugged goose neck lighting, cast guard gooseneck, cast guard goosenecks, cast guard goose neck, cast guard goose necks, cast guard wall light, cast guard wall lights, cast guard wall lighting, cast guard light fixture, cast guard light fixtures, cast guard gooseneck light, cast guard goose neck light, cast guard gooseneck lights, cast guard goose neck lights, cast guard gooseneck lighting, cast guard goose neck lighting, Queensland wall light, Queensland wall lights, Queensland wall lighting, Queensland Wall Fixture, Queensland wall fixtures, Queens land wall light, Queens land wall lights, Queens land wall lighting, Queens land Wall Fixture, Queens land wall fixtures, Queensland Gooseneck, Queensland goose neck, queensland goose necks, Queensland gooseneck light, Queensland gooseneck lights, Queensland gooseneck lighting, Queensland goose neck light, Queensland goose neck lights, Queensland goose neck lighting, Queens land Gooseneck, Queens land goose neck, queens land goose necks, Queens land gooseneck light, Queens land gooseneck lights, Queens land gooseneck lighting, Queens land goose neck light, Queens land goose neck lights, Queens land goose neck lighting, Wallaby Series, Wallaby Collection, The Wallaby Series, The Wallaby Collection, Australia collection, Australia Series, the Australia collection, the Australia Series, Queensland Collection, Queensland Series, The Queensland Collection, the Queensland Series, Queens land Collection, Queens land Series, The Queens land Collection, the Queens land Series, SPS-0322, SPS 0322, SPS0322, The wallaby gooseneck, the wallaby gooseneck light, The wallaby goose neck, The wallaby goose, wallaby gooseneck light, wallaby goose neck, wallaby goose, the wallby gooseneck light, The wallby goose neck, The wallby goose, wallby gooseneck light, wallby goose neck, wallby goose, 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, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount 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 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, wallaby series,
62273	ceiling lighting, industrial factory pendant, stem mounted warehouse pendant, vented pendant	Check out the industrial factory Cherokee Pendant! This stem mounted warehouse pendant features a flared shade with horizontal vents that cast ceiling lighting both up and down.	shade with jelly jar, cherokee, comanche, vented, flared shade, up light, upight, charokee uplight, charokee, Cherokee Uplight Stem Mount Pendant, cherokee stem pendant, uplight pendant, stem pendant, BLE-S-ULC-PC, stem mount cherokee, BLE-S-ULC16-PC, Cherokee Stem, Cherokee Stem Mount, new listing, cherokee uplight, cherokee pendant, BLE-S-ULC12, BLE-S-ULC14, BLE-S-ULC16, BLE-S-ULC18, SPS-0161, SPS 0161, SPS0161, cherokee uplight series, cherokee uplight collection, the cherokee uplight series, the cherokee uplight collection, cherokee up light series, cherokee up light collection, the cherokee up light series, the cherokee up light collection, cherokee up-light series, cherokee up-light collection, the cherokee up-light series, the cherokee up-light collection, cherokee series, cherokee collection, the cherokee series, the cherokee collection, stems, Stem pendant lights, stem light mount, stem light mounts, stem, 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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, cherokee stem hung pendant, cherokee stem mount light, cherokee pendants, slotted, slotted light,
64738	shallow bowl porch light, decorative wall sconce, outdoor wall lighting, american made exterior light, made in america sconce, flared shade wall light, shallow bowl wall sconce, sleek flared barn shade, plug-in sconce, apartment lighting	This shallow bowl wall sconce is the ideal down light for contemporary home exteriors! Customize the size, finish, and accessories of for a unique wall sconce.	Astro, Astro Shallow Bowl wall sconce, Astro sconce, Shallow bowl, sconce, powder coat, BLE-W-SBA-PC, shallow bowl porch light, decorative wall sconce, outdoor wall lighting, american made exterior light, made in america sconce, flared shade wall light, shallow bowl wall sconce, sleek flared barn shade, BLE-W-SBA12-PC, BLE-W-SBA14-PC, BLE-W-SBA16-PC, wall lighting, wall lights, plug-in wall lights, plug in wall lights, plug-in lighting, plug in lighting, plug-in sconces, plug in sconces, plug-in wall sconces, new rlm, new aero, new listing, Wheeler Aero Wall Scocne, Aero Wall sconce, Wheeler Aero, Shallow bowl sconce, BLE-W-SBA, BLE-W-SBA12, BLE-W-SBA14, BLE-W-SBA16, Wheeler Aero Wall Sconce, industrial wall light, industrial shade light, warehouse lighting, plug in lighting, plug-in lighting, plug in wall light, plug-in, plug in, barn lighting, barn lights, warehouse shade, warehouse sconce, warehouse wall sconce, aero sconce, wheeler aero, aero, Astro wall sconce, BLE-W-SBA12-N, BLE-W-SBA12, BLE-W-SBA14-N, BLE-W-SBA14, sconce outdoor wet rated, sconce outdoor wet-rated, Light with photocell, outdoor light light with photocell, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, Wall sconce outdoor, Outdoor wall sconces, 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 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, 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, 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, plug in barn light, plug-in barn light, plug-in light, jadeite, jadite, jadeite light, jadite light, bowl shallow,