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 (64706, 62056, 62062, 64694) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00053

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 (64706,62056,62062,64694) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
62056	factory gooseneck light, warehouse shade gooseneck, industrial gooseneck light, uplight barn light, exterior up lighting	For some extra uplighting for your home exteriors choose the Vented Original™ Gooseneck light. This outdoor barn light features vents for extra illumination!	vented, vented shade, vintage warehouse, Original™ Vented Warehouse Gooseneck Light, original, BLE-G-VWHS-PC, gooseneck, vinted, factory light, BLE-G-VWHS12-PC, BLE-G-VWHS14-PC, BLE-G-VWHS16-PC, warehouse lighting, warehouse gooseneck, gooseneck warehouse, original warehouse, original vented, vented gooseneck, Original, Original™, original vented, original vint, original vent, vented original, vent original, vented original, vented Original™, vent Original™, BLE-G-VWHS16, BLE-G-VWHS14, BLE-G-VWHS12, Goose neck interior, Gooseneck interior, Goose neck light interior, Gooseneck light interior, interior goose neck, interior gooseneck light, interior goose neck light, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, SPS-0020, SPS 0020, SPS0020, original vented series, original vented collection, original™ vented series, originaltm vented series, original vented collection, original™ vented collection, originaltm vented collection, the original vented series, the original vented collection, the original™ vented series, the originaltm vented series, the original vented collection, the original™ vented collection, the originaltm vented collection, orignial vented gooseneck, original vented gooseneck, originalgooseneck, 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, the original vented gooseneck light, original vented gooseneck light, slotted, slotted light, H-15612, H-15614, H15616, vented warehouse shade, vented warehouse shade gooseneck,	<div style="padding-left: 30px;"> </div>
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,
64694	deep bowl lighting, down light exterior light, dark sky lighting, galvanized barn lighting, deep bowl shades, gooseneck lighting	The stylish yet practical Wilcox Gooseneck Light brings a timeless, American made deep bowl shade to homes and businesses! Customize with a vibrant finish!	wesco, wesco gooseneck, deep bowl, gooseneck, outdoor, exterior, BLE-G-DBW-PC, BLE-G-DBW8-PC, BLE-G-DBW10-PC, BLE-G-DBW12-PC, BLE-G-DBW14-PC, BLE-G-DBW16-PC, The Wesco Gooseneck Light, Wesco gooseneck lighting, Wesco gooseneck wall light, Wesco gooseneck lighting, Wesco gooseneck outdoor light, outdoor Wesco gooseneck, outdoor gooseneck, outdoor wall light, outdoor warehouse, outdoor warehouse lighting, warehouse lighting, warehouse shade, warehouse rlm shade, rlm warehouse shade, gooseneck lighting, gooseneck wall light, new rlm, new listing, new wilcox, goodrich wilcox, BLE-G-DBW16-P/G64, Goodrich Gooseneck Light, Goodrich Gooseneck Lights, Goodrich Gooseneck Lighting, Goodrich Gooseneck Wall Light, Goodrich Gooseneck Wall Lights, Goodrich Gooseneck Wall Lighting, roscoe, g64, g65, BLE-G-DBW16, BLE-G-DBW20, BLE-G-DBW8, BLE-G-DBW10, BLE-G-DBW12, BLE-G-DBW14, BLE-G-DBW16, BLE-G-DBW20, willcox, willcox gooseneck, willcox goose neck, Wilcox series, Wilcox outdoor, Outdoor farm light, Light with photocell, outdoor light light with photocell, goodyear, wilcox gooseneck light, SPS-0158, SPS 0158, SPS0158, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, wilcox deep bowl, deep bowl wilcox, wilcox dbw, Wilcox shade, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, dark sky, dark-sky, 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, 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, wilcox bowl, jadeite, jadite, jadeite light, jadite light, gooseneck bowl, H-16008, H-16110, H-16112, H-16114, H-16116, H-16118, H-17124, classic deep bowl shade, classic deep bowl shade gooseneck,
64706	large outdoor lights, dark sky barn lighting, vintage gooseneck lighting	Attentively handcrafted, fully customizable gooseneck lighting! Bring a timeless yet modern look to indoor and outdoor décors with the USA-made Bomber Gooseneck!	Goodrich® Bomber Gooseneck Light, BLE-G-WHB, gooseneck, gooseneck, bomber gooseneck, gooseneck bomber, BLE-G-WHB11, BLE-G-WHB13, BLE-G-WHB15, BLE-G-WHB17, new listing, new rlm, new bomber, Warehouse, warehouse shade, barn light, gooseneck light, Old dixie, Gooseneck, Old dixie gooseneck, BLE-G-WHB11-PC, BLE-G-WHB13-PC, BLE-G-WHB15-PC, BLE-G-WHB17-PC, The Old Dixie Gooseneck Light, old Dixie gooseneck, old Dixie wall light, old Dixie gooseneck lighting, old Dixie warehouse shade, old Dixie warehouse lighting, old Dixie warehouse barn light, old Dixie warehouse gooseneck, Dixie warehouse, Dixie gooseneck, Dixie gooseneck barn light, Dixie wall light, Old Dixie, Goodrich Gooseneck Light, Goodrich Gooseneck Lights, Goodrich Gooseneck Lighting, Goodrich Gooseneck Wall Light, Goodrich Gooseneck Wall Lights, Gooseneck Light, gooseneck lighting, BLE-WHB17-P/G19, goodrich husky, g19, large gooseneck light, big gooseneck light, 17", BLE-G-WHB11, BLE-G-WHB13, BLE-G-WHB15, BLE-G-WHB17, goodyear, whb, whn, bomber lighting outdoor, outdoor bomber lighting, bomber light outdoor, bomber lights outdoor, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, outdoor gooseneck barn lights, outdoor gooseneck barn light, outdoor gooseneck barn lighting, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, dark sky, dark-sky, 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, 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, jadeite, jadite, jadeite light, jadite light,