Interest rates drop again! How low can they go?

Interest rates drop again! How low can they go?

The Official Cash Rate, as determined by the Reserve Bank of Australia (RBA), is now at an historic low of 2 per cent. This is notable because it is far below historic trends; since 1990 the average home loan interest rate has been 5.13 per cent, and the closest the cash rate has previously come to this level was when it briefly dropped as low as 3 per cent in April, 2009.

The reason this will impact home buyers is because the interest rate from your lender is the most critical indicator of the overall cost of borrowing money towards a property. The price of properties will fluctuate based on a host of factors, including the fact that lower interest rates may push property prices up, as cheaper cash means more people are likely to take out home loans. This then increases the demand for properties, which drives their price up. But for people looking to get into the property market, an environment of low interest rates is a good time to be involved.

Put simply, borrowing is cheaper now than it has been for many years.

 

 

Understanding the RBA

 

With the cash rate so low for such a long time, the first question many ask is why has the RBA kept it at that rate, and how long can we expect it to remain there?

The short answer is that the RBA cuts the cash rate when it wants to encourage consumers to spend money. A low cash rate is seen to have an impact on everything from home loan applications (which started 2015 with the strongest rise in six months) to reducing unemployment (which has eased from 6.3 per cent to 6.1 per cent, and is expected to fall lower). People and businesses borrow more money, more often, when interest rates come down, and we see that reflected in the debt to income ratio statistic, which hit a high of 152.8 in September last year, only slightly lower than the pre-financial crisis peak of 153.2.

The significance of this figure (152.8) is to show that the debt-to-income ratio is nearly at where it was pre-GFC, thanks to those with personal debts paying them down quickly and taking advantage of the current low interest rates. The additional money in the economy helps to simulate it, generating growth. When consumer and business sentiment is lower  as it is currently, this stimulation helps to ensure the Australian economy avoids dipping or even falling into recession. When you look at some of the other nations with low official cash rates, such as the Euro Area (0.05), Japan (0.00) and the United States (0.25), you can see a pattern; those nations with low interest rates do need to convince their people to spend money.
 

How Australia's Interest Rate Compares to Other Countries

As effective as it is for a short term stimulus strategy, low interest rates come with the risk of inflation as the market improves. Inflation refers to the rise of prices of goods and services over time. Some inflation is a positive, as it represents an economy that is healthy and growing. However, too much inflation can be a major problem, as a rapid increase in the price of goods can lead to a loss of purchasing power, because household incomes don’t increase at the same pace.

The RBA keeps an eye on statistics such as the Consumer Price Index (CPI) which represents the fluctuations in the cost of buying goods and services in Australia, and Producer Price Index (PPI) which tracks the cost of goods at a wholesale or producer level. For the December quarter in 2014 (the last reporting period), the CPI grew by 0.2 per cent when compared to the previous quarter, and 1.7 per cent compared to the previous year. Meanwhile, the PPI for the same time periods grew 0.1 per cent and 1.1 per cent respectively.

These numbers are significant, because once they reach a certain threshold, indicating that prices are growing too rapidly and inflation is becoming a problem, the RBA will be forced to raise the cash rate to try and ease spending.

The majority of economists have been predicting that interest rates will decline even further than they have already over the course of 2015, and those who disagree with that position still believe that interest rates will be simply left on hold, rather than rise.

The CPI and PPI rates, despite the cash rate cuts, have remained very low, indicating that inflation cannot be expected to become a problem for a while yet. Depressed oil prices have been a chief cause of the low CPI and PPI rates, but even as those start to escalate again there is thought to be little to concern the RBA in terms of inflation for some time to come.

We've just dropped out home loan rates! Compare them now.
 

Why this matters to home loan buyers

 

The cash interest rate in Australia has been cut to as low as 2 per cent by the RBA as of May 2015, and this is predicted to remain at record lows for the near future.

The main reasoning behind this is the NAB’s monthly business survey showing a significant decline in business confidence, despite the previous rate cuts (it fell by 3 points in February, as reported in the March report).

