Cookbookin.com Recipe Scrapbooking

		Products		Where to Shop
		Recipes		Jackie’s Corner
		Projects		Contact Us
		Meet the Designers		Everybody’s Cookbookin’

To receive email updates with free projects, free recipe cards to download, and information about new products, sign up now by putting in your name and address to receive email newsletter.

• HOME • RECIPE SCRAPBOOKING KITS • DELUXE KITS • EASY STAND BINDERS
• RECIPE ALBUMS • RECIPE BOXES • PAPERS • RECIPE CARDS • KITCHEN HELPERS
• STICKERS • TAGS • BRADS, CHARMS & EMBELLISHEMENTS

Debugging Information

ColdFusion Server Standard	6,1,0,83762
Template	/main.cfm
Time Stamp	20-Apr-06 05:03 PM
Locale	English (US)
User Agent	Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Remote IP	69.170.46.19
Host Name	69.170.46.19

Execution Time

Total Time	Avg Time	Count	Template
93 ms	93 ms	1	D:\http\resadmin\cms\cookbookin.com\www\main.cfm
0 ms	0 ms	1	D:\http\resadmin\cms\cookbookin.com\www\Application.cfm
0 ms	0 ms	1	D:\http\resadmin\cms\cookbookin.com\www\includes\footer.cfm
0 ms	0 ms	1	D:\http\resadmin\cms\cookbookin.com\www\includes\header.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
93 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

getdefault (Datasource=cookbookin, Time=31ms, Records=0) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

	SELECT tblEntries.ID, tblEntries.ID AS EID, tblEntries.strEntryTitle, tblEntries.ysnDateLine, tblEntries.strAlternateLink, tblCategories.ID, tblCategories.ID AS CATID, tblCategories.page_default, tblEntries.strDescription
	FROM tblEntries INNER JOIN tblCategories ON tblEntries.ID = tblCategories.page_default
	WHERE tblCategories.ID=50

getnodefault (Datasource=cookbookin, Time=0ms, Records=1) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

   	SELECT tblEntries.ID, tblEntries.ID AS EID, tblEntries.strEntryTitle, tblEntries.ysnDateLine, tblEntries.strAlternateLink, tblCategories.ID AS CATID, tblEntries.strDescription
   	FROM (tblEntries INNER JOIN tblCategorySelections ON tblEntries.ID = tblCategorySelections.EID) 
      INNER JOIN tblCategories ON tblCategorySelections.CATID = tblCategories.ID
   	WHERE CATID=50
   ORDER BY intSort, strEntryTitle

getentries (Datasource=cookbookin, Time=16ms, Records=1) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

	SELECT tblEntries.ID, tblEntries.strEntryTitle, tblEntries.ysnHide, tblCategories.ID AS CATID, tblCategorySelections.intSort
	FROM (tblEntries INNER JOIN tblCategorySelections ON tblEntries.ID = tblCategorySelections.EID) INNER JOIN tblCategories ON tblCategorySelections.CATID = tblCategories.ID
	WHERE CATID=50 and ysnHide = 0
   ORDER BY intSort, strEntryTitle

getcatinfo (Datasource=cookbookin, Time=0ms, Records=1) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

SELECT tblCategories.ID, tblCategories.rank1, tblCategories.rank2, tblCategories.rank3, tblCategories.rank4, tblCategories.level, tblCategories.ysnTOC
FROM tblCategories
WHERE ID=50

get_subs (Datasource=cookbookin, Time=16ms, Records=0) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

   SELECT tblCategories.ID, tblCategories.rank1, tblCategories.rank2, tblCategories.rank3, tblCategories.rank4, tblCategories.level, tblCategories.strCategory
FROM tblCategories INNER JOIN tblCategorySelections ON tblCategories.ID = tblCategorySelections.CATID
    WHERE rank1 = 1.00 and rank2=6.00 and level>2
GROUP BY tblCategories.ID, tblCategories.rank1, tblCategories.rank2, tblCategories.rank3, tblCategories.rank4, tblCategories.level, tblCategories.strCategory

getsubs (Datasource=cookbookin, Time=0ms, Records=0) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

   SELECT tblCategories.ID, tblCategories.rank1, tblCategories.rank2, tblCategories.rank3, tblCategories.rank4, tblCategories.level, tblCategories.strCategory
FROM tblCategories 
   WHERE id=0 
   
ORDER BY rank1, rank2, rank3

get_cat1 (Datasource=cookbookin, Time=15ms, Records=1) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

    SELECT * FROM tblCategories WHERE rank1 = 1.00 and rank2=0 and rank3=0 
    and rank4=0

get_cat2 (Datasource=cookbookin, Time=0ms, Records=1) in D:\http\resadmin\cms\cookbookin.com\www\main.cfm @ 17:03:15.015

    SELECT * FROM tblCategories WHERE rank1 = 1.00 and rank2=6.00 and rank3=0 
    and rank4=0

Scope Variables

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:\http\resadmin\cms\cookbookin.com\www\main.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=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=1574601; CFTOKEN=48825609; JSESSIONID=d030b8a47f8e$B8$AC$D
HTTP_HOST=www.cookbookin.com
HTTP_REFERER=http://www.cookbookin.com/main.cfm?eid=66
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
PATH_INFO=/main.cfm
PATH_TRANSLATED=D:\http\resadmin\cms\cookbookin.com\www\main.cfm
QUERY_STRING=id=50&r1=1.00&r2=6.00&level=2
REMOTE_ADDR=69.170.46.19
REMOTE_HOST=69.170.46.19
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/main.cfm
SERVER_NAME=www.cookbookin.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=1574601
CFTOKEN=48825609
JSESSIONID=d030b8a47f8e$B8$AC$D

Session Variables:
cfid=1574601
cftoken=48825609
sessionid=COOKBOOKIN_1574601_48825609
urltoken=CFID=1574601&CFTOKEN=48825609

URL Parameters:
ID=50
LEVEL=2
R1=1.00
R2=6.00

Debug Rendering Time: 63 ms