Tower.comTower.com
Search
tower.com
My Shopping Bag       Help   
Home Music Video Books Games Downloads Advanced Search
 [Skip to Content]   [Home Page]   []   []   []   []   []   [
You searched:
  • "

    9780609810118

    "

ADVERTISEMENT

1 | 
1 | 







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/tower_search/display-search-results.cfm?keywords=9780609810118&div_id=0
Tower 2.0 Version 6.0.0
 
Home Music Video Books Games Downloads
 [Skip to Content]   [Home Page]   []   []   []   []   [


Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /tower_search/display-search-results.cfm
Time Stamp 29-Jul-16 03:57 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.159.115.185
Host Name 54.159.115.185


Execution Time

Total Time Avg Time Count Template
1069 ms 1069 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/display-search-results.cfm
373 ms 373 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | SolrCall(0, sku=9780609810118&sort=Rank asc&facet=div_id, 0) ] from /www/cfc_v2/solr-general.cfc
310 ms 310 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/related_search.cfm
308 ms 308 ms 1 CFC[ /www/cfc_v2/related_search.cfc | GetRelatedSearchValues(9780609810118, 0) ] from /www/cfc_v2/related_search.cfc
182 ms 182 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | setWapiForTrait([complex value]) ] from /www/cfc_v2/solr-general.cfc
165 ms 165 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm
17 ms 17 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/didyoumean.cfm
7 ms 7 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(119473709, ss) ] from /www/cfc_v2/cnoah.cfc
7 ms 7 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(122790752, ss) ] from /www/cfc_v2/cnoah.cfc
6 ms 6 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(122504734, ss) ] from /www/cfc_v2/cnoah.cfc
6 ms 6 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138545497, ss) ] from /www/cfc_v2/cnoah.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137178821, ss) ] from /www/cfc_v2/cnoah.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137261937, ss) ] from /www/cfc_v2/cnoah.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138251705, ss) ] from /www/cfc_v2/cnoah.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138421129, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138290694, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138609206, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138848926, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138854794, ss) ] from /www/cfc_v2/cnoah.cfc
3 ms 3 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/gen_footer_valid_nodiv.cfm
3 ms 3 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/gen_header_valid_nodiv.cfm
3 ms 0 ms 12 CFC[ /www/cfc_v2/cnoah.cfc | fBuildNewURL() ] from /www/cfc_v2/cnoah.cfc
2 ms 2 ms 1 CFC[ /www/httpd/www-mytowersafe/Application.cfc | onRequestStart(/tower_search/display-search-results.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 2 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/prices-rules.cfm
1 ms 1 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/version.cfm
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(137178821) ] from /www/cfc_v2/cnoah.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/related_search.cfc | init(true) ] from /www/cfc_v2/related_search.cfc
1 ms 1 ms 2 CFC[ /www/cfc_v2/solr-general.cfc | getDivName(5) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 1 /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 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-column-openx.cfm
0 ms 0 ms 1 CFC[ /www/cfc_v2/base.cfc | _ReplaceSpecialCharsFromKeyword(9780609810118) ] from /www/cfc_v2/base.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(25 (CD) ~ Adele) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(A Moon Shaped Pool (CD) ~ Radiohead) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(Batman v Superman: Dawn of Justice (Ultimate Edition Blu-ray + Theatrical Blu-ray + DVD + Digital HD UltraViolet Combo Pack) ~ Ben Affleck) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(Batman: The Killing Joke (Blu-ray + DVD + Digital HD UltraViolet Combo Pack) ~ Kevin Conroy) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(First 100 Words (Hardcover) ~ Roger Priddy) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(KIDZ BOP 32 (CD) ~ Kidz Bop Kids) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(Leading Culture Change in Global Organizations: Aligning Culture and Strategy (J-B US non-Franchise Leadership) (Hardcover) ~ Daniel Denison) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(London Has Fallen (Blu-ray) ~ dftl) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(Me Before You: A Novel (Movie Tie-In) (Paperback) ~ Jojo Moyes) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(Miracles From Heaven (DVD) ~ dftl) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(Vision: Your Pathway to Victory (Paperback) ~ Gordon D'Angelo) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(We're All Somebody From Somewhere (CD) ~ Steven Tyler) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(119473709) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(122504734) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(122790752) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(137261937) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138251705) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138290694) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138421129) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138545497) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138609206) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138848926) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138854794) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/rss-links.cfc | GetRSSHeaders() ] from /www/cfc_v2/rss-links.cfc
0 ms 0 ms 2 CFC[ /www/cfc_v2/solr-general.cfc | getDivName(1) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | getShoppingCartEnabled(101518905) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 2 CFC[ /www/cfc_v2/solr-general.cfc | getTrait(101518905) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | setFacets(1) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 1 CFC[ /www/httpd/www-mytowersafe/Application.cfc | onSessionStart() ] from /www/httpd/www-mytowersafe/Application.cfc
4 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1075 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

QRYRelatedSearchValues (Datasource=tower_product_mssql, Time=306ms, Records=0) in /www/cfc_v2/related_search.cfc @ 15:57:01.001
                                SELECT 		TOP 10 a.link_text, a.link_URL, external_link
                                FROM 		pi_nerd_links a (nolock)
                                WHERE 		1=1
                                AND a.search_text = '9780609810118' AND a.division IN (0,0) 
                                AND 		a.Active = 1
                                ORDER BY a.rank ASC
                            
_ShoppingCartEnabled (Datasource=tower_product_mssql, Time=181ms, Records=1) in /www/cfc_v2/solr.cfc @ 15:57:01.001
              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) = 101518905
Parameter #2(cf_sql_integer) = 101518905
Parameter #3(cf_sql_integer) = -1

getitemtreasure2 (Datasource=tower_product_mssql, Time=42ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
    select top 4 b.piw_image_id , a.title, a.contributor , a.release_date,a.wapi,a.tower_rank
    from pi_wapi_data_list b (nolock)
    inner join pi_wapi_div_2 a (nolock) on a.wapi=b.wapi
    order by a.tower_rank
  
getitemtreasure3 (Datasource=tower_product_mssql, Time=4ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
    select top 4 b.piw_image_id , a.title, a.contributor , a.release_date,a.wapi,a.tower_rank
    from pi_wapi_data_list b (nolock)
    inner join pi_wapi_div_3 a (nolock) on a.wapi=b.wapi
    order by a.tower_rank
  
getitemtreasure1 (Datasource=tower_product_mssql, Time=4ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
    select top 4 b.piw_image_id , a.title, a.contributor , a.release_date,a.wapi,a.tower_rank
    from pi_wapi_data_list b (nolock)
    inner join pi_wapi_div_1 a (nolock) on a.wapi=b.wapi
    order by a.tower_rank
  
getitemtreasure4 (Datasource=tower_product_mssql, Time=4ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
    select top 4 b.piw_image_id , a.title, a.contributor , a.release_date,a.wapi,a.tower_rank
    from pi_wapi_data_list b (nolock)
    inner join pi_wapi_div_4 a (nolock) on a.wapi=b.wapi
    order by a.tower_rank
  
tres_122504734 (Datasource=tower_product_mssql, Time=8ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_1 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='122504734'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=3ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 122504734

tres_119473709 (Datasource=tower_product_mssql, Time=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_1 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='119473709'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=3ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 119473709

tres_122790752 (Datasource=tower_product_mssql, Time=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_1 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='122790752'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=3ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 122790752

tres_138545497 (Datasource=tower_product_mssql, Time=7ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_1 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='138545497'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 138545497

tres_137261937 (Datasource=tower_product_mssql, Time=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_2 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='137261937'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 137261937

tres_138854794 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_2 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='138854794'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 138854794

tres_138609206 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_2 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='138609206'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 138609206

tres_138848926 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:01.001
                                            select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                            from pi_wapi_data_list b(nolock)
                                            inner join pi_wapi_div_2 a (nolock) on a.wapi=b.wapi
                                            where 
                                            a.wapi='138848926'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=0ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:01.001
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 138848926

tres_138251705 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:02.002
                                        select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                        from pi_wapi_data_list b(nolock)
                                        inner join pi_wapi_div_3 a (nolock) on a.wapi=b.wapi
                                        where a.wapi='138251705'
                                      
qryGetAllInformations (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:02.002
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 138251705

tres_138421129 (Datasource=tower_product_mssql, Time=0ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:02.002
                                        select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                        from pi_wapi_data_list b(nolock)
                                        inner join pi_wapi_div_3 a (nolock) on a.wapi=b.wapi
                                        where a.wapi='138421129'
                                      
qryGetAllInformations (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:02.002
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 138421129

tres_137178821 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:02.002
                                        select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                        from pi_wapi_data_list b(nolock)
                                        inner join pi_wapi_div_3 a (nolock) on a.wapi=b.wapi
                                        where a.wapi='137178821'
                                      
qryGetAllInformations (Datasource=tower_product_mssql, Time=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:02.002
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 137178821

tres_138290694 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:57:02.002
                                        select top 1 a.title, a.contributor , a.release_date,a.wapi,a.tower_rank,b.price
                                        from pi_wapi_data_list b(nolock)
                                        inner join pi_wapi_div_3 a (nolock) on a.wapi=b.wapi
                                        where a.wapi='138290694'
                                      
qryGetAllInformations (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:57:02.002
                    SELECT	top 1 nav.[piw_island_id],
                            nav.[piw_flag_name],
                            nav.[meta_title],
                            nav.[meta_description],
                            nav.[short_display],
                            nav.[display_medium],
                            nav.[meta_keyword],
                            dl.piw_image_id,
                            img.URL_small,
                            img.URL_medium
                    FROM [pi_70000_navigator].[dbo].[pi_private_zone_wapi] nav (NOLOCK)
                    LEFT JOIN [pi_20000_product].[dbo].pi_wapi_data_list dl (nolock) ON dl.wapi = nav.piw_island_id
                    LEFT JOIN [pi_20000_product].[dbo].[pi_wapi_asin_image] img (nolock) ON img.wapi = nav.piw_island_id
                    WHERE nav.piw_island_id = ?
                
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 138290694

qryLastVersion (Datasource=tower_product_mssql, Time=0ms, Records=1, Cached Query) in /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/version.cfm @ 15:57:02.002
	    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/tower_search/display-search-results.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/tower_search/display-search-results.cfm
QUERY_STRING=keywords=9780609810118&div_id=0
REMOTE_ADDR=54.159.115.185
REMOTE_HOST=54.159.115.185
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/tower_search/display-search-results.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=322920
CFTOKEN=8ef7aba386d4127f-383B3AA3-0DA8-8E0B-D228F8B3DBCFD629
JSESSIONID=TOWERV2_322920_8ef7aba386d4127f-383B3AA3-0DA8-8E0B-D228F8B3DBCFD629
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=322920
cftoken=8ef7aba386d4127f-383B3AA3-0DA8-8E0B-D228F8B3DBCFD629
clientwallet=Struct (1)
sessionid=TOWERV2_322920_8ef7aba386d4127f-383B3AA3-0DA8-8E0B-D228F8B3DBCFD629
urltoken=CFID=322920&CFTOKEN=8ef7aba386d4127f-383B3AA3-0DA8-8E0B-D228F8B3DBCFD629
URL Parameters:
DIV_ID=0
KEYWORDS=9780609810118
Debug Rendering Time: 71 ms