Thread id: 979

29.01.2020 11:05:32.856     +0ms s: Application_BeginRequest

29.01.2020 11:05:32.856     +0ms     s: TopSearches2:GetData

29.01.2020 11:05:32.856     +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 > 20191021 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)

29.01.2020 11:05:32.996   +140ms         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 > 20191021 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: 146ms

29.01.2020 11:05:32.996     +0ms         s: UserLoginContent:GetUserLoginContentData

29.01.2020 11:05:32.996     +0ms         f: UserLoginContent:GetUserLoginContentData execute: 0ms, render: 0ms

29.01.2020 11:05:32.996     +0ms         s: Schranka:LoadFooter_VisitedProducts

29.01.2020 11:05:32.996     +0ms         f: Schranka:LoadFooter_VisitedProducts execute: 0ms, render: 0ms

29.01.2020 11:05:32.996     +0ms     f: TopSearches2:GetData execute: 147ms, render: 1ms