Total Time	Avg Time	Count	Template
32 ms	32 ms	1	D:\Domains\homesforsalemagazines\Application.cfm
16 ms	16 ms	1	D:\Domains\homesforsalemagazines\include\session_mgr\session.cfm
16 ms	5 ms	3	D:\Domains\homesforsalemagazines\include\session_mgr\storage_facility.cfm
15 ms	15 ms	1	D:\Domains\homesforsalemagazines\site_management\search_result_query.cfm
15 ms	15 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 19:29:48'} 

			INSERT INTO session_mgr
			(
				sid, ip, browser, created, storage
			)
			VALUES
			(
				'22c7a8c5oem35ab05x653j7s8n187n0z50kx5134j7k4lfgp8a2q6sk232948', '174.132.240.11','ColdFusion', {ts '2012-02-04 23:29:48'},
				'<wddxPacket version=''1.0''><header/><data><struct><var name=''SID''><string>22c7a8c5oem35ab05x653j7s8n187n0z50kx5134j7k4lfgp8a2q6sk232948</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 = '0' AND Homes.City = '1283' 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>22c7a8c5oem35ab05x653j7s8n187n0z50kx5134j7k4lfgp8a2q6sk232948</string></var></struct></data></wddxPacket>', created = {ts '2012-02-04 23:29:48'}
			WHERE sid = '22c7a8c5oem35ab05x653j7s8n187n0z50kx5134j7k4lfgp8a2q6sk232948'
		

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=0&Cur_City=1283
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=2864546
CFTOKEN=62957308
SID=22c7a8c5oem35ab05x653j7s8n187n0z50kx5134j7k4lfgp8a2q6sk232948

Session Variables:
cfid=2864546
cftoken=62957308
sessionid=LANGPAIR_2864546_62957308
urltoken=CFID=2864546&CFTOKEN=62957308

URL Parameters:
CUR_CITY=1283
CUR_COUNTY=0
CUR_STATE=GA