Thread id: 454

11.08.2020 23:16:00.914     +0ms s: Application_BeginRequest

11.08.2020 23:16:00.914     +0ms     s: GetDataFromDb: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM ( SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match' UNION ALL SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match' ) a) b /*WHERE poradie=1*/ @searchPhraseUpper : "SODASTREAM SPIRIT" @searchPhraseLower : "sodastream spirit"

11.08.2020 23:16:00.916     +2ms     f: GetDataFromDb: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM ( SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match' UNION ALL SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match' ) a) b /*WHERE poradie=1*/ @searchPhraseUpper : "SODASTREAM SPIRIT" @searchPhraseLower : "sodastream spirit" execute: NO, render: 1ms

11.08.2020 23:16:00.916     +0ms     s: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains) @like_notcompleted_a : SPIRIT% @like_notcompleted_b : %[^a-z0-9]SPIRIT% @like_notcompleted_c : %-SPIRIT% @contains : ("SODASTREAM")

11.08.2020 23:16:00.918     +2ms     f: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains) @like_notcompleted_a : SPIRIT% @like_notcompleted_b : %[^a-z0-9]SPIRIT% @like_notcompleted_c : %-SPIRIT% @contains : ("SODASTREAM") execute: NO, render: 1ms

11.08.2020 23:16:00.922     +4ms     s: SearchResults:_GetSearchResults

11.08.2020 23:16:00.923     +1ms         s: DUPL GetDataFromDb: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM ( SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match' UNION ALL SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match' ) a) b /*WHERE poradie=1*/ @searchPhraseUpper : "SODASTREAM SPIRIT" @searchPhraseLower : "sodastream spirit"

11.08.2020 23:16:00.924     +1ms         f: GetDataFromDb: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM ( SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match' UNION ALL SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match' ) a) b /*WHERE poradie=1*/ @searchPhraseUpper : "SODASTREAM SPIRIT" @searchPhraseLower : "sodastream spirit" execute: NO, render: 1ms

11.08.2020 23:16:00.936    +12ms         s: GetDataFromDb: select w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, (case when w.aktivny=0 and a.ppc_platic=0 then '' else w.dostupnost end) as dostupnost, a.handleAsVipPartner, (case when a.handleAsVipPartner = 0 then 0 else isnull(a.viptextmode,0)+1 end) vipprogram, a.produkt_id, w.load_vysl, w.load_vyrobca_id, (case when load_produkt_id is null then 0 else ISNULL(a.current_bids,0) END) as pocet_ponuk, (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane, w.pict, w.popis, '' as pictPath, a.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, a.kategoria_id, w.priradena_kategoria_id , w.aktivny, a.ppc_platic from web_searches_tdatas w with(nolock) join ( SELECT TOP 5000 w.web_search_tdata_id, p.produkt_id, p.kategoria_id, p.nazov, w.web_id, we.handleAsVipPartner, we.viptextmode, h.current_bids, we.ppc_platic FROM CONTAINSTABLE(web_searches_tdatas, (produkt_fulltext_2018), @contains) ft INNER JOIN najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) on ft.[key] = w.web_search_tdata_id JOIN najnakup_svk_remote.dbo.a_webs we WITH (NOLOCK) ON we.web_id=w.web_id LEFT OUTER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id LEFT OUTER JOIN najnakup_svk_remote.dbo.a_produkty_history h WITH (NOLOCK) ON h.produkt_id=p.produkt_id ORDER BY ft.[key] ) a on w.web_search_tdata_id=a.web_search_tdata_id ORDER BY a.handleAsVipPartner desc, pocet_ponuk DESC, w.cena ASC, vipprogram desc @contains : ("SODASTREAM" And "SPIRIT") AND "active_1"

11.08.2020 23:16:01.360   +424ms         f: GetDataFromDb: select w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, (case when w.aktivny=0 and a.ppc_platic=0 then '' else w.dostupnost end) as dostupnost, a.handleAsVipPartner, (case when a.handleAsVipPartner = 0 then 0 else isnull(a.viptextmode,0)+1 end) vipprogram, a.produkt_id, w.load_vysl, w.load_vyrobca_id, (case when load_produkt_id is null then 0 else ISNULL(a.current_bids,0) END) as pocet_ponuk, (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane, w.pict, w.popis, '' as pictPath, a.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, a.kategoria_id, w.priradena_kategoria_id , w.aktivny, a.ppc_platic from web_searches_tdatas w with(nolock) join ( SELECT TOP 5000 w.web_search_tdata_id, p.produkt_id, p.kategoria_id, p.nazov, w.web_id, we.handleAsVipPartner, we.viptextmode, h.current_bids, we.ppc_platic FROM CONTAINSTABLE(web_searches_tdatas, (produkt_fulltext_2018), @contains) ft INNER JOIN najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) on ft.[key] = w.web_search_tdata_id JOIN najnakup_svk_remote.dbo.a_webs we WITH (NOLOCK) ON we.web_id=w.web_id LEFT OUTER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id LEFT OUTER JOIN najnakup_svk_remote.dbo.a_produkty_history h WITH (NOLOCK) ON h.produkt_id=p.produkt_id ORDER BY ft.[key] ) a on w.web_search_tdata_id=a.web_search_tdata_id ORDER BY a.handleAsVipPartner desc, pocet_ponuk DESC, w.cena ASC, vipprogram desc @contains : ("SODASTREAM" And "SPIRIT") AND "active_1" execute: NO, render: 424ms

11.08.2020 23:16:01.367     +7ms         s: GetDataFromDb: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM ( SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match' UNION ALL SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match' ) a) b /*WHERE poradie=1*/ @searchPhraseUpper : "8718692619456 8718692619470 8590669264582 8590669278084" @searchPhraseLower : "8718692619456 8718692619470 8590669264582 8590669278084"

11.08.2020 23:16:01.369     +2ms         f: GetDataFromDb: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM ( SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match' UNION ALL SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match' ) a) b /*WHERE poradie=1*/ @searchPhraseUpper : "8718692619456 8718692619470 8590669264582 8590669278084" @searchPhraseLower : "8718692619456 8718692619470 8590669264582 8590669278084" execute: NO, render: 1ms

11.08.2020 23:16:01.369     +0ms         s: GetDataFromDb: select w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, (case when w.aktivny=0 and a.ppc_platic=0 then '' else w.dostupnost end) as dostupnost, a.handleAsVipPartner, (case when a.handleAsVipPartner = 0 then 0 else isnull(a.viptextmode,0)+1 end) vipprogram, a.produkt_id, w.load_vysl, w.load_vyrobca_id, (case when load_produkt_id is null then 0 else ISNULL(a.current_bids,0) END) as pocet_ponuk, (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane, w.pict, w.popis, '' as pictPath, a.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, a.kategoria_id, w.priradena_kategoria_id , w.aktivny, a.ppc_platic from web_searches_tdatas w with(nolock) join ( SELECT TOP 1000 w.web_search_tdata_id, p.produkt_id, p.kategoria_id, p.nazov, w.web_id, we.handleAsVipPartner, we.viptextmode, h.current_bids, we.ppc_platic FROM CONTAINSTABLE(web_searches_tdatas, (produkt_fulltext_2018), @contains) ft INNER JOIN najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) on ft.[key] = w.web_search_tdata_id JOIN najnakup_svk_remote.dbo.a_webs we WITH (NOLOCK) ON we.web_id=w.web_id LEFT OUTER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id LEFT OUTER JOIN najnakup_svk_remote.dbo.a_produkty_history h WITH (NOLOCK) ON h.produkt_id=p.produkt_id ORDER BY ft.[key] ) a on w.web_search_tdata_id=a.web_search_tdata_id ORDER BY a.handleAsVipPartner desc, pocet_ponuk DESC, w.cena ASC, vipprogram desc @contains : (("8718692619456" OR "-8718692619456") Or ("8718692619470" OR "-8718692619470") Or ("8590669264582" OR "-8590669264582") Or ("8590669278084" OR "-8590669278084")) AND "active_1"

11.08.2020 23:16:01.492   +123ms         f: GetDataFromDb: select w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, (case when w.aktivny=0 and a.ppc_platic=0 then '' else w.dostupnost end) as dostupnost, a.handleAsVipPartner, (case when a.handleAsVipPartner = 0 then 0 else isnull(a.viptextmode,0)+1 end) vipprogram, a.produkt_id, w.load_vysl, w.load_vyrobca_id, (case when load_produkt_id is null then 0 else ISNULL(a.current_bids,0) END) as pocet_ponuk, (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane, w.pict, w.popis, '' as pictPath, a.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, a.kategoria_id, w.priradena_kategoria_id , w.aktivny, a.ppc_platic from web_searches_tdatas w with(nolock) join ( SELECT TOP 1000 w.web_search_tdata_id, p.produkt_id, p.kategoria_id, p.nazov, w.web_id, we.handleAsVipPartner, we.viptextmode, h.current_bids, we.ppc_platic FROM CONTAINSTABLE(web_searches_tdatas, (produkt_fulltext_2018), @contains) ft INNER JOIN najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) on ft.[key] = w.web_search_tdata_id JOIN najnakup_svk_remote.dbo.a_webs we WITH (NOLOCK) ON we.web_id=w.web_id LEFT OUTER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id LEFT OUTER JOIN najnakup_svk_remote.dbo.a_produkty_history h WITH (NOLOCK) ON h.produkt_id=p.produkt_id ORDER BY ft.[key] ) a on w.web_search_tdata_id=a.web_search_tdata_id ORDER BY a.handleAsVipPartner desc, pocet_ponuk DESC, w.cena ASC, vipprogram desc @contains : (("8718692619456" OR "-8718692619456") Or ("8718692619470" OR "-8718692619470") Or ("8590669264582" OR "-8590669264582") Or ("8590669278084" OR "-8590669278084")) AND "active_1" execute: NO, render: 122ms

11.08.2020 23:16:01.492     +0ms         s: GetDataFromDb: SELECT TOP 1000 w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, (case when w.aktivny=1 then w.dostupnost else '' end) as dostupnost, (case when we.handleAsVipPartner = 0 then 0 else isnull(we.viptextmode,0)+1 end) vipprogram, we.handleAsVipPartner, p.produkt_id, w.load_vysl, w.load_vyrobca_id, (case when load_produkt_id is null then 0 else ISNULL(h.current_bids,0) END) as pocet_ponuk, (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane, w.pict, w.popis, '' as pictPath, p.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, p.kategoria_id, null as priradena_kategoria_id, w.aktivny, we.ppc_platic FROM najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) INNER JOIN a_webs we WITH (NOLOCK) ON we.web_id=w.web_id INNER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id LEFT OUTER JOIN a_produkty_history h WITH (NOLOCK) on h.produkt_id=p.produkt_id WHERE (w.aktivny=1 /*or (w.aktivny=0 and we.ppc_platic=0)*/) AND w.load_produkt_id in (3587917,2141302,804890,2141301) and w.load_vysl=0

11.08.2020 23:16:01.558    +66ms         f: GetDataFromDb: SELECT TOP 1000 w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, (case when w.aktivny=1 then w.dostupnost else '' end) as dostupnost, (case when we.handleAsVipPartner = 0 then 0 else isnull(we.viptextmode,0)+1 end) vipprogram, we.handleAsVipPartner, p.produkt_id, w.load_vysl, w.load_vyrobca_id, (case when load_produkt_id is null then 0 else ISNULL(h.current_bids,0) END) as pocet_ponuk, (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane, w.pict, w.popis, '' as pictPath, p.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, p.kategoria_id, null as priradena_kategoria_id, w.aktivny, we.ppc_platic FROM najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) INNER JOIN a_webs we WITH (NOLOCK) ON we.web_id=w.web_id INNER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id LEFT OUTER JOIN a_produkty_history h WITH (NOLOCK) on h.produkt_id=p.produkt_id WHERE (w.aktivny=1 /*or (w.aktivny=0 and we.ppc_platic=0)*/) AND w.load_produkt_id in (3587917,2141302,804890,2141301) and w.load_vysl=0 execute: NO, render: 65ms

11.08.2020 23:16:01.703   +145ms         s: CustomCode:CatController_sub.GetCatData

11.08.2020 23:16:01.742    +39ms             s: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (2141302,3587917,2141301,2551735) and key2=1

11.08.2020 23:16:01.746     +4ms             f: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (2141302,3587917,2141301,2551735) and key2=1 execute: NO, render: 4ms

11.08.2020 23:16:01.747     +1ms             s: PlainHtml:GetAddData

11.08.2020 23:16:01.748     +1ms             f: PlainHtml:GetAddData execute: 0ms, render: 0ms

11.08.2020 23:16:01.749     +1ms             s: PlainHtml:GetAddData

11.08.2020 23:16:01.749     +0ms             f: PlainHtml:GetAddData execute: 0ms, render: 0ms

11.08.2020 23:16:01.749     +0ms         f: CustomCode:CatController_sub.GetCatData execute: NO, render: 46ms

11.08.2020 23:16:01.819    +70ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.819     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

11.08.2020 23:16:01.820     +1ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.820     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

11.08.2020 23:16:01.820     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.820     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

11.08.2020 23:16:01.821     +1ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.821     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

11.08.2020 23:16:01.821     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.821     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

11.08.2020 23:16:01.821     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.821     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

11.08.2020 23:16:01.822     +1ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.822     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.822     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.822     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.822     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.823     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.823     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.823     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.823     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.823     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.824     +1ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.824     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.824     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.824     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.824     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.824     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

11.08.2020 23:16:01.825     +1ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.825     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

11.08.2020 23:16:01.825     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.825     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

11.08.2020 23:16:01.825     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.826     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

11.08.2020 23:16:01.826     +0ms         s: Product_Offers:Get_Grid_item

11.08.2020 23:16:01.826     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

11.08.2020 23:16:01.827     +1ms         s: UserLoginContent:GetUserLoginContentData

11.08.2020 23:16:01.827     +0ms         f: UserLoginContent:GetUserLoginContentData execute: 0ms, render: 0ms

11.08.2020 23:16:01.827     +0ms         s: Schranka:LoadFooter_VisitedProducts

11.08.2020 23:16:01.827     +0ms         f: Schranka:LoadFooter_VisitedProducts execute: 0ms, render: 0ms

11.08.2020 23:16:01.828     +1ms     f: SearchResults:_GetSearchResults execute: 904ms, render: 1ms