Queries and Complaints

We trust that you will find all of our Zed Candy products in excellent condition. Your feedback is important in helping us to review and improve our products. Your comments, suggestions, concerns and complaints are all feedback, so please feel free to get in touch
 

SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/boring-adult-zone/parent-zone/complaints-and-queries';
DECLARE @NodeAliasPath nvarchar(max) = N'/boring-adult-zone/parent-zone/complaints-and-queries';
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';
DECLARE @Now datetime2 = '5/28/2018 3:53:49 AM';

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], [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-IE' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/boring-adult-zone/parent-zone/complaints-and-queries' 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], [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))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.7 kB
 
Table (1 [64], 3.4 kB)
 
ApplicationModule.PostResolveRequestCache 0.000
 
2
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25476;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 13.2 kB)
 
ApplicationModule.PostResolveRequestCache 0.016
 
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';

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 IN (N'/Boring-Adult-Zone/Parent-Zone', N'/Boring-Adult-Zone', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (3 [157], 8.4 kB)
 
ApplicationModule.AcquireRequestState 0.000
 
4
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';
DECLARE @NodeID int = 15;
DECLARE @Now datetime2 = '5/28/2018 3:53:49 AM';

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], [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-IE' 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], [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) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.3 kB
 
Table (1 [64], 970 B)
 
PageContext.CurrentPage_InitComplete 0.031
 
5
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25479;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 12.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
6
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';
DECLARE @NodeID int = 13;
DECLARE @Now datetime2 = '5/28/2018 3:53:49 AM';

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], [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-IE' 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], [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) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.3 kB
 
Table (1 [64], 3.2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
7
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25478;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 37 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
8
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 24
PageContext.CurrentPage_InitComplete 0.000
 
9
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Widget';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 4.1 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
10
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Widget';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 16.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
11
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 2197)
PageContext.CurrentPage_InitComplete 0.000
 
12
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 2197)
PageContext.CurrentPage_InitComplete 0.016
 
13
(cms.widget.generalselect)
SELECT *
FROM CMS_Widget
Table (116 [22], 303 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
14
(cms.webpart.generalselect)
DECLARE @WebPartID int = 203;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
Table (1 [20], 4.1 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
15
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Form';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 6 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
16
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Form';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 17.3 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
17
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 880)
PageContext.CurrentPage_InitComplete 0.000
 
18
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 880)
PageContext.CurrentPage_InitComplete 0.000
 
19
(cms.form.generalselect)
SELECT *
FROM CMS_Form
Table (6 [25], 4.5 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
20
(cms.class.generalselect)
DECLARE @ClassID int = 5075;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 8.2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
21
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.AlternativeForm';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 3.5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
22
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.AlternativeForm';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 8.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
23
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1745)
PageContext.CurrentPage_InitComplete 0.000
 
24
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1745)
PageContext.CurrentPage_InitComplete 0.000
 
25
(cms.alternativeform.generalselect)
SELECT TOP 1 *
FROM CMS_AlternativeForm
WHERE (FormClassID = 5075 AND FormName = 'insert')
PageContext.CurrentPage_InitComplete 0.000
 
26
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'bizform.complaintsform';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2.5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
27

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('Form_ZEDCandy_ComplaintsForm');
Table (1 [1], 16 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
28
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.FormUserControl';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 5.1 kB)
 
EditingFormControl.CreateChildControls 0.000
 
29
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.FormUserControl';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 19.4 kB)
 
EditingFormControl.CreateChildControls 0.016
 
30
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 846)
EditingFormControl.CreateChildControls 0.000
 
31
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 846)
EditingFormControl.CreateChildControls 0.000
 
32
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'TextBoxControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 15.6 kB)
 
EditingFormControl.CreateChildControls 0.000
 
33
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'emailinput';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 2.3 kB)
 
0.000
 
34
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'TextAreaControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 17.1 kB)
 
0.000
 
35
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'UploadControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 3 kB)
 
0.000
 
36
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.ok';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.000
 
37
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MenuItemID AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE (NodeID = 22) AND [DocumentCulture] = @DocumentCulture
Table (1 [161], 3.8 kB)
 
ContentPage.OnLoad 0.000
 
38
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSAutoResizeImageWidth';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSFormControls_Media_UploadControl.Page_Load 0.000
 
39
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSAutoResizeImageHeight';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSFormControls_Media_UploadControl.Page_Load 0.000
 
40
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSAutoResizeImageMaxSideSize';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSFormControls_Media_UploadControl.Page_Load 0.000
 
41
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'uploader.deleteconfirmation';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
Uploader.OnLoad 0.000
 
42
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.uploadfile';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
LocalizedLabel.OnPreRender 0.000
 
43
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.submit';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
LocalizedButton.OnPreRender 0.016
 
  43 queries, 16.1 kB write, 523 kB read   0.141