On the one hand, if rates are to stay steady or fall lower it is an obvious boon for people with mortgages or applying for new home loans, as the cost of the loan will be cheaper. However, over the long term it is expected that the interest rate will grow again, and the standard wisdom remains that a borrower should ensure they’re able to meet a 7-8 per cent interest rate rise, but for now it means more money in the pocket. For example, according to the Sydney Morning Herald, with the last rate cut, a person with a $300,000 mortgage was looking at an average saving of $44 a month.

2005
January - 7.05%
February - 7.05%
March - 7.30%
April - 7.30%
May - 7.30%
June - 7.30%
July - 7.30%
August - 7.30%
September - 7.30%
October - 7.30%
November - 7.30%
December - 7.30%
2006
January - 7.30%
February - 7.30%
March - 7.30%
April - 7.30%
May - 7.30%
June - 7.30%
July - 7.30%
August - 7.30%
September - 7.30%
October - 7.30%
November - 7.30%
December - 7.30%
2007
January - 7.80%
February - 7.80%
March - 8.05%
April - 8.05%
May - 8.05%
June - 8.05%
July - 8.05%
August - 8.05%
September - 8.05%
October - 8.05%
November - 8.05%
December - 8.30%
2008
January - 8.30%
February - 8.30%
March - 8.55%
April - 8.55%
May - 8.70%
June - 9.00%
July - 9.35%
August - 9.45%
September - 9.45%
October - 9.45%
November - 9.45%
December - 9.45%
2009
January - 9.30%
February - 8.57%
March - 7.31%
April - 6.55%
May - 5.95%
June - 5.65%
July - 5.65%
August - 5.55%
September - 5.55%
October - 5.55%
November - 5.55%
December - 5.55%
2010
January - 5.74%
February - 5.99%
March - 6.24%
April - 6.65%
May - 6.65%
June - 6.65%
July - 6.91%
August - 7.16%
September - 7.40%
October - 7.40%
November - 7.79%
December - 7.79%
2011
January - 7.79%
February - 7.79%
March - 7.79%
April - 7.79%
May - 7.79%
June - 7.79%
July - 7.79%
August - 7.79%
September - 7.79%
October - 7.79%
November - 7.54%
December - 7.30%
2012
January - 7.30%
February - 7.30%
March - 7.36%
April - 7.36%
May - 6.99%
June - 6.99%
July - 6.99%
August - 6.99%
September - 6.99%
October - 6.60%
November - 6.60%
December - 6.40%
2013
January - 6.40%
February - 6.40%
March - 6.40%
April - 6.40%
May - 6.15%
June - 6.15%
July - 6.15%
August - 5.53%
September - 5.53%
October - 5.53%
November - 5.53%
December - 5.53%
2014
January - 5.53%
February - 5.53%
March - 5.53%
April - 5.53%
May - 5.53%
June - 5.53%
July - 5.53%
August - 5.51%
September - 5.51%
October - 5.51%
November - 5.51%
December - 5.51%

Why is the cash rate important for a home buyer?

 

It’s important to note that with lower interest rates more people are looking to move into the property market, and as a consequence demand is on the rise. The annual increase in the price of housing within capital cities is at 8.3% on average, with Brisbane (5.9%), Melbourne (7.4%), and Sydney (13.7%) experiencing the greatest increase in home prices over the past year. This means that while property in Brisbane increased in price by an average of 5.9% compared to their value last year, property in Sydney has on average increased by 13.7% in 2014 compared to 2013.

Other cities, such as Perth (0.6%), Hobart (0.7%), Darwin (1.6%) and Canberra (1.8%), have seen a more modest increase in home prices. But for most people it is important to be aware that the increase in housing prices does mean they’ll need to borrow more money to make the purchase, even if they are doing so at a lower interest rate.

For people with existing home loans, now could be an excellent time to refinance. This is especially true if you’re looking to continue to reside in the property over the long term as it will give you access to cheap cash with which to pay for expensive renovations, change providers if you’re not happy with you current bank’s competitiveness, or consolidate to pay off other large debts such as a more expensive credit card. It is quite likely interest rates will stay low for long enough to make this an efficient way to manage a large debt and minimise the total amount of interest you will pay.

Despite the rising costs of property, now is the ideal time to apply for a home loan and get yourself either into your first home, or start making property investments. The RBA looks set to keep the cash rate at a low point into the foreseeable future, if not lower it further, and this means that cash is currently cheap and you will have some time to make the most of low home loan interest rates.

