Thread id: 787

15.12.2019 07:16:24.210     +0ms s: Application_BeginRequest

15.12.2019 07:16:24.214     +4ms     s: TopSearches2:GetData

15.12.2019 07:16:24.214     +0ms         s: GetDataFromDb: select * from ( select TOP 40 *, (select fulltext from stat_searches_2015 with (nolock) where id=last_id) last_fulltext, (select products from stat_searches_2015 with (nolock) where id=last_id) last_products from ( SELECT text, avg(fulltext) as fulltext, avg(products) as products, sum(views) as count, max(id) as last_id FROM stat_searches_2015 with (nolock) WHERE den > 20190906 AND (fulltext+products<>0) AND (text NOT IN (SELECT word FROM NajNakup_Logs.dbo.web_searches_2015_ignore)) GROUP BY text) a ORDER BY count DESC) b WHERE (last_fulltext+last_products>0)

15.12.2019 07:16:24.586   +372ms         f: GetDataFromDb: select * from ( select TOP 40 *, (select fulltext from stat_searches_2015 with (nolock) where id=last_id) last_fulltext, (select products from stat_searches_2015 with (nolock) where id=last_id) last_products from ( SELECT text, avg(fulltext) as fulltext, avg(products) as products, sum(views) as count, max(id) as last_id FROM stat_searches_2015 with (nolock) WHERE den > 20190906 AND (fulltext+products<>0) AND (text NOT IN (SELECT word FROM NajNakup_Logs.dbo.web_searches_2015_ignore)) GROUP BY text) a ORDER BY count DESC) b WHERE (last_fulltext+last_products>0) execute: NO, render: 372ms

15.12.2019 07:16:24.588     +2ms         s: UserLoginContent:GetUserLoginContentData

15.12.2019 07:16:24.588     +0ms         f: UserLoginContent:GetUserLoginContentData execute: 0ms, render: 0ms

15.12.2019 07:16:24.588     +0ms         s: Schranka:LoadFooter_VisitedProducts

15.12.2019 07:16:24.588     +0ms         f: Schranka:LoadFooter_VisitedProducts execute: 0ms, render: 0ms

15.12.2019 07:16:24.588     +0ms     f: TopSearches2:GetData execute: 373ms, render: 1ms