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 (64657, 64728, 64821, 61180) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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 (64657,64728,64821,61180) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61180	fargo, wall sconce, handcrafted, industrial sconce, reading light, bedside lamp, bathroom, sconce, bedside sconce, classic light,	This handcrafted industrial sconce makes the perfect reading light, bedside lamp, or bathroom wall sconce. Add this classic wall sconce for a vintage look.	Fargo Wall Sconce, fargo, wall sconce, handcrafted, industrial sconce, reading light, bedside lamp, bathroom, sconce, bedside sconce, fargo sconce, BLE-W-FAR, wall light, warehouse shades, warehouse light, warehouse sconce, industrial light, industrial wall sconce, SPS-0166, SPS 0166, SPS 0166, fargo collection, fargo series, The Fargo Collection, The Fargo 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,
64657		A timeless yet unique design, the Egg Cord Hung Pendant Light captures attention in any location! Customize its look with various finish colors and cord styles!	egg, egg pendant, egg cord pendant, egg cord, new listing, BLE-C-DBE, Egg Cord Hung Pendant Light, Egg Cord Hung Pendant Lights, Egg Pendant Light, Egg Pendant, Egg pendants, egg ceiling pendant, egg, egg cord, egg cord hung, egg cord pendant, egg hanging pendant, Egg Cord Hung Pendant Lighting, Egg Pendant lighting, egg, BLE-C-DBE10, BLE-C-DBE16, BLE-C-DBE20, Deep bowl, deep bowls, deep bowl shade, deep bowl shades, deep bowl light, deep bowl lights, deep bowl lighting, deep bowl shade light, deep bowl shade lights, deep bowl shade lighting, deep bowl pendant, deep bowl pendants, deep bowl ceiling pendant, deep bowl ceiling light, deep bowl ceiling lights, deep bowl ceiling lighting, deep bowl pendant light, deep bowl pendant lights, deep bowl pendant lighting, deep bowl shade pendant, deep bowl shade pendants, deep bowl shade ceiling pendant, deep bowl shade ceiling light, deep bowl shade ceiling lights, deep bowl shade ceiling lighting, deep bowl shade pendant light, deep bowl shade pendant lights, deep bowl shade pendant lighting, Deep bowl cord mount, deep bowl cord mounts, deep bowl cord mount light, deep bowl cord mount lights, deep bowl cord mount lighting, deep bowl cord mount pendant, deep bowl cord mount pendants, deep bowl cord mount pendant light, deep bowl cord mount pendant lights, deep bowl cord mount pendant lighting, deep bowl cord mount ceiling light, deep bowl cord mount ceiling lights, deep bowl cord mount ceiling lighting, deep bowl cord mount ceiling pendant, deep bowl cord mount ceiling pendants, Cord mount deep bowl, cord mount deep bowl light, cord mount deep bowl lights, cord mount deep bowl lighting, cord mount deep bowl pendant, cord mount deep bowl pendants, cord mount deep bowl ceiling pendant, cord mount deep bowl ceiling pendants, cord mount deep bowl pendant light, cord mount deep bowl pendant lights, cord mount deep bowl pendant lighting, cord mount deep bowl ceiling light, cord mount deep bowl ceiling lighting, Deep bowl cord hung, deep bowl cord hung light, deep bowl cord hung lights, deep bowl cord hung lighting, deep bowl cord hung pendant, deep bowl cord hung pendants, deep bowl cord hung pendant light, deep bowl cord hung pendant lights, deep bowl cord hung pendant lighting, deep bowl cord hung ceiling light, deep bowl cord hung ceiling lights, deep bowl cord hung ceiling lighting, deep bowl cord hung ceiling pendant, deep bowl cord hung ceiling pendants, Cord hung deep bowl, cord hung deep bowl light, cord hung deep bowl lights, cord hung deep bowl lighting, cord hung deep bowl pendant, cord hung deep bowl pendants, cord hung deep bowl ceiling pendant, cord hung deep bowl ceiling pendants, cord hung deep bowl pendant light, cord hung deep bowl pendant lights, cord hung deep bowl pendant lighting, cord hung deep bowl ceiling light, cord hung deep bowl ceiling lighting, egg collection, egg series, the egg collection, the egg series, SPS-0432, SPS 0432, SPS0432, The egg pendant, 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, 23NDP1023
64728	exterior sconce lighting, deep bowl shade sconce, rlm shade wall sconce, deep bowl rlm reflector shade, commercial barn light, dark sky sconce light, plug in sconce, plug-in sconce, plug in wall light	Intend for smaller areas, this wall sconce is fully handcrafted and American-made! Fully customizable with numerous finishes, including our protective marine grade!	deep bowl sconce, wilcox sconce, deep bowl rlm, wilcox, Wheeler™ Wilcox Wall Sconce, down light, BLE-W-DBW10, BLE-W-DBW12, BLE-W-DBW14, Wheeler Wilcox Wall Sconce, wall lights, wall lighting, wall scone, deep bowl sconce light, warehouse lighting, warehouse sconce, plug in light, plug in sconce, plug-in light, plug-in sconce, wilcox sconce, deep bowl sconce, wheeler wilcox, wheeler wilcox sconce, new wilcox, new rlm, new listing, wesco, sconce, deep bowl, outdoor, exterior, BLE-W-DBW10-PC, BLE-W-DBW-PC, mini deep bowl light, gas station light with wire cage sconce, warehouse shade with cage sconce, outdoor sconce light, deep bowl sconce, industrial factory style sconce, barn light deep bowl, BLE-W-DBW10-PC, BLE-W-DBW8-PC, wall lighting, plug in light, plug-in lighting, warehouse lighting, warehouse wall light, warehouse plug in lighting, warehouse plug-in lighting, warehouse shade lights, The Bantam Wesco Wall Sconce, Bantam Wesco Wall Sconce, bantam sconce, Bantam Wilcox Deep Bowl Wall Sconce, Bantam Wilcox Wall Sconce, Bantam Wilcox Sconce, Bantam Wilcox, Bantam Deep Bowl Wall Sconce, Bantam Wall Sconce, Bantam Sconce, Wilcox Sconce, Wilcox Wall Sconce, BLE-W-DBW8, BLE-W-DBW10, Bantam wesco sconce, Bantam wesco sconces, Bantam wesco wall sconce, Bantam wesco wall sconces, willcox, willcox wall sconce, bantam willcox, willcox bantam, SPS-0372, SPS 0372, SPS0372, 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, bantam wilcox, Wilcox 8”, Wilcox 8, 8" Wilcox, 8 Wilcox, Wilcox 8 Inch, 8 inch Wilcox, Wilcox 11", Wilcox 11, Wilcox 11 inch, 11 inch wilcox, Wall sconce outdoor, outdoor Wall sconce, outdoor Wall sconces, Wall sconces outdoor, sconce outdoor, outdoor sconce, outdoor sconces, sconces outdoor, 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, wilcox bowl, jadeite, jadite, jadeite light, jadite light, wilcox bantam, H-16006, classic deep bowl shade,
64821		Hand-crafted, customizable, and American made! This deep bowl modern pendant light adds a contemporary style to homes and businesses!	loma, locke, BLE-C-DBL-PC, The Loma Pendant, The Loma Pendants, The Loma Pendant light, The Loma Pendant Lights, The Loma Pendant Lighting, The Loma Ceiling Pendant, The Loma Ceiling Pendants, The Loma Ceiling Light, The Loma Ceiling Lights, The Loma Ceiling Lighting, Loma Pendant, Loma Pendants, Loma Pendant light, Loma Pendant Lights, Loma Pendant Lighting, Loma Ceiling Pendant, Loma Ceiling Pendants, Loma Ceiling Light, Loma Ceiling Lights, Loma Ceiling Lighting, Loma, The Loma, The Loma Cord Hung Pendant, The Loma Cord Hung Pendants, The Loma Cord Hung Pendant light, The Loma Cord Hung Pendant Lights, The Loma Cord Hung Pendant Lighting, The Loma Cord Hung Ceiling Pendant, The Loma Cord Hung Ceiling Pendants, The Loma Cord Hung Ceiling Light, The Loma Cord Hung Ceiling Lights, The Loma Cord Hung Ceiling Lighting, Loma Cord Hung Pendant, Loma Cord Hung Pendants, Loma Cord Hung Pendant light, Loma Cord Hung Pendant Lights, Loma Cord Hung Pendant Lighting, Loma Cord Hung Ceiling Pendant, Loma Cord Hung Ceiling Pendants, Loma Cord Hung Ceiling Light, Loma Cord Hung Ceiling Lights, Loma Cord Hung Ceiling Lighting, The Loma Cord Pendant, The Loma Cord Pendants, The Loma Cord Pendant light, The Loma Cord Pendant Lights, The Loma Cord Pendant Lighting, The Loma Cord Ceiling Pendant, The Loma Cord Ceiling Pendants, The Loma Cord Ceiling Light, The Loma Cord Ceiling Lights, The Loma Cord Ceiling Lighting, Loma Cord Pendant, Loma Cord Pendants, Loma Cord Pendant light, Loma Cord Pendant Lights, Loma Cord Pendant Lighting, Loma Cord Ceiling Pendant, Loma Cord Ceiling Pendants, Loma Cord Ceiling Light, Loma Cord Ceiling Lights, Loma Cord Ceiling Lighting, hemisphere lighting, hemisphere light, hemisphere pendant, hemisphere, hemisphere fixture, hemisphere cord light, hemisphere cord pendant, hemisphere cord, loma deep bowl, new listing, new rlm, new loma, locke, loma, The Lock Pendant, The Lock Pendants, The Lock Pendant light, The Lock Pendant Lights, The Lock Pendant Lighting, Lock Pendant, Lock Pendants, Lock Pendant light, Lock Pendant Lights, Lock Pendant Lighting, The Lock Cord Hung Pendant, The Lock Cord Hung Pendants, The Lock Cord Hung Pendant light, The Lock Cord Hung Pendant Lights, The Lock Cord Hung Pendant Lighting, Lock Cord Hung Pendant, Lock Cord Hung Pendants, Lock Cord Hung Pendant light, Lock Cord Hung Pendant Lights, Lock Cord Hung Pendant Lighting, The Lock Cord Hung Pendant light, The Lock Cord Hung Lights, The Lock Cord Hung Lighting, Lock Cord Hung Pendant light, Lock Cord Hung Lights, Lock Cord Hung Lighting, The Lock Cord Pendant light, The Lock Cord Lights, The Lock Cord Lighting, Lock Cord Pendant light, Lock Cord Lights, Lock Cord Lighting, The Lock Ceiling Pendant, The Lock Ceiling Pendants, Lock Ceiling Pendant, Lock Ceiling Pendants, The Lock Ceiling Light, The Lock Ceiling Lights, The Lock Ceiling Lighting, Lock Ceiling Light, Lock Ceiling Lights, Lock Ceiling Lighting, Lock, The Lock, The Locke Pendant, The Locke Pendants, The Locke Pendant light, The Locke Pendant Lights, The Locke Pendant Lighting, Locke Pendant, Locke Pendants, Locke Pendant light, Locke Pendant Lights, Locke Pendant Lighting, The Locke Cord Hung Pendant, The Locke Cord Hung Pendants, The Locke Cord Hung Pendant light, The Locke Cord Hung Pendant Lights, The Locke Cord Hung Pendant Lighting, Locke Cord Hung Pendant, Locke Cord Hung Pendants, Locke Cord Hung Pendant light, Locke Cord Hung Pendant Lights, Locke Cord Hung Pendant Lighting, The Locke Cord Hung Pendant light, The Locke Cord Hung Lights, The Locke Cord Hung Lighting, Locke Cord Hung Pendant light, Locke Cord Hung Lights, Locke Cord Hung Lighting, The Locke Cord Pendant light, The Locke Cord Lights, The Locke Cord Lighting, Locke Cord Pendant light, Locke Cord Lights, Locke Cord Lighting, The Locke Ceiling Pendant, The Locke Ceiling Pendants, Locke Ceiling Pendant, Locke Ceiling Pendants, The Locke Ceiling Light, The Locke Ceiling Lights, The Locke Ceiling Lighting, Locke Ceiling Light, Locke Ceiling Lights, Locke Ceiling Lighting, Locke, The Locke, BLE-C-DBL, BLE-C-DBL12, BLE-C-DBL16, BLE-C-DBL20, Dome, dome light, dome lights, dome lighting, Dome shade, dome shades, loma dome shade, loma dome shades, loma dome light shade, loma dome light shades, dome light fixture, dome light fixtures, dome lighting fixture, dome lighting fixtures, dome shade lighting, dome shade lights, dome shade light, dome shade light fixture, dome shade light fixtures, Loma dome light fixture, Loma dome light fixtures, Loma dome lighting fixture, Loma dome lighting fixtures, Loma dome shade lighting, Loma dome shade lights, Loma dome shade light, Loma dome shade light fixture, Loma dome shade light fixtures, BLE-C-DBL, Lima, loma+pendant, loma deep bowl, locke loma deep bowl, locke & loma, lima pendant, lima pendants, loma deep bowl pendant, loma deep bowl pendants, ble-dbl, ble--dbl, dbl, dome pendant light 12", Loma Collection, Loma Series, The Loma Collection, The Loma Series, SPS-0013, SPS 0013, SPS0013, teal, 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, cord loma, jadeite, jadite, jadeite light, jadite light, lomas, H-26112, H-26116, hemisphere, hemisphere collection,