Barr

dominant category: 15273 Exercise & Fitness
inferred category: 0
query frequency: 6417
total clicks: 3293

Search request Module
site_id = 3 and profileId = 2471
Profile tracker id: Pr2471_5_Ed103_1_Ed107_3
Profile Expression: Pr3(((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,20000,1000000),BMSCALE(IF(LT(UKScore3,10000),10000,1000000),10000,1000000,10000,1000000),1000000,0))((),BMMUL(BMSCALE(ADD(MUL(EXPRLIST(VARSET(si,BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,2000000,0)),IF(LE(VARUSE(si),0),VARSET(f,0),IF(GE(VARUSE(si),2000000),VARSET(f,1),IF(LE(VARUSE(si),70989),EXPRLIST(VARSET(f,2),VARSET(min,0),VARSET(max,70989),VARSET(off,0)),IF(LE(VARUSE(si),115874),EXPRLIST(VARSET(f,2),VARSET(min,70989),VARSET(max,115874),VARSET(off,100)),IF(LE(VARUSE(si),169894),EXPRLIST(VARSET(f,2),VARSET(min,115874),VARSET(max,169894),VARSET(off,200)),IF(LE(VARUSE(si),216919),EXPRLIST(VARSET(f,2),VARSET(min,169894),VARSET(max,216919),VARSET(off,300)),IF(LE(VARUSE(si),293255),EXPRLIST(VARSET(f,2),VARSET(min,216919),VARSET(max,293255),VARSET(off,400)),IF(LE(VARUSE(si),376647),EXPRLIST(VARSET(f,2),VARSET(min,293255),VARSET(max,376647),VARSET(off,500)),IF(LE(VARUSE(si),476644),EXPRLIST(VARSET(f,2),VARSET(min,376647),VARSET(max,476644),VARSET(off,600)),IF(LE(VARUSE(si),636942),EXPRLIST(VARSET(f,2),VARSET(min,476644),VARSET(max,636942),VARSET(off,700)),IF(LE(VARUSE(si),852272),EXPRLIST(VARSET(f,2),VARSET(min,636942),VARSET(max,852272),VARSET(off,800)),EXPRLIST(VARSET(f,2),VARSET(min,852272),VARSET(max,2000000),VARSET(off,900))))))))))))),IF(EQ(VARUSE(f),0),0,IF(EQ(VARUSE(f),1),999,ADD(BMDIV(SUB(VARUSE(si),VARUSE(min)),SUB(VARUSE(max),VARUSE(min)),99,0,99,1),VARUSE(off))))),1000000),MUL(BMNORM(BMDIV(DecayedViewItemCount,MAX(1,DecayedImpressionCount),100000,0,100000,100000),100,9999,0,12500),100),BMNORM(DecayedSalesCount,100,99,0,71)),0,999999999,20000,1000000),BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,400000,600000),BMSCALE(IF(EQ(MACRO(FreeShippingInSite,$SiteId$),1),1010000,1000000),1000000,1010000,1000000,1010000),BMSCALE(IF(GT(UKScore3,10000),1100000,IF(LT(UKScore3,10000),10000,1000000)),10000,1100000,10000,1100000),1000000,0)))

site_id = 3 and profileId = 1145
Cannot find profileTrackerId. Look up again for SiteId= -1
Profile tracker id: Pr1145_1
Profile Expression: Pr(TitleRel(100))

site_id = 3 and profileId = 1145
Cannot find profileTrackerId. Look up again for SiteId= -1
Profile tracker id: Pr1145_1
Profile Expression: Pr(TitleRel(100))

Query : barr
Url : http://sibeclassic-qry-sqw-001.vip.ebay.com:9090/koios?Qy=barr&Si=3&Aq=0.9&Vr=2&Sr=SIFFTAS+KWNV&Rf=0&Rl=0&Sq=0&Qr=Barr
Query : barr
Url : http://sibeclassic-qry-sqw-001.vip.ebay.com:9090/koios?Qy=barr&Si=3&Aq=0.0&Vr=2&Sr=SERENDIP&Rf=5&Rl=5&Sq=0&Qr=Barr&Ca=11232

