Lighting | Imperial Supplies

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

{
	"fusionDebug": {
		"debug": {
			"track": {
				"rid": "10.50.205.208-MongoImperialItems_shard2_replica_n2-1656871888512-1383",
				"EXECUTE_QUERY": {
					"http://10.50.205.209:8983/solr/MongoImperialItems_shard1_replica_n1/": {
						"QTime": "3",
						"ElapsedTime": "5",
						"RequestPurpose": "GET_TOP_IDS,GET_FACETS",
						"NumFound": "3010",
						"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:Lighting, -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.208-MongoImperialItems_shard2_replica_n2-1656871888512-1383,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=NF4n4LugUF,version=2,q=*:*,f.webcatid1.facet.mincount=1,requestPurpose=GET_TOP_IDS,GET_FACETS,NOW=1656871888512,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=3010,start=0,maxScore=1.992721,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={GROTE=444,TRUCK-LITE=407,APPROVED SUPPLIER=280,LUMAPRO=203,GE LIGHTING=181,ECCO=121,IMPERIAL=117,MAXXIMA=110,PETERSON=105,STREAMLIGHT=90,PHILIPS=73,ACUITY LITHONIA=63,TUNGSRAM=59,BETTS=57,FEDERAL SIGNAL=53,LITHONIA LIGHTING=44,ORALITE=42,PHILIPS ADVANCE=42,3M=36,SYLVANIA=28,MILWAUKEE=24,J.W. SPEAKER=15,REFLEX=15,CODE 3=13,PRINCETON TEC=12,SHAT-R-SHIELD=12,PELICAN=11,RECYCLEPAK=10,GOLIGHT=9,BAYCO=7,HUBBELL WIRING DEVICE-KELLEMS=7,RAILHEAD GEAR=7,BUYERS PRODUCTS=6,HUBBELL LIGHTING - COLUMBIA=6,HUBBELL LIGHTING - OUTDOOR=6,KANDE SAFETY=6,LUTRON=6,NIGHTSTICK=6,SCHNEIDER ELECTRIC=6,ABILITY ONE=5,DEWALT=5,EDWARDS SIGNALING=5,HUBBELL LIGHTING - DUAL-LITE=5,NITE IZE=5,TRIDON=5,APPLETON ELECTRIC=4,FENIX LIGHTING=4,FULHAM WORKHORSE=4,K&E SAFETY=4,LIGHT EFFICIENT DESIGN=4,MAKITA=4,MAXLED=4,RADIONIC HI-TECH=4,WALDMANN=4,WOLO=4,ADVANCE=3,BRIGHT STAR=3,CEP=3,EMI=3,ENERGIZER=3,FULHAM FIREHORSE EMERGENCY LIGHTING=3,KH INDUSTRIES=3,KILLARK=3,MAGLITE=3,POLYMERSHAPES=3,REESE=3,SNAPLIGHT BY CYALUME TECHNOLOGIES=3,STUBBY=3,AIR CYCLE=2,BRITE-STRIKE=2,DESIGNERS EDGE=2,DIAMOND GRADE=2,EVERLIGHTS=2,HANG-A-LIGHT=2,HUBBELL LIGHTING - COMPASS=2,LENOX=2,LYLE=2,PHILIPS LIGHTOLIER=2,PSE AMBER=2,QUANTUM STORAGE SYSTEMS=2,REELCRAFT=2,SUPPLYPAK=2,UNGER=2,VISION-LUXO=2,8:12 ILLUMINATION=1,ACUITY SENSOR SWITCH=1,AUVECO=1,B-LINE BY EATON=1,BAYCO PRODUCTS INC=1,BOSCH=1,BUDGIT=1,BUSSMANN=1,CHEMLIGHT BY CYALUME TECHNOLOGIES=1,CRC=1,DAYTON=1,DEFENDER=1,DISCO AUTOMOTIVE=1,EATON=1,GE=1,GENERAL ELECTRIC=1,HAMSAR=1,HUBBELL LIGHTING - KIM=1,HUBBELL LIGHTING - PRESCOLITE=1,HUBBELL LIGHTING - SPAULDING=1,K&E GEAR=1,KLEIN TOOLS=1,LABELMASTER=1,LARSON ELECTRONICS LLC=1,LIND EQUIPMENT=1,LITHONIA=1,LITTELFUSE=1,MAESTRO=1,MAGNAFLUX=1,MAGSAFE=1,MINIPOD=1,NARROWSTICK=1,NIC=1,O.C. WHITE=1,PHILIPS BURTON=1,PROLIGHT=1,PULSE II=1,RADIONIC INDUSTRIES=1,RAYOVAC=1,ROADPRO=1,SAFETY DIRECTOR=1,SATCO=1,SIEMENS=1,SOUTHWIRE=1,SQUARE D=1,STINGER=1,STRYKER=1,SUREFIRE=1,TAPCO=1,TAYMAC=1,TRACERLINE=1,VANTAGE=1,W F HARRIS LIGHTING=1,WARNER TOOL PRODUCTS=1,WHELEN=1,WOBBLE LIGHT=1},pkgQty={1=2383,10=237,2=135,6=60,5=34,24=21,30=20,12=19,4=18,36=15,40=14,25=13,15=11,100=10,20=8,50=5,3=4,48=3},shopBy_s_M={New Products=136,Imperial Brand=117,Best Seller=54},webcatid1={313047=1916,313045=456,313043=318,313042=117,313046=91,313044=46,199936=44,199913=9,199865=8,461=5}},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=3010,field=brand_name_s,numBuckets=4273}, {elapse=0,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=3010,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=3010,field=shopBy_s_M,numBuckets=4}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=3010,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": "5",
						"ElapsedTime": "7",
						"RequestPurpose": "GET_TOP_IDS,GET_FACETS",
						"NumFound": "2983",
						"Response": "{responseHeader={zkConnected=true,status=0,QTime=5,params={df=_text_,distrib=false,fl=[id, score],shards.purpose=20,fsv=true,fq=[-isWeb:false, webcatclean0:Lighting, -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.208-MongoImperialItems_shard2_replica_n2-1656871888512-1383,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=NF4n4LugUF,version=2,q=*:*,f.webcatid1.facet.mincount=1,requestPurpose=GET_TOP_IDS,GET_FACETS,NOW=1656871888512,isShard=true,boost=popmult,facet=true,debugQuery=false,f.pkgQty.facet.limit=160}},response={numFound=2983,start=0,maxScore=1.9760832,docs=[]},sort_values={popularity=[],imagePath_s=[],id=[]},facet_counts={facet_queries={},facet_fields={brand_name_s={TRUCK-LITE=423,GROTE=416,APPROVED SUPPLIER=282,LUMAPRO=217,GE LIGHTING=144,ECCO=109,IMPERIAL=109,MAXXIMA=103,PETERSON=101,TUNGSRAM=83,STREAMLIGHT=78,ACUITY LITHONIA=77,PHILIPS=64,BETTS=46,LITHONIA LIGHTING=43,ORALITE=40,3M=38,FEDERAL SIGNAL=38,PHILIPS ADVANCE=36,MILWAUKEE=31,SYLVANIA=31,HUBBELL LIGHTING - COLUMBIA=15,LUTRON=15,SHAT-R-SHIELD=15,BUYERS PRODUCTS=13,BAYCO=11,CODE 3=10,J.W. SPEAKER=10,RAILHEAD GEAR=10,RECYCLEPAK=10,ENERGIZER=9,HUBBELL WIRING DEVICE-KELLEMS=9,REFLEX=9,DEWALT=8,EDWARDS SIGNALING=8,GOLIGHT=8,PELICAN=8,PRINCETON TEC=8,AERO-TECH=7,DIAMOND GRADE=7,FENIX LIGHTING=7,PROLIGHT=7,SCHNEIDER ELECTRIC=7,WOBBLE LIGHT=7,ADVANCE=6,KANDE SAFETY=6,RADIONIC HI-TECH=6,HUBBELL LIGHTING - DUAL-LITE=5,HUBBELL LIGHTING - OUTDOOR=5,LIGHT EFFICIENT DESIGN=5,CEP=4,HAMSAR=4,LARSON ELECTRONICS LLC=4,PSE AMBER=4,ROADPRO=4,TRIDON=4,VANTAGE=4,ACUITY SENSOR SWITCH=3,AVEN=3,FULHAM WORKHORSE=3,KH INDUSTRIES=3,LENOX=3,PHILIPS-BODINE=3,SIEMENS=3,TAPCO=3,ABILITY ONE=2,BIG BEAM=2,BRIGHT STAR=2,DEPO=2,DESIGNERS EDGE=2,EATON=2,EMI=2,FULHAM FIREHORSE EMERGENCY LIGHTING=2,HUBBELL LIGHTING - COMPASS=2,K&E SAFETY=2,KILLARK=2,MAGLITE=2,MAKITA=2,MAXLED=2,NIGHTSTICK=2,POLYMERSHAPES=2,REFLEXITE=2,SATCO=2,SNAPLIGHT BY CYALUME TECHNOLOGIES=2,STUBBY=2,SUREFIRE=2,TAYMAC=2,ULLMAN=2,WERMA=2,WOLO=2,YELLOW JACKET=2,ACUITY BRANDS=1,AMERICAN RED CROSS=1,BAYCO PRODUCTS INC=1,BOSCH=1,CADDY=1,CHEMLIGHT BY CYALUME TECHNOLOGIES=1,DAYTON=1,DISCO AUTOMOTIVE=1,EIKO=1,EVERLIGHTS=1,FLUKE=1,GE=1,GENERAL ELECTRIC=1,HANG-A-LIGHT=1,HELLA=1,HUBBELL LIGHTING - KIM=1,JUNO LIGHTING GROUP - JUNO TRAC-LITES=1,K&E GEAR=1,KLEIN TOOLS=1,LEXAN=1,LITHONIA=1,LYLE=1,MATERIAL HANDLING=1,NARROWSTICK=1,NITE IZE=1,OLD WORLD=1,OPTRONICS=1,OTC=1,PANASONIC=1,PHILIPS BURTON=1,PHILLIPS=1,PODLIGHT=1,PORTER CABLE=1,PROBUILT=1,PROGRESS LIGHTING=1,RCA=1,REESE=1,RIVERSIDE MFG.=1,SAFETY TECHNOLOGY INTERNATIONAL=1,STANLEY=1,SUPPLYPAK=1,UNGER=1,W F HARRIS LIGHTING=1,WALDMANN=1},pkgQty={1=2364,10=268,2=119,6=47,5=44,12=21,40=19,20=17,30=17,4=14,24=13,50=10,36=7,15=6,3=5,25=5,100=3,8=2,48=1,500=1},shopBy_s_M={New Products=122,Imperial Brand=109,Best Seller=78},webcatid1={313047=1906,313045=440,313043=301,313042=148,313046=105,199936=38,313044=30,199865=5,199913=5,461=5}},facet_ranges={},facet_intervals={},facet_heatmaps={}},debug={facet-debug={elapse=5,sub-facet=[{processor=SimpleFacets,elapse=5,action=field facet,maxThreads=0,sub-facet=[{elapse=1,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2983,field=brand_name_s,numBuckets=4300}, {elapse=1,requestedMethod=not specified,appliedMethod=FCS,inputDocSetSize=2983,field=pkgQty}, {elapse=0,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2983,field=shopBy_s_M,numBuckets=4}, {elapse=1,requestedMethod=not specified,appliedMethod=FC,inputDocSetSize=2983,field=webcatid1,numBuckets=405}]}]},timing={time=5.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=0.0},facet={time=5.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": 7,
				"sub-facet": [
					{
						"processor": "SimpleFacets",
						"elapse": 2,
						"action": "field facet",
						"maxThreads": 0,
						"sub-facet": [
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3010,
								"field": "brand_name_s",
								"numBuckets": 4273
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FCS",
								"inputDocSetSize": 3010,
								"field": "pkgQty"
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3010,
								"field": "shopBy_s_M",
								"numBuckets": 4
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 3010,
								"field": "webcatid1",
								"numBuckets": 409
							}
						]
					},
					{
						"processor": "SimpleFacets",
						"elapse": 5,
						"action": "field facet",
						"maxThreads": 0,
						"sub-facet": [
							{
								"elapse": 1,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 2983,
								"field": "brand_name_s",
								"numBuckets": 4300
							},
							{
								"elapse": 1,
								"requestedMethod": "not specified",
								"appliedMethod": "FCS",
								"inputDocSetSize": 2983,
								"field": "pkgQty"
							},
							{
								"elapse": 0,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 2983,
								"field": "shopBy_s_M",
								"numBuckets": 4
							},
							{
								"elapse": 1,
								"requestedMethod": "not specified",
								"appliedMethod": "FC",
								"inputDocSetSize": 2983,
								"field": "webcatid1",
								"numBuckets": 405
							}
						]
					}
				]
			},
			"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": 7,
					"query": {
						"time": 0
					},
					"facet": {
						"time": 7
					},
					"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": 9,
			"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:Lighting",
					"-487357_ATTR_attr_s:Yes",
					"-snbFilter_b:true",
					"-itemtype:n"
				],
				"sort": "score desc,popularity desc,imagePath_s desc,id asc",
				"rows": "0",
				"fusionQueryId": "NF4n4LugUF",
				"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": 17
		}
	},
	"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%3ALighting%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
}

Lighting ID: I_PCR_399476