Lower priced properties moving out of the market

Lower priced properties moving out of the market

The latest RP Data CoreLogic Property Pulse report has highlighted the changing trend in the nation's real estate market, with the market share of properties valued under $400,000 dropping significantly over the 12 months to August 2014.

Lower priced properties moving out of the market

Lower priced properties moving out of the market

The latest RP Data CoreLogic Property Pulse report has highlighted the changing trend in the nation's real estate market, with the market share of properties valued under $400,000 dropping significantly over the 12 months to August 2014.

Foreign investors having a positive impact

Foreign investors having a positive impact

If you're looking to purchase a new house or get pre-approval for your first home loan, it can be easy to imagine all competition from other buyers in the market is negative.

Foreign investment to increase - but not in housing

Minister for Trade and Investment, Andrew Robb has said that Austrade is now calling for submissions on proposed changes to the complying investment framework for certain visas.

Buyers turn their attention to new properties

Buyers turn their attention to new properties

When the time comes to buy a property you have three options - an off-the plan home, a new-build or an established piece of real estate.

Construction and housing grow to be Victoria's most important industries

The continued growth of the housing supply nationwide has been a massive point of conversation for home buyers and investors over the last few months, with a huge economic boost occurring throughout a number of states and territories.

New South Wales infrastructure strategy needed to prepare for future

A recent announcement from the New South Wales government offered some insight into the future of Sydney's infrastructure development.

Continued development of Northern Territory infrastructure offers investment potential

The importance of sustained infrastructure development cannot be overstated when looking for a suitable place to consider taking out a home loan and building an investment portfolio.

Car buying goes from strength to strength

Car buying goes from strength to strength

The Australian motor industry is faring pretty well at the moment, as consumers up and down the country look to upgrade their vehicles.

Which cars are more popular for Australians?

Which cars are more popular for Australians?

New data from the Australian Bureau of Statistics (ABS) reveals some surprising insights into the car-buying habits of Australians, most notably a trend in the type of vehicle being purchased.

Queensland set to see development of new jobs statewide

