RECENT NEWS
test-mah-link
June 14, 2016


Super Nate News!
August 12, 2014

An indepth look into Nate's awesome news.
Laboris anim labore mollit Ut #10
July 02, 2012

Laboris anim labore mollit Ut Laboris anim labore mollit Ut Laboris anim labore mollit Ut Laboris anim labore mollit Ut Laboris anim labore mollit Ut Laboris anim labore mollit Ut Laboris anim labore ...
UPCOMING EVENTS
Weekly Event
February 19, 2013

Weekly Event
February 19, 2013

ABC Link Event
February 22, 2013

ABC Event
February 22, 2013

Google
February 26, 2013

Weekly Event
February 26, 2013


Debugging Information
ColdFusion Server Developer 2018,0,02,313961
Template /index.cfm
Time Stamp 07-Jul-20 07:02 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 3.236.97.49
Host Name 3.236.97.49


Execution Time

Total Time Avg Time Count Template
157 ms 157 ms 1 D:/Sites/CMSDemo/template.cfm
157 ms 157 ms 1 D:/Sites/DWebCMS/website/index.cfm
157 ms 157 ms 1 d:/sites/cmsdemo/html/index.cfm
32 ms 32 ms 1 D:/Sites/DWebCMS/website/head.cfm
15 ms 15 ms 1 d:/sites/cmsdemo/html/Application.cfm
0 ms 0 ms 1 C:/ColdFusion2018/cfusion/CustomTags/browser.cfm
0 ms 0 ms 1 C:/ColdFusion2018/cfusion/CustomTags/hacker.cfm
0 ms 0 ms 1 C:/ColdFusion2018/cfusion/CustomTags/scriptkill.cfm
0 ms 0 ms 1 D:/Sites/DWebCMS/website/Application.cfm
0 ms 0 ms 1 D:/Sites/DWebCMS/website/share/udfs.cfm
0 ms 0 ms 1 d:/sites/cmsdemo/html/OnRequestEnd.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
172 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getPages (Datasource=DWebCMS, Time=16ms, Records=6) in D:\Sites\DWebCMS\website\head.cfm @ 07:02:01.001
	SELECT	P.unqPageID,
			P.unqPageTypeID,
			P.vchFileName,
			P.vchLink,
			P.vchLinkTarget,
			C.vchPageName,
			C.unqNavTypeID,
			C.vchLiveNavContent,
			C.unqNavStoreWareInstanceId,
			C.unqNavMediaGalleryId,
			C.unqNavCalendarId,
			C.unqNavNewsID,
			C.unqNavFAQID,
			C.vchNavIncludeFile
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
		INNER JOIN tblPageContentTypes T ON (C.unqPageContentTypeID = T.unqPageContentTypeID AND T.vchPageContentType = 'Desktop')
	WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	
	AND		P.bitActive = 1
	
	AND		P.bitShowOnNav = 1
	
	AND		P.unqParentPageID IS NULL
	ORDER BY P.intSortId
getCurrentPage (Datasource=DWebCMS, Time=16ms, Records=1) in D:\Sites\DWebCMS\website\head.cfm @ 07:02:01.001
 
	SELECT	P.unqPageTypeID,
			P.unqParentPageId,
			P.unqStoreWareInstanceId,
			P.unqPhotoGalleryId,
			P.unqCalendarId,
			P.unqNewsCategoryID,
			P.unqPageTurnId,
			P.unqFAQCategoryID,
			P.vchFileName,
			C.vchPageName,
			C.vchPageSubtitle,
			C.txtLivePageContent,
			C.vchLiveUnsecuredContent,
			C.vchTitle,
			C.txtDescription,
			C.txtKeywords,
			P.vchLink,
			P.vchLinkTarget,
			P.vchIncludeFile,
			P.xmlPageVariables,
			P.vchEmail,
			hasSecurity = (SELECT COUNT(unqPageGroupID) FROM tblWebsitePageGroup WHERE unqPageID = P.unqPageID)
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
		INNER JOIN tblPageContentTypes T ON (C.unqPageContentTypeID = T.unqPageContentTypeID AND T.vchPageContentType = 'Desktop')
	WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	AND		P.unqPageID = '144AB2A7-6182-4F10-B03F-E111F587B1F5'
	
		AND		P.bitActive = 1
		
