Welcome to my HQ.
See what I'm cooking up

Zed's HQ

On dark winter nights a soft flickering glow from Zed’s Lab can be seen for miles as the burners heat the copper pans spinning round and round like miniature cement mixers. Inside the pans, balls of candy are tumbling over each other, dancing like excited electrons as they are charged with hot syrup of delicious flavour. On another table, a vacuum cooker releases its molten hot river of candy, ready to be shaped and coloured into a giant swirl pop. What inclusions will be added tonight?  
 
In his cavernous Zed Candy factory, Zed and 300 candy fanatics make and offer these creations to the rest of the world. Zed loves nothing better than to arrive in the most out of the way place on Earth and to see a candy born in Zed HQ being enjoyed by the local’s.
 
On hot summer nights Zed can sometimes be seen floating in the factory’s outdoor swimming pool, dreaming of his next creation.
 

Design a emoti gumball competition

Have your art travel the globe on a gumball! Zed Candy wants you to design our next emoti gumball.

To win a chance to have your Emoji printed on thousands of gumballs worldwide click on the link below and use our "Emoji Creator" to create your confectionary masterpiece!

Open Emoji Creator

What are you waiting for?

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'/zeds-hq';
DECLARE @NodeAliasPath nvarchar(max) = N'/zeds-hq';
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';
DECLARE @Now datetime2 = '5/28/2018 3:59: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'/zeds-hq' 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.6 kB
 
Table (1 [64], 4 kB)
 
ApplicationModule.PostResolveRequestCache 0.031
 
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 = N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (1 [157], 3.6 kB)
 
ApplicationModule.AcquireRequestState 0.016
 
3
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 30
PageContext.CurrentPage_InitComplete 0.016
 
4
(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 = 28) AND [DocumentCulture] = @DocumentCulture
Table (1 [161], 4.4 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
5
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'zedcandy.sweetproduct';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 9.7 kB)
 
BasicRepeater.OnLoad 0.000
 
6

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('ZEDCandy_SweetProduct');
Table (1 [1], 14 B)
 
BasicRepeater.OnLoad 0.000
 
7
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5071)
BasicRepeater.OnLoad 0.000
 
8
(zedcandy.sweetproduct.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '5/28/2018 3:59:52 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/zed-s-creations/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN ZEDCandy_SweetProduct AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.SweetProductID AND V.ClassName = N'ZEDCandy.SweetProduct' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND ('' = '' OR (DocumentID IN ( SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID = '' ))) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
881 B
 
Table (13 [194], 57 kB)
 
BasicRepeater.OnLoad 0.016
 
9
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5071 AND [TransformationName] = N'Preview_en-IE')
BasicRepeater.OnLoad 0.000
 
10

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('COM_SKU');
Table (1 [1], 5 B)
 
cmsvirtualfiles_transformations__vg_ab4d6549_2d05_44aa_afb1_ab58ee798f70_zedcandy_sweetproduct_preview_ascx.__DataBind__control2 0.016
 
  10 queries, 6.3 kB write, 78 kB read   0.109