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:44 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
140 ms 140 ms 1 D:/Sites/CMSDemo/template.cfm
140 ms 140 ms 1 D:/Sites/DWebCMS/website/index.cfm
140 ms 140 ms 1 d:/sites/cmsdemo/html/index.cfm
31 ms 31 ms 1 d:/sites/cmsdemo/html/Application.cfm
16 ms 16 ms 1 D:/Sites/DWebCMS/website/Application.cfm
16 ms 16 ms 1 D:/Sites/DWebCMS/website/head.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/share/udfs.cfm
0 ms 0 ms 1 d:/sites/cmsdemo/html/OnRequestEnd.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
171 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:44:53.053
	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=0ms, Records=1) in D:\Sites\DWebCMS\website\head.cfm @ 07:44:53.053
 
	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=16ms, Records=6) in D:\Sites\CMSDemo\template.cfm @ 07:44:53.053
    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=78ms, Records=4) in D:\Sites\CMSDemo\template.cfm @ 07:44:53.053
    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:44:53'})
    AND		(NA.datDisplayEndDate IS NULL OR NA.datDisplayEndDate >= {ts '2020-07-07 07:44:53'})
    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:44:53.053
        SELECT	TOP 8 *
        FROM	CMSDemo_HomeSlideshow		
        WHERE	bitActive = 1
        ORDER BY intSortOrder
    
getRootPage (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\CMSDemo\template.cfm @ 07:44:53.053
	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:44:53.053
	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=35826
cftoken=8c3372d8074672ec-9D0A7185-D82A-D453-14358A0FD4E84306
hitcount=1
lastvisit={ts '2020-07-07 07:44:53'}
timecreated={ts '2020-07-07 07:44:53'}
urltoken=CFID=35826&CFTOKEN=8c3372d8074672ec-9D0A7185-D82A-D453-14358A0FD4E84306
Debug Rendering Time: 0 ms