• SearchQuery:AND(MACRO(ShowInSite5,3,8),MACRO(MskuView,1),EQ(AllCats,11232),bar,LE(SafeStartTime,NOW),GT(EndTime,NOW))
• CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C3%2C8%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C11232%29%2Cbar%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%29&Sp=&Nr=0&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+Ctry+SHIPCALC%28Fu%2CFa%2C3%2C0%2C0%2C2147483647%2C5%29+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Qi=%3A%3A%3A%3A:1259440114_0x9510.7.95.78:sq-wshop268:dvd-video.shop.ebay.co.uk:v3shopintl
• SearchIndex:ExpressSale
• BackendHost:sqwsn-stitle003+sqwsn-stitle852+sqwsn-stitle855+sqwsn-stitle949+sqwsn-stitle052+sqwsn-stitle861+sqwsn-stitle494+sqwsn-stitle090+sqwsn-stitle103+sqwsn-stitle730+sqwsn-stitle870+sqwsn-stitle517+sqwsn-stitle749+sqwsn-stitle835+sqwsn-stitle630+sqwsn-stitle270+sqwsn-stitle908+sqwsn-stitle913+sqwsn-stitle315+sqwsn-stitle480+sqwsn-stitle822+sqwsn-stitle351+sqwsn-stitle415+sqwsn-stitle151+sqwsn-stitle425+sqwsn-stitle170+sqwsn-stitle812+sqwsn-stitle184+sqwsn-stitle814+sqwsn-stitle237+sqwsn-agg121
• QueryTimeInMicroSec:66220
• NumMatched:132
• NumReturned:0

[ShowInFinding3 - EBAY_UK=3 SIF_AND_NSIF_ITEMS_SEARCH=8]
  ShowInSite5("3","8")

[CURRENT_ACTIVE]
  AND(
      LESSTHANEQUAL(SafeStartTime,"NOW"),
      GREATERTHAN(EndTime,"NOW"))

[MskuView - 1]
  MskuView("1")

[AllCats - 11232]
  EQUAL(AllCats,"11232")

[SIBEExpression - AND(AND(barr))]
  AND(
      AND("barr"))

