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 (65104, 64866, 64867, 64868) 
  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 (65104,64866,64867,64868) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
64866	Contemporary yet timeless, this uplight pendant incorporates a wooden top into its design. Handcrafted by talented artisans in the USA and fully customizable!	Wilcox Uplight Wooden Top Pendant, Wilcox Uplight Wooden Top Pendant light, Wilcox Wooden Top Pendant, Wilcox Wooden Top Pendant light, Wilcox Uplight Wooden Pendant, Wilcox Uplight Wooden Pendant light, Wilcox Wooden Pendant, Wilcox Wooden Pendant Light, Wilcox Up light Wooden Top Pendant, Wilcox Up light Wooden Top Pendant light, Wilcox Up light Wooden Pendant, Wilcox Up light Wooden Pendant light, Wooden Uplight pendant, Wooden Up Light Pendant, Wooden Uplight Pendant Light, Wooden Up Light Pendant light, Wilcox wooden pendant, wilcox wooden pendant light, wooden top pendant, wooden top pendant light, wooden pendant, wooden pendant light, Wilcox, Wilcox Uplight, Wilcox wooden uplight, Wilcox Up Light, Wilcox wooden up light, wood, Wilcox Uplight Wood Top Pendant, Wilcox Uplight Wood Top Pendant light, Wilcox Wood Top Pendant, Wilcox Wood Top Pendant light, Wilcox Uplight Wood Pendant, Wilcox Uplight Wood Pendant light, Wilcox Wood Pendant, Wilcox Wood Pendant Light, Wilcox Up light Wood Top Pendant, Wilcox Up light Wood Top Pendant light, Wilcox Up light Wood Pendant, Wilcox Up light Wood Pendant light, Wood Uplight pendant, Wood Up Light Pendant, Wood Uplight Pendant Light, Wood Up Light Pendant light, Wilcox wood pendant, wilcox wood pendant light, wood top pendant, wood top pendant light, wood pendant, wood pendant light, Wilcox, Wilcox Uplight, Wilcox wood uplight, Wilcox Up Light, Wilcox wood up light, wooden, BLE-C-WULW, timber, ore, timber and ore, timber & ore, wilcox cord hung pendant, wilcox cord hung pendant light, wilcox cord hung, wilcox cord, BLE-C-WULW20, BLE-C-WULW18, BLE-C-WULW20, Light with wooden top, light with wood top, light with wooden fixture, light with wood fixture, light with wood top, light with wooden top, light with wood, light with wood socket, light with wooden socket, light with wooden sockets, light with wood sockets, wood socket, wooden sockets, wood socket light, wooden socket lights, Pendant with wooden top, pendant with wood top, Pendant with wooden fixture, pendant with wood fixture, pendant with wood top, pendant with wooden top, pendant with wood, pendant with wood socket, pendant with wooden socket, pendant with wooden sockets, pendant with wood sockets, Pendants with wooden top, pendants with wood top, Pendants with wooden fixture, pendants with wood fixture, pendants with wood top, pendants with wooden top, pendants with wood, pendants with wood socket, pendants with wooden socket, pendants with wooden sockets, pendants with wood sockets, BLE-C-WULW14, BLE-C-WULW16, BLE-C-WULW18, BLE-C-WULW20, Wilcox uplight series, wilcox uplight collection, wilcox up light series, wilcox up light collection, wilcox up-light series, wilcox up-light collection, The Wilcox uplight series, the wilcox uplight collection, the wilcox up light series, the wilcox up light collection, the wilcox up-light series, the wilcox up-light collection, SPS-0501, SPS 0501, SPS0501, wooden wesco, wood wesco, wooden wilcox, wood wilcox, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, timber ore wilcox, wooden top barn light, wood lights, wood and metal lights, wilcox uplight wooden top pendent, timber ore,
64867	Iconic lighting designs with wooden tops, this handcrafted pendant contributes character and illumination to any décor! Customize a unique look for your space!	BLE-C-WYDM, Marathon Uplight Wooden Top Pendant, Marathon Uplight Wooden Top Pendant light, Marathon Wooden Top Pendant, Marathon Wooden Top Pendant light, Marathon Uplight Wooden Pendant, Marathon Uplight Wooden Pendant light, Marathon Wooden Pendant, Marathon Wooden Pendant Light, Marathon Up light Wooden Top Pendant, Marathon Up light Wooden Top Pendant light, Marathon Up light Wooden Pendant, Marathon Up light Wooden Pendant light, Wooden Uplight pendant, Wooden Up Light Pendant, Wooden Uplight Pendant Light, Wooden Up Light Pendant light, Marathon wooden pendant, marathon wooden pendant light, wooden top pendant, wooden top pendant light, wooden pendant, wooden pendant light, Marathon, Marathon Uplight, Marathon wooden uplight, Marathon Up Light, Marathon wooden up light, wood, Marathon Uplight Wood Top Pendant, Marathon Uplight Wood Top Pendant light, Marathon Wood Top Pendant, Marathon Wood Top Pendant light, Marathon Uplight Wood Pendant, Marathon Uplight Wood Pendant light, Marathon Wood Pendant, Marathon Wood Pendant Light, Marathon Up light Wood Top Pendant, Marathon Up light Wood Top Pendant light, Marathon Up light Wood Pendant, Marathon Up light Wood Pendant light, Wood Uplight pendant, Wood Up Light Pendant, Wood Uplight Pendant Light, Wood Up Light Pendant light, Marathon wood pendant, marathon wood pendant light, wood top pendant, wood top pendant light, wood pendant, wood pendant light, Marathon, Marathon Uplight, Marathon wood uplight, Marathon Up Light, Marathon wood up light, wooden, timber, ore, timber and ore, timber & ore, Light with wooden top, light with wood top, light with wooden fixture, light with wood fixture, light with wood top, light with wooden top, light with wood, light with wood socket, light with wooden socket, light with wooden sockets, light with wood sockets, wood socket, wooden sockets, wood socket light, wooden socket lights, Pendant with wooden top, pendant with wood top, Pendant with wooden fixture, pendant with wood fixture, pendant with wood top, pendant with wooden top, pendant with wood, pendant with wood socket, pendant with wooden socket, pendant with wooden sockets, pendant with wood sockets, Pendants with wooden top, pendants with wood top, Pendants with wooden fixture, pendants with wood fixture, pendants with wood top, pendants with wooden top, pendants with wood, pendants with wood socket, pendants with wooden socket, pendants with wooden sockets, pendants with wood sockets, BLE-C-WYDM12, BLE-C-WYDM14, BLE-C-WYDM16, marathon series, marathon collection, the marathon series, the marathon collection, marathon led series, marathon led collection, the marathon led series, the marathon led collection, SPS-0477, SPS0477, SPS 0477, white pendant, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, wooden top barn light, wood lights, wood and metal lights, timber ore, jadeite, jadite, jadeite light, jadite light,
64868	A classic design, this pendant light’s shade is handcrafted from a single block of wood! Made entirely in the United States!	Ventura Wooden Shade Pendant, Ventura Wooden Shade Pendant light, Ventura Wooden Pendant, Ventura Wooden Pendant light, Ventura Pendant, Ventura Pendant light, Ventura, Wooden Shade Pendant, Wooden Shade Pendant Light, Wooden Pendant Light, Wooden Pendant, Wooden pendants, wood, Ventura Wood Shade Pendant, Ventura Wood Shade Pendant light, Ventura Wood Pendant, Ventura Wood Pendant light, Ventura Pendant, Ventura Pendant light, Ventura, Wood Shade Pendant, Wood Shade Pendant Light, Wood Pendant Light, Wood Pendant, Wood pendants, BLE-C-WVNT, timber, ore, timber and ore, timber & ore, Light with wooden top, light with wood top, light with wooden fixture, light with wood fixture, light with wood top, light with wooden top, light with wood, light with wood socket, light with wooden socket, light with wooden sockets, light with wood sockets, wood socket, wooden sockets, wood socket light, wooden socket lights, Statement light, statement lights, statement lighting, statement light fixture, statement light fixtures, statement lighting fixture, statement lighting fixtures, State ment light, state ment lights, state ment lighting, state ment light fixture, state ment light fixtures, state ment lighting fixture, state ment lighting fixtures, Statement pendant, statement pendants, statement ceiling pendant, statement ceiling pendants, statement pendant light, statement pendant lights, statement pendant lighting, statement ceiling light, statement ceiling lights, statement ceiling lighting, Decorative light, decorative lights, decorative lighting, decorative light fixture, decorative light fixtures, decorative lighting fixture, decorative lighting fixtures, Decorative pendant, decorative pendants, decorative ceiling pendant, decorative ceiling pendants, decorative pendant light, decorative pendant lights, decorative pendant lighting, decorative ceiling light, decorative ceiling lighting, decorative shade, decorative shades, decorative wood shade, decorative wood shades, decorative wood shade, decorative wooden shade, decorative wood shades, decorative wooden shades, Wood accent light, wood accent lights, wood accent lighting, wood accent light fixture, wood accent light fixtures, wood accent lighting fixture, wood accent lighting fixtures, wood accent, wood accents, Wooden accent light, wooden accent lights, wooden accent lighting, wooden accent light fixture, wooden accent light fixtures, wooden accent lighting fixture, wooden accent lighting fixtures, wooden accent, wooden accents, Wood accent pendant, wood accent pendants, wood accent ceiling pendant, wood accent ceiling pendants, wood accent pendant light, wood accent pendant lights, wood accent pendant lighting, wood accent ceiling light, wood accent ceiling lights, wood accent ceiling lighting, timber & ore collection, the timber & ore collection, timber & ore collection, the timber & ore collection, timber and ore collection, the timber and ore collection, timber and ore collection, the timber and ore collection, timber & ore series, the timber & ore series, timber & ore series, the timber & ore series, timber and ore series, the timber and ore series, timber and ore series, the timber and ore series, Ventura Collection, Ventura Series, SPS-0499, SPS 0499, SPS0499, wood ventura, wooden ventura, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wood hanging light, wood hanging lights, wood hanging lighting, wooden hanging light, wooden hanging lights, wooden hanging lighting, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, wood lights, 23NDP1023, wood and metal lights, timber ore,
65104	A handcrafted metal shade and lathe-turned wooden top unite in the Brunson’s truly unique design. Transform every space with this eye-catching pendant light.	BLE-C-BRN, Brunson, the brunson, Bruson Cord, Brunson Cord Pendant, Cord Brunson, Bruson Cord Light, brunson wood, wood pendant, wooden pendant, wood cord pendant, wooden cord pendant, Brunson pendant, wood cord pendant, wooden cord pendant, wood cord light, wooden cord light, timber and ore, timber & ore, timber and ore collection, timber & ore collection, wood lighting, wooden lighting, wood light, wooden light, wood cord lighting, wooden cord lighting, Brunson Wooden Top Pendant, Brunson Wooden Top Pendant Light, Brunson Wood Top Pendant, Bruson Wood top, Bruson wooden top, branson, brunsen, Statement light, statement lights, statement lighting, statement light fixture, statement light fixtures, statement lighting fixture, statement lighting fixtures, State ment light, state ment lights, state ment lighting, state ment light fixture, state ment light fixtures, state ment lighting fixture, state ment lighting fixtures, Statement pendant, statement pendants, statement ceiling pendant, statement ceiling pendants, statement pendant light, statement pendant lights, statement pendant lighting, statement ceiling light, statement ceiling lights, statement ceiling lighting, Decorative light, decorative lights, decorative lighting, decorative light fixture, decorative light fixtures, decorative lighting fixture, decorative lighting fixtures, Decorative pendant, decorative pendants, decorative ceiling pendant, decorative ceiling pendants, decorative pendant light, decorative pendant lights, decorative pendant lighting, decorative ceiling light, decorative ceiling lighting, decorative shade, decorative shades, decorative wood shade, decorative wood shades, decorative wood shade, decorative wooden shade, decorative wood shades, decorative wooden shades, Wood accent light, wood accent lights, wood accent lighting, wood accent light fixture, wood accent light fixtures, wood accent lighting fixture, wood accent lighting fixtures, wood accent, wood accents, Wooden accent light, wooden accent lights, wooden accent lighting, wooden accent light fixture, wooden accent light fixtures, wooden accent lighting fixture, wooden accent lighting fixtures, wooden accent, wooden accents, Wood accent pendant, wood accent pendants, wood accent ceiling pendant, wood accent ceiling pendants, wood accent pendant light, wood accent pendant lights, wood accent pendant lighting, wood accent ceiling light, wood accent ceiling lights, wood accent ceiling lighting, timber & ore collection, the timber & ore collection, timber & ore collection, the timber & ore collection, timber and ore collection, the timber and ore collection, timber and ore collection, the timber and ore collection, timber & ore series, the timber & ore series, timber & ore series, the timber & ore series, timber and ore series, the timber and ore series, timber and ore series, the timber and ore series, Brunson Collection, Brunson Series, SPS-0553, SPS 0553, SPS0553, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, wooden top rlm, wood and metal, wooden top barn light, wood lights, wood and metal lights, 23NDP1023, timber ore,