Show as List

Registration is available for this event. Register Now

View Close


Debugging Information
ColdFusion Server Developer 2018,0,02,313961
Template /events.cfm
Time Stamp 07-Jul-20 06:20 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
360 ms 360 ms 1 D:/Sites/CMSDemo/html/index.cfm
360 ms 360 ms 1 D:/Sites/CMSDemo/template.cfm
360 ms 360 ms 1 D:/Sites/DWebCMS/website/index.cfm
360 ms 360 ms 1 d:/sites/cmsdemo/html/events.cfm
78 ms 78 ms 1 D:/Sites/DWebCMS/website/head.cfm
78 ms 78 ms 1 d:/sites/cmsdemo/html/Application.cfm
47 ms 47 ms 1 D:/Sites/DWebCMS/website/body.cfm
31 ms 31 ms 1 D:/Sites/DWebCMS/website/SystemApplications/calendar/index.cfm
31 ms 31 ms 1 D:/Sites/DWebCMS/website/page_calendar_v2.cfm
16 ms 16 ms 1 D:/Sites/DWebCMS/website/SystemApplications/calendar/Calendars/dspView.cfm
16 ms 16 ms 1 D:/Sites/DWebCMS/website/SystemApplications/calendar/Calendars/index.cfm
15 ms 15 ms 1 D:/Sites/DWebCMS/website/Application.cfm
15 ms 15 ms 1 D:/Sites/DWebCMS/website/SystemApplications/calendar/appinfo.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/SystemApplications/calendar/Calendars/appinfo.cfm
0 ms 0 ms 1 D:/Sites/DWebCMS/website/SystemApplications/calendar/Events/dspSlide.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
438 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getPages (Datasource=DWebCMS, Time=47ms, Records=6) in D:\Sites\DWebCMS\website\head.cfm @ 06:20:09.009
	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 @ 06:20:09.009
 
	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 = '4B4E79A0-155D-00D3-04C8-B9B9421C7E62'
	
		AND		P.bitActive = 1
		
GetSelectedCalendars (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\DWebCMS\website\head.cfm @ 06:20:09.009
			SELECT 	unqCalendarId
			FROM 	tblWebsitePageCalendars
			WHERE 	unqWebsitePageId = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 4B4E79A0-155D-00D3-04C8-B9B9421C7E62

getHomeEvents (Datasource=DWebCMS, Time=63ms, Records=6) in D:\Sites\CMSDemo\template.cfm @ 06:20:09.009
    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 @ 06:20:10.010
    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 06:20:09'})
    AND		(NA.datDisplayEndDate IS NULL OR NA.datDisplayEndDate >= {ts '2020-07-07 06:20:09'})
    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=15ms, Records=3) in D:\Sites\CMSDemo\template.cfm @ 06:20:10.010
        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 @ 06:20:10.010
	SELECT	unqPageID,
			vchFilename
	FROM	tblWebSitePages
	WHERE	unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	AND		unqPageID = dbo.GetRoot('3751BCB4-1301-4D3A-8B05-3EAB862C1CE0','4B4E79A0-155D-00D3-04C8-B9B9421C7E62')
getChildPages (Datasource=DWebCMS, Time=16ms, Records=0) in D:\Sites\CMSDemo\template.cfm @ 06:20:10.010
	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) = 4B4E79A0-155D-00D3-04C8-B9B9421C7E62

getRootPage (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\CMSDemo\template.cfm @ 06:20:10.010
                            SELECT	unqPageID,
                                    vchFilename
                            FROM	tblWebSitePages
                            WHERE	unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
                            AND		unqPageID = dbo.GetRoot('3751BCB4-1301-4D3A-8B05-3EAB862C1CE0','4B4E79A0-155D-00D3-04C8-B9B9421C7E62')
                        
getParentPage (Datasource=DWebCMS, Time=15ms, Records=2) in D:\Sites\CMSDemo\template.cfm @ 06:20:10.010
                            SELECT	P.unqPageID, unqParentPageID, vchPageName, vchFileName
                            FROM	tblWebsitePages P
                                INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID)
                            WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
                            AND		P.bitActive  = 1
                            AND 	c.unqPageContentTypeId = 'e26018f9-e9f8-4dce-ad95-543c83c77ffe'
                            AND		P.unqPageID = '4B4E79A0-155D-00D3-04C8-B9B9421C7E62'
                            ORDER BY intSortID
                        
getChildPages (Datasource=DWebCMS, Time=16ms, Records=0) in D:\Sites\CMSDemo\template.cfm @ 06:20:10.010
                            SELECT	P.*,
                                    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 	c.unqPageContentTypeId = 'e26018f9-e9f8-4dce-ad95-543c83c77ffe'
                            AND		P.unqParentPageID = ?
                            ORDER BY P.intSortID
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 4B4E79A0-155D-00D3-04C8-B9B9421C7E62

getCalendarSettings (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\DWebCMS\website\SystemApplications\calendar\appinfo.cfm @ 06:20:10.010
	SELECT 	CS.unqDisplayTypeId, 
			CS.intListMaxEventsPerPage,
			CS.vchFacebookCommentsAppId
	FROM 	SysApp_v2_CalendarSettings CS
	WHERE	CS.unqCustomerID = ?
	AND CS.unqPageID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3751BCB4-1301-4D3A-8B05-3EAB862C1CE0
Parameter #2(cf_sql_char) = 4B4E79A0-155D-00D3-04C8-B9B9421C7E62

GetCalendars (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\DWebCMS\website\SystemApplications\calendar\Calendars\appinfo.cfm @ 06:20:10.010
	SELECT	*
	FROM	SysApp_v2_Calendars C
	JOIN SysApp_v2_CalendarLocalizations CL 
		ON (C.unqCalendarID = CL.unqCalendarID AND CL.unqLanguageId = ?)
	
	WHERE	C.unqCalendarID IN (?)
	
    AND		C.unqCustomerID = ? 
    AND 	CL.bitActive = 1
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 385E8678-FFDC-4169-A1B5-2D5A2F248D64
Parameter #2(CF_SQL_CHAR) = FC724BAF-CA59-8AE1-9F79-E2EBE5D4DF77
Parameter #3(CF_SQL_CHAR) = 3751BCB4-1301-4D3A-8B05-3EAB862C1CE0

GetCalendarMeta (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\DWebCMS\website\SystemApplications\calendar\Calendars\dspView.cfm @ 06:20:10.010
		SELECT 	CL.vchCalendarPageName
				,CL.vchCalendarMetaDescription
		FROM 	SysApp_v2_CalendarLocalizations CL
		WHERE 	CL.unqCalendarId = ?
		AND 	CL.unqLanguageId = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FC724BAF-CA59-8AE1-9F79-E2EBE5D4DF77
Parameter #2(cf_sql_varchar) = 385E8678-FFDC-4169-A1B5-2D5A2F248D64


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\events.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=/events.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\events.cfm
QUERY_STRING=
REMOTE_ADDR=3.236.97.49
REMOTE_HOST=3.236.97.49
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/events.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=35815
cftoken=562be2103dcf8af2-9A02CCE9-DDEA-F434-70850BFBAB95C348
hitcount=1
lastvisit={ts '2020-07-07 06:20:09'}
timecreated={ts '2020-07-07 06:20:09'}
urltoken=CFID=35815&CFTOKEN=562be2103dcf8af2-9A02CCE9-DDEA-F434-70850BFBAB95C348
URL Parameters:
ACTION=Calendar
PAGE=0
Debug Rendering Time: 0 ms