Total Time	Avg Time	Count	Template
140 ms	140 ms	1	E:\websites\swinglifestyle.com\ww2\flashevents\clubevents.cfm
140 ms	140 ms	1	E:\websites\swinglifestyle.com\ww2\flashevents\urlfix.cfm
140 ms	140 ms	1	E:\websites\swinglifestyle.com\ww2\urlfix.cfm
125 ms	125 ms	1	E:\websites\swinglifestyle.com\ww2\flashevents\clubeventsinclude.cfm
0 ms	0 ms	11	C:\ColdFusion\CustomTags\changecase.cfm
0 ms	0 ms	1	E:\websites\swinglifestyle.com\ww2\Application.cfm
0 ms	0 ms	1	E:\websites\swinglifestyle.com\ww2\OnRequestEnd.cfm
0 ms	0 ms	1	E:\websites\swinglifestyle.com\ww2\flashevents\checkstate.cfm
0 ms	0 ms	1	E:\websites\swinglifestyle.com\ww2\flashevents\eventinclude.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
140 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

	select club from club with (nolock) 
	where id=? 

	select events.eventid,events.userid,events.eventdate,events.title,events.shortdesc,events.longdesc,events.slsevent,
	events.status,events.type,events.contact, events.city,events.clubid ,events.state,
	events.country from events (nolock)
	where events.status > 0 and events.clubid=?
	and events.isgroupevent = 0
	and events.eventdate > (getdate()-1)
	order by eventdate desc

	select club,star,state from club with (nolock)
	where id=? 

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

			select count(id) as mycount
			from eventgoers with (NOLOCK)
			where eventid =?
			AND attending = 1
		

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=E:\websites\swinglifestyle.com\ww2\urlfix.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=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.swinglifestyle.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/urlfix.cfm
PATH_TRANSLATED=E:\websites\swinglifestyle.com\ww2\urlfix.cfm
QUERY_STRING=404;http://www.swinglifestyle.com:80/swingersclubevents/do-you-know-george?-7357.cfm
REMOTE_ADDR=192.168.50.21
REMOTE_HOST=192.168.50.21
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/urlfix.cfm
SERVER_NAME=www.swinglifestyle.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Cookie Variables:
SIGNUP=doyouknowgeorge?7357.HD

Request Parameters:
ip=54.81.0.22

Server Variables:
ARYAVGREQ=Array (10)
ARYCNTREQ=Array (10)
COLDFUSION=Struct (8)
HOSTNAME=sls-151
HUNDRED=80
OFFLINECOUNT=0
OS=Struct (5)
STATUSPARTFINISHEDTIME={ts '2018-05-25 11:08:34'}
TEN=8

URL Parameters:
404;HTTP://WWW.SWINGLIFESTYLE.COM:80/SWINGERSCLUBEVENTS/DO-YOU-KNOW-GEORGE?-7357.CFM=