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 (62165, 62433, 62582, 62431) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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 (62165,62433,62582,62431) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
62165	industrial stem mount pendant, up light shade with stem mount, industrial ceiling lighting, flared shade with guard and glass, vintage-inspired lighting	Give your space industrial detail with an up light that is packed with history. The Wallaby's vintage-inspired cage and flared shade is mounted to a rustic stem mount.	Wallaby Stem Mount Pendant, BLE-S-ULA-PC, wallaby, wallaby stem, stem pendant, industrial stem, wallaby, BLE-S-ULA12-PC, BLE-S-ULA14-PC, BLE-S-ULA16-PC, BLE-S-ULA12, BLE-S-ULA14, BLE-S-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 stem hung pendant, industrial stem hung pendants, industrial stem hung pendant light, Industrial stem hung pendant lights, Industrial stem hung pendant lighting, Industrial stem hung ceiling pendant, Industrial stem hung ceiling pendants, Industrial stem hung pendant light, Industrial stem hung pendant lights, Industrial stem hung pendant lighting, Industrial stem hung ceiling light, Industrial stem hung ceiling lights, Industrial stem hung ceiling lighting, Industrial stem pendant, industrial stem pendants, industrial stem pendant light, Industrial stem pendant lights, Industrial stem pendant lighting, Industrial stem ceiling pendant, Industrial stem ceiling pendants, Industrial stem pendant light, Industrial stem pendant lights, Industrial stem pendant lighting, Industrial stem ceiling light, Industrial stem ceiling lights, Industrial stem ceiling lighting, rugged stem hung pendant, rugged stem hung pendants, rugged stem hung pendant light, rugged stem hung pendant lights, rugged stem hung pendant lighting, rugged stem hung ceiling pendant, rugged stem hung ceiling pendants, rugged stem hung pendant light, rugged stem hung pendant lights, rugged stem hung pendant lighting, rugged stem hung ceiling light, rugged stem hung ceiling lights, rugged stem hung ceiling lighting, rugged stem pendant, rugged stem pendants, rugged stem pendant light, rugged stem pendant lights, rugged stem pendant lighting, rugged stem ceiling pendant, rugged stem ceiling pendants, rugged stem pendant light, rugged stem pendant lights, rugged stem pendant lighting, rugged stem ceiling light, rugged stem ceiling lights, rugged stem ceiling lighting, cast guard stem hung pendant, cast guard stem hung pendants, cast guard stem hung pendant light, cast guard stem hung pendant lights, cast guard stem hung pendant lighting, cast guard stem hung ceiling pendant, cast guard stem hung ceiling pendants, cast guard stem hung pendant light, cast guard stem hung pendant lights, cast guard stem hung pendant lighting, cast guard stem hung ceiling light, cast guard stem hung ceiling lights, cast guard stem hung ceiling lighting, cast guard stem pendant, cast guard stem pendants, cast guard stem pendant light, cast guard stem pendant lights, cast guard stem pendant lighting, cast guard stem ceiling pendant, cast guard stem ceiling pendants, cast guard stem pendant light, cast guard stem pendant lights, cast guard stem pendant lighting, cast guard stem ceiling light, cast guard stem ceiling lights, cast guard stem ceiling lighting, Queensland Stem, Queensland Stem Mount, Queensland Stem Mounts, Queensland Stem Mount Light, Queensland Stem Mount Lights, Queensland Stem Mount Lighting, Queensland Stem Mount Pendant, Queensland Stem Mount Pendants, Queensland Stem Mount Pendant Light, Queensland Stem Mount pendant Lights, Queensland Stem Mount Pendant Lighting, Queensland Stem Mount Ceiling Pendant, Queensland Stem Mount Ceiling Pendants, Queensland Stem Mount Ceiling Light, Queensland Stem Mount Ceiling Lights, Queensland Stem Mount Ceiling Lighting, Queens land Stem, Queens land Stem Mount, Queens land Stem Mounts, Queens land Stem Mount Light, Queens land Stem Mount Lights, Queens land Stem Mount Lighting, Queens land Stem Mount Pendant, Queens land Stem Mount Pendants, Queens land Stem Mount Pendant Light, Queens land Stem Mount pendant Lights, Queens land Stem Mount Pendant Lighting, Queens land Stem Mount Ceiling Pendant, Queens land Stem Mount Ceiling Pendants, Queens land Stem Mount Ceiling Light, Queens land Stem Mount Ceiling Lights, Queens land Stem Mount Ceiling Lighting, industrial pendant, industrial pendants, industrial ceiling pendant, industrial ceiling pendants, industrial ceiling light, industrial ceiling lights, industrial ceiling lighting, rugged pendant, rugged pendants, rugged ceiling pendant, rugged ceiling pendants, rugged ceiling light, rugged ceiling lights, rugged ceiling lighting, cast guard pendant, cast guard pendants, cast guard ceiling pendant, cast guard ceiling pendants, cast guard ceiling light, cast guard ceiling lights, cast guard ceiling lighting, Queensland pendant, Queensland pendants, queensland pendant light, queensland pendant lights, queensland pendant lighting, queensland ceiling pendant, queensland ceiling pendants, queensland ceiling light, queensland ceiling lights, queensland ceiling lighting, Queens land pendant, Queens land pendants, queens land pendant light, queens land pendant lights, queens land pendant lighting, queens land ceiling pendant, queens land ceiling pendants, queens land ceiling light, queens land ceiling lights, queens land ceiling 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, stems, Stem pendant lights, stem light mount, stem light mounts, stem, wallby, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, 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, wallaby series,
62431	led warehouse pendant, industrial led light, led uplight	This LED warehouse pendant features a flared shade along with horizontal vents for an interesting play of uplighting. Hang this industrial LED light indoors or out!	Cherokee LED Uplight Stem Mount Pendant, BLE-S-ULC-PC-LED, cherokee led stem pendant, led stem pendant, led cherokee, led uplight, led uplight stem, rustic led barn light, rustic led, decorative led, led pendant, led, stem mount led, ceiling light, led ceiling light, stem hung pendant, stem hung pendant light, cherokee led, cherokee stem, stem cherokee, cherokee stem mount, stem mount cherokee, Cherokee uplight, cherokee up light, cherokee uplight led, cherokee led uplight, cherokee up light led, cherokee up light led, uplight led, up light led, led uplight, led up light, led uplight pendant, led up light pendant, led pendant uplight, led pendant up light, led uplight stem, led up light stem, led uplight stem mount, led up light stem mount, uplight pendant, up light 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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, 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, The Cherokee led, Cherokee led, cherokee led light, cherokee stem hung pendant, cherokee stem mount light, cherokee pendants,
62433	industrial uplight, pendant lighting, deep bowl pendant light, uplight pendant	Reflecting the utilitarian detail in industrial factory pendant lights, the Wilcox Uplight features our hand-spun deep bowl shade and heavy duty stem mount.	Wesco Uplight Stem Mount Pendant, BLE-S-ULW-PC, deep bowl pendant, uplight, industrial, up light, up-light, stem pendant, wesco, deep bowl uplight, uplight stem mount, up light stem, Wilcox Uplight, Wilcox Uplights, Wilcox Uplight Stem Mount Pendant, Wilcox Uplight Stem Mount Pendants, Wilcox Uplight Pendant, Wilcox Uplight Pendants, BLE-S-ULW16, BLE-S-ULW18, BLE-S-ULW18, BLE-S-ULW12, BLE-S-ULW14, Wilcox Up Light Stem Mount, SPS-0323, SPS 0323, SPS0323, 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, stems, Stem pendant lights, stem light mount, stem light mounts, stem, H-16312, H-16314, H-16316, uplight deep bowl shade, uplight deep bowl shade stem mount,
62582	aluminum cast guard light, classic RLM shade, warehouse shade, dining room light, kitchen island light, outback light, up and down lighting	Our versatile Outback pendant projects light two ways, both downward and up! It features a classic RLM shade and aluminum cast guard affixed to a durable stem.	BLE-S-ULO-PC, BLE-S-ULO12-PC, BLE-S-ULO14-PC, BLE-S-ULO16-PC, the outback stem mount pendant, outback stem mount light, outback, outback up and down light, up and down light, two way light, The Outback Stem Mount Pendant, The Outback Stem Mount Pendants, Outback Stem Mount Pendant, Outback Stem Mount Pendants, The Outback Industrial Stem Mount Pendant, The Outback Industrial Stem Mount Pendants, Outback Industrial Stem Mount Pendant, Outback Industrial Stem Mount Pendants, BLE-S-ULO12, BLE-S-ULO14, BLE-S-ULO16, BLE-S-ULO18, BLE-S-ULO20, 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 stem hung pendant, industrial stem hung pendants, industrial stem hung pendant light, Industrial stem hung pendant lights, Industrial stem hung pendant lighting, Industrial stem hung ceiling pendant, Industrial stem hung ceiling pendants, Industrial stem hung pendant light, Industrial stem hung pendant lights, Industrial stem hung pendant lighting, Industrial stem hung ceiling light, Industrial stem hung ceiling lights, Industrial stem hung ceiling lighting, Industrial stem pendant, industrial stem pendants, industrial stem pendant light, Industrial stem pendant lights, Industrial stem pendant lighting, Industrial stem ceiling pendant, Industrial stem ceiling pendants, Industrial stem pendant light, Industrial stem pendant lights, Industrial stem pendant lighting, Industrial stem ceiling light, Industrial stem ceiling lights, Industrial stem ceiling lighting, rugged stem hung pendant, rugged stem hung pendants, rugged stem hung pendant light, rugged stem hung pendant lights, rugged stem hung pendant lighting, rugged stem hung ceiling pendant, rugged stem hung ceiling pendants, rugged stem hung pendant light, rugged stem hung pendant lights, rugged stem hung pendant lighting, rugged stem hung ceiling light, rugged stem hung ceiling lights, rugged stem hung ceiling lighting, rugged stem pendant, rugged stem pendants, rugged stem pendant light, rugged stem pendant lights, rugged stem pendant lighting, rugged stem ceiling pendant, rugged stem ceiling pendants, rugged stem pendant light, rugged stem pendant lights, rugged stem pendant lighting, rugged stem ceiling light, rugged stem ceiling lights, rugged stem ceiling lighting, cast guard stem hung pendant, cast guard stem hung pendants, cast guard stem hung pendant light, cast guard stem hung pendant lights, cast guard stem hung pendant lighting, cast guard stem hung ceiling pendant, cast guard stem hung ceiling pendants, cast guard stem hung pendant light, cast guard stem hung pendant lights, cast guard stem hung pendant lighting, cast guard stem hung ceiling light, cast guard stem hung ceiling lights, cast guard stem hung ceiling lighting, cast guard stem pendant, cast guard stem pendants, cast guard stem pendant light, cast guard stem pendant lights, cast guard stem pendant lighting, cast guard stem ceiling pendant, cast guard stem ceiling pendants, cast guard stem pendant light, cast guard stem pendant lights, cast guard stem pendant lighting, cast guard stem ceiling light, cast guard stem ceiling lights, cast guard stem ceiling lighting, Queensland Stem, Queensland Stem Mount, Queensland Stem Mounts, Queensland Stem Mount Light, Queensland Stem Mount Lights, Queensland Stem Mount Lighting, Queensland Stem Mount Pendant, Queensland Stem Mount Pendants, Queensland Stem Mount Pendant Light, Queensland Stem Mount pendant Lights, Queensland Stem Mount Pendant Lighting, Queensland Stem Mount Ceiling Pendant, Queensland Stem Mount Ceiling Pendants, Queensland Stem Mount Ceiling Light, Queensland Stem Mount Ceiling Lights, Queensland Stem Mount Ceiling Lighting, Queens land Stem, Queens land Stem Mount, Queens land Stem Mounts, Queens land Stem Mount Light, Queens land Stem Mount Lights, Queens land Stem Mount Lighting, Queens land Stem Mount Pendant, Queens land Stem Mount Pendants, Queens land Stem Mount Pendant Light, Queens land Stem Mount pendant Lights, Queens land Stem Mount Pendant Lighting, Queens land Stem Mount Ceiling Pendant, Queens land Stem Mount Ceiling Pendants, Queens land Stem Mount Ceiling Light, Queens land Stem Mount Ceiling Lights, Queens land Stem Mount Ceiling Lighting, industrial pendant, industrial pendants, industrial ceiling pendant, industrial ceiling pendants, industrial ceiling light, industrial ceiling lights, industrial ceiling lighting, rugged pendant, rugged pendants, rugged ceiling pendant, rugged ceiling pendants, rugged ceiling light, rugged ceiling lights, rugged ceiling lighting, cast guard pendant, cast guard pendants, cast guard ceiling pendant, cast guard ceiling pendants, cast guard ceiling light, cast guard ceiling lights, cast guard ceiling lighting, Queensland pendant, Queensland pendants, queensland pendant light, queensland pendant lights, queensland pendant lighting, queensland ceiling pendant, queensland ceiling pendants, queensland ceiling light, queensland ceiling lights, queensland ceiling lighting, Queens land pendant, Queens land pendants, queens land pendant light, queens land pendant lights, queens land pendant lighting, queens land ceiling pendant, queens land ceiling pendants, queens land ceiling light, queens land ceiling lights, queens land ceiling lighting, Outback Series, Outback Collection, The Outback Series, The Outback 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, Out back Series, Out back Collection, The Out back Series, The Out back Collection, SPS-0160, SPS 0160, SPS0160, 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,