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

    9781583228975

    "

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=9781583228975&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 02:01 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.161.3.108
Host Name 54.161.3.108


Execution Time

Total Time Avg Time Count Template
208 ms 208 ms 1 top level /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/display-search-results.cfm
95 ms 95 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm
55 ms 55 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | SolrCall(0, sku=9781583228975&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
8 ms 8 ms 1 CFC[ /www/cfc_v2/related_search.cfc | GetRelatedSearchValues(9781583228975, 0) ] from /www/cfc_v2/related_search.cfc
7 ms 7 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | setWapiForTrait([complex value]) ] from /www/cfc_v2/solr-general.cfc
6 ms 6 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138290694, ss) ] from /www/cfc_v2/cnoah.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(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(119473709, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(135457198, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137001576, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137178821, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138545497, 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
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/httpd/www-mytowersafe/Application.cfc | onRequestStart(/tower_search/display-search-results.cfm) ] from /www/httpd/www-mytowersafe/Application.cfc
1 ms 1 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/directly_link.cfm
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 | 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 /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/tower_search/adds-column-openx.cfm
0 ms 0 ms 1 CFC[ /www/cfc_v2/base.cfc | _ReplaceSpecialCharsFromKeyword(9781583228975) ] 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(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(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(135457198) ] 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 1 CFC[ /www/cfc_v2/related_search.cfc | init(true) ] from /www/cfc_v2/related_search.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 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(113446330) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 2 CFC[ /www/cfc_v2/solr-general.cfc | getTrait(113446330) ] 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
214 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

QRYRelatedSearchValues (Datasource=tower_product_mssql, Time=6ms, Records=0) in /www/cfc_v2/related_search.cfc @ 02:01:22.022
                                SELECT 		TOP 10 a.link_text, a.link_URL, external_link
                                FROM 		pi_nerd_links a (nolock)
                                WHERE 		1=1
                                AND a.search_text = '9781583228975' AND a.division IN (0,0) 
                                AND 		a.Active = 1
                                ORDER BY a.rank ASC
                            
_ShoppingCartEnabled (Datasource=tower_product_mssql, Time=7ms, Records=1) in /www/cfc_v2/solr.cfc @ 02:01:22.022
              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) = 113446330
Parameter #2(cf_sql_integer) = 113446330
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 @ 02:01:22.022
    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=2ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
    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=2ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
    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 @ 02:01:22.022
    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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 @ 02:01:22.022
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 02:01:22.022
                    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=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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 @ 02:01:22.022
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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 @ 02:01:22.022
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 02:01:22.022
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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 @ 02:01:22.022
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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 @ 02:01:22.022
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                            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=0ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 02:01:22.022
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                        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 @ 02:01:22.022
                    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=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                        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 @ 02:01:22.022
                    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 @ 02:01:22.022
                                        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 @ 02:01:22.022
                    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=2ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 02:01:22.022
                                        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=3ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 02:01:22.022
                    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 @ 02:01:22.022
	    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=9781583228975&div_id=0
REMOTE_ADDR=54.161.3.108
REMOTE_HOST=54.161.3.108
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=259174
CFTOKEN=7c8c068516bea2f8-353E2C82-F48E-8C28-84AF351C411B8ED7
JSESSIONID=TOWERV2_259174_7c8c068516bea2f8-353E2C82-F48E-8C28-84AF351C411B8ED7
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=259174
cftoken=7c8c068516bea2f8-353E2C82-F48E-8C28-84AF351C411B8ED7
clientwallet=Struct (1)
sessionid=TOWERV2_259174_7c8c068516bea2f8-353E2C82-F48E-8C28-84AF351C411B8ED7
urltoken=CFID=259174&CFTOKEN=7c8c068516bea2f8-353E2C82-F48E-8C28-84AF351C411B8ED7
URL Parameters:
DIV_ID=0
KEYWORDS=9781583228975
Debug Rendering Time: 79 ms