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

    9780679994589

    "

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=9780679994589&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:54 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
197 ms 197 ms 1 top level /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/display-search-results.cfm
94 ms 94 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm
52 ms 52 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | SolrCall(0, sku=9780679994589&sort=Rank asc&facet=div_id, 0) ] from /www/cfc_v2/solr-general.cfc
17 ms 17 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/didyoumean.cfm
10 ms 10 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/related_search.cfm
7 ms 7 ms 1 CFC[ /www/cfc_v2/related_search.cfc | GetRelatedSearchValues(9780679994589, 0) ] from /www/cfc_v2/related_search.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(122504734, ss) ] from /www/cfc_v2/cnoah.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(122790752, 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(138421129, ss) ] from /www/cfc_v2/cnoah.cfc
5 ms 5 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(138848926, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(119473709, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137261937, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138251705, 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(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 0 ms 12 CFC[ /www/cfc_v2/cnoah.cfc | fBuildNewURL() ] from /www/cfc_v2/cnoah.cfc
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/cfc_v2/solr-general.cfc | setWapiForTrait([complex value]) ] from /www/cfc_v2/solr-general.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(122790752) ] from /www/cfc_v2/cnoah.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138421129) ] from /www/cfc_v2/cnoah.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(138545497) ] from /www/cfc_v2/cnoah.cfc
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/httpd/www-mytowersafe/Application.cfc | onRequestStart(/tower_search/display-search-results.cfm) ] from /www/httpd/www-mytowersafe/Application.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 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(9780679994589) ] 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(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(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/related_search.cfc | init(true) ] from /www/cfc_v2/related_search.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(100077162) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 2 CFC[ /www/cfc_v2/solr-general.cfc | getTrait(100077162) ] 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
4 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

getitemtreasure2 (Datasource=tower_product_mssql, Time=2ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
    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=1ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
    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=1ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
    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=1ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
                                            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=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:54:44.044
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
                                            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=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:54:44.044
                    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:54:44.044
                                            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=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:54:44.044
                    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=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
                                            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=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:54:44.044
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
                                            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=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:54:44.044
                    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:54:44.044
                                            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:54:44.044
                    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:54:44.044
                                            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:54:44.044
                    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=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
                                            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=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:54:44.044
                    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:54:44.044
                                        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:54:44.044
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
                                        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:54:44.044
                    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=0ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 15:54:44.044
                                        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=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 15:54:44.044
                    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:54:44.044
                                        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:54:44.044
                    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:54:44.044
	    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=9780679994589&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=322722
CFTOKEN=18e6ba85e0c60d02-38392619-92C4-AC0B-E26EC2DE07E7FBCC
JSESSIONID=TOWERV2_322722_18e6ba85e0c60d02-38392619-92C4-AC0B-E26EC2DE07E7FBCC
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=322722
cftoken=18e6ba85e0c60d02-38392619-92C4-AC0B-E26EC2DE07E7FBCC
clientwallet=Struct (1)
sessionid=TOWERV2_322722_18e6ba85e0c60d02-38392619-92C4-AC0B-E26EC2DE07E7FBCC
urltoken=CFID=322722&CFTOKEN=18e6ba85e0c60d02-38392619-92C4-AC0B-E26EC2DE07E7FBCC
URL Parameters:
DIV_ID=0
KEYWORDS=9780679994589
Debug Rendering Time: 72 ms