getHomeEvents (Datasource=DWebCMS, Time=15ms, Records=6) in D:\Sites\CMSDemo\template.cfm @ 07:02:01.001
    SELECT	TOP 6 CEL.*,
            CE.datStartDate,
            CE.datEndDate,
            CL.vchCalendarName
    FROM	SysApp_v2_CalendarEvents CE
        INNER JOIN SysApp_v2_CalendarEventLocalizations CEL ON (CE.unqCalendarEventId = CEL.unqCalendarEventId)
        INNER JOIN SysApp_v2_CalendarLocalizations CL ON (CE.unqCalendarId = CL.unqCalendarId)
    AND		CE.unqCalendarId IN (SELECT unqCalendarId FROM SysApp_v2_Calendars WHERE unqCustomerID = ?)
    ORDER BY CE.datStartDate
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 3751BCB4-1301-4D3A-8B05-3EAB862C1CE0

getNews (Datasource=DWebCMS, Time=94ms, Records=4) in D:\Sites\CMSDemo\template.cfm @ 07:02:01.001
    SELECT	TOP 6 NAL.*,
            NA.vchAuthor,
            NCL.vchCategoryName,
            COALESCE(NA.datArticleDate, CAST((STR( YEAR( GETDATE() ) ) + '/' + STR( MONTH( GETDATE() ) ) + '/' + STR( DAY( GETDATE()))) AS DATETIME)) AS datArticleDate
    FROM	SysApp_v2_NewsArticles NA
        INNER JOIN SysApp_v2_NewsArticleLocalizations NAL ON (NA.unqNewsArticleId = NAL.unqNewsArticleId
        	AND NAL.unqLanguageId = ?)
        INNER JOIN SysApp_v2_NewsCategories NC ON (NA.unqNewsCategoryId = NC.unqNewsCategoryId)
        INNER JOIN SysApp_v2_NewsCategoryLocalizations NCL ON (NC.unqNewsCategoryId = NCL.unqNewsCategoryId
        	AND NCL.unqLanguageId = ?)
    WHERE	NA.unqNewsCategoryId IN (SELECT unqNewsCategoryId FROM SysApp_v2_NewsCategories WHERE unqCustomerID = ?)
    AND		NA.bitFeatured = 1
    AND 	NAL.bitActive = ?
    AND		(NA.datDisplayStartDate IS NULL OR NA.datDisplayStartDate <= {ts '2020-07-07 07:02:01'})
    AND		(NA.datDisplayEndDate IS NULL OR NA.datDisplayEndDate >= {ts '2020-07-07 07:02:01'})
    ORDER BY NA.datArticleDate DESC, NAL.vchArticleTitle
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 385E8678-FFDC-4169-A1B5-2D5A2F248D64
Parameter #2(cf_sql_varchar) = 385E8678-FFDC-4169-A1B5-2D5A2F248D64
Parameter #3(cf_sql_char) = 3751BCB4-1301-4D3A-8B05-3EAB862C1CE0
Parameter #4(cf_sql_bit) = YES

getRotateImages (Datasource=DWebCMSCustom, Time=0ms, Records=3) in D:\Sites\CMSDemo\template.cfm @ 07:02:01.001
        SELECT	TOP 8 *
        FROM	CMSDemo_HomeSlideshow		
        WHERE	bitActive = 1
        ORDER BY intSortOrder
    
getRootPage (Datasource=DWebCMS, Time=16ms, Records=1) in D:\Sites\CMSDemo\template.cfm @ 07:02:01.001
	SELECT	unqPageID,
			vchFilename
	FROM	tblWebSitePages
	WHERE	unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	AND		unqPageID = dbo.GetRoot('3751BCB4-1301-4D3A-8B05-3EAB862C1CE0','144AB2A7-6182-4F10-B03F-E111F587B1F5')
getChildPages (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\CMSDemo\template.cfm @ 07:02:01.001
	SELECT	P.unqPageID,
			P.unqPageTypeID,
			P.vchFileName,
			C.vchPageName
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
	WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	AND		P.bitActive = 1
	AND		P.unqParentPageID = ?
	ORDER BY P.intSortID
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 144AB2A7-6182-4F10-B03F-E111F587B1F5


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=d:\sites\cmsdemo\html\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=demo.devwebware.com
HTTP_REFERER=
HTTP_URL=/index.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.13
PATH_INFO=
PATH_TRANSLATED=d:\sites\cmsdemo\html\index.cfm
QUERY_STRING=
REMOTE_ADDR=3.236.97.49
REMOTE_HOST=3.236.97.49
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=demo.devwebware.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=35822
cftoken=19f0c76090c4271a-9B8204DD-995C-A85E-1DC901EB01AE0059
hitcount=1
lastvisit={ts '2020-07-07 07:02:01'}
timecreated={ts '2020-07-07 07:02:01'}
urltoken=CFID=35822&CFTOKEN=19f0c76090c4271a-9B8204DD-995C-A85E-1DC901EB01AE0059
Debug Rendering Time: 0 ms