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

    9780812984132

    "

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=9780812984132&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 31-Jul-16 05:44 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.166.247.229
Host Name 54.166.247.229


Execution Time

Total Time Avg Time Count Template
347 ms 347 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/display-search-results.cfm
201 ms 201 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm
90 ms 90 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | SolrCall(0, sku=9780812984132&sort=Rank asc&facet=div_id, 0) ] from /www/cfc_v2/solr-general.cfc
26 ms 26 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137261937, ss) ] from /www/cfc_v2/cnoah.cfc
20 ms 20 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138545497, ss) ] from /www/cfc_v2/cnoah.cfc
19 ms 19 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/didyoumean.cfm
14 ms 14 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(137001576, ss) ] from /www/cfc_v2/cnoah.cfc
14 ms 14 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138421129, ss) ] from /www/cfc_v2/cnoah.cfc
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(9780812984132, 0) ] from /www/cfc_v2/related_search.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(119473709, 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(135457198, 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(138251705, ss) ] from /www/cfc_v2/cnoah.cfc
5 ms 5 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuildURL(138819354, ss) ] from /www/cfc_v2/cnoah.cfc
4 ms 4 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/gen_footer_valid_nodiv.cfm
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_header_valid_nodiv.cfm
2 ms 0 ms 12 CFC[ /www/cfc_v2/cnoah.cfc | fBuildNewURL() ] from /www/cfc_v2/cnoah.cfc
2 ms 2 ms 1 CFC[ /www/cfc_v2/solr-general.cfc | setWapiForTrait([complex value]) ] from /www/cfc_v2/solr-general.cfc
2 ms 2 ms 1 CFC[ /www/httpd/www-mytowersafe/Application.cfc | onRequestStart(/tower_search/display-search-results.cfm) ] from /www/httpd/www-mytowersafe/Application.cfc
1 ms 1 ms 2 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/drop-down.cfm
1 ms 1 ms 2 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/prices-rules.cfm
1 ms 1 ms 1 /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/version.cfm
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | 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
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
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(London Has Fallen (Blu-ray) ~ dftl) ] from /www/cfc_v2/cnoah.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fBuilImgAlt(The Divergent Series: Allegiant [Blu-ray + DVD + Digital HD] ~ Shailene Woodley) ] from /www/cfc_v2/cnoah.cfc
1 ms 1 ms 1 CFC[ /www/cfc_v2/cnoah.cfc | fCheckWAPI(119473709) ] from /www/cfc_v2/cnoah.cfc
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/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
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(9780812984132) ] 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: 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(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(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(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 | fCheckWAPI(122504734) ] 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(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(138819354) ] 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 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(124543169) ] from /www/cfc_v2/solr-general.cfc
0 ms 0 ms 2 CFC[ /www/cfc_v2/solr-general.cfc | getTrait(124543169) ] 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
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
353 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 @ 05:44:47.047
                                SELECT 		TOP 10 a.link_text, a.link_URL, external_link
                                FROM 		pi_nerd_links a (nolock)
                                WHERE 		1=1
                                AND a.search_text = '9780812984132' AND a.division IN (0,0) 
                                AND 		a.Active = 1
                                ORDER BY a.rank ASC
                            
_ShoppingCartEnabled (Datasource=tower_product_mssql, Time=2ms, Records=1) in /www/cfc_v2/solr.cfc @ 05:44:47.047
              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) = 124543169
Parameter #2(cf_sql_integer) = 124543169
Parameter #3(cf_sql_integer) = -1

getitemtreasure2 (Datasource=tower_product_mssql, Time=1ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
    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 @ 05:44:47.047
    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 @ 05:44:47.047
    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=2ms, Records=4) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
    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 @ 05:44:47.047
                                            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=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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 @ 05:44:47.047
                                            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 @ 05:44:47.047
                    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=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
                                            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 @ 05:44:47.047
                    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 @ 05:44:47.047
                                            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=16ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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=19ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
                                            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=22ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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_135457198 (Datasource=tower_product_mssql, Time=13ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
                                            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=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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_137001576 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
                                            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=10ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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_138854794 (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
                                            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 @ 05:44:47.047
                    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_138251705 (Datasource=tower_product_mssql, Time=8ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
                                        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=2ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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 @ 05:44:47.047
                                        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=11ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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 @ 05:44:47.047
                                        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 @ 05:44:47.047
                    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_138819354 (Datasource=tower_product_mssql, Time=9ms, Records=1) in /www/httpd/www-mytowersafe/unlock/www-tower/tower_search/adds-hori-openx.cfm @ 05:44:47.047
                                        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='138819354'
                                      
qryGetAllInformations (Datasource=tower_product_mssql, Time=1ms, Records=1) in /www/cfc_v2/cnoah.cfc @ 05:44:47.047
                    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) = 138819354

qryLastVersion (Datasource=tower_product_mssql, Time=0ms, Records=1, Cached Query) in /www/httpd/www-mytowersafe/unlock/www-tower/surf/includes/general/version.cfm @ 05:44:47.047
	    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=9780812984132&div_id=0
REMOTE_ADDR=54.166.247.229
REMOTE_HOST=54.166.247.229
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=506828
CFTOKEN=5ae062cc67ab4fef-40576E65-ACBD-91B1-30E594391F4F9584
JSESSIONID=TOWERV2_506828_5ae062cc67ab4fef-40576E65-ACBD-91B1-30E594391F4F9584
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=506828
cftoken=5ae062cc67ab4fef-40576E65-ACBD-91B1-30E594391F4F9584
clientwallet=Struct (1)
sessionid=TOWERV2_506828_5ae062cc67ab4fef-40576E65-ACBD-91B1-30E594391F4F9584
urltoken=CFID=506828&CFTOKEN=5ae062cc67ab4fef-40576E65-ACBD-91B1-30E594391F4F9584
URL Parameters:
DIV_ID=0
KEYWORDS=9780812984132
Debug Rendering Time: 73 ms