Queensland Premier Campbell Newman announced a number of plans to help develop the state in the future earlier this month (November 17), which could be a great benefit for those considering taking out a home loan and make moves into property investment in the future.

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 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 >> URLRewritingEvents.ProcessABTest.Execute SimpleHandler`2.StartEvent
>>> ABHandlers.ProcessABTest
9 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
10 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
11 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
12 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
13 >>> TypeInfo(om.contact).Events.Insert SimpleHandler`2.StartEvent
>>>> ObjectEvents.Insert.Before
>>>> ObjectEvents.Insert.After
14 >>>>> TypeInfo(om.contact).Events.LogChange SimpleHandler`2.StartEvent
>>>>> ContinuousIntegrationHandlers.InsertAfter
15 >>> TypeInfo(om.scorecontactrule).Events.GetData SimpleHandler`2.StartEvent
16 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
17 RequestEvents.AcquireRequestState.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
18 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
19 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
20 >>> TypeInfo(om.contact).Events.GetData SimpleHandler`2.StartEvent
21 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
22 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
23 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
24 >>>> TypeInfo(cms.versionhistory).Events.GetData SimpleHandler`2.StartEvent
25 >> TypeInfo(om.abvariant).Events.GetData SimpleHandler`2.StartEvent
26 >>> TypeInfo(om.abvariant).Events.GetData SimpleHandler`2.StartEvent
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
27 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
28 >> DocumentEvents.GetData PageContext.CurrentPage_InitComplete
29 >>> TypeInfo(cms.document.cms.blogmonth).Events.GetData PageContext.CurrentPage_InitComplete
30 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
31 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
32 DocumentEvents.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
33 TypeInfo(cms.document.cms.blogpost).Events.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
34 DocumentEvents.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
35 TypeInfo(cms.document.cms.blogpost).Events.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
36 CMSControlsEvents.TransformationEval.Execute cmsvirtualfiles_transformations__vg_f5715833_f65d_42a1_83d7_ad09fd6dc22b_cms_blogpost_loansblogpostsummary_tiles_ascx.__DataBind__control2
> BackwardCompatibilityHandlers.TransformationEval_Execute
37 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
38 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
39 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
40 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
41 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
42 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
43 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
44 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
45 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
46 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
47 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
48 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
49 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
50 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
51 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
52 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
53 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
54 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
55 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
56 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
57 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
58 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
59 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
60 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
61 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
62 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
63 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
64 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
65 CMSControlsEvents.TransformationEval.Execute
> BackwardCompatibilityHandlers.TransformationEval_Execute
   
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
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 GET pageinfo|www.loans.com.au|/news-media/news-hub|en-au||false SimpleHandler`2.StartEvent
2 ADD pageinfo|www.loans.com.au|/news-hub/january-2015|en-au|/news-hub/january-2015|true
template|23445
nodeid|3589
pageinfo
SimpleHandler`2.StartEvent
3 ADD pageinfobyurl|www.loans.com.au|https://www.loans.com.au/news-hub/january-2015|en-au||true|true
template|23445
nodeid|3589
pageinfo
SimpleHandler`2.StartEvent
4 GET allabtests SimpleHandler`2.StartEvent
5 ADD maxmind|172.30.22.250 SimpleHandler`2.StartEvent
6 TOUCH om.contact|all
om.contact|byid|3166394
om.contact|byguid|cb24f182-3b20-42f8-ba70-e7d5f807d8e2
SimpleHandler`2.StartEvent
7 GET cms.searchengine|cachedids|crawlers SimpleHandler`2.StartEvent
8 GET pageinfo|www.loans.com.au|/news-media|en-au||false PageContext.CurrentPage_InitComplete
9 GET pageinfo|www.loans.com.au|/|en-au||false
10 ADD currentdocument|www.loans.com.au|/news-media/news-hub/january-2015|en-au
nodes|www.loans.com.au|cms.blogmonth|all
node|www.loans.com.au|/news-media/news-hub/january-2015
PageContext.CurrentPage_InitComplete
11 ADD cmsdatasource||en-au|www.loans.com.au|/news-media/news-hub/january-2015/%|en-au|false|cms.blogpost||blogpostdate desc|-1|true|00000000-0000-0000-0000-000000000000||true|1||false||
webpartinstance|693dd7d7-3ec6-4226-be62-e2f49a1cdfe7
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/news-media/news-hub/january-2015|childnodes
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
12 ADD cmsdatasource||en-au|www.loans.com.au|/news-media/news-hub/january-2015/%|en-au|false|cms.blogpost||blogpostdate desc|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||page|0|10
webpartinstance|1a4891bf-142c-4ab2-a2e3-e2c0a0a1bd5b
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/news-media/news-hub/january-2015|childnodes
13 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /news-hub/january-2015 0.000
0.016
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.016
0.047
 
3 > OnPreInit 0.062
0.000
 
4 > OnInit 0.062
0.031
 
5 > OnLoad 0.094
0.000
 
6 > OnPreRender 0.094
N/A
    0.094  
Request cookies:
 NameValue
1 CMSPreferredCultureen-AU
2 ASP.NET_SessionId5et21eus0cbcq5uz5o2rr02g
3 Campaign 
4 Source 
5 CurrentContactcb24f182-3b20-42f8-ba70-e7d5f807d8e2
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-AU27/04/2018 7:33:55 AM
2 ASP.NET_SessionId5et21eus0cbcq5uz5o2rr02g 
3 Campaign 27/04/2016 7:33:55 AM
4 Source 27/04/2016 7:33:55 AM
5 CurrentContactcb24f182-3b20-42f8-ba70-e7d5f807d8e227/04/2067 7:33:55 AM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (http://commoncrawl.org/faq/)
4 UserHostAddress172.30.22.250
5 UserName 
6 SessionID5et21eus0cbcq5uz5o2rr02g
7 ServerNameKWFS-A1
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-hub/january-2015';
DECLARE @NodeAliasPath nvarchar(max) = N'/news-hub/january-2015';
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/january-2015' 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], 446 B)
 
SimpleHandler`2.StartEvent 0.000
 
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/News-Hub', N'/News-Media', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (3 [157], 10.8 kB)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
SimpleHandler`2.StartEvent N/A
3
(om.contact.generalinsert)
DECLARE @ContactFirstName nvarchar = NULL;
DECLARE @ContactMiddleName nvarchar = NULL;
DECLARE @ContactLastName nvarchar(max) = N'Anonymous - 2017-04-27 07:33:55.067';
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 = 'cb24f182-3b20-42f8-ba70-e7d5f807d8e2';
DECLARE @ContactLastModified datetime2 = '4/27/2017 7:33:55 AM';
DECLARE @ContactCreated datetime2 = '4/27/2017 7:33:55 AM';
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
4
(om.scorecontactrule.generalselect)
DECLARE @ContactID int = 3166394;

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
5
(cms.user.updateallsessions)
Proc_CMS_Session_UpdateAll
@SetColumns ("SessionFullName = 'Anonymous - 2017-04-27 07:33:55.067',SessionUserCreated = '4/27/2017 7:33:55 AM'")
@WhereCond ("SessionContactID = 3166394")
151 B
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
N/A
6
(cms.user.updatesession)
Proc_CMS_Session_Update
@SessionIdentifier ("5et21eus0cbcq5uz5o2rr02g")
@SessionUserID ()
@SessionLocation ("/News-Media/News-Hub/January-2015")
@SessionLastActive (4/27/2017 7:33:55 AM)
@SessionLastLogon (4/27/2017 7:33:55 AM)
@SessionExpires (4/27/2017 7:54:55 AM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-27 07:33:55.067")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/27/2017 7:33:55 AM)
@SessionContactID (3166394)
173 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
7
(om.contact.generalselect)
DECLARE @ContactID int = 3166394;

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
8
(cms.user.updatesession)
Proc_CMS_Session_Update
@SessionIdentifier ("5et21eus0cbcq5uz5o2rr02g")
@SessionUserID ()
@SessionLocation ("/News-Media/News-Hub/January-2015")
@SessionLastActive (4/27/2017 7:33:55 AM)
@SessionLastLogon ()
@SessionExpires (4/27/2017 7:54:55 AM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-27 07:33:55.067")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/27/2017 7:33:55 AM)
@SessionContactID (3166394)
169 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
9
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeGUID uniqueidentifier = '6043e678-5740-4ae6-b9c1-45dbd478ee9e';
DECLARE @Now datetime2 = '4/27/2017 7:33:55 AM';

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], 807 B)
 
SimpleHandler`2.StartEvent 0.016
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
10
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 7330
Table (1 [23], 2.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
11
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/News-Media/News-Hub/January-2015';
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
12
(cms.blogmonth.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogMonth AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogMonthID AND V.ClassName = N'CMS.BlogMonth' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE (NodeID = 3589) AND [DocumentCulture] = @DocumentCulture
Table (1 [160], 831 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
13
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/27/2017 7:33:55 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/News-Media/News-Hub/January-2015/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
DECLARE @CMS_DUP int = 1;

SELECT TOP 1 *
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
 
Table (1 [171], 5.5 kB)
 
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender 0.016
 
CloseConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
OpenConnection()
N/A
14
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/27/2017 7:33:55 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/News-Media/News-Hub/January-2015/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
DECLARE @CMS_DUP int = 1;


WITH AllData AS
(
SELECT *, ROW_NUMBER() OVER (ORDER BY [CMS_ORN]) AS [CMS_RN]
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
)
SELECT *, (SELECT COUNT(*) FROM AllData) AS [CMS_TOT]
FROM AllData
WHERE CMS_RN BETWEEN 1 AND 10
ORDER BY CMS_RN
1.2 kB
 
Table (10 [173], 54 kB)
 
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender 0.047
 
CloseConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
  14 queries, 11.9 kB write, 75 kB read   0.078
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 {% pagetitle_orelse_name %} News Hub - Loans.com.au Pty Ltd DocumentBase.Load 0.000
> pagetitle_orelse_name News Hub - Loans.com.au Pty Ltd 0.000
7 {% CurrentDateTime.Hour %} 7 FIRSTMAC-srvc-kentico CMSWebParts_General_javascript.OnPreRender 0.000
> CurrentDateTime.Hour 7 FIRSTMAC-srvc-kentico 0.000
8 {% CurrentDateTime.Hour %} 7 FIRSTMAC-srvc-kentico 0.000
> CurrentDateTime.Hour 7 FIRSTMAC-srvc-kentico 0.000
      
Web farm synchronizations done by this page:
 Task typeTargetDataContext
1 DICTIONARYCOMMAND DELETEITEMINT¦om.contact_ContactID¦3166394 SimpleHandler`2.StartEvent
2 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦cb24f182-3b20-42f8-ba70-e7d5f807d8e2|1
3 TOUCHCACHEITEM om.contact|all¦om.contact|byid|3166394¦om.contact|byguid|cb24f182-3b20-42f8-ba70-e7d5f807d8e2 SimpleHandler`2.StartEvent
4 DICTIONARYCOMMAND DELETEITEMINT¦om.contact_ContactID¦3166394 SimpleHandler`2.StartEvent
5 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦cb24f182-3b20-42f8-ba70-e7d5f807d8e2|1
6 INVALIDATEOBJECT om.contact 3166394 SimpleHandler`2.StartEvent
     
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/news-hub/january-2015" (22 B)
22 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId1
Yes
Text = "5et21eus0cbcq5uz5o2rr02g" (24 B)
24 B
 
4 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId2
Yes
Text = "5et21eus0cbcq5uz5o2rr02g" (24 B)
24 B
 
5 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId3
Yes
Text = "5et21eus0cbcq5uz5o2rr02g" (24 B)
24 B
 
6 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId4
Yes
Text = "5et21eus0cbcq5uz5o2rr02g" (24 B)
24 B
 
7 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
8 BlogPostsRepeater_Hero
plcBasicRepeater
N/A
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
ResolveDynamicControls = True
DataSourceName = "BlogPostsDataSource_Hero" (24 B)
HideControlForZeroRows = True
DataBindByDefault = False
_!ItemCount = 1
37 B
 
9 BlogPostsRepeater_AllPosts
plcBasicRepeater
N/A
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
ResolveDynamicControls = True
DataSourceName = "BlogPostsDataSource_AllPosts" (28 B)
HideControlForZeroRows = True
DataBindByDefault = False
_!ItemCount = 10
41 B
 
10 ZoneA
UniPager1
pagerElem
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
PageSize = 10
QueryStringKey = "page" (4 B)
ItemsCount = 2
DisplayFirstLastAutomatically = False
WasGenerated = True
CurrentPage = 1
FakeMode = True
GroupSize = 5
DataSourceItemsCount = 12
PageCount = 2
DisplayPreviousNextAutomatically = False
PagerMode = Querystring
4 B
 
11 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes