Organizéry do kabelky

Thread id: 102

28.02.2020 20:27:50.461     +0ms s: Application_BeginRequest

28.02.2020 20:27:50.464     +3ms     s: Cat:Index

28.02.2020 20:27:50.464     +0ms         s: CustomCode:CatController_sub.GetCatData

28.02.2020 20:27:50.468     +4ms             s: GetDataFromDb: select top 180 w.load_produkt_id, w.cena, w.dopravne, w.cena + w.dopravne as spolu, (case when w.aktivny = 0 then '' else w.dostupnost end) as dostupnost, w.hyperlinkTarget as hl, w.load_produkt_id as produkt_id, w.cpc, w.gift, w.produkt as nazov, w.web_id, w.pict, w.web_search_tdata_id, w.popis, '' as pictPath, ROW_NUMBER() OVER(ORDER BY w.cena, w.dostupnost) riadok, -0.1 km, w.aktivny, w.load_vysl from web_searches_tdatas w with(nolock) join web_searches_tdatas_cats wc with(nolock) on w.priradena_kategoria_id = wc.id where wc.kategoria_id = 7996 and wc.stav_priradenia = 1 and w.aktivny = 1 and (w.load_vysl is null or w.load_vysl <> 0)

28.02.2020 20:27:50.512    +44ms             f: GetDataFromDb: select top 180 w.load_produkt_id, w.cena, w.dopravne, w.cena + w.dopravne as spolu, (case when w.aktivny = 0 then '' else w.dostupnost end) as dostupnost, w.hyperlinkTarget as hl, w.load_produkt_id as produkt_id, w.cpc, w.gift, w.produkt as nazov, w.web_id, w.pict, w.web_search_tdata_id, w.popis, '' as pictPath, ROW_NUMBER() OVER(ORDER BY w.cena, w.dostupnost) riadok, -0.1 km, w.aktivny, w.load_vysl from web_searches_tdatas w with(nolock) join web_searches_tdatas_cats wc with(nolock) on w.priradena_kategoria_id = wc.id where wc.kategoria_id = 7996 and wc.stav_priradenia = 1 and w.aktivny = 1 and (w.load_vysl is null or w.load_vysl <> 0) execute: NO, render: 43ms

28.02.2020 20:27:50.513     +1ms             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 : "ORGANIZERY DO KABELKY" @searchPhraseLower : "organizery do kabelky"

28.02.2020 20:27:50.515     +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 : "ORGANIZERY DO KABELKY" @searchPhraseLower : "organizery do kabelky" execute: NO, render: 1ms

28.02.2020 20:27:50.515     +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 180 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 : ((("Organizéry" AND "do" AND "kabelky") OR ("organizer" AND "do" AND "kabelky"))) AND "active_1"

28.02.2020 20:27:50.759   +244ms             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 180 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 : ((("Organizéry" AND "do" AND "kabelky") OR ("organizer" AND "do" AND "kabelky"))) AND "active_1" execute: NO, render: 244ms

28.02.2020 20:27:50.782    +23ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.782     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

28.02.2020 20:27:50.783     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.783     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

28.02.2020 20:27:50.783     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.783     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

28.02.2020 20:27:50.783     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.784     +1ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

28.02.2020 20:27:50.784     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.784     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms

28.02.2020 20:27:50.784     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.784     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.785     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.785     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.785     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.785     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.785     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.786     +1ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.786     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.786     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.786     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.786     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.787     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.787     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.787     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.787     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms

28.02.2020 20:27:50.787     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.787     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.788     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.788     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.788     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.788     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.788     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.789     +1ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.789     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.789     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.789     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.789     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.790     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.790     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.790     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.790     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 2ms

28.02.2020 20:27:50.790     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.790     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.791     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.791     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.791     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.791     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.791     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.792     +1ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.792     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.792     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.792     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.792     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.793     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.793     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.793     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.793     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 3ms

28.02.2020 20:27:50.793     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.794     +1ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.794     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.794     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.794     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.794     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.795     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.795     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.795     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.795     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.795     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.795     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.796     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.796     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.796     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.796     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 4ms

28.02.2020 20:27:50.796     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.796     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.797     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.797     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.797     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.797     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.797     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.797     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.798     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.798     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.798     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.798     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.798     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.798     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.799     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.799     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 5ms

28.02.2020 20:27:50.799     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.799     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 6ms

28.02.2020 20:27:50.799     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.799     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 6ms

28.02.2020 20:27:50.800     +1ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.800     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 6ms

28.02.2020 20:27:50.800     +0ms             s: Product_Offers:Get_Grid_item

28.02.2020 20:27:50.800     +0ms             f: Product_Offers:Get_Grid_item execute: 0ms, render: 6ms

28.02.2020 20:27:50.800     +0ms             s: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (2588751,2588754,2588757,1757121) and key2=1

28.02.2020 20:27:50.809     +9ms             f: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (2588751,2588754,2588757,1757121) and key2=1 execute: NO, render: 8ms

28.02.2020 20:27:50.810     +1ms             s: PlainHtml:GetAddData

28.02.2020 20:27:50.810     +0ms             f: PlainHtml:GetAddData execute: 0ms, render: 0ms

28.02.2020 20:27:50.811     +1ms         f: CustomCode:CatController_sub.GetCatData execute: NO, render: 347ms

28.02.2020 20:27:50.812     +1ms         s: UserLoginContent:GetUserLoginContentData

28.02.2020 20:27:50.812     +0ms         f: UserLoginContent:GetUserLoginContentData execute: 0ms, render: 0ms

28.02.2020 20:27:50.813     +1ms         s: Schranka:LoadFooter_VisitedProducts

28.02.2020 20:27:50.813     +0ms         f: Schranka:LoadFooter_VisitedProducts execute: 0ms, render: 0ms

28.02.2020 20:27:50.813     +0ms     f: Cat:Index execute: 347ms, render: 2ms