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 (64734, 61698, 61081, 61699) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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 (64734,61698,61081,61699) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61081 american designer wall sconce, industrial wall sconce, steampunk wall sconce, flared cone wall light, industrial chic pendant light, upcycled wall sconce This eye-catching wall sconce combines industrial pipe mounting with an RLM inspired shade. Our Canal Sconce brings the spirit of SoHo to your rustic room! The Canal Street Soho Sconce, canal light, canal sconce, canal, BLE-W-SOH-CAN-PC, soho light, soho sconce, industrial sconce, durable light, cone light, chunky light, modern industrial, modern, industrial space, outdoor lighting, wall lighting, soho lighting, soho wall light, soho wall sconce, exterior lighting, exterior wall lighting, canal street wall lighting, canal street lighting, industrial sconce, industrial sconce lighting, industrial sconce light, outdoor sconce, outdoor sconce light, industrial outdoor light, industrial outdoor lighting, industrial lighting, canal street sconce, canal soho sconce, canal, canal soho, soho sconce, canal wall sconce, soho, soho wall sconce, SPS-0417, SPS 0417, SPS0417, soho collection, soho series, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor 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, canal soho wall sconce, soho canal sconce,
61698 minimalist lighting for home exteriors, bell jar wall light, minimalist contemporary light, durable outdoor light, industrial garage lighting, modern walkway light, gooseneck down light, dark sky home lighting, factory style lighting, wall light, outdoor The Tuscany's subtly curved shade channels minimalist style into your home or commercial spaces! Add durability with our traditional gooseneck mount! Tuscany Gooseneck Light, BLE-G-CAF, tuscany, modern wall light, modern gooseneck light, SPS-0369, SPS 0369, SPS0369, The Tuscany Collection, The Tuscany Series, Tuscany Collection Tuscany Series, 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,
61699 bell shade gooseneck light, hand crafted gooseneck light, modern exterior lighting, modern garage lighting, contemporary outdoor wall lighting fixtures, outdoor wall light fixture, modern lantern style lighting, architectural wall light, GU 24 decorative Add decorative down lighting with our Chateau Gooseneck Light! Its decoratively spun cone shape and durable wall arm makes it great for modern facades! Chateau Gooseneck Light, BLE-G-BIS, modern gooseneck, modern wall light, chateau, chateau gooseneck, chateau wall light, chateau light, Chateau Collection, Chateau Series, The Chateau Collection, The Chateau Series, SPS-0371, SPS 0371, SPS0371, CHEATEAU, 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,
64734 goodrich gooseneck light, aero wall light, nautical gooseneck light, shallow bowl down light, GU24 compliant exterior fixture Classic yet modern gooseneck lighting! Entirely handcrafted in the United States and fully customizable with various finishes! goodrich Aero, aero gooseneck, new listing, new aero, new rlm, Astro, Astro Shallow Bowl Gooseneck, Astro Gooseneck, Shallow bowl, gooseneck, BLE-G-SBA12-PC, BLE-G-SBA14-PC, BLE-G-SBA16-PC, astro gooseneck, astro gooseneck light, BLE-G-SBA16-P/G64, Avara, The Avara, The Avara Gooseneck, Avara Gooseneck, Avara Goosenecks, The Avara Goosenecks, Avara Gooseneck Light, Avara Gooseneck Lights, Avara Gooseneck Lighting, Avara Gooseneck Wall Light, Avara Gooseneck Wall Lights, Avara Gooseneck Wall Lighting, The Avara Gooseneck Wall Light, The Avara Gooseneck Wall Lighting, Avara Light, Avara Lights, Avara Lighting, The Avara Light, The Avara Lights, The Avara Lighting, Avara Wall Light, Avara Wall Lights, Avara Wall Lighting, The Avara Wall Light, The Avara Wall Lights, The Avara Wall Lighting, The Avara Gooseneck Light, The Avara Gooseneck Lights, The Avara Gooseneck Lighting, Goodrich® Avara Gooseneck Light, Goodrich® Avara Gooseneck Lights, Goodrich® Avara Gooseneck Lighting, Goodrich® Avara Gooseneck Wall Light, Goodrich® Avara Gooseneck Wall Lights, Goodrich® Avara Gooseneck Wall Lighting, Goodrich Avara Gooseneck Light, Goodrich Avara Gooseneck Lights, Goodrich Avara Gooseneck Lighting, Goodrich Avara Gooseneck Wall Light, Goodrich Avara Gooseneck Wall Lights, Goodrich Avara Gooseneck Wall Lighting, Goodrich Gooseneck Light, Goodrich Gooseneck Lights, Goodrich Gooseneck Lighting, Goodrich Gooseneck Wall Light, Goodrich Gooseneck Wall Lights, Goodrich Gooseneck Wall Lighting, avara, g64, g65, BLE-G-SBA12, BLE-G-SBA14, BLE-G-SBA16, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, 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, bowl shallow,