To take advantage of the historically low interest rates currently on offer from the RBA, click here to compare our home loans and offer a fast online application process.
 

Apply now


Additional sources:

http://www.loansense.com.au/historical-rates.html
http://www.homeloanadvicecentre.com.au/tools/interestrates.php
http://www.investopedia.com/articles/stocks/09/how-interest-rates-affect-markets.asp
http://www.investopedia.com/articles/03/111203.asp
http://australianpolitics.com/topics/rba/interest-rates-since-1990
http://www.smh.com.au/business/the-economy/interest-rates-at-record-low-but-cheap-debt-a-trap-for-unwary-borrowers-20150307-13xuc5.html
http://www.infochoice.com.au/news/history-of-interest-rate-movements/22007/6/2
http://www.yourmortgage.com.au/article/interest-rate-predictions-188981.aspx
http://propertyupdate.com.au/borrowers-better-2015-rba-holds-rates/
http://mozo.com.au/reserve-bank-interest-rates
http://www.finder.com.au/should-i-refinance-my-home-loan#lower

Image credit: ArchivesACT

x-smallsmallmediumlarge
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 RequestEvents.PostAuthorize.Execute
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
7 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
8 >> TypeInfo(cms.pagetemplate).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 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
31 TypeInfo(cms.document).Events.GetData PageContext.CurrentPage_InitComplete
32 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
33 >> DocumentEvents.GetData PageContext.CurrentPage_InitComplete
34 >>> TypeInfo(cms.document.cms.blogpost).Events.GetData PageContext.CurrentPage_InitComplete
35 >> TypeInfo(om.mvtest).Events.GetData PageContext.CurrentPage_InitComplete
36 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
37 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
38 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
39 DocumentEvents.GetData BasicRepeater.OnLoad
40 TypeInfo(cms.document.cms.blogpost).Events.GetData BasicRepeater.OnLoad
41 DocumentEvents.GetData BasicRepeater.OnLoad
42 TypeInfo(cms.document.cms.pressrelease).Events.GetData BasicRepeater.OnLoad
43 DocumentEvents.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
44 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 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico CMSWebParts_General_javascript.OnPreRender
2 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico
3 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico
4 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-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go|en-au|/news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go|true
template|23526
nodeid|1829
pageinfo
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|www.loans.com.au|https://www.loans.com.au/news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go|en-au||true|true
template|23526
nodeid|1829
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|3159291
om.contact|byguid|d2adfb7d-7026-4daa-bb41-881391bf8443
SimpleHandler`2.StartEvent
6 GET cms.searchengine|cachedids|crawlers SimpleHandler`2.StartEvent
7 ADD pageinfo|www.loans.com.au|/news-media/media-releases|en-au||false
template|23448
nodeid|1363
pageinfo
PageContext.CurrentPage_InitComplete
8 ADD pageinfo|www.loans.com.au|/news-media/media-releases/april-2015|en-au||false
template|23448
nodeid|1783
pageinfo
PageContext.CurrentPage_InitComplete
9 GET pageinfo|www.loans.com.au|/news-media|en-au||false PageContext.CurrentPage_InitComplete
10 GET pageinfo|www.loans.com.au|/|en-au||false
11 ADD currentdocument|www.loans.com.au|/news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go|en-au
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go
PageContext.CurrentPage_InitComplete
12 GET 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|| BasicRepeater.OnLoad
13 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.blogpost|||-1|true|3efa96b7-03e5-4c76-bc4e-99f33a670e49|isrelatedto|true|0||false||
webpartinstance|ea053f36-bb90-46cf-ab6a-71fd621d41d9
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/|childnodes
BasicRepeater.OnLoad
14 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.pressrelease|||-1|true|3efa96b7-03e5-4c76-bc4e-99f33a670e49|isrelatedto|true|0||false||
webpartinstance|72d33e65-b249-4e1c-a37c-14a0c66c0dc2
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/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go|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/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
16 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go 0.000
0.078
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.078
0.094
 
3 > OnPreInit 0.172
0.000
 
4 > OnInit 0.172
0.078
 
5 > OnLoad 0.250
0.016
 
6 > OnPreRender 0.266
N/A
    0.266  
Request cookies:
 NameValue
