Fusion Debug Info
Splainer Link
Fusion re-written query: `*:*`
Fusion Query ID: `EYI2jq4JyO`
Raw Debug Dump:
{ "fusionDebug": { "debug": { "track": { "rid": "10.50.205.209-MongoImperialItems_shard1_replica_n1-1657002101181-1666", "EXECUTE_QUERY": { "http://10.50.205.209:8983/solr/MongoImperialItems_shard1_replica_n1/": { "QTime": "3", "ElapsedTime": "7", "RequestPurpose": "GET_TOP_IDS,GET_FACETS", "NumFound": "2055", "Response": "{responseHeader={zkConnected=true,status=0,QTime=3,params={df=_text_,distrib=false,fl=[id, score],shards.purpose=20,fsv=true,fq=[-isWeb:false, webcatclean0:Furniture___Office_Supplies, -487357_ATTR_attr_s:Yes, -snbFilter_b:true, -itemtype:n],shard.url=http://10.50.205.209:8983/solr/MongoImperialItems_shard1_replica_n1/,rid=10.50.205.209-MongoImperialItems_shard1_replica_n1-1657002101181-1666,f.shopBy_s_M.facet.mincount=1,defType=edismax,qf=[name^1.2, shortdesc^1.2, itemID_s^1.0, prettyid^1.5, cat^1.0, keywords^1.0, invngroup^1.0, xref^1.0, brand_name_txt^1.0, trade_name_txt^1.0, catpage^1.0, description_no_html^1.0, searchable_text_en^1.0, searchable_text_stemmed^1.0, lowFractions^1.5, highFractions^3.0, webcattext^1.0, specText_txt^300.0],context=app:ImperialItems,f.brand_name_s.facet.limit=160,f.brand_name_s.facet.mincount=1,wt=javabin,mm=3,facet.field=[brand_name_s, pkgQty, shopBy_s_M, webcatid1],debug=[false, timing, track],lw.pipelineId=LegacySearch,f.pkgQty.facet.mincount=1,start=0,isFusionQuery=true,sort=score desc,popularity desc,imagePath_s desc,id asc,f.shopBy_s_M.facet.limit=160,rows=0,f.webcatid1.facet.limit=160,fusionQueryId=EYI2jq4JyO,version=2,q=*:*,f.webcatid1.facet.mincount=1,requestPurpose=GET_TOP_IDS,GET_FACETS,NOW=1657002101181,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=2055,start=0,maxScore=1.8138648,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={APPROVED SUPPLIER=227,ABILITY ONE=61,HP=60,QUARTET=52,DIXIE=49,CLOVER=34,AVERY=33,PENDAFLEX=31,UNIVERSAL ONE=31,BIC=30,NATIONAL PUBLIC SEATING=30,BEVCO=29,CRESTWARE=29,NYLGLO=29,UNIVERSAL=29,GHENT=28,HIRSH=25,REGENCY=24,TOPS=22,PILOT=21,FELLOWES=20,SHARPIE=20,FLASH FURNITURE=19,MAGNA VISUAL=19,SWINGLINE=18,COSCO=17,HSM OF AMERICA=17,ICEBERG=17,PENTEL=17,PYRAMID=17,SOURCE AMERICA=17,BOSS=16,SAUNDERS=16,INNOVERA=15,MASTERVISION=15,MONOPRICE=15,POST-IT=15,RITE IN THE RAIN=15,TENNSCO=14,BESTAR=13,AMANO=12,EXPO=12,OFFICEMATE=12,VOLLRATH=12,BEST-RITE=11,BUNN=11,DANBY=11,RUBBERMAID=11,BALT=10,BRADY=10,GARVEY=10,PAPER MATE=10,SIRCLE=10,DOLPHIN COMPONENTS CORP=9,FRIGIDAIRE=9,NITE IZE=9,ULTRASITE=9,ANNIN FLAGMAKERS=8,OFFICE SNAX=8,PEERLESS=8,SHARPIE ACCENT=8,SMARTSTOCK=8,DAX=7,DURHAM=7,LUXOR=7,MEAD=7,QUALITY PARK=7,SPECO TECHNOLOGIES=7,BANKERS BOX=6,C-LINE PRODUCTS=6,DART=6,ECO STYLE=6,MSE=6,REYNOLDS=6,TARIFOLD=6,VICTOR=6,WHIRLPOOL=6,BENCHPRO=5,BROTHER=5,COMFORT PRODUCTS=5,CRETORS=5,FOLGERS=5,GBC=5,IRON BREW=5,ISLAND UMBRELLA=5,KENSINGTON=5,MANITOWOC=5,OFFICE STAR=5,R & R TEXTILE=5,ROLODEX=5,SAN JAMAR=5,SCOTSMAN=5,STANLEY=5,TRIPP LITE=5,2000PLUS=4,ACCUFORM=4,ACCUSTAMP 2=4,BLUELINE=4,CETIS=4,CHEEZ-IT=4,CTA DIGITAL=4,DATAPRODUCTS=4,DEFLECTO=4,DETECTAMET, INC.=4,FLASH=4,FLOORTEX=4,GARDNER BENDER=4,GROSFILLEX=4,HOSHIZAKI=4,JJ KELLER=4,KIND=4,LOGITECH=4,MASTER CASTER=4,MERCER CUTLERY=4,NEENAH PAPER=4,NUDELL=4,READ RIGHT=4,REMCO=4,ROYAL BASKET TRUCK=4,SAFCO=4,SKILCRAFT=4,SPRING USA=4,STANLEY BOSTITCH=4,True=4,VIDEO MOUNT PRODUCTS=4,WILSON JONES=4,ZEBRA PEN=4,ACCO=3,AMERICAN TIME=3,BLACK N' RED=3,BOARDWALK=3,C-LINE=3,CALCULATED INDUSTRIES=3,COFFEE MATE=3,CRAMER=3,CSL=3,DEXTER RUSSELL=3,DUST-OFF=3,FIREKING=3,HERGO=3,HONEY-CAN-DO=3,ICE-O-MATIC=3,LEXMARK=3,MOBILESPEC=3,PREMIER=3,QUALITY RESOURCE GROUP=3,SCOTCH=3,SHARP=3,SOLO CUP=3,TENSABARRIER=3,TIMEPILOT=3,TOUGH-TEX=3,UNI-BALL=3,UNITED VISUAL PRODUCTS=3,VERBATIM=3,VERSA PRODUCTS=3,VISIONTRON=3,WALCO=3,AMERICAN METALCRAFT=2,ARTISTIC=2},pkgQty={1=1466,12=145,100=70,1000=61,25=38,4=31,500=30,10=28,2=25,50=18,5=12,24=12,6=9,15=9,8=8,36=8,3=7,20=7,42=7,250=7,960=7,2000=6,200=5,5000=5,3000=4,16=3,30=3,40=3,2500=3,6000=2,7=1,18=1,45=1,60=1,80=1,90=1,110=1,300=1,540=1,600=1,750=1,1200=1,1500=1,1600=1,4000=1,8000=1},shopBy_s_M={New Products=161,Best Seller=4},webcatid1={231824=1203,231486=370,231408=318,301398=164}},facet_ranges={},facet_intervals={},facet_heatmaps={}},debug={facet-debug={elapse=2,sub-facet=[{processor=SimpleFacets,elapse=2,action=field facet,maxThreads=0,sub-facet=[{elapse=1,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2055,field=brand_name_s,numBuckets=4273}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=2055,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2055,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2055,field=webcatid1,numBuckets=409}]}]},timing={time=3.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},terms={time=0.0},debug={time=0.0}},process={time=2.0,query={time=0.0},facet={time=2.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},terms={time=0.0},debug={time=0.0}}}}}" }, "http://10.50.205.208:8983/solr/MongoImperialItems_shard2_replica_n2/": { "QTime": "3", "ElapsedTime": "9", "RequestPurpose": "GET_TOP_IDS,GET_FACETS", "NumFound": "2130", "Response": "{responseHeader={zkConnected=true,status=0,QTime=3,params={df=_text_,distrib=false,fl=[id, score],shards.purpose=20,fsv=true,fq=[-isWeb:false, webcatclean0:Furniture___Office_Supplies, -487357_ATTR_attr_s:Yes, -snbFilter_b:true, -itemtype:n],shard.url=http://10.50.205.208:8983/solr/MongoImperialItems_shard2_replica_n2/,rid=10.50.205.209-MongoImperialItems_shard1_replica_n1-1657002101181-1666,f.shopBy_s_M.facet.mincount=1,defType=edismax,qf=[name^1.2, shortdesc^1.2, itemID_s^1.0, prettyid^1.5, cat^1.0, keywords^1.0, invngroup^1.0, xref^1.0, brand_name_txt^1.0, trade_name_txt^1.0, catpage^1.0, description_no_html^1.0, searchable_text_en^1.0, searchable_text_stemmed^1.0, lowFractions^1.5, highFractions^3.0, webcattext^1.0, specText_txt^300.0],context=app:ImperialItems,f.brand_name_s.facet.limit=160,f.brand_name_s.facet.mincount=1,wt=javabin,mm=3,facet.field=[brand_name_s, pkgQty, shopBy_s_M, webcatid1],debug=[false, timing, track],lw.pipelineId=LegacySearch,f.pkgQty.facet.mincount=1,start=0,isFusionQuery=true,sort=score desc,popularity desc,imagePath_s desc,id asc,f.shopBy_s_M.facet.limit=160,rows=0,f.webcatid1.facet.limit=160,fusionQueryId=EYI2jq4JyO,version=2,q=*:*,f.webcatid1.facet.mincount=1,requestPurpose=GET_TOP_IDS,GET_FACETS,NOW=1657002101181,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=2130,start=0,maxScore=1.377123,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={APPROVED SUPPLIER=239,HP=83,ABILITY ONE=71,QUARTET=59,BEVCO=48,NATIONAL PUBLIC SEATING=44,BIC=39,UNIVERSAL=39,UNIVERSAL ONE=35,AVERY=32,PENDAFLEX=27,NYLGLO=25,CLOVER=24,DIXIE=24,PENTEL=24,SHARPIE=23,VOLLRATH=22,GHENT=21,OFFICEMATE=21,SWINGLINE=21,FLASH FURNITURE=20,HIRSH=20,SAUNDERS=20,PILOT=19,PYRAMID=19,TOPS=19,FELLOWES=18,REGENCY=18,TENNSCO=18,BALT=17,MAGNA VISUAL=17,SIRCLE=15,VICTOR=15,COSCO=14,CRESTWARE=14,ICEBERG=14,RITE IN THE RAIN=14,RUBBERMAID=14,BOSS=13,POST-IT=13,EXPO=12,HSM OF AMERICA=12,UNITED VISUAL PRODUCTS=12,BEST-RITE=11,PAPER MATE=11,SMARTSTOCK=11,BRADY=10,INNOVERA=10,KENSINGTON=10,MONOPRICE=10,SOURCE AMERICA=10,ACCUSTAMP 2=9,AMANO=9,DART=9,FLASH=9,PEERLESS=9,SHARPIE ACCENT=9,TRIPP LITE=9,DOLPHIN COMPONENTS CORP=8,HAMMERMILL=8,LOGITECH=8,OFFICE SNAX=8,BANKERS BOX=7,DEXTER RUSSELL=7,FRIGIDAIRE=7,IRON BREW=7,MANITOWOC=7,MASTERVISION=7,NITE IZE=7,OFFICE STAR=7,READ RIGHT=7,SCOTSMAN=7,VERBATIM=7,2000PLUS=6,ANNIN FLAGMAKERS=6,BESTAR=6,C-LINE PRODUCTS=6,CRAMER=6,DANBY=6,FLOORTEX=6,FOLGERS=6,OFM INC=6,SHARP=6,STANLEY BOSTITCH=6,ULTRASITE=6,VERSA PRODUCTS=6,ZEBRA PEN=6,BROTHER=5,CRETORS=5,DURHAM=5,NUDELL=5,POWER FIRST=5,QUALITY RESOURCE GROUP=5,SAMSILL=5,SAN JAMAR=5,TOUGH-TEX=5,WILSON JONES=5,ABUS=4,ACCO=4,ALERA=4,ALLSOP=4,BULLDOG=4,CAMBRO=4,DAX=4,GARDNER BENDER=4,GARVEY=4,GREENE MANUFACTURING, INC.=4,HONEY-CAN-DO=4,HOSHIZAKI=4,LEXMARK=4,LUXOR=4,MEAD=4,MSE=4,NEENAH PAPER=4,QUALITY PARK=4,R & R TEXTILE=4,ROYAL BASKET TRUCK=4,SHOPSOL=4,TARIFOLD=4,UNI-BALL=4,VIDEO MOUNT PRODUCTS=4,WHIRLPOOL=4,ACCUFORM=3,AMERICAN METALCRAFT=3,BLUE WAVE PRODUCTS=3,BUNN=3,CALCULATED INDUSTRIES=3,CETIS=3,CLAUSS=3,DAYMARK=3,DETECTAMET, INC.=3,DURAFRAME=3,DUST-OFF=3,FALCON=3,FIREKING=3,GLARO=3,JUSTRITE=3,KAPAK BY AMPAC=3,LEGACY=3,LIQUID PAPER=3,NUTRIGRAIN=3,ROLODEX=3,SANI-LAV=3,SENTRY SAFE=3,SOLO CUP=3,SPECO TECHNOLOGIES=3,SPRING USA=3,STANLEY=3,STOREX=3,TABLECRAFT PRODUCTS COMPANY=3,TAYLOR=3,True=3,9 TO 5 COFFEE=2,ACCUFORM SIGNS=2,AMERICAN SOLUTIONS FOR BUSINESS=2,AMERICAN TIME=2,APW WYOTT=2,BARSKA=2,BAW PLASTICS=2,BENCHPRO=2},pkgQty={1=1477,12=184,100=71,1000=55,2=35,4=33,500=31,25=30,10=27,50=23,3=13,5=13,6=13,960=11,15=9,24=9,42=7,8=6,36=6,40=6,250=6,5000=6,200=5,16=4,30=3,60=3,2000=3,6000=3,18=2,20=2,28=2,48=2,72=2,110=2,400=2,10000=2,9=1,14=1,35=1,55=1,75=1,80=1,144=1,210=1,320=1,450=1,540=1,600=1,640=1,750=1,800=1,820=1,1200=1,1240=1,1500=1,2500=1,4000=1,8000=1},shopBy_s_M={New Products=201},webcatid1={231824=1275,231486=400,231408=288,301398=167}},facet_ranges={},facet_intervals={},facet_heatmaps={}},debug={facet-debug={elapse=3,sub-facet=[{processor=SimpleFacets,elapse=3,action=field facet,maxThreads=0,sub-facet=[{elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2130,field=brand_name_s,numBuckets=4300}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=2130,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2130,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2130,field=webcatid1,numBuckets=405}]}]},timing={time=3.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},terms={time=0.0},debug={time=0.0}},process={time=3.0,query={time=0.0},facet={time=3.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},terms={time=0.0},debug={time=0.0}}}}}" } }, "GET_FIELDS": { "http://10.50.205.209:8983/solr/MongoImperialItems_shard1_replica_n1/": { "QTime": "0", "ElapsedTime": "1", "RequestPurpose": "REFINE_FACETS", "NumFound": "2055", "Response": "{responseHeader={zkConnected=true,status=0,QTime=0,params={df=_text_,distrib=false,fl=brand_name_s,canshipair,catalogNeedAppr_is,categoryPath,catpage,excludeSt_s_M,id,itemID_s,itemQtyLimit_i,image,imagePath_s,itemFlagsExcl_s_M,hoverImagePath_s,isBestSeller_b,isCat,isNew,listPrice_d,listPriceEa_d,lottracking,msdsavail,name,numItems,ormd,pandemicItem_b,pandemicItemBlocked_b,pkgQty,prettyid,prop65b_b,prop65c_b,prop65b_chemicals_s,prop65c_chemicals_s,shortdesc,webcatid,graMsdsavail_b,GSDP_ID_s,sds_s,sdsAssetFileName_s,upsHazard,prevPurchased:exists(query({!v=purchasedBy_s_M:undefined})),shards.purpose=32,fq=[-isWeb:false, webcatclean0:Furniture___Office_Supplies, -487357_ATTR_attr_s:Yes, -snbFilter_b:true, -itemtype:n],shard.url=http://10.50.205.209:8983/solr/MongoImperialItems_shard1_replica_n1/,rid=10.50.205.209-MongoImperialItems_shard1_replica_n1-1657002101181-1666,brand_name_s__terms=HAMMERMILL,defType=edismax,qf=[name^1.2, shortdesc^1.2, itemID_s^1.0, prettyid^1.5, cat^1.0, keywords^1.0, invngroup^1.0, xref^1.0, brand_name_txt^1.0, trade_name_txt^1.0, catpage^1.0, description_no_html^1.0, searchable_text_en^1.0, searchable_text_stemmed^1.0, lowFractions^1.5, highFractions^3.0, webcattext^1.0, specText_txt^300.0],context=app:ImperialItems,wt=javabin,mm=3,facet.field={!terms=$brand_name_s__terms}brand_name_s,debug=[false, timing, track],lw.pipelineId=LegacySearch,isFusionQuery=true,sort=score desc,popularity desc,imagePath_s desc,id asc,rows=0,fusionQueryId=EYI2jq4JyO,version=2,q=*:*,requestPurpose=REFINE_FACETS,NOW=1657002101181,isShard=true,boost=popmult,facet.mincount=1,facet=true,debugQuery=false}},response={numFound=2055,start=0,docs=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={HAMMERMILL=1}},facet_ranges={},facet_intervals={},facet_heatmaps={}},debug={facet-debug={elapse=0,sub-facet=[{processor=SimpleFacets,elapse=0,action=field facet,maxThreads=0,sub-facet=[{}]}]},timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},terms={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},terms={time=0.0},debug={time=0.0}}}}}" } } }, "facet-debug": { "elapse": 5, "sub-facet": [ { "processor": "SimpleFacets", "elapse": 2, "action": "field facet", "maxThreads": 0, "sub-facet": [ { "elapse": 1, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 2055, "field": "brand_name_s", "numBuckets": 4273 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FCS", "inputDocSetSize": 2055, "field": "pkgQty" }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 2055, "field": "shopBy_s_M", "numBuckets": 4 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 2055, "field": "webcatid1", "numBuckets": 409 } ] }, { "processor": "SimpleFacets", "elapse": 3, "action": "field facet", "maxThreads": 0, "sub-facet": [ { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 2130, "field": "brand_name_s", "numBuckets": 4300 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FCS", "inputDocSetSize": 2130, "field": "pkgQty" }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 2130, "field": "shopBy_s_M", "numBuckets": 4 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 2130, "field": "webcatid1", "numBuckets": 405 } ] }, { "processor": "SimpleFacets", "elapse": 0, "action": "field facet", "maxThreads": 0, "sub-facet": [ {} ] } ] }, "timing": { "time": 6, "prepare": { "time": 0, "query": { "time": 0 }, "facet": { "time": 0 }, "facet_module": { "time": 0 }, "mlt": { "time": 0 }, "highlight": { "time": 0 }, "stats": { "time": 0 }, "expand": { "time": 0 }, "terms": { "time": 0 }, "debug": { "time": 0 } }, "process": { "time": 5, "query": { "time": 0 }, "facet": { "time": 5 }, "facet_module": { "time": 0 }, "mlt": { "time": 0 }, "highlight": { "time": 0 }, "stats": { "time": 0 }, "expand": { "time": 0 }, "terms": { "time": 0 }, "debug": { "time": 0 } } }, "rawquerystring": "*:*", "querystring": "*:*", "parsedquery": "FunctionScoreQuery(FunctionScoreQuery(+*:*, scored by boost(float(popmult))))", "parsedquery_toString": "FunctionScoreQuery(+*:*, scored by boost(float(popmult)))", "QParser": "ExtendedDismaxQParser", "altquerystring": null, "boost_queries": null, "parsed_boost_queries": [], "boostfuncs": null, "explain": {} }, "responseHeader": { "zkConnected": true, "status": 0, "QTime": 13, "params": { "mm": "3", "facet.field": [ "brand_name_s", "pkgQty", "shopBy_s_M", "webcatid1" ], "debug": "true", "lw.pipelineId": "LegacySearch", "fl": "brand_name_s,canshipair,catalogNeedAppr_is,categoryPath,catpage,excludeSt_s_M,id,itemID_s,itemQtyLimit_i,image,imagePath_s,itemFlagsExcl_s_M,hoverImagePath_s,isBestSeller_b,isCat,isNew,listPrice_d,listPriceEa_d,lottracking,msdsavail,name,numItems,ormd,pandemicItem_b,pandemicItemBlocked_b,pkgQty,prettyid,prop65b_b,prop65c_b,prop65b_chemicals_s,prop65c_chemicals_s,shortdesc,webcatid,graMsdsavail_b,GSDP_ID_s,sds_s,sdsAssetFileName_s,upsHazard,prevPurchased:exists(query({!v=purchasedBy_s_M:undefined}))", "start": "0", "isFusionQuery": "true", "fq": [ "-isWeb:false", "webcatclean0:Furniture___Office_Supplies", "-487357_ATTR_attr_s:Yes", "-snbFilter_b:true", "-itemtype:n" ], "sort": "score desc,popularity desc,imagePath_s desc,id asc", "rows": "0", "fusionQueryId": "EYI2jq4JyO", "q": "*:*", "defType": "edismax", "qf": [ "name^1.2", "shortdesc^1.2", "itemID_s^1.0", "prettyid^1.5", "cat^1.0", "keywords^1.0", "invngroup^1.0", "xref^1.0", "brand_name_txt^1.0", "trade_name_txt^1.0", "catpage^1.0", "description_no_html^1.0", "searchable_text_en^1.0", "searchable_text_stemmed^1.0", "lowFractions^1.5", "highFractions^3.0", "webcattext^1.0", "specText_txt^300.0" ], "context": "app:ImperialItems", "boost": "popmult", "facet.mincount": "1", "wt": "json", "facet": "true" }, "totalTime": 29 } }, "splainerURL": "http://splainer.io/#?solr=http%3A%2F%2Fdvlfusap001.us.grainger.com%3A8764%2Fapi%2Fapps%2FImperialItems%2Fquery%2FLegacySearch%3Fq%3D*%253A*%26debug%3Dtrue%26sort%3Dscore%2520desc%2Cpopularity%2520desc%2CimagePath_s%2520desc%2Cid%2520asc%26fq%3D-isWeb%3Afalse%26fq%3Dwebcatclean0%3AFurniture___Office_Supplies%26facet%3Dtrue%26facet.field%3Dbrand_name_s%26facet%3Dtrue%26facet.field%3DpkgQty%26facet%3Dtrue%26facet.field%3DshopBy_s_M%26facet%3Dtrue%26facet.field%3Dwebcatid1%26rows%3D0%26fl%3Dbrand_name_s%252Ccanshipair%252CcatalogNeedAppr_is%252CcategoryPath%252Ccatpage%252CexcludeSt_s_M%252Cid%252CitemID_s%252CitemQtyLimit_i%252Cimage%252CimagePath_s%252CitemFlagsExcl_s_M%252ChoverImagePath_s%252CisBestSeller_b%252CisCat%252CisNew%252ClistPrice_d%252ClistPriceEa_d%252Clottracking%252Cmsdsavail%252Cname%252CnumItems%252Cormd%252CpandemicItem_b%252CpandemicItemBlocked_b%252CpkgQty%252Cprettyid%252Cprop65b_b%252Cprop65c_b%252Cprop65b_chemicals_s%252Cprop65c_chemicals_s%252Cshortdesc%252Cwebcatid%252CgraMsdsavail_b%252CGSDP_ID_s%252Csds_s%252CsdsAssetFileName_s%252CupsHazard%252CprevPurchased%253Aexists(query(%257B!v%253DpurchasedBy_s_M%253Aundefined%257D))&fieldSpec=name,itemID_s,webcattext,shortdesc_s", "legacyQueryDebug": true }
Skip to main content
Shop Talk
Create Account
|
Log In
|
Contact Us
Filter
Fleet Maintenance Supply Experts 1-800-558-2808
My Account
Orders
PRODUCTS
QUICK-ADD
SERVICES
FEATURED
Order History
My Lists
File Import
Auto-Reorder
Catalog
My Most Frequently Purchased Products
View All
Loading...
Shop All
Best Sellers
Imperial Brand
Monthly Flyer
Catalog
New
All Brands
Abrasives
Air Brake
Assortments
Building & Grounds
Chemicals
Cutting & Holemaking Tools
Electrical
Fasteners
Furniture & Office Supplies
Hardware
Hose & Hose Ends
HVACR
Hydraulics
Janitorial
Lighting
Material Handling
Paint & Paint Supplies
Pipe, Tubing & Fittings
Plumbing
Pneumatics
Pumps
Raw Materials
Safety
Steel Equipment & Storage
Tape
Tools
Vehicle & Trailer Parts
Welding
Wheel & Tire
Wiper Blade Finder
Select Vehicle
Emergency Preparedness
Active Shooter
Earthquake
Extreme Heat
Fire
Flooding
Hurricane
Power Outage
Tornado
Winter Storm
View All
Home
All Products
Furniture & Office Supplies
Filter Results
Sort By
Popularity
Brand A-Z
Brand Z-A
Description A-Z
Description Z-A
Item 0-9
Item 9-0
Newest to Oldest
Oldest To Newest
Product Categories
Electronics & Appliances
(331)
Furniture
(770)
Hospitality and Food Service
(606)
Office Supplies
(2478)
Brand
Refine filter
No matches found.
2000PLUS
(10)
ABILITY ONE
(132)
ACCUSTAMP 2
(13)
AMANO
(21)
ANNIN FLAGMAKERS
(14)
APPROVED SUPPLIER
(466)
AVERY
(65)
BALT
(27)
BANKERS BOX
(13)
BEST-RITE
(22)
BESTAR
(19)
BEVCO
(77)
BIC
(69)
BOSS
(29)
BRADY
(20)
BROTHER
(10)
BUNN
(14)
C-LINE PRODUCTS
(12)
CLOVER
(58)
COSCO
(31)
CRAMER
(9)
CRESTWARE
(43)
CRETORS
(10)
DANBY
(17)
DART
(15)
DAX
(11)
DEXTER RUSSELL
(10)
DIXIE
(73)
DOLPHIN COMPONENTS CORP
(17)
DURHAM
(12)
EXPO
(24)
FELLOWES
(38)
FLASH
(13)
FLASH FURNITURE
(39)
FLOORTEX
(10)
FOLGERS
(11)
FRIGIDAIRE
(16)
GARVEY
(14)
GHENT
(49)
HAMMERMILL
(9)
HIRSH
(45)
HP
(143)
HSM OF AMERICA
(29)
ICEBERG
(31)
INNOVERA
(25)
IRON BREW
(12)
KENSINGTON
(15)
LOGITECH
(12)
LUXOR
(11)
MAGNA VISUAL
(36)
MANITOWOC
(12)
MASTERVISION
(22)
MEAD
(11)
MONOPRICE
(25)
MSE
(10)
NATIONAL PUBLIC SEATING
(74)
NITE IZE
(16)
NUDELL
(9)
NYLGLO
(54)
OFFICE SNAX
(16)
OFFICE STAR
(12)
OFFICEMATE
(33)
PAPER MATE
(21)
PEERLESS
(17)
PENDAFLEX
(58)
PENTEL
(41)
PILOT
(40)
POST-IT
(28)
PYRAMID
(36)
QUALITY PARK
(11)
QUARTET
(111)
R & R TEXTILE
(9)
READ RIGHT
(11)
REGENCY
(42)
RITE IN THE RAIN
(29)
RUBBERMAID
(25)
SAN JAMAR
(10)
SAUNDERS
(36)
SCOTSMAN
(12)
SHARPIE
(43)
SHARPIE ACCENT
(17)
SIRCLE
(25)
SMARTSTOCK
(19)
SOURCE AMERICA
(27)
SPECO TECHNOLOGIES
(10)
STANLEY BOSTITCH
(10)
SWINGLINE
(39)
TARIFOLD
(10)
TENNSCO
(32)
TOPS
(41)
TRIPP LITE
(14)
ULTRASITE
(15)
UNITED VISUAL PRODUCTS
(15)
UNIVERSAL
(68)
UNIVERSAL ONE
(66)
VERBATIM
(10)
VICTOR
(21)
VOLLRATH
(34)
WHIRLPOOL
(10)
ZEBRA PEN
(10)
+ See More
Package Quantity
Refine filter
No matches found.
1
(2943)
2
(60)
3
(20)
4
(64)
5
(25)
6
(22)
7
(1)
8
(14)
9
(1)
10
(55)
12
(329)
14
(1)
15
(18)
16
(7)
18
(3)
20
(9)
24
(21)
25
(68)
28
(2)
30
(6)
35
(1)
36
(14)
40
(9)
42
(14)
45
(1)
48
(2)
50
(41)
55
(1)
60
(4)
72
(2)
75
(1)
80
(2)
90
(1)
100
(141)
110
(3)
144
(1)
200
(10)
210
(1)
250
(13)
300
(1)
320
(1)
400
(2)
450
(1)
500
(61)
540
(2)
600
(2)
640
(1)
750
(2)
800
(1)
820
(1)
960
(18)
1000
(116)
1200
(2)
1240
(1)
1500
(2)
1600
(1)
2000
(9)
2500
(4)
3000
(4)
4000
(2)
5000
(11)
6000
(5)
8000
(2)
10000
(2)
+ See More
Shop By
No matches found.
Best Seller
(4)
New Products
(362)
Furniture & Office Supplies ID: I_PCR_399861
Filter
Popular Categories
Office Supplies
| ID: I_PCR_399868
(2478)
Writing and Correction
Paper, Envelopes, and Notebooks
Binders and Clipboards
Hospitality and Food Service
| ID: I_PCR_399867
(606)
Food Service Disposables and Dispensers
Snack Foods, Coffee, Creamers and Condiments
Food Service Tableware, Bar, And Buffet
Furniture
| ID: 112274_AA
(770)
Office Chairs & Shop Stools
Office Desks & Accessories
Computer Cabinets & Media Storage
Electronics & Appliances
| ID: 118945_AA
(331)
TV, Phone and Computer
Electronics
Appliances
