Drill Bits & Extensions, Drilling And Holemaking

Fusion re-written query: `*:*`
Fusion Query ID: `P0hBpaaOYm`
Raw Debug Dump:

{
	"fusionDebug": {
		"debug": {
			"track": {
				"rid": "dev-solr-0.dev-solr-headless-1102445",
				"EXECUTE_QUERY": {
					"http://dev-solr-0.dev-solr-headless:8983/solr/ImperialItems_shard2_replica_n2/": {
						"QTime": "2",
						"ElapsedTime": "3",
						"RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS",
						"NumFound": "1722",
						"Response": "{responseHeader={zkConnected=true,status=0,QTime=2,params={df=_text_,distrib=false,preferLocalShards=false,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Cutting___Holemaking_Tools, webcatclean1:Drilling___Holemaking, webcatclean2:Drill_Bits___Extensions, -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-0.dev-solr-headless-1102445,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,f.webcatid3.facet.mincount=1,mm=3,facet.field=[brand_name_s, pkgQty, shopBy_s_M, webcatid3],_stateVer_=ImperialItems:24,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,queryProfileID=LegacySearch,fusionQueryId=P0hBpaaOYm,version=2,f.webcatid3.facet.limit=160,q=*:*,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1685447036569,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=1722,numFoundExact=true,start=0,maxScore=1.9870431,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={CHICAGO-LATROBE=484,WESTWARD=195,IMPERIAL=146,CLE-LINE=139,DEWALT=139,BOSCH=97,APPROVED SUPPLIER=94,CLEVELAND=82,MILWAUKEE=46,MONSTER=46,VIKING=34,CJT KOOLCARB=29,OSG=28,NORSEMAN=25,HUSQVARNA=19,IRWIN SPEEDBOR=17,IRWIN=16,DIAMOND VANTAGE=13,ROCKY MOUNTAIN TWIST=11,WALTER TITEX=10,KEO=9,B & A=5,BLAIR=2,EAZYPOWER=2,KEYSCO TOOLS=2,M.A. FORD=2,MICRO 100=2,PRECISION TWIST DRILL=2,TAPCON=2,QUICK CABLE=1},pkgQty={1=1451,3=85,6=63,2=33,5=32,12=25,50=12,10=11,25=8,4=1,100=1},shopBy_s_M={Imperial Brand=146,New Products=61,Best Seller=29},webcatid3={30114=732,307926=223,30118=191,302134=99,30116=93,302133=65,247521=53,247523=49,302137=46,307942=30,315804=30,307925=26,302344=16,302347=15,302136=13,271353=10,28912=9,302345=9,276=7,302135=5}},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=1722,field=brand_name_s,numBuckets=4760}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=1722,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=1722,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=1722,field=webcatid3,numBuckets=2801}]}]},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}}}}}"
					},
					"http://dev-solr-search-0.dev-solr-search-headless:8983/solr/ImperialItems_shard1_replica_n1/": {
						"QTime": "3",
						"ElapsedTime": "4",
						"RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS",
						"NumFound": "1744",
						"Response": "{responseHeader={zkConnected=true,status=0,QTime=3,params={df=_text_,distrib=false,preferLocalShards=false,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Cutting___Holemaking_Tools, webcatclean1:Drilling___Holemaking, webcatclean2:Drill_Bits___Extensions, -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-0.dev-solr-headless-1102445,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,f.webcatid3.facet.mincount=1,mm=3,facet.field=[brand_name_s, pkgQty, shopBy_s_M, webcatid3],_stateVer_=ImperialItems:24,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,queryProfileID=LegacySearch,fusionQueryId=P0hBpaaOYm,version=2,f.webcatid3.facet.limit=160,q=*:*,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1685447036569,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=1744,numFoundExact=true,start=0,maxScore=1.9790697,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={CHICAGO-LATROBE=466,WESTWARD=208,CLE-LINE=154,IMPERIAL=151,DEWALT=146,BOSCH=110,APPROVED SUPPLIER=105,MILWAUKEE=58,CLEVELAND=56,MONSTER=39,VIKING=37,CJT KOOLCARB=30,OSG=29,IRWIN=23,NORSEMAN=20,WALTER TITEX=18,DIAMOND VANTAGE=14,IRWIN SPEEDBOR=12,ROCKY MOUNTAIN TWIST=10,HUSQVARNA=7,KEO=6,TAPCON=5,EAZYPOWER=4,BLAIR=2,KYOCERA=2,B & A=1,DEWALT ENGINEERED BY POWERS=1,DIVERSIFIED FASTENING SYSTEMS=1,KLEIN TOOLS=1,M.A. FORD=1,POWERS FASTENERS=1,WIDIA=1,YG-1 TOOL COMPANY=1},pkgQty={1=1490,3=93,6=49,5=41,2=19,12=19,10=15,50=13,25=4,4=1},shopBy_s_M={Imperial Brand=151,New Products=61,Best Seller=20},webcatid3={30114=724,307926=240,30118=194,302134=113,30116=86,247521=61,302137=56,302133=55,247523=48,315804=39,307925=29,307942=26,302347=16,271353=10,302136=9,302344=9,302345=9,302135=8,276=6,28912=3}},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=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=1744,field=brand_name_s,numBuckets=4778}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=1744,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=1744,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=1744,field=webcatid3,numBuckets=2800}]}]},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}}}}}"
					}
				}
			},
			"facet-debug": {
				"elapse": 3,
				"sub-facet": [
					{
						"processor": "SimpleFacets",
						"elapse": 1,
						"action": "field facet",
						"maxThreads": 0,
						"sub-facet": [
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 1722,
								"field": "brand_name_s",
								"numBuckets": 4760
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FCS",
								"inputDocSetSize": 1722,
								"field": "pkgQty"
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 1722,
								"field": "shopBy_s_M",
								"numBuckets": 4
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 1722,
								"field": "webcatid3",
								"numBuckets": 2801
							}
						]
					},
					{
						"processor": "SimpleFacets",
						"elapse": 2,
						"action": "field facet",
						"maxThreads": 0,
						"sub-facet": [
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 1744,
								"field": "brand_name_s",
								"numBuckets": 4778
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FCS",
								"inputDocSetSize": 1744,
								"field": "pkgQty"
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 1744,
								"field": "shopBy_s_M",
								"numBuckets": 4
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 1744,
								"field": "webcatid3",
								"numBuckets": 2800
							}
						]
					}
				]
			},
			"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": 3
					},
					"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": 5,
			"totalTime": 19,
			"params": {
				"mm": "3",
				"facet.field": [
					"brand_name_s",
					"pkgQty",
					"shopBy_s_M",
					"webcatid3"
				],
				"_stateVer_": "ImperialItems:24",
				"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:Cutting___Holemaking_Tools",
					"webcatclean1:Drilling___Holemaking",
					"webcatclean2:Drill_Bits___Extensions",
					"-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": "P0hBpaaOYm",
				"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"
			},
			"status": 0
		}
	},
	"legacyQueryDebug": true
}

Drill Bits & Extensions ID: 103107