Skip to Content 
Tower Downloads
Search
Tower.com
My Shopping Bag     Help   
Home Music Video Books Games Downloads
 [Skip to Content]   [Home]   []   []   []   []   [
Advanced Search

Non-Classifiable in Downloads

 
Tower.com  »  Downloads  »  Non-Classifiable  »  Non-Classifiable
 
 


ADVERTISEMENT

  1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  Next |  >>
1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  Next |  >>
 

ADVERTISEMENT

 Try Our Advanced Search!  
 

Tower.com
About |  Community |  Tower Newsletters |  RSS |  Advertise |  Terms |  Privacy |  Returns |  Contact Us |  Directory |  Help |  FAQ 

Copyright © 1995-2012 TOWER.COM INC
Tower, Tower Records, TowerRecords.com, Tower.com, Tower CD Listening Station, Tower Outlet, Tower Records Videos Books, Tower Essentials, Pulse! and associated logos and trademarks are registered trademarks of Tower.com Inc. in the United States and other countries.
Copyright 2012. For personal noncommercial use only.
Tower.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.
To link directly to this page: http://www.tower.com/surf/explore/nav_exp/nav_5_browse.cfm?div_id=5&type=1&cat102=2734
Tower 2.0 Version 6.0.0

Home Music Video Books Games Downloads
 [Skip to Content]   [Home]   []   []   []   []   [


Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /surf/explore/nav_exp/nav_5_browse.cfm
Time Stamp 29-Jul-16 02:04 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.161.3.108
Host Name 54.161.3.108


Execution Time

Total Time Avg Time Count Template
898 ms 898 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/explore/nav_exp/nav_5_browse.cfm
630 ms 630 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/explore/nav_exp/includes/nav_x_browser_init.cfm
613 ms 613 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | SolrCall(5, &sec_cat=2734&price=%5B0%20TO%2089999%2E00%5D&release_date=%5B1896%2D07%2D29T00%3A00%3A00Z%20TO%202018%2D07%2D29T00%3A00%3A00Z%5D&type=1&sort=Rank asc&facet=sec_cat format publisher, 0) ] from /www/cfc_v2/solr-general.cfc
46 ms 46 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/searchresult/result.cfm
40 ms 40 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/banner/default_inc/11_default.cfm
34 ms 34 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/banner/default_inc/9_default.cfm
28 ms 28 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/banner/default_inc/10_default.cfm
23 ms 23 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/searchresult/leftmenu.cfm
23 ms 23 ms 1 CFC[ /www/cfc_v2/balo_v2.cfc | fReturnHTML(155, 728, 90) ] from /www/cfc_v2/balo_v2.cfc
21 ms 21 ms 1 CFC[ /www/cfc_v2/seo-headers.cfc | GetSeoHeader() ] from /www/cfc_v2/seo-headers.cfc
21 ms 21 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | setWapiForTrait([complex value]) ] from /www/cfc_v2/solr-general.cfc
19 ms 19 ms 1 CFC[ /www/cfc_v2/balo_v2.cfc | Execute(155, 1) ] from /www/cfc_v2/balo_v2.cfc
15 ms 15 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/seo-dynamic.cfm
11 ms 11 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/searchresult/crumb-cat102.cfm
11 ms 11 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | getdiv_records(10, 5, 3) ] from /www/cfc_v2/getbanner.cfc
10 ms 10 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | getCat102Name(2734) ] from /www/cfc_v2/solr-general.cfc
9 ms 9 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | get101_records(9, 0, 3) ] from /www/cfc_v2/getbanner.cfc
9 ms 9 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | getdiv_records(9, 5, 3) ] from /www/cfc_v2/getbanner.cfc
7 ms 7 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/gen_header_valid.cfm
7 ms 7 ms 1 CFC[ /www/cfc_v2/balo_v2.cfc | fReturnTemple() ] from /www/cfc_v2/balo_v2.cfc
6 ms 6 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/gen_footer_valid.cfm
6 ms 6 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | get102_records(9, 2734, 3) ] from /www/cfc_v2/getbanner.cfc
6 ms 6 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | getCat101Name(32) ] from /www/cfc_v2/solr-general.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/balo_v2.cfc | fReturnFeed() ] from /www/cfc_v2/balo_v2.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | get101_records(10, 0, 3) ] from /www/cfc_v2/getbanner.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | get102_records(10, 2734, 3) ] from /www/cfc_v2/getbanner.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/seo-auto-gen.cfc | fGetSeoAuto([complex value]) ] from /www/cfc_v2/seo-auto-gen.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | get102_records(11, 2734, 3) ] from /www/cfc_v2/getbanner.cfc
3 ms 3 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | get101_records(11, 0, 3) ] from /www/cfc_v2/getbanner.cfc
2 ms 2 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/open-x.cfm
2 ms 2 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/version.cfm
2 ms 2 ms 1 CFC[ /www/cfc_v2/getbanner.cfc | getdiv_records(11, 5, 3) ] from /www/cfc_v2/getbanner.cfc
2 ms 2 ms 1 CFC[ /www/httpd/www-mytowersafe/Application.cfc | onRequestStart(/surf/explore/nav_exp/nav_5_browse.cfm) ] from /www/httpd/www-mytowersafe/Application.cfc
1 ms 1 ms 2 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/drop-down.cfm
1 ms 1 ms 1 CFC[ /www/cfc_v2/rss-links.cfc | GetRSSHeaders() ] from /www/cfc_v2/rss-links.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/seo-headers.cfc | getCurrentPath() ] from /www/cfc_v2/seo-headers.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/seo-headers.cfc | init() ] from /www/cfc_v2/seo-headers.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | getCat102ByID(2734) ] from /www/cfc_v2/solr-general.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | setFacets(11100) ] from /www/cfc_v2/solr-general.cfc
1 ms 1 ms 1 CFC[ /www/httpd/www-mytowersafe/Application.cfc | onSessionStart() ] from /www/httpd/www-mytowersafe/Application.cfc
0 ms 0 ms 3 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/callbalo_v2.cfm
0 ms 0 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/cartdsp.cfm
0 ms 0 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/directly_link.cfm
0 ms 0 ms 1 CFC[ /www/cfc_v2/balo_v2.cfc | fResetObject() ] from /www/cfc_v2/balo_v2.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/base.cfc | _ReplaceSpecialCharsFromKeywordnolowercase() ] from /www/cfc_v2/base.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | getDivName(5) ] from /www/cfc_v2/solr-general.cfc
4 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
905 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getURLrewrite (Datasource=tower_badge_mssql, Time=7ms, Records=0) in /www/cfc_v2/seo-headers.cfc @ 02:04:47.047
			select top 1 LINK_PATH,link_url,par_1_desc,par_2_desc,par_3_desc,par_1,par_2,par_3
			FROM pi_link_map_v2 (nolock)
			where LINK_URL = ?
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = /surf/explore/nav_exp/nav_5_browse.cfm?div_id=5&type=1&cat102=2734

