Fusion Debug Info
Splainer Link
Fusion re-written query: `*:*`
Fusion Query ID: `7XNwxuN63a`
Raw Debug Dump:
{ "fusionDebug": { "debug": { "track": { "rid": "dev-solr-search-0.dev-solr-search-headless-1794529", "EXECUTE_QUERY": { "http://dev-solr-search-0.dev-solr-search-headless:8983/solr/ImperialItems_shard1_replica_n1/": { "QTime": "3", "ElapsedTime": "12", "RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS", "NumFound": "216", "Response": "{responseHeader={zkConnected=true,status=0,QTime=3,params={df=_text_,distrib=false,preferLocalShards=false,f.spec.981752_ATTR_VA_ID_s.facet.limit=160,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Assortments, -487357_ATTR_attr_s:Yes, -snbFilter_b:true, -itemtype:n],shard.url=http://dev-solr-search-0.dev-solr-search-headless:8983/solr/ImperialItems_shard1_replica_n1/,rid=dev-solr-search-0.dev-solr-search-headless-1794529,f.shopBy_s_M.facet.mincount=1,defType=edismax,qf=[id^1.0, prettyid^1.5, cat^1.0, keywords^1.0, webcattext^1.0, name^1.2, shortdesc^1.2, 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, lowFractions^1.5, highFractions^3.0],context=app:ImperialItems,f.brand_name_s.facet.limit=160,shards.preference=replica.type:PULL,f.brand_name_s.facet.mincount=1,wt=javabin,mm=3,facet.field=[spec.981752_ATTR_VA_ID_s, brand_name_s, pkgQty, shopBy_s_M, webcatid1],_stateVer_=ImperialItems:4,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,queryProfileID=LegacySearch,fusionQueryId=7XNwxuN63a,version=2,q=*:*,f.spec.981752_ATTR_VA_ID_s.facet.mincount=1,f.webcatid1.facet.mincount=1,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1680002414417,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=216,numFoundExact=true,start=0,maxScore=1.3947369,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={spec.981752_ATTR_VA_ID_s={VA_Asset_981768=92,VA_Asset_981770=90,VA_Asset_981771=15,VA_Asset_981772=3,NA_322023=1,VA_Asset_981769=1,VA_Asset_981774=1},brand_name_s={IMPERIAL=102,APPROVED SUPPLIER=39,DISCO=38,AUVECO=13,ITW BEE LEITZKE=10,BAND-IT=2,METRI-PACK=2,NORTON=2,PERFORMANCE TOOL=1,QUICK CABLE=1},pkgQty={1=216},shopBy_s_M={Imperial Brand=102,New Products=38},webcatid1={315494=89,28422=49,476=22,481=21,471=18,479=8,30276=5,28524=2,483=2}},facet_ranges={},facet_intervals={},facet_heatmaps={}},debug={facet-debug={elapse=1,sub-facet=[{processor=SimpleFacets,elapse=1,action=field facet,maxThreads=0,sub-facet=[{elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=216,field=spec.981752_ATTR_VA_ID_s,numBuckets=8}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=216,field=brand_name_s,numBuckets=4769}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=216,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=216,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=216,field=webcatid1,numBuckets=410}]}]},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=1.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://dev-solr-0.dev-solr-headless:8983/solr/ImperialItems_shard2_replica_n2/": { "QTime": "2", "ElapsedTime": "14", "RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS", "NumFound": "203", "Response": "{responseHeader={zkConnected=true,status=0,QTime=2,params={df=_text_,distrib=false,preferLocalShards=false,f.spec.981752_ATTR_VA_ID_s.facet.limit=160,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Assortments, -487357_ATTR_attr_s:Yes, -snbFilter_b:true, -itemtype:n],shard.url=http://dev-solr-0.dev-solr-headless:8983/solr/ImperialItems_shard2_replica_n2/,rid=dev-solr-search-0.dev-solr-search-headless-1794529,f.shopBy_s_M.facet.mincount=1,defType=edismax,qf=[id^1.0, prettyid^1.5, cat^1.0, keywords^1.0, webcattext^1.0, name^1.2, shortdesc^1.2, 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, lowFractions^1.5, highFractions^3.0],context=app:ImperialItems,f.brand_name_s.facet.limit=160,shards.preference=replica.type:PULL,f.brand_name_s.facet.mincount=1,wt=javabin,mm=3,facet.field=[spec.981752_ATTR_VA_ID_s, brand_name_s, pkgQty, shopBy_s_M, webcatid1],_stateVer_=ImperialItems:4,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,queryProfileID=LegacySearch,fusionQueryId=7XNwxuN63a,version=2,q=*:*,f.spec.981752_ATTR_VA_ID_s.facet.mincount=1,f.webcatid1.facet.mincount=1,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1680002414417,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=203,numFoundExact=true,start=0,maxScore=1.4173884,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={spec.981752_ATTR_VA_ID_s={VA_Asset_981770=82,VA_Asset_981768=80,VA_Asset_981771=16,VA_Asset_981772=5,VA_Asset_981769=3,VA_Asset_981774=3,VA_Asset_981775=1},brand_name_s={IMPERIAL=97,APPROVED SUPPLIER=33,DISCO=31,ITW BEE LEITZKE=14,AUVECO=7,DEUTSCH=2,OETIKER=2,PRECISION BRAND=2,WEATHER PACK=2,GATES=1,IDEAL=1,KERR LAKESIDE=1,NORTON=1,PERFORMANCE TOOL=1,SCOTCH-BRITE=1},pkgQty={1=201,255=1,265=1},shopBy_s_M={Imperial Brand=97,New Products=36},webcatid1={315494=76,28422=46,476=23,481=23,471=15,30276=10,28524=4,479=3,483=3}},facet_ranges={},facet_intervals={},facet_heatmaps={}},debug={facet-debug={elapse=1,sub-facet=[{processor=SimpleFacets,elapse=1,action=field facet,maxThreads=0,sub-facet=[{elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=203,field=spec.981752_ATTR_VA_ID_s,numBuckets=8}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=203,field=brand_name_s,numBuckets=4751}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=203,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=203,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=203,field=webcatid1,numBuckets=409}]}]},timing={time=2.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=1.0,query={time=0.0},facet={time=1.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": 2, "sub-facet": [ { "processor": "SimpleFacets", "elapse": 1, "action": "field facet", "maxThreads": 0, "sub-facet": [ { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 216, "field": "spec.981752_ATTR_VA_ID_s", "numBuckets": 8 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 216, "field": "brand_name_s", "numBuckets": 4769 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FCS", "inputDocSetSize": 216, "field": "pkgQty" }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 216, "field": "shopBy_s_M", "numBuckets": 4 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 216, "field": "webcatid1", "numBuckets": 410 } ] }, { "processor": "SimpleFacets", "elapse": 1, "action": "field facet", "maxThreads": 0, "sub-facet": [ { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 203, "field": "spec.981752_ATTR_VA_ID_s", "numBuckets": 8 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 203, "field": "brand_name_s", "numBuckets": 4751 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FCS", "inputDocSetSize": 203, "field": "pkgQty" }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 203, "field": "shopBy_s_M", "numBuckets": 4 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 203, "field": "webcatid1", "numBuckets": 409 } ] } ] }, "timing": { "time": 5, "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": 3, "query": { "time": 0 }, "facet": { "time": 2 }, "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", "parsed_boost_queries": [], "explain": {} }, "responseHeader": { "zkConnected": true, "QTime": 16, "totalTime": 35, "params": { "mm": "3", "facet.field": [ "spec.981752_ATTR_VA_ID_s", "brand_name_s", "pkgQty", "shopBy_s_M", "webcatid1" ], "_stateVer_": "ImperialItems:4", "debug": "true", "lw.pipelineId": "LegacySearch", "fl": "brand_name_s,canshipair,catalogNeedAppr_is,categoryPath,catpage,excludeSt_s_M,graMsdsavail_b,GSDP_ID_s,hoverImagePath_s,id,image,imagePath_s,isBestSeller_b,isCat,isdiscontinue,isNew,itemFlagsExcl_s_M,itemID_s,itemQtyLimit_i,listPrice_d,listPriceEa_d,lottracking,msdsavail,name,numItems,ormd,pandemicItem_b,pandemicItemBlocked_b,pkgQty,prettyid,prop65b_b,prop65b_chemicals_s,prop65c_b,prop65c_chemicals_s,sds_s,sdsAssetFileName_s,shortdesc,upsHazard,webcatid,prevPurchased:exists(query({!v=purchasedBy_s_M:undefined}))", "start": "0", "isFusionQuery": "true", "fq": [ "-isWeb:false", "webcatclean0:Assortments", "-487357_ATTR_attr_s:Yes", "-snbFilter_b:true", "-itemtype:n" ], "sort": "score desc,popularity desc,imagePath_s desc,id asc", "rows": "0", "version": "2.2", "queryProfileID": "LegacySearch", "fusionQueryId": "7XNwxuN63a", "q": "*:*", "defType": "edismax", "qf": [ "id^1.0", "prettyid^1.5", "cat^1.0", "keywords^1.0", "webcattext^1.0", "name^1.2", "shortdesc^1.2", "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", "lowFractions^1.5", "highFractions^3.0" ], "context": "app:ImperialItems", "boost": "popmult", "facet.mincount": "1", "shards.preference": "replica.type:PULL", "wt": "json", "facet": [ "true", "true", "true", "true", "true" ] }, "status": 0 } }, "splainerURL": "http://splainer.io/#?solr=http%3A%2F%2Fimperialsupplies-dev.b.lucidworks.cloud%3A443%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%3AAssortments%26facet%3Dtrue%26facet.field%3Dspec.981752_ATTR_VA_ID_s%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%252CgraMsdsavail_b%252CGSDP_ID_s%252ChoverImagePath_s%252Cid%252Cimage%252CimagePath_s%252CisBestSeller_b%252CisCat%252Cisdiscontinue%252CisNew%252CitemFlagsExcl_s_M%252CitemID_s%252CitemQtyLimit_i%252ClistPrice_d%252ClistPriceEa_d%252Clottracking%252Cmsdsavail%252Cname%252CnumItems%252Cormd%252CpandemicItem_b%252CpandemicItemBlocked_b%252CpkgQty%252Cprettyid%252Cprop65b_b%252Cprop65b_chemicals_s%252Cprop65c_b%252Cprop65c_chemicals_s%252Csds_s%252CsdsAssetFileName_s%252Cshortdesc%252CupsHazard%252Cwebcatid%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
Manage Orders
You must
select an account
to see your open orders
Create New Order
View All 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
Full Catalog
Automotive Catalog
New
All Brands
Abrasives
Air Brake
Assortments
Building & Grounds
Chemicals
Cutting & Holemaking Tools
Electrical
Fasteners
Fluid Transfer & Pumps
Furniture & Office Supplies
Hardware
Hose & Hose Ends
HVACR
Hydraulics
Janitorial
Lighting
Material Handling
Paint & Paint Supplies
Pipe, Tubing & Fittings
Plumbing
Pneumatics
Power Transmission
Safety
Steel Equipment & Storage
Tape
Testing & Inspection Tools
Tools
Vehicle & Trailer Parts
Welding
Wheel & Tire
Wiper Blade Finder
Select Vehicle
Emergency Preparedness
Active Shooter
Hurricane
Earthquake
Power Outage
Extreme Heat
Tornado
Fire
Winter Storm
Flooding
View All
Home
All Products
Assortments
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
Abrasive Assortments
(5)
Air Brake Assortments
(11)
Automotive Assortments
(33)
Electrical Assortments
(45)
Fastener Assortments
(95)
Hardware Assortments
(44)
Hose End Assortments
(6)
Portable Assortments
(165)
Tubing & Tube Fitting Assortments
(15)
Automotive Storage Type
No matches found.
Steel Drawer
(172)
Plastic Organizer
(172)
Steel Hole Bin
(31)
Steel Clamp Rack
(8)
Steel Wire Rack
(4)
Steel Drawer Cabinet
(4)
Steel Tilt-Out Cabinet
(1)
Plastic Tray
(1)
Brand
Refine filter
No matches found.
APPROVED SUPPLIER
(72)
AUVECO
(20)
BAND-IT
(2)
DEUTSCH
(2)
DISCO
(69)
GATES
(1)
IDEAL
(1)
IMPERIAL
(199)
ITW BEE LEITZKE
(24)
KERR LAKESIDE
(1)
METRI-PACK
(2)
NORTON
(3)
OETIKER
(2)
PERFORMANCE TOOL
(2)
PRECISION BRAND
(2)
QUICK CABLE
(1)
SCOTCH-BRITE
(1)
WEATHER PACK
(2)
+ See More
Package Quantity
No matches found.
1
(417)
255
(1)
265
(1)
Shop By
No matches found.
Imperial Brand
(199)
New Products
(74)
Assortments ID: 102540
Filter
Portable Assortments
| ID: 1968973
(165)
Electrical Assortments
| ID: 103196
(45)
Hardware Assortments
| ID: 103198
(44)
Fastener Assortments
| ID: 103197
(95)
Air Brake Assortments
| ID: 103194
(11)
Tubing & Tube Fitting Assortments
| ID: 103202
(15)
Automotive Assortments
| ID: 103195
(33)
Hose End Assortments
| ID: 103199
(6)
Abrasive Assortments
| ID: 103193
(5)
