Total Time	Avg Time	Count	Template
31 ms	31 ms	1	D:\Domains\homesforsalemagazines\Application.cfm
31 ms	31 ms	1	D:\Domains\homesforsalemagazines\include\session_mgr\session.cfm
31 ms	10 ms	3	D:\Domains\homesforsalemagazines\include\session_mgr\storage_facility.cfm
16 ms	16 ms	1	D:\Domains\homesforsalemagazines\site_management\search_result_query.cfm
16 ms	16 ms	1	D:\Domains\homesforsalemagazines\www\search_result.cfm
0 ms	0 ms	1	D:\Domains\homesforsalemagazines\OnRequestEnd.cfm
0 ms	0 ms	1	D:\Domains\homesforsalemagazines\include\session_mgr\key_generator.cfm
0 ms	0 ms	3	D:\Domains\homesforsalemagazines\include\session_mgr\sess_globals.cfm
0 ms	0 ms	1	D:\Domains\homesforsalemagazines\site_management\search_result_city.cfm
0 ms	0 ms	1	D:\Domains\homesforsalemagazines\site_management\search_result_top.cfm
0 ms	0 ms	1	D:\Domains\homesforsalemagazines\www\includes\footer.cfm
0 ms	0 ms	1	D:\Domains\homesforsalemagazines\www\includes\header3.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
47 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

			DELETE FROM session_mgr
			WHERE created <{ts '2012-02-04 20:08:34'} 

			INSERT INTO session_mgr
			(
				sid, ip, browser, created, storage
			)
			VALUES
			(
				'fex4e7wvxfh342j3ftwf7j18ybxs50k2e4rc3925bo59o93aj8yei96l12920165e000834', '174.132.240.11','ColdFusion', {ts '2012-02-05 00:08:34'},
				'<wddxPacket version=''1.0''><header/><data><struct><var name=''SID''><string>fex4e7wvxfh342j3ftwf7j18ybxs50k2e4rc3925bo59o93aj8yei96l12920165e000834</string></var></struct></data></wddxPacket>'
			)
			

       
    SELECT Homes.*, PropertyTypes.PropTypeName, Agents.Company AS company
	FROM (Homes Left Join PropertyTypes ON Homes.PropType = PropertyTypes.PropTypeID)
		  Left Join Agents ON Homes.Agent = Agents.AgentID
	WHERE 
		Homes.State = 'GA'	
	   AND Homes.County = 'Ellijay' AND Homes.City = 'East Ellijay' AND PropType <> 5  AND Price > 0 
		AND IsActive = 1 and Display_Properties = 1
	   
    ORDER BY Price, Homes.State, HomeID

			UPDATE session_mgr
			SET storage = '<wddxPacket version=''1.0''><header/><data><struct type=''coldfusion.util.FastHashtable''><var name=''SID''><string>fex4e7wvxfh342j3ftwf7j18ybxs50k2e4rc3925bo59o93aj8yei96l12920165e000834</string></var></struct></data></wddxPacket>', created = {ts '2012-02-05 00:08:34'}
			WHERE sid = 'fex4e7wvxfh342j3ftwf7j18ybxs50k2e4rc3925bo59o93aj8yei96l12920165e000834'
		

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:\Domains\homesforsalemagazines\www\search_result.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.homesforsalemagazines.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/search_result.cfm
PATH_TRANSLATED=D:\Domains\homesforsalemagazines\www\search_result.cfm
QUERY_STRING=&Cur_State=GA&Cur_County=Ellijay&Cur_City=East%20Ellijay&Range=Any&CurType=0&CurPeriod=0&StartRow=11
REMOTE_ADDR=174.132.240.11
REMOTE_HOST=174.132.240.11
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search_result.cfm
SERVER_NAME=www.homesforsalemagazines.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFID=2864637
CFTOKEN=43371690
SID=fex4e7wvxfh342j3ftwf7j18ybxs50k2e4rc3925bo59o93aj8yei96l12920165e000834

Session Variables:
cfid=2864637
cftoken=43371690
sessionid=LANGPAIR_2864637_43371690
urltoken=CFID=2864637&CFTOKEN=43371690

URL Parameters:
CURPERIOD=0
CURTYPE=0
CUR_CITY=East Ellijay
CUR_COUNTY=Ellijay
CUR_STATE=GA
RANGE=Any
STARTROW=11