Pricepatch Product search

108,859 new products and 323,993 new offers in the last 7 days!







Browse Stuff - Privacy Policy & Terms of Use
 
©2010 Pricepatch



  Find Pricepatch.com on Facebook   Follow Pricepatch.com on Twitter   ICRA


Debugging Information
ColdFusion Server Developer 8,0,1,195520
Template /index.cfm
Time Stamp 08-Sep-10 03:28 AM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 192.168.1.4
Host Name 192.168.1.4

Execution Time

Total Time Avg Time Count Template
8 ms 8 ms 1 top level /var/www/html/pricepatch_linux/index.cfm
4 ms 4 ms 1 /var/www/html/pricepatch_linux/template1.cfm
2 ms 2 ms 1 /var/www/html/pricepatch_linux/newapplication.cfm
2 ms 2 ms 1 /var/www/html/pricepatch_linux/newstatistics.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newcleanquerystring.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newfooter.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
8 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

getoffers (Datasource=pricepatch2, Time=1ms, Records=1) in /var/www/html/pricepatch_linux/newstatistics.cfm @ 03:28:44.044
select * from updatestatistics where days=7 and statistic='NewOffers'
getProducts (Datasource=pricepatch2, Time=0ms, Records=1) in /var/www/html/pricepatch_linux/newstatistics.cfm @ 03:28:44.044
select * from updatestatistics where days=7 and statistic='NewProducts'
getParent (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/template1.cfm @ 03:28:44.044
SELECT *		
FROM menumaster
WHERE menuID = '01' and active=1
getBreadCrumbs (Datasource=pricepatch2, Time=0ms, Records=0, Cached Query) in /var/www/html/pricepatch_linux/template1.cfm @ 03:28:44.044
SELECT *		
FROM menumaster
WHERE menuid in ('0')
and active=1
order by menuid
getTopics (Datasource=pricepatch2, Time=0ms, Records=22, Cached Query) in /var/www/html/pricepatch_linux/template1.cfm @ 03:28:44.044
SELECT *
FROM menumaster
WHERE lstparent LIKE '%,01'
and active=1
ORDER BY menuid

Scope Variables

Application Variables:
applicationname=pricepatch

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=/var/www/html/pricepatch_linux/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=CFID=2284933; CFTOKEN=35288966
HTTP_HOST=www.pricepatch.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/var/www/html/pricepatch_linux/index.cfm
QUERY_STRING=m=01&mname=Shop%20by%20Category
REMOTE_ADDR=192.168.1.4
REMOTE_HOST=192.168.1.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.pricepatch.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.6 (Fedora)
WEB_SERVER_API=

Cookie Variables:
CFID=2284933
CFTOKEN=35288966

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
cfid=2284933
cftoken=35288966
sessionid=PRICEPATCH_2284933_35288966
urltoken=CFID=2284933&CFTOKEN=35288966

URL Parameters:
M=01
MNAME=Shop by Category
Debug Rendering Time: 15 ms