• SearchQuery:AND(MACRO(ShowInSite5,3,8),MACRO(MskuView,1),EQ(AllCats,11232),LE(SafeStartTime,NOW),GT(EndTime,NOW),barr)
• CompleteBackendQuery:callname=DSAggregate&requestencoding=NV&responseencoding=NV&dsHdr=3;2;4&Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C3%2C8%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C11232%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Cbarr%29&Sp=RELEVANCE_SORT2&Nr=28&So=Decreasing&St=Num=1&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+Ctry+SHIPCALC%28Fu%2CFa%2C3%2C0%2C0%2C2147483647%2C5%29+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Gb=%7BHASATTR%28ProdReferenceId%29,COUNT,Incr,0,0,0,0+%7D+%7BStoreSellerID,COUNT,Decrv%280%29,0,150,0,0+%7D+%7BSite,COUNT,Incr,0,0,0,0+%7D+%7BDsaPseudo,SUBCAT(%220%22,%2211232%22),Incr,0,0,0,0+DSAJoin+qd.category.category+%2B%3D+mst.LeafCats+DSAWhere+qd.query.query+%3D+%22barr%22+AND+qd.site.site+%3D+%223%22%7D+%7BDsaPseudo,SUBDAP(%22_%7C_%22),Incr,0,0,0,0+DSAJoin+qd.dap.dap+%2B%3D+qd.dap.dap+DSAWhere+qd.query.query+%3D+%22kw%3Abarr%22+AND+qd.site.site+%3D+%223%22%7D&Im=saleclass1&Rkw=%5Bkeyword%3DBarr%2Csite%3D3%2Ccategory%3D11232%5D&Pr=Pr3%28%28%28EQ%28saleclass1%2C1%29%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CEndTime%29%2C100%2C1000000%2C-864000%2C0%29%2C0%2C1000000%2C20000%2C1000000%29%2CBMSCALE%28IF%28LT%28UKScore3%2C10000%29%2C10000%2C1000000%29%2C10000%2C1000000%2C10000%2C1000000%29%2C1000000%2C0%29%29%28%28%29%2CBMMUL%28BMSCALE%28ADD%28MUL%28EXPRLIST%28VARSET%28si%2CBMDIV%28DecayedSalesCount%2CMAX%281%2CDecayedImpressionCount%29%2C100000000%2C0%2C2000000%2C0%29%29%2CIF%28LE%28VARUSE%28si%29%2C0%29%2CVARSET%28f%2C0%29%2CIF%28GE%28VARUSE%28si%29%2C2000000%29%2CVARSET%28f%2C1%29%2CIF%28LE%28VARUSE%28si%29%2C70989%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C0%29%2CVARSET%28max%2C70989%29%2CVARSET%28off%2C0%29%29%2CIF%28LE%28VARUSE%28si%29%2C115874%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C70989%29%2CVARSET%28max%2C115874%29%2CVARSET%28off%2C100%29%29%2CIF%28LE%28VARUSE%28si%29%2C169894%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C115874%29%2CVARSET%28max%2C169894%29%2CVARSET%28off%2C200%29%29%2CIF%28LE%28VARUSE%28si%29%2C216919%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C169894%29%2CVARSET%28max%2C216919%29%2CVARSET%28off%2C300%29%29%2CIF%28LE%28VARUSE%28si%29%2C293255%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C216919%29%2CVARSET%28max%2C293255%29%2CVARSET%28off%2C400%29%29%2CIF%28LE%28VARUSE%28si%29%2C376647%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C293255%29%2CVARSET%28max%2C376647%29%2CVARSET%28off%2C500%29%29%2CIF%28LE%28VARUSE%28si%29%2C476644%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C376647%29%2CVARSET%28max%2C476644%29%2CVARSET%28off%2C600%29%29%2CIF%28LE%28VARUSE%28si%29%2C636942%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C476644%29%2CVARSET%28max%2C636942%29%2CVARSET%28off%2C700%29%29%2CIF%28LE%28VARUSE%28si%29%2C852272%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C636942%29%2CVARSET%28max%2C852272%29%2CVARSET%28off%2C800%29%29%2CEXPRLIST%28VARSET%28f%2C2%29%2CVARSET%28min%2C852272%29%2CVARSET%28max%2C2000000%29%2CVARSET%28off%2C900%29%29%29%29%29%29%29%29%29%29%29%29%29%2CIF%28EQ%28VARUSE%28f%29%2C0%29%2C0%2CIF%28EQ%28VARUSE%28f%29%2C1%29%2C999%2CADD%28BMDIV%28SUB%28VARUSE%28si%29%2CVARUSE%28min%29%29%2CSUB%28VARUSE%28max%29%2CVARUSE%28min%29%29%2C99%2C0%2C99%2C1%29%2CVARUSE%28off%29%29%29%29%29%2C1000000%29%2CMUL%28BMNORM%28BMDIV%28DecayedViewItemCount%2CMAX%281%2CDecayedImpressionCount%29%2C100000%2C0%2C100000%2C100000%29%2C100%2C9999%2C0%2C12500%29%2C100%29%2CBMNORM%28DecayedSalesCount%2C100%2C99%2C0%2C71%29%29%2C0%2C999999999%2C20000%2C1000000%29%2CBMSCALE%28BMNORM%28TitleRel%2C100%2C1000000%2C-32000%2C32000%29%2C0%2C1000000%2C400000%2C600000%29%2CBMSCALE%28IF%28EQ%28MACRO%28FreeShippingInSite%2C3%29%2C1%29%2C1010000%2C1000000%29%2C1000000%2C1010000%2C1000000%2C1010000%29%2CBMSCALE%28IF%28GT%28UKScore3%2C10000%29%2C1100000%2CIF%28LT%28UKScore3%2C10000%29%2C10000%2C1000000%29%29%2C10000%2C1100000%2C10000%2C1100000%29%2C1000000%2C0%29%29%29&Es=saleclass1%2C1%3A70%25%3B0%3A30%25%2C24&Qi=core_all_matching_items_orch%3APageMA2ShowItems%3AM168%3A2471%3APr2471_5_Ed103_1_Ed107_3:1259440114_0x9510.7.95.78:sq-wshop268:dvd-video.shop.ebay.co.uk:v3shopintl
• SearchIndex:DSA
• BackendHost:sqwsn-stitle006+sqwsn-stitle999+sqwsn-stitle946+sqwsn-stitle385+sqwsn-stitle766+sqwsn-stitle063+sqwsn-stitle828+sqwsn-stitle091+sqwsn-stitle104+sqwsn-stitle111+sqwsn-stitle504+sqwsn-stitle783+sqwsn-stitle536+sqwsn-stitle980+sqwsn-stitle254+sqwsn-stitle687+sqwsn-stitle882+sqwsn-stitle819+sqwsn-stitle658+sqwsn-stitle657+sqwsn-stitle890+sqwsn-stitle996+sqwsn-stitle131+sqwsn-stitle138+sqwsn-stitle581+sqwsn-stitle171+sqwsn-stitle204+sqwsn-stitle188+sqwsn-stitle603+sqwsn-stitle604+sqwsn-agg187
• QueryTimeInMicroSec:48067
• NumMatched:70
• NumReturned:28