1 CMSPreferredCultureen-AU
2 ASP.NET_SessionId32jeqfgr5r03k1iibnsf0e3s
3 Campaign 
4 Source 
5 CurrentContactd2adfb7d-7026-4daa-bb41-881391bf8443
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-AU26/04/2018 5:48:29 PM
2 ASP.NET_SessionId32jeqfgr5r03k1iibnsf0e3s 
3 Campaign 26/04/2016 5:48:29 PM
4 Source 26/04/2016 5:48:29 PM
5 CurrentContactd2adfb7d-7026-4daa-bb41-881391bf844326/04/2067 5:48:29 PM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (http://commoncrawl.org/faq/)
4 UserHostAddress172.30.22.250
5 UserName 
6 SessionID32jeqfgr5r03k1iibnsf0e3s
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
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go';
DECLARE @NodeAliasPath nvarchar(max) = N'/news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go';
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-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go' 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.6 kB
 
Table (1 [64], 791 B)
 
SimpleHandler`2.StartEvent 0.031
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
2
(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/Media-Releases/April-2015', N'/News-Media/Media-Releases', N'/News-Media', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (4 [157], 12.5 kB)
 
SimpleHandler`2.StartEvent 0.031
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
3
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 23526;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 35 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:48:29.374';
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 = 'd2adfb7d-7026-4daa-bb41-881391bf8443';
DECLARE @ContactLastModified datetime2 = '4/26/2017 5:48:29 PM';
DECLARE @ContactCreated datetime2 = '4/26/2017 5:48:29 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.031
 
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 = 3159291;

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:48:29.374',SessionUserCreated = '4/26/2017 5:48:29 PM'")
@WhereCond ("SessionContactID = 3159291")
151 B
 
SimpleHandler`2.StartEvent 0.016
 
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 ("32jeqfgr5r03k1iibnsf0e3s")
@SessionUserID ()
@SessionLocation ("/News-Media/Media-Releases/April-2015/Interest-rates-drop-again!-How-low-can-they-go")
@SessionLastActive (4/26/2017 5:48:29 PM)
@SessionLastLogon (4/26/2017 5:48:29 PM)
@SessionExpires (4/26/2017 6:09:29 PM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-26 17:48:29.374")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/26/2017 5:48:29 PM)
@SessionContactID (3159291)
224 B
 
Table (1 [1], 4 B)
 
SimpleHandler`2.StartEvent 0.000
 
CommitTransaction()
SimpleHandler`2.StartEvent N/A
CloseConnection()
N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
8
(om.contact.generalselect)
DECLARE @ContactID int = 3159291;

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 ("32jeqfgr5r03k1iibnsf0e3s")
@SessionUserID ()
@SessionLocation ("/News-Media/Media-Releases/April-2015/Interest-rates-drop-again!-How-low-can-they-go")
@SessionLastActive (4/26/2017 5:48:29 PM)
@SessionLastLogon ()
@SessionExpires (4/26/2017 6:09:29 PM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-26 17:48:29.374")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/26/2017 5:48:29 PM)
@SessionContactID (3159291)
220 B
 
Table (1 [1], 4 B)
 
SimpleHandler`2.StartEvent 0.000
 
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 = '3efa96b7-03e5-4c76-bc4e-99f33a670e49';
DECLARE @Now datetime2 = '4/26/2017 5:48:29 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], 1.1 kB)
 
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] = 4694
Table (1 [23], 33 kB)
 
