BookBrowse for Libraries: Videos

Animated Introduction for Patrons (2 minutes)

Introduction

A Tour of BookBrowse for Libraries

Building Community Through Book Clubs

Actionable findings from BookBrowse's surveys. Recommended for librarians who run book clubs and/or provide readers advisory to those in groups.

Building Community Through Book Clubs Webinar

Podcast: Thoughts from a Page

An audio podcast with book columnist Cindy Burnett

Thoughts from a Page podcast

Interview on Lit With Lloyd

A conversation with broadcaster and blogger Lloyd Russell

Niche Academy Videos (1 - 3 minutes)

Introduction

Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /lib/videos/index.cfm
Time Stamp 01-Jun-26 01:41 AM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1

Execution Time

Total Time Avg Time Count Template
169 ms 169 ms 1 top level /root/website/lib/videos/index.cfm
110 ms 110 ms 1 /root/website/lib/blocks/app_layout.cfm
74 ms 74 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
73 ms 73 ms 1 /root/website/adsystem/adsystem_mod.cfm
73 ms 73 ms 1 /root/website/adzones/showcase_track.cfm
57 ms 57 ms 1 /root/website/lib/blocks/app_globals.cfm
34 ms 34 ms 1 /root/website/act_check_login.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_member_info.cfm
26 ms 26 ms 1 /root/website/lib/blocks/dsp_libinfo_left_border.cfm
26 ms 26 ms 1 /root/website/lib/blocks/dsp_libsidemenu.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_member_classification_number.cfm
19 ms 10 ms 2 /root/website/actions/act_spider_tracker.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/main_menu.cfm
1 ms 1 ms 1 /root/website/Application.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/app_server.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/lib/videos/dsp_main.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
170 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 01:41:38.038
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=33ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 01:41:38.038
select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 01:41:38.038
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_member_classification_number (Datasource=bookbrowse_com_new, Time=25ms, Records=0) in /root/website/queries/qry_get_member_classification_number.cfm @ 01:41:38.038
select  	a.member_classification_number, b.member_classification_description
	FROM 		members a
	INNER JOIN 	member_classification b on b.member_classification_number = a.member_classification_number
	WHERE		a.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_ads (Datasource=bookbrowse_com_new, Time=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:41:38.038
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:41:38.038
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track

get_type (Datasource=bookbrowse_com_new, Time=35ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:41:38.038
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594

Scope Variables

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=/root/website/lib/videos/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFID=4081360; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4081360%26CFTOKEN%23%3D22a7f49d06f09cc1%2D086B74B5%2DC147%2D3252%2DB3A8FFB5482EB1FB%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2001%3A41%3A38%27%7D%23hitcount%3D176%23timecreated%3D%7Bts%20%272026%2D06%2D01%2001%3A41%3A09%27%7D%23cftoken%3D35a6ea430b0eeb97%2D086B63A0%2DA32A%2DEE1C%2D59441C13FABC6D17%23cfid%3D4081358%23; CFTOKEN=22a7f49d06f09cc1-086B74B5-C147-3252-B3A8FFB5482EB1FB
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=
PATH_TRANSLATED=/root/website/lib/videos/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib/videos/index.cfm
SERVER_NAME=dev.bookbrowse.com
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=
WEB_SERVER_API=

Client Variables:
cfid=4081358
cftoken=35a6ea430b0eeb97-086B63A0-A32A-EE1C-59441C13FABC6D17
hitcount=176
lastvisit={ts '2026-06-01 01:41:38'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 01:41:09'}
urltoken=CFID=4081360&CFTOKEN=22a7f49d06f09cc1-086B74B5-C147-3252-B3A8FFB5482EB1FB
view=books

Cookie Variables:
CFCLIENT_BOOKBROWSE=order=p#member_number=0#member_active_flag=0#member_logged_in_flag=0#library_user_flag=0#view=books#
CFGLOBALS=urltoken=CFID#=4081360&CFTOKEN#=22a7f49d06f09cc1-086B74B5-C147-3252-B3A8FFB5482EB1FB#lastvisit={ts '2026-06-01 01:41:38'}#hitcount=176#timecreated={ts '2026-06-01 01:41:09'}#cftoken=35a6ea430b0eeb97-086B63A0-A32A-EE1C-59441C13FABC6D17#cfid=4081358#
CFID=4081360
CFTOKEN=22a7f49d06f09cc1-086B74B5-C147-3252-B3A8FFB5482EB1FB

Session Variables:
cfid=4081360
cftoken=22a7f49d06f09cc1-086B74B5-C147-3252-B3A8FFB5482EB1FB
paramlist=Struct (6)
results=Query (1087)
sessionid=BOOKBROWSE_4081360_22a7f49d06f09cc1-086B74B5-C147-3252-B3A8FFB5482EB1FB
urltoken=CFID=4081360&CFTOKEN=22a7f49d06f09cc1-086B74B5-C147-3252-B3A8FFB5482EB1FB
Debug Rendering Time: 28 ms