Product Enquiry

If you cant find your favourite Zed Candy products at your local store, let us know and we will try and get them stocked for you.  So just give us details of your location, (city, town, region) and we will do our best to get some Zed Candy items stocked nearby.

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/distributors';
DECLARE @NodeAliasPath nvarchar(max) = N'/boring-adult-zone/distributors';
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';
DECLARE @Now datetime2 = '5/28/2018 4:02:04 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/distributors' 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.2 kB)
 
ApplicationModule.PostResolveRequestCache 0.016
 
2
(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', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 7.1 kB)
 
ApplicationModule.AcquireRequestState 0.000
 
3
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 8
PageContext.CurrentPage_InitComplete 0.000
 
4
(cms.class.generalselect)
DECLARE @ClassID int = 5073;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 8.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
5
(cms.alternativeform.generalselect)
SELECT TOP 1 *
FROM CMS_AlternativeForm
WHERE (FormClassID = 5073 AND FormName = 'insert')
PageContext.CurrentPage_InitComplete 0.000
 
6
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'bizform.distributorcontactform';

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

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_DistributorContactForm');
Table (1 [1], 24 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
8
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'countrySelector';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 2.8 kB)
 
EditingFormControl.CreateChildControls 0.000
 
9
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.nodatafound';
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
cmsadmincontrols_ui_uniselector_uniselector_ascx.FrameworkInitialize 0.016
 
10
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'unigrid.filteredzerorowstext';
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
0.000
 
11
(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 = 6) AND [DocumentCulture] = @DocumentCulture
Table (1 [161], 3.6 kB)
 
ContentPage.OnLoad 0.000
 
12
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'countryselector.selectcountryrecord';
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
CMSFormControls_CountrySelector.Page_Load 0.000
 
13
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'countryselector.selectstaterecord';
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
0.016
 
14
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Country';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2.3 kB)
 
CMSAdminControls_UI_UniSelector_UniSelector.OnPreRender 0.000
 
15
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Country';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 7.9 kB)
 
CMSAdminControls_UI_UniSelector_UniSelector.OnPreRender 0.000
 
16
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1125)
CMSAdminControls_UI_UniSelector_UniSelector.OnPreRender 0.000
 
17
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1125)
CMSAdminControls_UI_UniSelector_UniSelector.OnPreRender 0.000
 
18
(cms.country.generalselect)
SELECT TOP 351 [CountryDisplayName], [CountryName]
FROM cms_country
ORDER BY CountryDisplayName
Table (247 [2], 4.8 kB)
 
CMSAdminControls_UI_UniSelector_UniSelector.OnPreRender 0.000
 
  18 queries, 6.9 kB write, 42 kB read   0.047