Debugging Information
| ColdFusion Server Enterprise |
7,0,0,91690 |
| Template |
/shoptalk.cfm |
| Time Stamp |
09-Feb-10 10:24 AM |
| Locale |
English (US) |
| User Agent |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote IP |
209.208.132.227 |
| Host Name |
209.208.132.227 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 109 ms |
109 ms |
1 |
E:\Inetpub\wwwroot\tvspy\shoptalk.cfm |
| 62 ms |
62 ms |
1 |
E:\Inetpub\wwwroot\tvspy\_far-right.cfm |
| 62 ms |
62 ms |
1 |
E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\Application.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\_bottom.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\_google_include.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\_left.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\_shoptalk_right.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\_top.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\ads\_adinclude-tiles.cfm |
| 0 ms |
0 ms |
1 |
E:\Inetpub\wwwroot\tvspy\ads\_adincludetop.cfm |
| 16 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 125 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
gethome (Datasource=vault, Time=0ms, Records=1, Cached Query) in E:\Inetpub\wwwroot\tvspy\shoptalk.cfm @ 10:24:05.005
SELECT * from t_main
where type=1
shoptalk_id (Datasource=vault, Time=0ms, Records=1, Cached Query) in E:\Inetpub\wwwroot\tvspy\shoptalk.cfm @ 10:24:05.005
select t_shoptalk_id
from t_shoptalk
where active = 1
order by datecreated desc
shoptalklist (Datasource=vault, Time=0ms, Records=1, Cached Query) in E:\Inetpub\wwwroot\tvspy\shoptalk.cfm @ 10:24:05.005
select job, datecreated, t_shoptalk_id, active, quote, attribution,
PRESS_TITLE,ON_TVSPY,SHORTTAKES_HEADLINES
from t_shoptalk
where t_shoptalk_id = 19414
ShortTakeArticles (Datasource=vault, Time=0ms, Records=0) in E:\Inetpub\wwwroot\tvspy\_shoptalk_right.cfm @ 10:24:05.005
select TITLE,ORDERBY,active,T_SHOPTALK_ID,ARTICLE_ID,datecreated
from t_shoptalk_articles
where T_SHOPTALK_ID=19414
and active=1
order by active desc,ORDERBY
getcategories (Datasource=vault, Time=0ms, Records=7) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT categorytitle,storefront_categories.storefrontcategory_id
from channels,storefront_categories
WHERE channels.ch_id=storefront_categories.ch_id
and storefront_categories.ch_id=345
order by categorytitle
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=1) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
showcase,storefront_categories.storefrontcategory_id
FROM storefronts,relate_storefront_ind,storefront_categories
WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
AND ch_id=345
AND featured=1
and relate_storefront_ind.storefrontcategory_id=1506
order by ORDERS
getfeaturedstorefronts (Datasource=vault, Time=15ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
showcase,storefront_categories.storefrontcategory_id
FROM storefronts,relate_storefront_ind,storefront_categories
WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
AND ch_id=345
AND featured=1
and relate_storefront_ind.storefrontcategory_id=1464
order by ORDERS
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=1) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
showcase,storefront_categories.storefrontcategory_id
FROM storefronts,relate_storefront_ind,storefront_categories
WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
AND ch_id=345
AND featured=1
and relate_storefront_ind.storefrontcategory_id=1507
order by ORDERS
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
showcase,storefront_categories.storefrontcategory_id
FROM storefronts,relate_storefront_ind,storefront_categories
WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
AND ch_id=345
AND featured=1
and relate_storefront_ind.storefrontcategory_id=1470
order by ORDERS
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
showcase,storefront_categories.storefrontcategory_id
FROM storefronts,relate_storefront_ind,storefront_categories
WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
AND ch_id=345
AND featured=1
and relate_storefront_ind.storefrontcategory_id=1467
order by ORDERS
getfeaturedstorefronts (Datasource=vault, Time=16ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
showcase,storefront_categories.storefrontcategory_id
FROM storefronts,relate_storefront_ind,storefront_categories
WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
AND ch_id=345
AND featured=1
and relate_storefront_ind.storefrontcategory_id=1471
order by ORDERS
getfeaturedstorefronts (Datasource=vault, Time=31ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:24:05.005
SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
showcase,storefront_categories.storefrontcategory_id
FROM storefronts,relate_storefront_ind,storefront_categories
WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
AND ch_id=345
AND featured=1
and relate_storefront_ind.storefrontcategory_id=1404
order by ORDERS
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=E:\Inetpub\wwwroot\tvspy\shoptalk.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=text/xml,application/xhtml+xml,text/html;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=NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660
HTTP_HOST=survey1.vault.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/shoptalk.cfm
PATH_TRANSLATED=E:\Inetpub\wwwroot\tvspy\shoptalk.cfm
QUERY_STRING=page=1
REMOTE_ADDR=209.208.132.227
REMOTE_HOST=209.208.132.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/shoptalk.cfm
SERVER_NAME=survey1.vault.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=62127274
cftoken=79476840
hitcount=1
lastvisit={ts '2010-02-09 10:24:05'}
timecreated={ts '2010-02-09 10:24:05'}
urltoken=CFID=62127274&CFTOKEN=79476840
Cookie Variables:
CFID=62127274
CFTOKEN=79476840
NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660
Session Variables:
cfid=62127274
cftoken=79476840
sessionid=TVSPYNEW_62127274_79476840
urltoken=CFID=62127274&CFTOKEN=79476840
URL Parameters:
PAGE=1
Debug Rendering Time: 47 ms
|
