Total Time	Avg Time	Count	Template
1216 ms	1216 ms	1	/usr/local/apache/htdocs/photogalleries/newsgallery-static.cfm
1197 ms	1197 ms	1	/usr/local/apache/htdocs/photogalleries/includes/newsgallerygrid.htm
6 ms	6 ms	1	/usr/local/apache/htdocs/photogalleries/includes/newstop.htm
3 ms	3 ms	1	/usr/local/apache/htdocs/photogalleries/includes/newsbottom.htm
0 ms	0 ms	1	/usr/local/apache/htdocs/Application.cfm
0 ms	0 ms	1	/usr/local/apache/htdocs/OnRequestEnd.cfm
0 ms	0 ms	1	/usr/local/apache/htdocs/ads/grayrail/photogalleries/newsgallery.cfm
0 ms	0 ms	1	/usr/local/apache/htdocs/includes/datefunctions.cfm
0 ms	0 ms	1	/usr/local/apache/htdocs/includes/homenav3.htm
0 ms	0 ms	1	/usr/local/apache/htdocs/includes/homepage/search.htm
0 ms	0 ms	1	/usr/local/apache/htdocs/includes/photorailnav.htm
5 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1221 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

	SELECT headline, project, pix, pubdate, caption
	FROM newsgallery
 	WHERE PUBDATE <=20051114 AND pixnumber = 1
	ORDER BY -pubdate
	LIMIT 1

	SELECT headline, project, thumburl, pubdate
	FROM newsgallery
 	WHERE PUBDATE <=20051114 AND pixnumber = 1
	ORDER BY -pubdate
	LIMIT 1, 20

	SELECT pubdate 
	FROM newsgallery
    WHERE pubdate <= 20051114	
    ORDER BY pubdate DESC

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=/usr/local/apache/htdocs/photogalleries/newsgallery-static.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=
HTTP_HOST=10.5.8.55
HTTP_REFERER=
HTTP_USER_AGENT=Java1.3.1_03
PATH_INFO=
PATH_TRANSLATED=/usr/local/apache/htdocs/photogalleries/newsgallery-static.cfm
QUERY_STRING=
REMOTE_ADDR=10.5.8.55
REMOTE_HOST=10.5.8.55
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/photogalleries/newsgallery-static.cfm
SERVER_NAME=info4.detnews.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.26 (Unix)
WEB_SERVER_API=

Cookie Variables:
CFID=1974987
CFTOKEN=56412991

Session Variables:
cfid=1974987
cftoken=56412991
sessionid=LETTERS_1974987_56412991
urltoken=CFID=1974987&CFTOKEN=56412991