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:
  • "

    9781846034305

    "

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=9781846034305&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 06:10 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.146.4.250
Host Name 54.146.4.250


Execution Time

Total Time Avg Time Count Template
666 ms 666 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/display-search-results.cfm
466 ms 466 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm
88 ms 88 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | SolrCall(0, sku=9781846034305&sort=Rank asc&facet=div_id, 0) ] from /www/cfc_v2/solr-general.cfc
41 ms 41 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | setWapiForTrait([complex value]) ] from /www/cfc_v2/solr-general.cfc
32 ms 32 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/related_search.cfm
30 ms 30 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138421129, ss) ] from /www/cfc_v2/cnoah.cfc
30 ms 30 ms 1 CFC[ /www/cfc_v2/related_search.cfc | GetRelatedSearchValues(9781846034305, 0) ] from /www/cfc_v2/related_search.cfc
24 ms 24 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138251705, ss) ] from /www/cfc_v2/cnoah.cfc
19 ms 19 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137178821, ss) ] from /www/cfc_v2/cnoah.cfc
18 ms 18 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(135457198, ss) ] from /www/cfc_v2/cnoah.cfc
17 ms 17 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(119473709, ss) ] from /www/cfc_v2/cnoah.cfc
17 ms 17 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138545497, ss) ] from /www/cfc_v2/cnoah.cfc
17 ms 17 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138848926, ss) ] from /www/cfc_v2/cnoah.cfc
16 ms 16 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/didyoumean.cfm
16 ms 16 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(122790752, ss) ] from /www/cfc_v2/cnoah.cfc
16 ms 16 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137001576, ss) ] from /www/cfc_v2/cnoah.cfc
16 ms 16 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137261937, ss) ] from /www/cfc_v2/cnoah.cfc
14 ms 14 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138290694, ss) ] from /www/cfc_v2/cnoah.cfc
13 ms 13 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(122504734, 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
2 ms 2 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/gen_header_valid_nodiv.cfm
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/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 | fBuilImgAlt(Vision: Your Pathway to Victory (Paperback) ~ Gordon D'Angelo) ] from /www/cfc_v2/cnoah.cfc
1 ms 0 ms 12 CFC[ /www/cfc_v2/cnoah.cfc | fBuildNewURL() ] from /www/cfc_v2/cnoah.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(122504734) ] from /www/cfc_v2/cnoah.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(135457198) ] 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 1 CFC[ /www/cfc_v2/rss-links.cfc | GetRSSHeaders() ] from /www/cfc_v2/rss-links.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 2 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/drop-down.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(9781846034305) ] 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(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(Hamilton (Original Broadway Cast Recording)(Explicit)(2CD) ~ Various Artists) ] 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(Traveller (CD) ~ Chris Stapleton) ] 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(122790752) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(137001576) ] from /www/cfc_v2/cnoah.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(137178821) ] 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(138848926) ] from /www/cfc_v2/cnoah.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 2 CFC[ /www/cfc_v2/solr-general.cfc | getDivName(5) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | getShoppingCartEnabled(113312146) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 2 CFC[ /www/cfc_v2/solr-general.cfc | getTrait(113312146) ] 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
672 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

getitemtreasure2 (Datasource=tower_product_mssql, Time=14ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:27.027
    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=16ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:27.027
    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=16ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:27.027
    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=14ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:27.027
    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_119473709 (Datasource=tower_product_mssql, Time=16ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:27.027
                                            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=13ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:27.027
                    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_122504734 (Datasource=tower_product_mssql, Time=12ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:27.027
                                            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=10ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:27.027
                    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_122790752 (Datasource=tower_product_mssql, Time=13ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:27.027
                                            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=13ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:27.027
                    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=15ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                            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=12ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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_135457198 (Datasource=tower_product_mssql, Time=15ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                            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='135457198'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=14ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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) = 135457198

tres_137261937 (Datasource=tower_product_mssql, Time=12ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                            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=13ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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_138848926 (Datasource=tower_product_mssql, Time=13ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                            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=13ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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_137001576 (Datasource=tower_product_mssql, Time=12ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                            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='137001576'
                                          
qryGetAllInformations (Datasource=tower_product_mssql, Time=12ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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) = 137001576

tres_138251705 (Datasource=tower_product_mssql, Time=12ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                        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=19ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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=18ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                        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=26ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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=16ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                        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=16ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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=11ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 06:10:28.028
                                        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=11ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 06:10:28.028
                    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 @ 06:10:28.028
	    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=9781846034305&div_id=0
REMOTE_ADDR=54.146.4.250
REMOTE_HOST=54.146.4.250
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=277073
CFTOKEN=1300ad0dfa38a740-362238BC-9A6B-820C-DBAA535DCEB40151
JSESSIONID=TOWERV2_277073_1300ad0dfa38a740-362238BC-9A6B-820C-DBAA535DCEB40151
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=277073
cftoken=1300ad0dfa38a740-362238BC-9A6B-820C-DBAA535DCEB40151
clientwallet=Struct (1)
sessionid=TOWERV2_277073_1300ad0dfa38a740-362238BC-9A6B-820C-DBAA535DCEB40151
urltoken=CFID=277073&CFTOKEN=1300ad0dfa38a740-362238BC-9A6B-820C-DBAA535DCEB40151
URL Parameters:
DIV_ID=0
KEYWORDS=9781846034305
Debug Rendering Time: 75 ms