Cutting Tools | Imperial Supplies

Splainer Link
Fusion re-written query: `*:*`
Fusion Query ID: `Uo8kIXGkzG`
Raw Debug Dump:

{
	"fusionDebug": {
		"debug": {
			"track": {
				"rid": "dev-solr-0.dev-solr-headless-1257369",
				"EXECUTE_QUERY": {
					"http://dev-solr-0.dev-solr-headless:8983/solr/ImperialItems_shard2_replica_n2/": {
						"QTime": "7",
						"ElapsedTime": "8",
						"RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS",
						"NumFound": "3378",
						"Response": "{responseHeader={zkConnected=true,status=0,QTime=7,params={df=_text_,distrib=false,preferLocalShards=false,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Cutting___Holemaking_Tools, -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-1257369,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=Uo8kIXGkzG,version=2,q=*:*,f.webcatid1.facet.mincount=1,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1679481185260,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=3378,numFoundExact=true,start=0,maxScore=1.9853431,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={CHICAGO-LATROBE=513,APPROVED SUPPLIER=308,WESTWARD=306,OSG=244,WIDIA GTD=201,CLEVELAND=188,CLE-LINE=161,DEWALT=161,IMPERIAL=157,GREENFIELD THREADING=120,KEO=108,BOSCH=102,MONSTER=73,IRWIN HANSON=54,MILWAUKEE=54,INNOVATIVE COMPONENTS=37,WALTER PROTOTYP=36,VIKING=34,CJT KOOLCARB=29,JACOBS=28,NORSEMAN=26,DAYTON=24,IRWIN=22,YANKEE=22,NORTH AMERICAN=20,IRWIN SPEEDBOR=19,KIPP=18,HUOT=17,HUSQVARNA=16,MICRO 100=15,TE-CO=12,ROCKY MOUNTAIN TWIST=11,DIAMOND VANTAGE=10,WALTER TITEX=10,YG-1 TOOL COMPANY=10,SUPER TOOL=9,DAVIES=8,GRAY=7,PROTO=7,B & A=6,GEARWRENCH=6,GREENLEE=6,ALDEN=5,DAKE CORPORATION=5,DE-STA-CO=5,EAZYPOWER=5,HEIN-WERNER=5,RECOIL=5,ULTRA-DEX USA=5,VERMONT AMERICAN=5,ENERPAC=4,JET=4,SCIENTIFIC CUTTING TOOLS=4,SUMITOMO=4,WILTON=4,BAILEIGH INDUSTRIAL=3,DRILL DOCTOR=3,GENERAL=3,HELICOIL=3,LLAMBRICH USA=3,PALMGREN=3,PRECISION TWIST DRILL=3,REPAR=3,SOCK IT OUT=3,TALON PRECISION TOOLING=3,WALTER=3,ADVANTAGE PLUS=2,CENTURY DRILL AND TOOL=2,DORIAN=2,ECONOLINE=2,EDWARDS=2,HASSAY SAVAGE CO.=2,KEYSCO TOOLS=2,M.A. FORD=2,RIDGID=2,SGS TOOL=2,SHINN FU=2,STARRETT=2,SUBURBAN=2,TAPCON=2,TAPMATIC=2,TECHNIKS=2,TITAN=2,WIDIA HANITA=2,BLAIR=1,DAREX=1,GENERAL TOOLS=1,H & R MFG=1,HYDRO-HANDLE=1,KLEIN TOOLS=1,KYOCERA=1,LYNDEX-NIKKEN=1,MELIN TOOL COMPANY=1,MSSC=1,NICHOLSON=1,PARLEC=1,ROYAL PRODUCTS=1,WALTER VALENITE=1,WIDIA=1,WORK SHARP=1},pkgQty={1=3070,3=91,6=69,5=37,2=36,12=33,10=18,50=12,25=8,4=2,7=1,100=1},shopBy_s_M={Imperial Brand=157,New Products=90,Best Seller=30},webcatid1={303655=2057,302556=980,302645=136,302577=85,302565=51,302735=32,302608=15,302753=11,302624=10,302749=1}},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=3378,field=brand_name_s,numBuckets=4751}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=3378,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=3378,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=3378,field=webcatid1,numBuckets=409}]}]},timing={time=7.0,prepare={time=1.0,query={time=1.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=5.0,query={time=2.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://dev-solr-search-0.dev-solr-search-headless:8983/solr/ImperialItems_shard1_replica_n1/": {
						"QTime": "6",
						"ElapsedTime": "8",
						"RequestPurpose": "GET_TOP_IDS,GET_FACETS,SET_TERM_STATS",
						"NumFound": "3386",
						"Response": "{responseHeader={zkConnected=true,status=0,QTime=6,params={df=_text_,distrib=false,preferLocalShards=false,fl=[id, score],shards.purpose=16404,fsv=true,fq=[-isWeb:false, webcatclean0:Cutting___Holemaking_Tools, -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-1257369,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=Uo8kIXGkzG,version=2,q=*:*,f.webcatid1.facet.mincount=1,omitHeader=false,requestPurpose=GET_TOP_IDS,GET_FACETS,SET_TERM_STATS,NOW=1679481185260,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=3386,numFoundExact=true,start=0,maxScore=1.9770154,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={CHICAGO-LATROBE=487,WESTWARD=365,APPROVED SUPPLIER=300,OSG=250,WIDIA GTD=195,CLE-LINE=174,CLEVELAND=157,DEWALT=157,IMPERIAL=156,GREENFIELD THREADING=145,BOSCH=120,KEO=87,MILWAUKEE=69,MONSTER=61,IRWIN HANSON=50,WALTER PROTOTYP=44,IRWIN=40,VIKING=37,INNOVATIVE COMPONENTS=36,CJT KOOLCARB=30,NORSEMAN=24,YANKEE=21,HUOT=19,MICRO 100=18,KIPP=16,WALTER TITEX=16,JACOBS=13,NORTH AMERICAN=13,EAZYPOWER=12,IRWIN SPEEDBOR=12,TE-CO=12,VERMONT AMERICAN=11,ROCKY MOUNTAIN TWIST=10,DAVIES=9,DAYTON=9,HEIN-WERNER=8,DIAMOND VANTAGE=7,ENERPAC=7,WILTON=7,DE-STA-CO=6,HELICOIL=6,YG-1 TOOL COMPANY=6,B & A=5,GEARWRENCH=5,GREENLEE=5,HUSQVARNA=5,PALMGREN=5,PROTO=5,RECOIL=5,STARRETT=5,TAPCON=5,ALDEN=4,DAKE CORPORATION=4,DRILL DOCTOR=4,GENERAL=4,OTC=4,SOCK IT OUT=4,SUPER TOOL=4,BAILEIGH INDUSTRIAL=3,DORIAN=3,HASSAY SAVAGE CO.=3,RIDGID=3,SGS TOOL=3,SUMITOMO=3,ULTRA-DEX USA=3,ARTU=2,BLAIR=2,DAREX=2,EMUGE=2,FACOM=2,KYOCERA=2,LLAMBRICH USA=2,PARLEC=2,SUBURBAN=2,80/20 INC=1,ADVANTAGE PLUS=1,CENTURY DRILL AND TOOL=1,DEWALT ENGINEERED BY POWERS=1,DIVERSIFIED FASTENING SYSTEMS=1,DREMEL=1,ECHO=1,ECONOLINE=1,EXTRACT-ALL=1,GRAY=1,H & R MFG=1,HECK INDUSTRIES=1,HELI-COIL=1,JET=1,JET ELITE=1,KLEIN TOOLS=1,LENOX=1,LYNDEX-NIKKEN=1,M.A. FORD=1,MALCO=1,MITUTOYO=1,ONSRUD=1,PFERD=1,PORTER CABLE=1,POWERS FASTENERS=1,REGAL=1,REPAR=1,SANDVIK COROMANT=1,SHINN FU=1,TAPMATIC=1,TECHNIKS=1,TIGER=1,WALTER=1,WALTER VALENITE=1,WIDIA=1,WIDIA METAL REMOVAL=1},pkgQty={1=3089,3=104,6=52,5=51,2=23,10=23,12=23,50=13,25=6,4=2},shopBy_s_M={Imperial Brand=156,New Products=92,Best Seller=20},webcatid1={303655=2048,302556=1023,302645=130,302577=81,302565=47,302608=23,302735=17,302753=8,302749=6,302624=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=3386,field=brand_name_s,numBuckets=4769}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=3386,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=3386,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=3386,field=webcatid1,numBuckets=410}]}]},timing={time=6.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=5.0,query={time=2.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": 4,
				"sub-facet": [
					{
						"processor": "SimpleFacets",
						"elapse": 2,
						"action": "field facet",
						"maxThreads": 0,
						"sub-facet": [
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3378,
								"field": "brand_name_s",
								"numBuckets": 4751
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FCS",
								"inputDocSetSize": 3378,
								"field": "pkgQty"
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3378,
								"field": "shopBy_s_M",
								"numBuckets": 4
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3378,
								"field": "webcatid1",
								"numBuckets": 409
							}
						]
					},
					{
						"processor": "SimpleFacets",
						"elapse": 2,
						"action": "field facet",
						"maxThreads": 0,
						"sub-facet": [
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3386,
								"field": "brand_name_s",
								"numBuckets": 4769
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FCS",
								"inputDocSetSize": 3386,
								"field": "pkgQty"
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3386,
								"field": "shopBy_s_M",
								"numBuckets": 4
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3386,
								"field": "webcatid1",
								"numBuckets": 410
							}
						]
					}
				]
			},
			"timing": {
				"time": 13,
				"prepare": {
					"time": 1,
					"query": {
						"time": 1
					},
					"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": 10,
					"query": {
						"time": 4
					},
					"facet": {
						"time": 4
					},
					"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": 11,
			"totalTime": 28,
			"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:Cutting___Holemaking_Tools",
					"-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": "Uo8kIXGkzG",
				"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%3ACutting___Holemaking_Tools%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
}

Orders

Manage Orders

Cutting Tools ID: 102531