• SearchQuery:AND(MACRO(ShowInSite5,3,8),MACRO(MskuView,1),EQ(AllCats,11232),MACRO(IsFeaturedFirstTnsFiltered),EQ(UKLevel,1),EQ(Site,3),LE(SafeStartTime,NOW),GT(EndTime,NOW),barr)
• CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C3%2C8%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C11232%29%2CMACRO%28IsFeaturedFirstTnsFiltered%29%2CEQ%28UKLevel%2C1%29%2CEQ%28Site%2C3%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Cbarr%29&Sp=RELEVANCE_SORT2&Nr=10&So=Decreasing&St=Num=1&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+Ctry+SHIPCALC%28Fu%2CFa%2C3%2C0%2C0%2C2147483647%2C5%29+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Rkw=%5Bkeyword%3DBarr%2Csite%3D3%2Ccategory%3D11232%5D&Pr=Pr%28TitleRel%28100%29%29&Qi=fetch_featuredfirst_items%3APageMA2ShowItems%3AC2%3APr2471_5_Ed103_1_Ed107_3%3APr2471_5_Ed103_1_Ed107_3:1259440114_0x9510.7.95.78:sq-wshop268:dvd-video.shop.ebay.co.uk:v3shopintl
• SearchIndex:ExpressSale
• BackendHost:sqwsn-stitle940+sqwsn-stitle999+sqwsn-stitle855+sqwsn-stitle694+sqwsn-stitle858+sqwsn-stitle861+sqwsn-stitle081+sqwsn-stitle962+sqwsn-stitle099+sqwsn-stitle409+sqwsn-stitle499+sqwsn-stitle522+sqwsn-stitle749+sqwsn-stitle980+sqwsn-stitle982+sqwsn-stitle246+sqwsn-stitle585+sqwsn-stitle634+sqwsn-stitle920+sqwsn-stitle313+sqwsn-stitle781+sqwsn-stitle351+sqwsn-stitle124+sqwsn-stitle418+sqwsn-stitle425+sqwsn-stitle433+sqwsn-stitle590+sqwsn-stitle188+sqwsn-stitle223+sqwsn-stitle237+sqwsn-agg129
• QueryTimeInMicroSec:33445
• NumMatched:0
• NumReturned:0

calling DFN surface algorithm 

Total Supply Count For Product Type:70
Total Demand Score For Product Type:0
PT coverage list
PT Name=DVDs:	id=1608	supply=55	demand=0.0	score=78.57142857142857	high confidence=80.0	light confidence=80.0
PT Name=Videos: VHS:	id=4455	supply=9	demand=0.0	score=12.85714285714286	high confidence=80.0	light confidence=80.0
PT Name=Film Memorabilia:	id=3983	supply=6	demand=0.0	score=8.571428571428573	high confidence=80.0	light confidence=80.0
-------------------------
WinningPT is null because qualfiedPTList is empty
WinningPT is null because there is no qualified ProductType

• SearchQuery:AND(OR(EQ(OwnerId,187128896),EQ(OwnerId,124428122),EQ(OwnerId,98736747),EQ(OwnerId,897590825),EQ(OwnerId,47972116),EQ(OwnerId,35058249),EQ(OwnerId,84594472),EQ(OwnerId,33396904),EQ(OwnerId,2720668),EQ(OwnerId,783911067),EQ(OwnerId,52490364),EQ(OwnerId,29502064),EQ(OwnerId,178733162),EQ(OwnerId,839549444),EQ(OwnerId,32578545),EQ(OwnerId,260913696),EQ(OwnerId,294563936),EQ(OwnerId,65919830)))
• CompleteBackendQuery:Vr=0.1&Qy=AND%28OR%28EQ%28OwnerId%2C187128896%29%2CEQ%28OwnerId%2C124428122%29%2CEQ%28OwnerId%2C98736747%29%2CEQ%28OwnerId%2C897590825%29%2CEQ%28OwnerId%2C47972116%29%2CEQ%28OwnerId%2C35058249%29%2CEQ%28OwnerId%2C84594472%29%2CEQ%28OwnerId%2C33396904%29%2CEQ%28OwnerId%2C2720668%29%2CEQ%28OwnerId%2C783911067%29%2CEQ%28OwnerId%2C52490364%29%2CEQ%28OwnerId%2C29502064%29%2CEQ%28OwnerId%2C178733162%29%2CEQ%28OwnerId%2C839549444%29%2CEQ%28OwnerId%2C32578545%29%2CEQ%28OwnerId%2C260913696%29%2CEQ%28OwnerId%2C294563936%29%2CEQ%28OwnerId%2C65919830%29%29%29&Sp=StoreId&Nr=150&So=Increasing&St=Num=1&Sk=0&Fl=StoreId+SubsLevel+SiteId+Name+OwnerId&Qi=FindingVoyagerStoreCache-StoreQuery%3A%3AFindingVoyagerStoreCache%3A%3A:1259440114_0x9510.7.95.78:sq-wshop268:dvd-video.shop.ebay.co.uk:v3shopintl
• SearchIndex:Store
• BackendHost:sqwsn-sname003
• QueryTimeInMicroSec:106
• NumMatched:18
• NumReturned:18