Fusion Debug Info
Splainer Link
Fusion re-written query: `*:*`
Fusion Query ID: `2KIaPsXjbQ`
Raw Debug Dump:
{ "fusionDebug": { "debug": { "track": { "rid": "dev-solr-search-0.dev-solr-search-headless-1545152", "EXECUTE_QUERY": { "http://dev-solr-search-0.dev-solr-search-headless:8983/solr/ImperialItems_shard1_replica_n1/": { "QTime": "4", "ElapsedTime": "5", "RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS", "NumFound": "483", "Response": "{responseHeader={zkConnected=true,status=0,QTime=4,params={df=_text_,distrib=false,preferLocalShards=false,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Hose___Hose_Ends, -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-1545152,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=[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=2KIaPsXjbQ,version=2,q=*:*,f.webcatid1.facet.mincount=1,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1679755653671,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=483,numFoundExact=true,start=0,maxScore=1.6422385,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={APPROVED SUPPLIER=265,EATON=101,HI-TECH DURAVENT=24,GATES=20,DIXON VALVE & COUPLING=7,MILTON=6,PARKER=6,FLEXTECH=5,THERMOID=5,CONTINENTAL=4,EATON AEROQUIP=4,SNAP-TITE=4,DAYCO=2,DAYTON=2,SUR&R=2,VELVAC=2,CONTINENTAL CONTITECH=1,COXREELS=1,DETROIT FLEX DEFENSE=1,DIXON=1,EATON HANSEN=1,GUARDIAN EQUIPMENT=1,KURIYAMA=1,PARKER HANNIFIN=1},pkgQty={1=215,5=70,10=66,50=36,25=29,3=23,2=14,250=13,100=6,150=3,200=3,6=1,12=1,15=1,300=1,550=1},shopBy_s_M={New Products=6,Best Seller=3},webcatid1={29396=175,29440=161,29799=66,30256=37,29959=33,29950=11}},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=483,field=brand_name_s,numBuckets=4769}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=483,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=483,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=483,field=webcatid1,numBuckets=410}]}]},timing={time=4.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=2.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": "4", "ElapsedTime": "6", "RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS", "NumFound": "483", "Response": "{responseHeader={zkConnected=true,status=0,QTime=4,params={df=_text_,distrib=false,preferLocalShards=false,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Hose___Hose_Ends, -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-1545152,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=[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=2KIaPsXjbQ,version=2,q=*:*,f.webcatid1.facet.mincount=1,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1679755653671,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=483,numFoundExact=true,start=0,maxScore=1.5259827,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={APPROVED SUPPLIER=233,EATON=111,HI-TECH DURAVENT=32,GATES=25,FLEXTECH=10,PARKER=9,DAYCO=6,THERMOID=6,DIXON VALVE & COUPLING=5,EATON AEROQUIP=4,SNAP-TITE=3,SUR&R=3,EATON HANSEN=2,SAFEWAY HYDRAULICS=2,VELVAC=2,CONTINENTAL=1,DAYTON=1,DETROIT FLEX DEFENSE=1,EATON WEATHERHEAD=1,MILTON=1,NOVAFLEX=1,PARKER HANNIFIN=1,PREVOST=1},pkgQty={1=233,50=56,10=53,5=51,25=25,3=22,2=14,250=11,100=9,6=3,200=3,15=1,300=1,550=1},shopBy_s_M={New Products=6,Best Seller=1},webcatid1={29396=206,29440=146,29799=64,30256=30,29959=24,29950=13}},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=483,field=brand_name_s,numBuckets=4751}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=483,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=483,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=483,field=webcatid1,numBuckets=409}]}]},timing={time=4.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=2.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": 483, "field": "brand_name_s", "numBuckets": 4769 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FCS", "inputDocSetSize": 483, "field": "pkgQty" }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 483, "field": "shopBy_s_M", "numBuckets": 4 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 483, "field": "webcatid1", "numBuckets": 410 } ] }, { "processor": "SimpleFacets", "elapse": 1, "action": "field facet", "maxThreads": 0, "sub-facet": [ { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 483, "field": "brand_name_s", "numBuckets": 4751 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FCS", "inputDocSetSize": 483, "field": "pkgQty" }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 483, "field": "shopBy_s_M", "numBuckets": 4 }, { "elapse": 0, "requestedMethod": "not specified", "appliedMethod": "FC", "inputDocSetSize": 483, "field": "webcatid1", "numBuckets": 409 } ] } ] }, "timing": { "time": 8, "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": 6, "query": { "time": 4 }, "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": 8, "totalTime": 24, "params": { "mm": "3", "facet.field": [ "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:Hose___Hose_Ends", "-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": "2KIaPsXjbQ", "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" ] }, "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%3AHose___Hose_Ends%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
Hose & Hose Ends
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
Barbed Fittings
(57)
Couplers
(130)
Hose Accessories
(24)
Hose Ends
(307)
Hoses
(381)
Vacuum Connectors
(67)
Brand
Refine filter
No matches found.
APPROVED SUPPLIER
(498)
CONTINENTAL
(5)
CONTINENTAL CONTITECH
(1)
COXREELS
(1)
DAYCO
(8)
DAYTON
(3)
DETROIT FLEX DEFENSE
(2)
DIXON
(1)
DIXON VALVE & COUPLING
(12)
EATON
(212)
EATON AEROQUIP
(8)
EATON HANSEN
(3)
EATON WEATHERHEAD
(1)
FLEXTECH
(15)
GATES
(45)
GUARDIAN EQUIPMENT
(1)
HI-TECH DURAVENT
(56)
KURIYAMA
(1)
MILTON
(7)
NOVAFLEX
(1)
PARKER
(15)
PARKER HANNIFIN
(2)
PREVOST
(1)
SAFEWAY HYDRAULICS
(2)
SNAP-TITE
(7)
SUR&R
(5)
THERMOID
(11)
VELVAC
(4)
+ See More
Package Quantity
Refine filter
No matches found.
1
(448)
2
(28)
3
(45)
5
(121)
6
(4)
10
(119)
12
(1)
15
(2)
25
(54)
50
(92)
100
(15)
150
(3)
200
(6)
250
(24)
300
(2)
550
(2)
+ See More
Shop By
No matches found.
Best Seller
(4)
New Products
(12)
Hose & Hose Ends ID: 102530
Filter
Popular Categories
Hoses
| ID: 103095
(381)
Coolant Hose
Fuel Hose
Truck Hydraulic Hose
Hose Ends
| ID: 103097
(307)
Reusable/Field Attachable Hose Ends
EZ-Clip System
PTFE Hose Ends
Barbed Fittings
| ID: 103093
(57)
Coolant Fittings
Fuel Fittings
Vacuum Connectors
| ID: 103099
(67)
Nylon Vacuum Connectors
Vacuum Caps
Plastic Vacuum Connectors
Additional Categories
Couplers
| ID: 103094
(130)
Hose Accessories
| ID: 103096
(24)