GetSEOHeaders (Datasource=tower_product_mssql, Time=3ms, Records=0) in /www/cfc_v2/seo-headers.cfc @ 02:04:47.047
			select 	top 1 
					[description_3] as [H1], 
					[description_1] as [H2],
					[DESCRIPTION_2],
					[seo_title],
					[seo_description],
					[seo_keywords]
			from 	[seo_reference] (nolock)
			where 	[seo_reference].[path_id] = ?
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = /surf/explore/nav_exp/nav_5_browse.cfm?div_id=5&type=1&cat102=2734

_getCat102ByID (Datasource=tower_product_mssql, Time=7ms, Records=1) in /www/cfc_v2/solr.cfc @ 02:04:47.047
            SELECT [PIW_cat102_id]
                  ,[PIW_cat101_id]
                  ,[cat102_en]
              FROM [pi_20000_product].[dbo].[PI_cat102] (nolock)
              where [PIW_cat102_id] = 2734          
        
banner_get102 (Datasource=tower_product_mssql, Time=2ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:47.047
                select sold_cat102_id from sold_cat102
                where
                content_area =  10
                and active = 1
                and page_tosell_id = 3
                and cat102 = 2734
            
banner_get101 (Datasource=tower_product_mssql, Time=2ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:47.047
                select sold_cat101_id from sold_cat101
              where
                content_area =  10
                and active = 1
                and page_tosell_id = 3  
                and cat101 = 0
            
banner_getdiv (Datasource=tower_product_mssql, Time=9ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:47.047
                select sold_div_id from sold_div
                where
                content_area =  10
                and active = 1
                and div =  5
            
_getCat102ByID (Datasource=tower_product_mssql, Time=0ms, Records=1, Cached Query) in /www/cfc_v2/solr.cfc @ 02:04:47.047
            SELECT [PIW_cat102_id]
                  ,[PIW_cat101_id]
                  ,[cat102_en]
              FROM [pi_20000_product].[dbo].[PI_cat102] (nolock)
              where [PIW_cat102_id] = 2734          
        
_getCat101Name (Datasource=tower_product_mssql, Time=4ms, Records=1) in /www/cfc_v2/solr.cfc @ 02:04:48.048
            SELECT [PIW_Cat101_id]
                  ,[Cat101_en]
              FROM [pi_20000_product].[dbo].[PI_cat101] (nolock)
            where [PIW_Cat101_id] = 32       
         
banner_get102 (Datasource=tower_product_mssql, Time=4ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:48.048
                select sold_cat102_id from sold_cat102
                where
                content_area =  9
                and active = 1
                and page_tosell_id = 3
                and cat102 = 2734
            
banner_get101 (Datasource=tower_product_mssql, Time=6ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:48.048
                select sold_cat101_id from sold_cat101
              where
                content_area =  9
                and active = 1
                and page_tosell_id = 3  
                and cat101 = 0
            
banner_getdiv (Datasource=tower_product_mssql, Time=7ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:48.048
                select sold_div_id from sold_div
                where
                content_area =  9
                and active = 1
                and div =  5
            
_ShoppingCartEnabled (Datasource=tower_product_mssql, Time=14ms, Records=25) in /www/cfc_v2/solr.cfc @ 02:04:48.048
              SELECT   a.[wapi]
                      ,b.[OfferListingID]
                      ,b.[ShoppingCartEnabled]
                FROM [pi_20000_product].[dbo].[pi_wapi_asin] a (nolock) 
                      left join [pi_20000_product].[dbo].[pi_wapi_asin_offer] b (nolock) on a.[asin]=b.[asin]
                where a.[wapi] in ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )      
            
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 112402972
Parameter #2(cf_sql_integer) = 112193073
Parameter #3(cf_sql_integer) = 112536508
Parameter #4(cf_sql_integer) = 112522953
Parameter #5(cf_sql_integer) = 111926661
Parameter #6(cf_sql_integer) = 112536507
Parameter #7(cf_sql_integer) = 112402977
Parameter #8(cf_sql_integer) = 112402978
Parameter #9(cf_sql_integer) = 112935259
Parameter #10(cf_sql_integer) = 112930567
Parameter #11(cf_sql_integer) = 111989910
Parameter #12(cf_sql_integer) = 113057179
Parameter #13(cf_sql_integer) = 112414750
Parameter #14(cf_sql_integer) = 113089574
Parameter #15(cf_sql_integer) = 113018542
Parameter #16(cf_sql_integer) = 113031542
Parameter #17(cf_sql_integer) = 100666023
Parameter #18(cf_sql_integer) = 112301714
Parameter #19(cf_sql_integer) = 112464132
Parameter #20(cf_sql_integer) = 113057354
Parameter #21(cf_sql_integer) = 100215408
Parameter #22(cf_sql_integer) = 108639662
Parameter #23(cf_sql_integer) = 111989847
Parameter #24(cf_sql_integer) = 109189066
Parameter #25(cf_sql_integer) = 111989899
Parameter #26(cf_sql_integer) = -1

banner_get102 (Datasource=tower_product_mssql, Time=2ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:48.048
                select sold_cat102_id from sold_cat102
                where
                content_area =  11
                and active = 1
                and page_tosell_id = 3
                and cat102 = 2734
            
banner_get101 (Datasource=tower_product_mssql, Time=1ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:48.048
                select sold_cat101_id from sold_cat101
              where
                content_area =  11
                and active = 1
                and page_tosell_id = 3  
                and cat101 = 0
            
banner_getdiv (Datasource=tower_product_mssql, Time=1ms, Records=0) in /www/cfc_v2/getbanner.cfc @ 02:04:48.048
                select sold_div_id from sold_div
                where
                content_area =  11
                and active = 1
                and div =  5
            
qryGetFeed (Datasource=tower_zone_nav, Time=1ms, Records=0) in /www/cfc_v2/balo_v2.cfc @ 02:04:48.048
				SELECT 
				[html],
				[b_width],
				[b_height]
				FROM [pi_70000_navigator].[dbo].[pi_balo_feed]  (nolock)
				WHERE active_balo = ?
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 155

qryGetTemple (Datasource=tower_zone_nav, Time=4ms, Records=1) in /www/cfc_v2/balo_v2.cfc @ 02:04:48.048
				SELECT TOP 1
				[default_html] AS html,
				[b_width],
				[b_height]
				FROM [pi_70000_navigator].[dbo].[pi_balo_temple]  (nolock) 
				WHERE piw_balo_id = ?
			
Query Parameter Value(s) -
Parameter #1(cf_sql_idstamp) = 155

qryLastVersion (Datasource=tower_product_mssql, Time=1ms, Records=1, Cached Query) in /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/version.cfm @ 02:04:48.048
	    select top 1 ver_number from pi_20000_product.dbo.[Pi_version]
    


Scope Variables

Application Variables:
applicationname=Towerv2
baseregex=Complex type
digprodhelper=Struct (2)
downprodhelper=Struct (5)
global=Struct (3)
keywordsregex=Complex type
ogoogle=Struct (9)
prodhelper=Struct (17)
site_cat_id_2=Array (6)
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=/www/httpd/www-mytowersafe/unlock/www-tower/surf/explore/nav_exp/nav_5_browse.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,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.tower.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/www/httpd/www-mytowersafe/unlock/www-tower/surf/explore/nav_exp/nav_5_browse.cfm
QUERY_STRING=div_id=5&type=1&cat102=2734
REMOTE_ADDR=54.161.3.108
REMOTE_HOST=54.161.3.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/surf/explore/nav_exp/nav_5_browse.cfm
SERVER_NAME=www.tower.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
CFID=259414
CFTOKEN=5ac375397883a3ae-35414D1F-F283-F5C5-96D92AD4D0D9CE03
JSESSIONID=TOWERV2_259414_5ac375397883a3ae-35414D1F-F283-F5C5-96D92AD4D0D9CE03
Request Parameters:
chcklocation=secure.tower
domainname=.tower.com
htmlsite=http://www.tower.com/
locksite=https://secure.tower.com/
site_variables=Struct (2)
unlocksite=http://www.tower.com/
Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
cfid=259414
cftoken=5ac375397883a3ae-35414D1F-F283-F5C5-96D92AD4D0D9CE03
clientwallet=Struct (1)
sessionid=TOWERV2_259414_5ac375397883a3ae-35414D1F-F283-F5C5-96D92AD4D0D9CE03
urltoken=CFID=259414&CFTOKEN=5ac375397883a3ae-35414D1F-F283-F5C5-96D92AD4D0D9CE03
URL Parameters:
CAT102=2734
DIV_ID=5
TYPE=1
Debug Rendering Time: 79 ms