SimpleHandler`2.StartEvent 0.016
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
12
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/News-Media/Media-Releases/April-2015/Interest-rates-drop-again!-How-low-can-they-go';
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 = 1783;

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], 966 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
14
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/News-Media/Media-Releases';
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 [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 ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))
) AS SubData
ORDER BY CMS_P DESC
3.2 kB
 
Table (1 [64], 3 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
15
(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
16
(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/Media-Releases', N'/News-Media', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (3 [157], 11.2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
17
(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 = 1829) AND [DocumentCulture] = @DocumentCulture
Table (1 [169], 25 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
18
(om.mvtest.generalselect)
DECLARE @MVTestPage nvarchar(max) = N'/News-Media/Media-Releases/April-2015/Interest-rates-drop-again!-How-low-can-they-go';
DECLARE @MVTestSiteID int = 1;

SELECT *
FROM OM_MVTest
WHERE [MVTestPage] = @MVTestPage AND [MVTestSiteID] = @MVTestSiteID
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
19
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 1824
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
BasicRepeater.OnLoad N/A
20
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/26/2017 5:48:29 PM';
DECLARE @NodeGUID uniqueidentifier = '3efa96b7-03e5-4c76-bc4e-99f33a670e49';
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.000
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
21
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/26/2017 5:48:29 PM';
DECLARE @NodeGUID uniqueidentifier = '3efa96b7-03e5-4c76-bc4e-99f33a670e49';
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.016
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
22
(cms.blogpost.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/26/2017 5:48:29 PM';
DECLARE @NodeAliasPath nvarchar(max) = N'/News-Media/Media-Releases/April-2015/Interest-rates-drop-again!-How-low-can-they-go';
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
831 B
 
Table (1 [169], 25 kB)
 
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender 0.016
 
CloseConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
  22 queries, 21 kB write, 155 kB read   0.203
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% CanonicalURL != "" %} False CMSAbstractWebPart.OnInit 0.000
> CanonicalURL != "" False 0.000
2 {% NoFollow %} null 0.000
> NoFollow null 0.000
3 {% IncludeOptimizely %} null 0.000
> IncludeOptimizely null 0.000
4 {% DisclaimerContent %} null PageContext.CurrentPage_InitComplete 0.000
> DisclaimerContent null 0.000
5 {% CanonicalURL != "" %} False CMSAbstractWebPart.OnInit 0.000
> CanonicalURL != "" False 0.000
6 {% NoFollow %} null 0.000
> NoFollow null 0.000
7 {% IncludeOptimizely %} null 0.000
> IncludeOptimizely null 0.000
8 {% DisclaimerContent %} null PageContext.CurrentPage_InitComplete 0.000
> DisclaimerContent null 0.000
9 {% pagetitle_orelse_name %} Interest Rates Drop Again! How Low Can They Go? DocumentBase.Load 0.000
> pagetitle_orelse_name Interest Rates Drop Again! How Low Can They Go? 0.000
10 {% CurrentDateTime.Hour %} 17 FIRSTMAC-srvc-kentico CMSWebParts_General_javascript.OnPreRender 0.000
> CurrentDateTime.Hour 17 FIRSTMAC-srvc-kentico 0.000
11 {% CurrentDateTime.Hour %} 17 FIRSTMAC-srvc-kentico 0.000
> CurrentDateTime.Hour 17 FIRSTMAC-srvc-kentico 0.000
12 {% CurrentDateTime.Hour %} 17 FIRSTMAC-srvc-kentico 0.000
> CurrentDateTime.Hour 17 FIRSTMAC-srvc-kentico 0.000
13 {% 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¦3159291 SimpleHandler`2.StartEvent
2 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦d2adfb7d-7026-4daa-bb41-881391bf8443|1
3 TOUCHCACHEITEM om.contact|all¦om.contact|byid|3159291¦om.contact|byguid|d2adfb7d-7026-4daa-bb41-881391bf8443 SimpleHandler`2.StartEvent
4 DICTIONARYCOMMAND DELETEITEMINT¦om.contact_ContactID¦3159291 SimpleHandler`2.StartEvent
5 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦d2adfb7d-7026-4daa-bb41-881391bf8443|1
6 INVALIDATEOBJECT om.contact 3159291 SimpleHandler`2.StartEvent
     
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/news-media/media-releases/april-2015/interest-rates-drop-again!-how-low-can-they-go" (84 B)
84 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId1
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
4 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId2
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
5 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId3
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
6 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId4
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
7 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
8 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId1
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
9 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId2
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
10 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId3
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
11 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId4
Yes
Text = "32jeqfgr5r03k1iibnsf0e3s" (24 B)
24 B
 
12 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
13 ZoneA
MediaReleasesDataSource
srcDocuments
Yes
IsSelected = True
0 B
 
14 MediaReleasesRepeater
plcBasicRepeater
N/A
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
ResolveDynamicControls = True
DataSourceName = "MediaReleasesDataSource" (23 B)
HideControlForZeroRows = True
DataBindByDefault = False
_!ItemCount = 1
36 B
 
15 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes