Look Before You Leap

A warning has been sounded to small investors to take precautions when investing in residential real estate if associated with the mining boom. While there are big opportunities for “mum and dad” style investors to capitalise on the boom and enter into a new mortgage, the Chief Operating Officer of Surat Basin Property Group said there are numerous factors to consider, including local representation.

“There are a number of operators active nationally who are marketing property in the mining areas, but in many instances they have no local representation,” Jason van Hooft said. He said they often have no maintenance teams on the ground to deal with warranty issues and don’t have leasing and rental management capabilities. Potential investors should do their homework and make sure they look at the quality of construction and design, the true location of the property and local representation of the development company that is marketing the investment in question.
Source: http://www.news.com.au/realestate/news/use-caution-with-mining-real-estate/story-fncq3gat-1226425975833

Follow loans.com.au

x-smallsmallmediumlarge
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute
> URLRewritingHandlers.AuthorizeRequest
4 >> TypeInfo(cms.deviceprofile).Events.GetData SimpleHandler`2.StartEvent
5 RequestEvents.PostAuthorize.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.HandleClickjacking
6 RequestEvents.PostResolveRequestCache.Execute
> URLRewritingHandlers.RewriteUrl
7 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
8 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
9 >> URLRewritingEvents.ProcessABTest.Execute SimpleHandler`2.StartEvent
>>> ABHandlers.ProcessABTest
10 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
11 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
12 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
13 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
14 >>> TypeInfo(om.contact).Events.Insert SimpleHandler`2.StartEvent
>>>> ObjectEvents.Insert.Before
>>>> ObjectEvents.Insert.After
15 >>>>> TypeInfo(om.contact).Events.LogChange SimpleHandler`2.StartEvent
>>>>> ContinuousIntegrationHandlers.InsertAfter
16 >>> TypeInfo(om.scorecontactrule).Events.GetData SimpleHandler`2.StartEvent
17 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
18 RequestEvents.AcquireRequestState.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
19 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
20 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
21 >>> TypeInfo(om.contact).Events.GetData SimpleHandler`2.StartEvent
22 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
23 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
24 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
25 >>>> TypeInfo(cms.versionhistory).Events.GetData SimpleHandler`2.StartEvent
26 >> TypeInfo(om.abvariant).Events.GetData SimpleHandler`2.StartEvent
27 >>> TypeInfo(om.abvariant).Events.GetData SimpleHandler`2.StartEvent
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
28 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
29 TypeInfo(cms.document).Events.GetData PageContext.CurrentPage_InitComplete
30 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
31 >> DocumentEvents.GetData PageContext.CurrentPage_InitComplete
32 >>> TypeInfo(cms.document.cms.blogpost).Events.GetData PageContext.CurrentPage_InitComplete
33 >> TypeInfo(om.mvtest).Events.GetData PageContext.CurrentPage_InitComplete
34 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
35 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
36 DocumentEvents.GetData BasicRepeater.OnLoad
37 TypeInfo(cms.document.cms.blogpost).Events.GetData BasicRepeater.OnLoad
38 DocumentEvents.GetData BasicRepeater.OnLoad
39 TypeInfo(cms.document.cms.article).Events.GetData BasicRepeater.OnLoad
40 DocumentEvents.GetData BasicRepeater.OnLoad
41 TypeInfo(cms.document.cms.blogpost).Events.GetData BasicRepeater.OnLoad
42 DocumentEvents.GetData BasicRepeater.OnLoad
43 TypeInfo(cms.document.cms.pressrelease).Events.GetData BasicRepeater.OnLoad
44 DocumentEvents.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
45 TypeInfo(cms.document.cms.blogpost).Events.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
2 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
3 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
4 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 ValidateHash True maxSideSize = 480; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true;administrator SimpleHandler`2.StartEvent
2 ValidateHash True maxSideSize = 1024; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true;administrator
3 ValidateHash True maxSideSize = 1366; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true;administrator
4 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico CMSWebParts_General_javascript.OnPreRender
5 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|www.loans.com.au|/news-hub/leap|en-au|/news-hub/leap|true
template|23462
nodeid|3445
pageinfo
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|www.loans.com.au|https://www.loans.com.au/news-hub/leap|en-au||true|true
template|23462
nodeid|3445
pageinfo
SimpleHandler`2.StartEvent
3 GET allabtests SimpleHandler`2.StartEvent
4 GET maxmind|172.30.22.250 SimpleHandler`2.StartEvent
5 TOUCH om.contact|all
om.contact|byid|3159238
om.contact|byguid|7d595382-febb-4786-addc-33dacfc17cd8
SimpleHandler`2.StartEvent
6 GET cms.searchengine|cachedids|crawlers SimpleHandler`2.StartEvent
7 ADD pageinfo|www.loans.com.au|/news-media/news-hub|en-au||false
template|23445
nodeid|4
pageinfo
PageContext.CurrentPage_InitComplete
8 ADD pageinfo|www.loans.com.au|/news-media|en-au||false
template|23446
nodeid|1
pageinfo
9 GET pageinfo|www.loans.com.au|/|en-au||false PageContext.CurrentPage_InitComplete
10 ADD currentdocument|www.loans.com.au|/news-media/news-hub/look-before-you-leap|en-au
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/news-media/news-hub/look-before-you-leap
PageContext.CurrentPage_InitComplete
11 ADD cmsdatasource||en-au|loans|/news-media/blog/%|en-au|false|cms.blogpost||blogpostdate desc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|6||false||
webpartinstance|7ebd9011-5514-472e-9542-4df7b5928feb
nodes|loans|cms.blogpost|all
node|loans|/news-media/blog|childnodes
BasicRepeater.OnLoad
12 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.article|||-1|true|7d57c697-92c1-4749-a8ac-bce66639aca7|isrelatedto|true|0||false||
webpartinstance|a7695d19-63a2-421c-8272-b6c47da34f52
nodes|www.loans.com.au|cms.article|all
node|www.loans.com.au|/|childnodes
13 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.blogpost|||-1|true|7d57c697-92c1-4749-a8ac-bce66639aca7|isrelatedto|true|0||false||
webpartinstance|394f2e77-7a15-44c2-ac8e-6a58bf8640ce
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/|childnodes
14 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.pressrelease|||-1|true|7d57c697-92c1-4749-a8ac-bce66639aca7|isrelatedto|true|0||false||
webpartinstance|36d9cf08-b17c-4f12-ae7d-110df9357271
nodes|www.loans.com.au|cms.pressrelease|all
node|www.loans.com.au|/|childnodes
15 ADD cmsdatasource||en-au|www.loans.com.au|/news-media/news-hub/look-before-you-leap|en-au|false|cms.blogpost||blogpostdate desc|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
webpartinstance|8e3fa3b7-068f-478e-b421-d106bafd6ded
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/news-media/news-hub/look-before-you-leap
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
16 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /news-hub/leap 0.000
0.016
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.016
0.062
 
3 > OnPreInit 0.078
0.000
 
4 > OnInit 0.078
0.047
 
5 > OnLoad 0.125
0.172
 
6 > OnPreRender 0.297
N/A
    0.297  
Request cookies:
 NameValue
1 CMSPreferredCultureen-AU
2 ASP.NET_SessionIdg2p4kbqzth4neh5bl0hh4rhu
3 Campaign 
4 Source 
5 CurrentContact7d595382-febb-4786-addc-33dacfc17cd8
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-AU26/04/2018 5:45:33 PM
2 ASP.NET_SessionIdg2p4kbqzth4neh5bl0hh4rhu 
3 Campaign 26/04/2016 5:45:33 PM
4 Source 26/04/2016 5:45:33 PM
5 CurrentContact7d595382-febb-4786-addc-33dacfc17cd826/04/2067 5:45:33 PM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (http://commoncrawl.org/faq/)
4 UserHostAddress172.30.22.250
5 UserName 
6 SessionIDg2p4kbqzth4neh5bl0hh4rhu
7 ServerNameKWFS-B1
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
(cms.deviceprofile.generalselect)
DECLARE @ProfileEnabled int = 1;

SELECT *
FROM CMS_DeviceProfile
WHERE [ProfileEnabled] = @ProfileEnabled
ORDER BY ProfileOrder
Table (3 [12], 1.3 kB)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
2
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/news-hub/leap';
DECLARE @NodeAliasPath nvarchar(max) = N'/news-hub/leap';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

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-AU' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/news-hub/leap' 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)))
) AS SubData
ORDER BY CMS_P DESC
3.4 kB
 
Table (1 [64], 638 B)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-au';

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'/News-Media/News-Hub', N'/News-Media', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (3 [157], 10.8 kB)
 
SimpleHandler`2.StartEvent 0.016
 
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 - 2017-04-26 17:45:33.865';
DECLARE @ContactSalutation nvarchar = NULL;
DECLARE @ContactTitleBefore nvarchar = NULL;
DECLARE @ContactTitleAfter nvarchar = NULL;
DECLARE @ContactJobTitle nvarchar = NULL;
DECLARE @ContactAddress1 nvarchar = NULL;
DECLARE @ContactAddress2 nvarchar = NULL;
DECLARE @ContactCity nvarchar = NULL;
DECLARE @ContactZIP nvarchar = NULL;
DECLARE @ContactStateID nvarchar = NULL;
DECLARE @ContactCountryID nvarchar = NULL;
DECLARE @ContactMobilePhone nvarchar = NULL;
DECLARE @ContactHomePhone nvarchar = NULL;
DECLARE @ContactBusinessPhone nvarchar = NULL;
DECLARE @ContactEmail nvarchar = NULL;
DECLARE @ContactWebSite 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 @ContactMergedWithContactID nvarchar = NULL;
DECLARE @ContactIsAnonymous bit = 1;
DECLARE @ContactSiteID int = 1;
DECLARE @ContactGUID uniqueidentifier = '7d595382-febb-4786-addc-33dacfc17cd8';
DECLARE @ContactLastModified datetime2 = '4/26/2017 5:45:33 PM';
DECLARE @ContactCreated datetime2 = '4/26/2017 5:45:33 PM';
DECLARE @ContactMergedWhen nvarchar = NULL;
DECLARE @ContactGlobalContactID nvarchar = NULL;
DECLARE @ContactBounces nvarchar = NULL;
DECLARE @ContactLastLogon 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], [ContactSalutation], [ContactTitleBefore], [ContactTitleAfter], [ContactJobTitle], [ContactAddress1], [ContactAddress2], [ContactCity], [ContactZIP], [ContactStateID], [ContactCountryID], [ContactMobilePhone], [ContactHomePhone], [ContactBusinessPhone], [ContactEmail], [ContactWebSite], [ContactBirthday], [ContactGender], [ContactStatusID], [ContactNotes], [ContactOwnerUserID], [ContactMonitored], [ContactMergedWithContactID], [ContactIsAnonymous], [ContactSiteID], [ContactGUID], [ContactLastModified], [ContactCreated], [ContactMergedWhen], [ContactGlobalContactID], [ContactBounces], [ContactLastLogon], [ContactCampaign], [ContactSalesForceLeadID], [ContactSalesForceLeadReplicationDisabled], [ContactSalesForceLeadReplicationDateTime], [ContactSalesForceLeadReplicationSuspensionDateTime], [ContactCompanyName], [ContactSalesForceLeadReplicationRequired], [ContactPersonaID])
VALUES (@ContactFirstName, @ContactMiddleName, @ContactLastName, @ContactSalutation, @ContactTitleBefore, @ContactTitleAfter, @ContactJobTitle, @ContactAddress1, @ContactAddress2, @ContactCity, @ContactZIP, @ContactStateID, @ContactCountryID, @ContactMobilePhone, @ContactHomePhone, @ContactBusinessPhone, @ContactEmail, @ContactWebSite, @ContactBirthday, @ContactGender, @ContactStatusID, @ContactNotes, @ContactOwnerUserID, @ContactMonitored, @ContactMergedWithContactID, @ContactIsAnonymous, @ContactSiteID, @ContactGUID, @ContactLastModified, @ContactCreated, @ContactMergedWhen, @ContactGlobalContactID, @ContactBounces, @ContactLastLogon, @ContactCampaign, @ContactSalesForceLeadID, @ContactSalesForceLeadReplicationDisabled, @ContactSalesForceLeadReplicationDateTime, @ContactSalesForceLeadReplicationSuspensionDateTime, @ContactCompanyName, @ContactSalesForceLeadReplicationRequired, @ContactPersonaID);

