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 (65050, 64987, 64744, 64852) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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 (65050,64987,64744,64852) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
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,
64852	vintage warehouse lighting, led gooseneck, led gooseneck light, custom wall light	The look of vintage warehouse lighting--now in an affordable LED gooseneck. This energy efficient, customizable wall light is rated for indoor and outdoor use!	Warehouse, warehouse shade, barn light, gooseneck light, H-15116G, The Original, Original, BLE-G-WHS-PC-LED, Original LED, LED gooseneck, LED light, commercial lighting, BLE-G-WHS12-PC-LED, BLE-G-WHS14-PC-LED, BLE-G-WHS16-PC-LED, BLE-G-WHS18-PC-LED, BLE-G-WHS20-PC-LED, original led, original led gooseneck, gooseneck original, new led, sky chief, sky chief gooseneck, sky chief gooseneck light, Sky Chief LED gooseneck light, sky chief led, led sky chief, The Original™ LED Warehouse Gooseneck Light, Original™ LED Warehouse Gooseneck Light, The Original LED Warehouse Gooseneck Light, Original LED Warehouse Gooseneck Light, Original LED Gooseneck Light, The Original LED Gooseneck, Original LED Gooseneck, LED warehouse, LED warehouse shade, LED warehouse shades, original gooseneck, original goosenecks, original gooseneck, original gooseneck led, original led, BLE-G-WHS16, BLE-G-WHS18, BLE-G-WHS20, BLE-G-WHS24, BLE-G-WHS28, BLE-G-WHS12, BLE-G-WHS14, original led warehouse, original led ware house, original led warehouse shade, original led ware house shade, original led warehouse shades, original led ware house shades, 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, Original led warehouse light, 24" shade, 28" shade, H-15112, H-15114, H-15116, H-15118, H-15120, classic warehouse shade gooseneck rlm, classic warehouse shade,
64987		Versatile, efficient, and stylish: This LED Gooseneck light partners cutting-edge components and timeless designs. Customize its look for your space!	The Skylark LED Gooseneck Light, BLE-G-SBS-LED, The Skylark LED Gooseneck Lights, The Skylark LED Gooseneck Lighting, Skylark LED Gooseneck Light, Skylark LED Gooseneck Lights, Skylark LED Gooseneck Lighting, Skylark LED Gooseneck Light, Skylark LED Gooseneck Lights, Skylark LED Gooseneck Lighting, LED Gooseneck, LED goosenecks, LED gooseneck light, LED gooseneck lights, LED gooseneck lighting, BLE-G-SBS10, BLE-G-SBS12, BLE-G-SBS14, BLE-G-SBS16, Sinclaire, SPS-0463, SPS 0463, SPS0463, Sinclair LED series, Sinclair LED Collection, The Sinclair LED series, the Sinclair LED Collection, Sinclair Integrated LED series, Sinclair Integrated LED Collection, The Sinclair Integrated LED series, The Sinclair Integrated LED Collection, 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,
65050		Old-world craftsmanship and modern LED components meet in the Dominion! With its handcrafted design and innovative technology, the Dominion is a smart addition to any decor!	The District Nautical LED Gooseneck Light, District Nautical LED Gooseneck Light, The District Nautical Gooseneck Light, District Nautical Gooseneck Light, District gooseneck light, the District gooseneck light, District, the District, nautical led light, nautical led lighting, nautical led lights, nautical light, nautical lights, nautical lighting, BLE-G-SBD-PC-CGG-LED, The District Rustic LED Gooseneck Light, District Rustic LED Gooseneck Light, The District LED Gooseneck Light, District LED Gooseneck Light, The District Rustic Gooseneck Light, District Rustic Gooseneck Light, District gooseneck light, the District gooseneck light, District, the District, rustic led light, rustic led lighting, rustic led lights, rustic light, rustic lights, rustic lighting, led light, led lights, led lighting, led gooseneck light, led, led gooseneck, led goose neck, led gooseneck lights, led gooseneck lighting, gooseneck led light, gooseneck led lights, led gooseneck lighting, gooseneck light, gooseneck lights, gooseneck lighting, led light, led lights, led lighting, Goodrich® Dominion Rustic LED Gooseneck Light, Goodrich Dominion Rustic LED Gooseneck Light, Dominion Rustic LED Gooseneck Light, Goodrich Rustic LED Gooseneck Light, Goodrich, good rich, dominion, Goodrich dominion, rustic led gooseneck light, rustic led gooseneck lights, rustic led gooseneck lighting, led gooseneck light, led gooseneck lights, led gooseneck lighting, gooseneck led light, gooseneck led lights, gooseneck led lighting, rustic light, rustic lights, rustic lighting, dominion gooseneck, dominion gooseneck light, dominion gooseneck lights, dominion gooseneck lighting, led, rustic lighting, rustic light, rustic lights, rustic led lighting, rustic led light, rustic led lights, rustic lights, rustic lighting, wall light, wall lights, wall lighting, led wall light, led wall lights, led wall lighting, rustic gooseneck, rustic goosenecks, rustic gooseneck light, rustic gooseneck lights, rustic gooseneck lighting, gooseneck rustic light, gooseneck rustic lights, gooseneck rustic lighting, BLE-G-SBD-CGG-LED, nautical led, cgg led, cast guard led, nautical, dominion, goodrich dominion, dominion gooseneck, dominion led, dominion nautical, nautical dominion, dominion cgg, dominion gooseneck led, led dominion gooseneck, Goodrich® Dominion Nautical LED Gooseneck Light, Goodrich Dominion Nautical LED Gooseneck Light, Dominion Nautical LED Gooseneck Light, Goodrich Nautical LED Gooseneck Light, Goodrich, good rich, dominion, Goodrich dominion, nautical led gooseneck light, nautical led gooseneck lights, nautical led gooseneck lighting, nautical light, nautical lights, nautical lighting, dominion gooseneck, dominion gooseneck light, dominion gooseneck lights, dominion gooseneck lighting, led, nautical lighting, nautical light, nautical lights, nautical led lighting, nautical led light, nautical led lights, nautical lights, nautical lighting, wall light, wall lights, wall lighting, led wall light, led wall lights, led wall lighting, nautical gooseneck, nautical goosenecks, nautical gooseneck light, nautical gooseneck lights, nautical gooseneck lighting, gooseneck nautical light, gooseneck nautical lights, gooseneck nautical lighting, BLE-G-SBD12, BLE-G-SBD14, BLE-G-SBD16, SPS-0489, SPS 0489, SPS0489, dominion integrated LED series, dominion integrated LED collection, the dominion integrated LED series, the dominion integrated LED collection, dominion LED series, dominion LED collection, the dominion LED series, the dominion LED collection, Dominion Nautical LED Series, Dominion Nautical LED Collection, The Dominion Nautical LED Series, The Dominion Nautical LED Collection, SPS-0527, SPS 0527, SPS0527, 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, bleg, dominion gooseneck nautical, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse gooseneck,