|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass83_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry AbstractDataConnection.get_NativeDBConnection <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass83_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
1
|
(.generalselect) DECLARE @NodeSiteID int = 2; DECLARE @DocumentUrlPath nvarchar(max) = N'/Services'; DECLARE @NodeAliasPath nvarchar(max) = N'/Services'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/Services' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P] FROM ( SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild] FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))) ) AS SubData ORDER BY CMS_P DESC @NodeSiteID (2) @DocumentUrlPath ("/Services") @NodeAliasPath ("/Services") @DocumentCulture ("en-US") 3.5 kB
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass83_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass83_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) URLRewriter.GetTemplateFileName PageInfo.EnsurePageTemplateInfo PageTemplateInfoProvider.GetPageTemplateInfo AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
2
|
(cms.pagetemplate.generalselect) DECLARE @PageTemplateID int = 6;
SELECT TOP 1 * FROM CMS_PageTemplate WHERE [PageTemplateID] = @PageTemplateID
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) URLRewriter.GetTemplateFileName PageInfo.EnsurePageTemplateInfo PageTemplateInfoProvider.GetPageTemplateInfo AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) URLRewriter.GetTemplateFileName PageInfo.EnsurePageTemplateInfo PageTemplateInfoProvider.GetPageTemplateInfo AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.CheckSecurity PageSecurityHelper.CheckPageSecurity PageSecurityHelper.RequestSecurePage PageInfo.get_RequiresSSLValue PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
3
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 2; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] = N'/' AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (2) @DocumentCulture ("en-US") 360 B
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.CheckSecurity PageSecurityHelper.CheckPageSecurity PageSecurityHelper.RequestSecurePage PageInfo.get_RequiresSSLValue PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.CheckSecurity PageSecurityHelper.CheckPageSecurity PageSecurityHelper.RequestSecurePage PageInfo.get_RequiresSSLValue PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities ModuleCommands.OnlineMarketingGetCurrentContactID OnlineMarketingModule.GetCurrentContactId ContactManagementContext.GetCurrentContactInternal DefaultCurrentContactProvider.GetCurrentContact DefaultContactCreator.CreateContact ContactInfoProvider.SetContactInfoInternal AbstractInfoProvider`3.SetInfo TransactionScopeFactory.GetTransactionScopeInternal CMSTransactionScope..ctor CMSConnectionScope.Open <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
BeginTransaction(ReadCommitted)
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities ModuleCommands.OnlineMarketingGetCurrentContactID OnlineMarketingModule.GetCurrentContactId ContactManagementContext.GetCurrentContactInternal DefaultCurrentContactProvider.GetCurrentContact DefaultContactCreator.CreateContact ContactInfoProvider.SetContactInfoInternal AbstractInfoProvider`3.SetInfo TransactionScopeFactory.GetTransactionScopeInternal CMSTransactionScope..ctor <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
4
|
(om.contact.generalinsert) DECLARE @ContactFirstName nvarchar = NULL; DECLARE @ContactMiddleName nvarchar = NULL; DECLARE @ContactLastName nvarchar(max) = N'Anonymous - 2024-03-29 10:55:59.865'; DECLARE @ContactJobTitle nvarchar = NULL; DECLARE @ContactAddress1 nvarchar = NULL; DECLARE @ContactCity nvarchar = NULL; DECLARE @ContactZIP nvarchar = NULL; DECLARE @ContactStateID nvarchar = NULL; DECLARE @ContactCountryID nvarchar = NULL; DECLARE @ContactMobilePhone nvarchar = NULL; DECLARE @ContactBusinessPhone nvarchar = NULL; DECLARE @ContactEmail nvarchar = NULL; DECLARE @ContactBirthday nvarchar = NULL; DECLARE @ContactGender nvarchar = NULL; DECLARE @ContactStatusID nvarchar = NULL; DECLARE @ContactNotes nvarchar = NULL; DECLARE @ContactOwnerUserID nvarchar = NULL; DECLARE @ContactMonitored bit = 1; DECLARE @ContactGUID uniqueidentifier = 'a00c3128-463f-40a0-9c20-05232d3a64f3'; DECLARE @ContactLastModified datetime2 = '3/29/2024 10:55:59 AM'; DECLARE @ContactCreated datetime2 = '3/29/2024 10:55:59 AM'; DECLARE @ContactBounces nvarchar = NULL; DECLARE @ContactCampaign nvarchar = NULL; DECLARE @ContactSalesForceLeadID nvarchar = NULL; DECLARE @ContactSalesForceLeadReplicationDisabled nvarchar = NULL; DECLARE @ContactSalesForceLeadReplicationDateTime nvarchar = NULL; DECLARE @ContactSalesForceLeadReplicationSuspensionDateTime nvarchar = NULL; DECLARE @ContactCompanyName nvarchar = NULL; DECLARE @ContactSalesForceLeadReplicationRequired nvarchar = NULL; DECLARE @ContactPersonaID nvarchar = NULL;
INSERT INTO OM_Contact ([ContactFirstName], [ContactMiddleName], [ContactLastName], [ContactJobTitle], [ContactAddress1], [ContactCity], [ContactZIP], [ContactStateID], [ContactCountryID], [ContactMobilePhone], [ContactBusinessPhone], [ContactEmail], [ContactBirthday], [ContactGender], [ContactStatusID], [ContactNotes], [ContactOwnerUserID], [ContactMonitored], [ContactGUID], [ContactLastModified], [ContactCreated], [ContactBounces], [ContactCampaign], [ContactSalesForceLeadID], [ContactSalesForceLeadReplicationDisabled], [ContactSalesForceLeadReplicationDateTime], [ContactSalesForceLeadReplicationSuspensionDateTime], [ContactCompanyName], [ContactSalesForceLeadReplicationRequired], [ContactPersonaID]) VALUES (@ContactFirstName, @ContactMiddleName, @ContactLastName, @ContactJobTitle, @ContactAddress1, @ContactCity, @ContactZIP, @ContactStateID, @ContactCountryID, @ContactMobilePhone, @ContactBusinessPhone, @ContactEmail, @ContactBirthday, @ContactGender, @ContactStatusID, @ContactNotes, @ContactOwnerUserID, @ContactMonitored, @ContactGUID, @ContactLastModified, @ContactCreated, @ContactBounces, @ContactCampaign, @ContactSalesForceLeadID, @ContactSalesForceLeadReplicationDisabled, @ContactSalesForceLeadReplicationDateTime, @ContactSalesForceLeadReplicationSuspensionDateTime, @ContactCompanyName, @ContactSalesForceLeadReplicationRequired, @ContactPersonaID);
SELECT SCOPE_IDENTITY() AS [ID] @ContactFirstName () @ContactMiddleName () @ContactLastName ("Anonymous - 2024-03-29 10:55:59.865") @ContactJobTitle () @ContactAddress1 () @ContactCity () @ContactZIP () @ContactStateID () @ContactCountryID () @ContactMobilePhone () @ContactBusinessPhone () @ContactEmail () @ContactBirthday () @ContactGender () @ContactStatusID () @ContactNotes () @ContactOwnerUserID () @ContactMonitored (True) @ContactGUID (a00c3128-463f-40a0-9c20-05232d3a64f3) @ContactLastModified (3/29/2024 10:55:59 AM) @ContactCreated (3/29/2024 10:55:59 AM) @ContactBounces () @ContactCampaign () @ContactSalesForceLeadID () @ContactSalesForceLeadReplicationDisabled () @ContactSalesForceLeadReplicationDateTime () @ContactSalesForceLeadReplicationSuspensionDateTime () @ContactCompanyName () @ContactSalesForceLeadReplicationRequired () @ContactPersonaID () 3.1 kB
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities ModuleCommands.OnlineMarketingGetCurrentContactID OnlineMarketingModule.GetCurrentContactId ContactManagementContext.GetCurrentContactInternal DefaultCurrentContactProvider.GetCurrentContact DefaultContactCreator.CreateContact ContactInfoProvider.SetContactInfoInternal AbstractInfoProvider`3.SetInfo AbstractInfoBase`1.InsertData SimpleDataClass.Insert DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities ModuleCommands.OnlineMarketingGetCurrentContactID OnlineMarketingModule.GetCurrentContactId ContactManagementContext.GetCurrentContactInternal DefaultCurrentContactProvider.GetCurrentContact DefaultContactCreator.CreateContact ContactInfoProvider.SetContactInfoInternal AbstractInfoProvider`3.SetInfo CMSTransactionScope.Commit <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities ModuleCommands.OnlineMarketingGetCurrentContactID OnlineMarketingModule.GetCurrentContactId ContactManagementContext.GetCurrentContactInternal DefaultCurrentContactProvider.GetCurrentContact DefaultContactCreator.CreateContact ContactInfoProvider.SetContactInfoInternal AbstractInfoProvider`3.SetInfo CMSLateBoundTransaction.Dispose CMSConnectionScope.Close <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log ActivityLogService.ApplyModifications ContactActivityModifier.Modify DefaultCurrentContactProvider.GetCurrentContact DefaultCurrentContactProvider.GetExistingContact DefaultContactPersistentStorage.GetPersistentContact ContactInfoProvider.GetContactInfoInternal AbstractInfoProvider`3.GetInfoByGuid CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
5
|
(om.contact.generalselect) DECLARE @ContactGUID uniqueidentifier = 'a00c3128-463f-40a0-9c20-05232d3a64f3';
SELECT TOP 1 * FROM OM_Contact WHERE [ContactGUID] = @ContactGUID @ContactGUID (a00c3128-463f-40a0-9c20-05232d3a64f3) 186 B
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log ActivityLogService.ApplyModifications ContactActivityModifier.Modify DefaultCurrentContactProvider.GetCurrentContact DefaultCurrentContactProvider.GetExistingContact DefaultContactPersistentStorage.GetPersistentContact ContactInfoProvider.GetContactInfoInternal AbstractInfoProvider`3.GetInfoByGuid CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log ActivityLogService.ApplyModifications ContactActivityModifier.Modify DefaultCurrentContactProvider.GetCurrentContact DefaultCurrentContactProvider.GetExistingContact DefaultContactPersistentStorage.GetPersistentContact ContactInfoProvider.GetContactInfoInternal AbstractInfoProvider`3.GetInfoByGuid CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log ActivityLogService.ApplyModifications ContactActivityModifier.Modify DefaultCurrentContactProvider.GetCurrentContact DefaultCurrentContactProvider.GetExistingContact DefaultContactValidator.ValidateContact AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
6
This same query was called more than once within this request.
|
(om.contact.generalselect) DECLARE @ContactID int = 47777;
SELECT TOP 1 * FROM OM_Contact WHERE [ContactID] = @ContactID
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log ActivityLogService.ApplyModifications ContactActivityModifier.Modify DefaultCurrentContactProvider.GetCurrentContact DefaultCurrentContactProvider.GetExistingContact DefaultContactValidator.ValidateContact AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log ActivityLogService.ApplyModifications ContactActivityModifier.Modify DefaultCurrentContactProvider.GetCurrentContact DefaultCurrentContactProvider.GetExistingContact DefaultContactValidator.ValidateContact AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log Enumerable.All ContactActivityLogValidator.IsValid AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
7
This same query was called more than once within this request.
|
(om.contact.generalselect) DECLARE @ContactID int = 47777;
SELECT TOP 1 * FROM OM_Contact WHERE [ContactID] = @ContactID
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log Enumerable.All ContactActivityLogValidator.IsValid AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute WebAnalyticsHandlers.LogBeginAnalytics WebAnalyticsHandlers.LogBeginActivities PagesActivityLogger.LogLandingPage ActivityLogService.Log Enumerable.All ContactActivityLogValidator.IsValid AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
8
|
(.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US'; DECLARE @NodeID int = 525;
SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END AS [CMS_P] FROM ( SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild] FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID) ) AS SubData ORDER BY CMS_P DESC @DocumentCulture ("en-US") @NodeID (525) 3.1 kB
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfo.EnsurePageTemplateInfo (2) PageTemplateInfoProvider.GetPageTemplateInfo AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
9
|
(cms.pagetemplate.generalselect) DECLARE @PageTemplateID int = 85;
SELECT TOP 1 * FROM CMS_PageTemplate WHERE [PageTemplateID] = @PageTemplateID @PageTemplateID (85) 120 B
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfo.EnsurePageTemplateInfo (2) PageTemplateInfoProvider.GetPageTemplateInfo AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfo.EnsurePageTemplateInfo (2) PageTemplateInfoProvider.GetPageTemplateInfo AbstractInfoProvider`3.GetInfoById CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetCompleteSettings DataQueryBase`1.EnsureDefaultSource DataQueryBase`1.GetDefaultSource ClassStructureInfo.GetClassInfo DataClassInfoProvider.GetClassStructureInfoFromDB DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
10
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'cms.personalization';
SELECT [ClassXmlSchema], [ClassTableName] FROM CMS_Class WHERE [ClassName] = @ClassName @ClassName ("cms.personalization") 170 B
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetCompleteSettings DataQueryBase`1.EnsureDefaultSource DataQueryBase`1.GetDefaultSource ClassStructureInfo.GetClassInfo DataClassInfoProvider.GetClassStructureInfoFromDB DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetCompleteSettings DataQueryBase`1.EnsureDefaultSource DataQueryBase`1.GetDefaultSource ClassStructureInfo.GetClassInfo DataClassInfoProvider.GetClassStructureInfoFromDB DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal QueryInfoProvider.GetFullNameWhereCondition AbstractInfoProvider`3.GetInfoByCodeName DataClassInfoProviderBase`1.GetInfoByColumn DataQueryBase`1.get_TotalRecords DataQueryBase`1.LoadTotalRecordsNonPaged DataQueryBase`1.get_TotalRecords DataQueryBase`1.LoadTotalRecordsNonPaged DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
11
|
(.generalselect) DECLARE @ClassName nvarchar(max) = N'cms.personalization';
SELECT (COUNT(*)) AS [Count] FROM ( SELECT * FROM CMS_Class WHERE [ClassName] = @ClassName ) AS SubData @ClassName ("cms.personalization") 189 B
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal QueryInfoProvider.GetFullNameWhereCondition AbstractInfoProvider`3.GetInfoByCodeName DataClassInfoProviderBase`1.GetInfoByColumn DataQueryBase`1.get_TotalRecords DataQueryBase`1.LoadTotalRecordsNonPaged DataQueryBase`1.get_TotalRecords DataQueryBase`1.LoadTotalRecordsNonPaged DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal QueryInfoProvider.GetFullNameWhereCondition AbstractInfoProvider`3.GetInfoByCodeName DataClassInfoProviderBase`1.GetInfoByColumn DataQueryBase`1.get_TotalRecords DataQueryBase`1.LoadTotalRecordsNonPaged DataQueryBase`1.get_TotalRecords DataQueryBase`1.LoadTotalRecordsNonPaged DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal QueryInfoProvider.GetFullNameWhereCondition AbstractInfoProvider`3.GetInfoByCodeName DataClassInfoProviderBase`1.GetInfoByColumn DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
12
|
(cms.class.generalselect) DECLARE @ClassName nvarchar(max) = N'cms.personalization';
SELECT * FROM CMS_Class WHERE [ClassName] = @ClassName @ClassName ("cms.personalization") 137 B
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal QueryInfoProvider.GetFullNameWhereCondition AbstractInfoProvider`3.GetInfoByCodeName DataClassInfoProviderBase`1.GetInfoByColumn DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal QueryInfoProvider.GetFullNameWhereCondition AbstractInfoProvider`3.GetInfoByCodeName DataClassInfoProviderBase`1.GetInfoByColumn DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
13
|
(cms.query.generalselect) SELECT TOP 1 * FROM CMS_Query WHERE QueryName = N'selectall' AND ClassID = 1841
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal DataQueryBase`1.GetCompleteQueryParametersInternal DataQueryBase`1.GetQueryParameters QueryInfoProvider.GetQueryInfo QueryInfoProvider.GetQueryInfoInternal AbstractInfoProvider`3.GetInfoByFullName AbstractInfoProvider`3.GetInfoByFullNameInternal CMSQueryProvider`1.Execute EnumerableExecutor`1.ExecuteBoxed Enumerable.FirstOrDefault <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
14
|
(cms.personalization.selectall) SELECT TOP 1 * FROM CMS_Personalization WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 525
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
15
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N''; DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText] FROM View_CMS_ResourceString_Joined WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("") @CultureCode ("en-US") 262 B
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
16
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryText'; DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText] FROM View_CMS_ResourceString_Joined WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("QueryLog.QueryText") @CultureCode ("en-US") 298 B
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
17
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'General.Context'; DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText] FROM View_CMS_ResourceString_Joined WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("General.Context") @CultureCode ("en-US") 292 B
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
18
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryDuration'; DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText] FROM View_CMS_ResourceString_Joined WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("QueryLog.QueryDuration") @CultureCode ("en-US") 306 B
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSAdminControls_Debug_QueryLog.OnPreRender ControlsExtensions.SetHeaders LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
CMSAdminControls_Debug_QueryLog.OnPreRender AbstractUserControl.GetString LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
19
|
(cms.resourcestring.generalselect) DECLARE @StringKey nvarchar(max) = N'QueryLog.Info'; DECLARE @CultureCode nvarchar(max) = N'en-US';
SELECT TOP 1 [TranslationText] FROM View_CMS_ResourceString_Joined WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode @StringKey ("QueryLog.Info") @CultureCode ("en-US") 288 B
|
CMSAdminControls_Debug_QueryLog.OnPreRender AbstractUserControl.GetString LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSAdminControls_Debug_QueryLog.OnPreRender AbstractUserControl.GetString LocalizationService.GetString LocalizationHelper.GetStringInternal LocalizationHelper.GetStringFromLocalizationSource Enumerable.FirstOrDefault WhereSelectArrayIterator`2.MoveNext SQLLocalizationSource.GetString ResourceStringInfoProvider.GetStringInternal DataQueryBase`1.GetScalarResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|