SELECT SCOPE_IDENTITY() AS [ID]
3.9 kB
 
Table (1 [1], 7 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.scorecontactrule.generalselect)
DECLARE @ContactID int = 3159238;

SELECT DISTINCT [ContactID], [ScoreID], (SUM(Value)) AS [Score]
FROM OM_ScoreContactRule
WHERE ([Expiration] IS NULL OR (DATEDIFF(d, GETDATE(), Expiration) >= 0)) AND [ContactID] = @ContactID
GROUP BY ContactID, ScoreID
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
6
(cms.user.updateallsessions)
Proc_CMS_Session_UpdateAll
@SetColumns ("SessionFullName = 'Anonymous - 2017-04-26 17:45:33.865',SessionUserCreated = '4/26/2017 5:45:33 PM'")
@WhereCond ("SessionContactID = 3159238")
151 B
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
N/A
7
(cms.user.updatesession)
Proc_CMS_Session_Update
@SessionIdentifier ("g2p4kbqzth4neh5bl0hh4rhu")
@SessionUserID ()
@SessionLocation ("/News-Media/News-Hub/Look-Before-You-Leap")
@SessionLastActive (4/26/2017 5:45:33 PM)
@SessionLastLogon (4/26/2017 5:45:33 PM)
@SessionExpires (4/26/2017 6:06:33 PM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-26 17:45:33.865")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/26/2017 5:45:33 PM)
@SessionContactID (3159238)
181 B
 
Table (1 [1], 4 B)
 
SimpleHandler`2.StartEvent 0.016
 
CommitTransaction()
SimpleHandler`2.StartEvent N/A
CloseConnection()
N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
8
(om.contact.generalselect)
DECLARE @ContactID int = 3159238;

SELECT *
FROM OM_Contact
WHERE [ContactID] = @ContactID
Table (1 [43], 237 B)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
N/A
9
(cms.user.updatesession)
Proc_CMS_Session_Update
@SessionIdentifier ("g2p4kbqzth4neh5bl0hh4rhu")
@SessionUserID ()
@SessionLocation ("/News-Media/News-Hub/Look-Before-You-Leap")
@SessionLastActive (4/26/2017 5:45:33 PM)
@SessionLastLogon ()
@SessionExpires (4/26/2017 6:06:33 PM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-26 17:45:33.865")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/26/2017 5:45:33 PM)
@SessionContactID (3159238)
177 B
 
Table (1 [1], 4 B)
 
SimpleHandler`2.StartEvent 0.016
 
CommitTransaction()
SimpleHandler`2.StartEvent N/A
CloseConnection()
N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
10
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeGUID uniqueidentifier = '7d57c697-92c1-4749-a8ac-bce66639aca7';
DECLARE @Now datetime2 = '4/26/2017 5:45:33 PM';

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 [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
522 B
 
Table (1 [157], 998 B)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
11
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 8451
Table (1 [23], 4.6 kB)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
12
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/News-Media/News-Hub/Look-Before-You-Leap';
DECLARE @ABVariantSiteID int = 1;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
13
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
DECLARE @NodeID int = 4;

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-AU' 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)
) AS SubData
ORDER BY CMS_P DESC
3 kB
 
Table (1 [64], 2.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
14
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

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'/News-Media', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 7.9 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
15
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
DECLARE @NodeID int = 1;

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-AU' 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)
) AS SubData
ORDER BY CMS_P DESC
3 kB
 
Table (1 [64], 5.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
16
(cms.blogpost.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-au';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogPost AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogPostID AND V.ClassName = N'CMS.BlogPost' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE (NodeID = 3445) AND [DocumentCulture] = @DocumentCulture
Table (1 [169], 2.6 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
17
(om.mvtest.generalselect)
DECLARE @MVTestPage nvarchar(max) = N'/News-Media/News-Hub/Look-Before-You-Leap';
DECLARE @MVTestSiteID int = 1;

SELECT *
FROM OM_MVTest
WHERE [MVTestPage] = @MVTestPage AND [MVTestSiteID] = @MVTestSiteID
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
18
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 3440
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
BasicRepeater.OnLoad N/A
19
(.generalselect)
DECLARE @NodeSiteID int = 0;
DECLARE @Now datetime2 = '4/26/2017 5:45:33 PM';
DECLARE @NodeAliasPath nvarchar(max) = N'/News-Media/Blog/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
DECLARE @CMS_DUP int = 1;

SELECT TOP 6 *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY DocumentNodeID, DocumentCulture ORDER BY CASE WHEN NodeLinkedNodeID IS NULL THEN 1 ELSE 2 END) AS [CMS_DUP], ROW_NUMBER() OVER (ORDER BY BlogPostDate DESC) AS [CMS_ORN]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogPost AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogPostID AND V.ClassName = N'CMS.BlogPost' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_DUP] = @CMS_DUP
ORDER BY CMS_ORN
1 kB
 
BasicRepeater.OnLoad 0.016
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
20
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/26/2017 5:45:33 PM';
DECLARE @NodeGUID uniqueidentifier = '7d57c697-92c1-4749-a8ac-bce66639aca7';
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';
DECLARE @DocumentCulture nvarchar(max) = N'en-au';
DECLARE @CMS_C int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_Article AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.ArticleID AND V.ClassName = N'CMS.Article' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeID] IN (
SELECT [RightNodeID]
FROM CMS_Relationship LEFT OUTER JOIN CMS_RelationshipName ON CMS_Relationship.RelationshipNameID = CMS_RelationshipName.RelationshipNameID
WHERE [LeftNodeID] IN (
SELECT [NodeID]
FROM CMS_Tree
WHERE [NodeGUID] = @NodeGUID
) AND [RelationshipName] = @RelationshipName
) AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_C] = @CMS_C
1.3 kB
 
BasicRepeater.OnLoad 0.047
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
21
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/26/2017 5:45:34 PM';
DECLARE @NodeGUID uniqueidentifier = '7d57c697-92c1-4749-a8ac-bce66639aca7';
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';
DECLARE @DocumentCulture nvarchar(max) = N'en-au';
DECLARE @CMS_C int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogPost AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogPostID AND V.ClassName = N'CMS.BlogPost' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeID] IN (
SELECT [RightNodeID]
FROM CMS_Relationship LEFT OUTER JOIN CMS_RelationshipName ON CMS_Relationship.RelationshipNameID = CMS_RelationshipName.RelationshipNameID
WHERE [LeftNodeID] IN (
SELECT [NodeID]
FROM CMS_Tree
WHERE [NodeGUID] = @NodeGUID
) AND [RelationshipName] = @RelationshipName
) AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_C] = @CMS_C
1.3 kB
 
