SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent 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
 
Table (1 [65], 356 B)
 
SimpleHandler`2.StartEvent 0.000
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
2
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 6;

SELECT TOP 1 *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (6)
119 B
 
Table (1 [31], 1 kB)
 
SimpleHandler`2.StartEvent 0.000
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent 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
 
Table (1 [158], 973 B)
 
SimpleHandler`2.StartEvent 0.000
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
SimpleHandler`2.StartEvent 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
 
Table (1 [1], 16 B)
 
SimpleHandler`2.StartEvent 0.000
CommitTransaction()
SimpleHandler`2.StartEvent N/A
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent 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
 
Table (1 [31], 192 B)
 
SimpleHandler`2.StartEvent 0.000
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent 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
@ContactID (47777)
102 B
 
Table (1 [31], 192 B)
 
SimpleHandler`2.StartEvent 0.000
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent 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
@ContactID (47777)
102 B
 
Table (1 [31], 192 B)
 
SimpleHandler`2.StartEvent 0.000
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
PageContext.CurrentPage_InitComplete 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
 
Table (1 [65], 652 B)
 
PageContext.CurrentPage_InitComplete 0.000
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
9
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 85;

SELECT TOP 1 *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (85)
120 B
 
Table (1 [31], 384 B)
 
PageContext.CurrentPage_InitComplete 0.000
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete 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
 
Table (1 [2], 2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete 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
 
Table (1 [1], 4 B)
 
PageContext.CurrentPage_InitComplete 0.000
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete 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
 
Table (1 [54], 4.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
13
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1841
PageContext.CurrentPage_InitComplete 0.000
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
14
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 525
PageContext.CurrentPage_InitComplete 0.000
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender 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 0.000
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
OpenConnection()
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 0.000
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
OpenConnection()
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 0.000
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
OpenConnection()
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 0.000
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender 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 0.000
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
  19 queries, 12.7 kB write, 10.7 kB read   0.000