View Trainings

Total Time	Avg Time	Count	Template
15 ms	15 ms	1	C:\webs\phtcOnline\learning\default.cfm
0 ms	0 ms	1	C:/webs/phtcOnline/assets/customtags/template.cfm
0 ms	0 ms	1	CFC[ C:/webs/phtcOnline/Application.cfc | onRequestStart(/learning/default.cfm) ] from C:/webs/phtcOnline/Application.cfc
0 ms	0 ms	2	CFC[ C:/webs/phtcOnline/learning/courses/orientation-to-ph/Application.cfc | checkIfPositiveInteger() ] from C:/webs/phtcOnline/learning/courses/orientation-to-ph/Application.cfc
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
15 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT 	c.courseId, c.courseTitle, c.certificateUrl, c.courseUrl, c.active, c.development, u.registrationDate, u.completedDate, s.seriesId, s.seriesTitle, s.thumbnailFilename, cc.hasCes,
				CASE
					WHEN (seriesTitle IS NULL OR seriesTitle = '') THEN g.courseGroupName
					ELSE g2.courseGroupName
				END AS courseGroupName,
				CASE
					WHEN (seriesTitle IS NULL OR seriesTitle = '') THEN (CAST(g.displayOrder AS varchar(3)) + '+' + REPLACE(g.courseGroupName, 'the ', '') + '+' + REPLACE(c.courseTitle, 'the ', ''))
					ELSE (CAST(g2.displayOrder AS varchar(3)) + '+' + REPLACE(g2.courseGroupName, 'the ', '') + '+' + REPLACE(s.seriesTitle, 'the ', '') + '+' + CAST(seriesDisplayOrder AS varchar(3)) + '+' + REPLACE(c.courseTitle, 'the ', ''))
				END AS sortValue
		FROM 	tblCourses c LEFT OUTER JOIN tblCourseGroups g ON c.courseGroupId = g.courseGroupId
					LEFT OUTER JOIN tblCourseSeries s ON c.seriesId = s.seriesId
					LEFT OUTER JOIN tblCourseGroups g2 ON s.courseGroupId = g2.courseGroupId
					LEFT OUTER JOIN (
									SELECT 	*
									FROM 	tblUserCourses
									WHERE 	uniqueUserId = ?
									) u
					ON c.courseId = u.courseId
					LEFT OUTER JOIN (
									SELECT 	cr.courseId, 1 AS hasCes
									FROM 	tblCeCredits cr INNER JOIN tblCeCreditCategories cat ON cr.creditCatId = cat.creditCatId
									WHERE 	cat.availableThroughLms = 1 AND 
											cr.creditStartDate <= CAST(GETDATE() AS date) AND 
											(cr.creditEndDate IS NULL OR cr.creditEndDate >= CAST(GETDATE() AS date))
									GROUP BY cr.courseId
									) cc
					ON c.courseId = cc.courseId
		WHERE 
			 
				(
					(
						active = 1 AND 
						(
							regClosingDate IS NULL OR 
							CAST(GETDATE() AS date) <= regClosingDate
						)
					) OR
					completedDate IS NOT NULL
				)
			
				AND development = 0
			
		ORDER BY sortValue

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=4096
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT=CN=www.phtc-online.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\webs\phtcOnline\learning\default.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=4096
HTTPS_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=CN=www.phtc-online.org
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=ac7b77caac064e45-A28DC0E0-9536-7BCF-FAF9CE44CC50B887; CFID=1799374
HTTP_HOST=phtc-online.org
HTTP_REFERER=https://phtc-online.org/learning/cert-program/?certProgId=1+
HTTP_URL=/learning/default.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=169.226.63.108
PATH_INFO=
PATH_TRANSLATED=C:\webs\phtcOnline\learning\default.cfm
QUERY_STRING=
REMOTE_ADDR=3.144.104.210
REMOTE_HOST=3.144.104.210
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/learning/default.cfm
SERVER_NAME=phtc-online.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=1799374
CFTOKEN=ac7b77caac064e45-A28DC0E0-9536-7BCF-FAF9CE44CC50B887

Session Variables:
firstname=
lastname=
uniqueuserid=0
urltoken=CFID=1799374&CFTOKEN=ac7b77caac064e45-A28DC0E0-9536-7BCF-FAF9CE44CC50B887
useremail=
username=
userpermissions=

URL Parameters:
COURSEID=
SERIESID=
SORT=group
STATUS=all