BasicRepeater.OnLoad 0.047
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
22
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/26/2017 5:45:34 PM';
DECLARE @NodeGUID uniqueidentifier = '7d57c697-92c1-4749-a8ac-bce66639aca7';
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';
DECLARE @DocumentCulture nvarchar(max) = N'en-au';
DECLARE @CMS_C int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_PressRelease AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.PressReleaseID AND V.ClassName = N'CMS.PressRelease' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeID] IN (
SELECT [RightNodeID]
FROM CMS_Relationship LEFT OUTER JOIN CMS_RelationshipName ON CMS_Relationship.RelationshipNameID = CMS_RelationshipName.RelationshipNameID
WHERE [LeftNodeID] IN (
SELECT [NodeID]
FROM CMS_Tree
WHERE [NodeGUID] = @NodeGUID
) AND [RelationshipName] = @RelationshipName
) AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_C] = @CMS_C
1.3 kB
 
BasicRepeater.OnLoad 0.062
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
23
(cms.blogpost.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/26/2017 5:45:34 PM';
DECLARE @NodeAliasPath nvarchar(max) = N'/News-Media/News-Hub/Look-Before-You-Leap';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogPost AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogPostID AND V.ClassName = N'CMS.BlogPost' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY BlogPostDate DESC
788 B
 
Table (1 [169], 2.6 kB)
 
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender 0.016
 
CloseConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
  23 queries, 22 kB write, 40 kB read   0.250
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% maxSideSize = 480; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true; %} False administrator SimpleHandler`2.StartEvent 0.016
 
return false False 0.000
 
> maxSideSize = 480; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true; False administrator 0.000
 
2 {% maxSideSize = 1024; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true; %} False administrator 0.000
 
return false False 0.000
 
> maxSideSize = 1024; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true; False administrator 0.000
 
3 {% maxSideSize = 1366; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true; %} False administrator 0.000
 
return false False 0.000
 
> maxSideSize = 1366; width = CurrentDevice.ScreenPixelsWidth; height = CurrentDevice.ScreenPixelsHeight; if (!CurrentDevice.IsMobile || ((width > maxSideSize)||(height > maxSideSize))){ return false; } return true; False administrator 0.000
 
4 {% CanonicalURL != "" %} False CMSAbstractWebPart.OnInit 0.000
 
> CanonicalURL != "" False 0.000
 
5 {% NoFollow %} null 0.000
 
> NoFollow null 0.000
 
6 {% IncludeOptimizely %} null 0.016
 
> IncludeOptimizely null 0.000
 
7 {% DisclaimerContent %} null PageContext.CurrentPage_InitComplete 0.000
 
> DisclaimerContent null 0.000
 
8 {% pagetitle_orelse_name %} Look Before You Leap - Loans.com.au DocumentBase.Load 0.000
 
> pagetitle_orelse_name Look Before You Leap - Loans.com.au 0.000
 
9 {% CurrentDateTime.Hour %} 17 FIRSTMAC-srvc-kentico CMSWebParts_General_javascript.OnPreRender 0.000
 
> CurrentDateTime.Hour 17 FIRSTMAC-srvc-kentico 0.000
 
10 {% CurrentDateTime.Hour %} 17 FIRSTMAC-srvc-kentico 0.000
 
> CurrentDateTime.Hour 17 FIRSTMAC-srvc-kentico 0.000
 
      
Web farm synchronizations done by this page:
 Task typeTargetDataContext
1 DICTIONARYCOMMAND DELETEITEMINT¦om.contact_ContactID¦3159238 SimpleHandler`2.StartEvent
2 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦7d595382-febb-4786-addc-33dacfc17cd8|1
3 TOUCHCACHEITEM om.contact|all¦om.contact|byid|3159238¦om.contact|byguid|7d595382-febb-4786-addc-33dacfc17cd8 SimpleHandler`2.StartEvent
4 DICTIONARYCOMMAND DELETEITEMINT¦om.contact_ContactID¦3159238 SimpleHandler`2.StartEvent
5 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦7d595382-febb-4786-addc-33dacfc17cd8|1
6 INVALIDATEOBJECT om.contact 3159238 SimpleHandler`2.StartEvent
     
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/news-hub/leap" (14 B)
14 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId1
Yes
Text = "g2p4kbqzth4neh5bl0hh4rhu" (24 B)
24 B
 
4 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId2
Yes
Text = "g2p4kbqzth4neh5bl0hh4rhu" (24 B)
24 B
 
5 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId3
Yes
Text = "g2p4kbqzth4neh5bl0hh4rhu" (24 B)
24 B
 
6 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId4
Yes
Text = "g2p4kbqzth4neh5bl0hh4rhu" (24 B)
24 B
 
7 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
8 ZoneA
BlogPostsDataSource
srcDocuments
Yes
IsSelected = True
0 B
 
9 BlogPostsRepeater
plcBasicRepeater
N/A
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
ResolveDynamicControls = True
DataSourceName = "BlogPostsDataSource" (19 B)
HideControlForZeroRows = True
DataBindByDefault = False
_!ItemCount = 1
32 B
 
10 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes