Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"bristol-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/death-becomes-her-1-2026-01-03-tm-new-york-ny.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"bristol-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","bristol-county-ri","bristol-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"af6dd759b2e6abd2a93bb49c36b4e4e4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	8
6	db.events_radius_cache.find( {"_id":"d3278c47e79378362dbc82355114bc4f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
7	db.events.count( {"address.town_sef_url":"bristol-ri","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	1	9
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.26100158691406,41.682498931884766],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	4	36
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.26100158691406,41.682498931884766],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	36	37
10	db.events_radius_cache.count( {"_id":"d3278c47e79378362dbc82355114bc4f"} )	0	1
11	db.events_radius_cache.insert( {"_id":"d3278c47e79378362dbc82355114bc4f","radius":15,"modified":"MongoDate(0.48500000 1765843736)","created":"MongoDate(0.48500000 1765843736)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-71.26100158691406,41.682498931884766],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 16 ).skip( 0 )	16	124
13	db.events_cache.count( {"_id":"af6dd759b2e6abd2a93bb49c36b4e4e4"} )	0	1
14	db.events_cache.count( {"_id":"af6dd759b2e6abd2a93bb49c36b4e4e4"} )	0	1
15	db.events_cache.insert( {"_id":"af6dd759b2e6abd2a93bb49c36b4e4e4","town_sef_url":"bristol-ri","data_key":["68a75b5d03a70639b6cf080b","68a75b5f03a70639b6cf0ecc","69036ade4389be6be5f5f290","69036ade4389be6be5f5f5f5","69036ade4389be6be5f5f5cf","68a75b6103a70639b6cf184b","69036adf4389be6be5f5f8af","69036adf4389be6be5f5f91f","69036adf4389be6be5f5f9d2","69036adf4389be6be5f5f9f2","69036adf4389be6be5f5fae8","69036ae04389be6be5f5fde0","68a75b6203a70639b6cf1d6f","68a75b6203a70639b6cf1c85","69036ae04389be6be5f5ff7d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Bristol Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"death-becomes-her-1-2026-01-03-tm-new-york-ny.html\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":41.682498931884766,\"lng\":-71.26100158691406,\"latlng\":\"41.682498931885,-71.261001586914\",\"city\":\"Bristol\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.64900000 1765843736)","created":"MongoDate(0.64900000 1765843736)"} , true)	0	2

Bristol

Rhode Island

Bristol Featured Events

Live Music - Matt Martin and the Daydrinkers

Live Music - Dan Lilley and The Keepers

Sparkling Lights at The Breakers

The Wizards of Winter

Bywater Call

Fall River Farmers Market At Cardinal Medeiros Towers

Holiday Lantern Tour

Holiday Lights Spectacular at Roger Williams Park Zoo

Rehoboth Holiday Market

Providence College Friars Mens Basketball vs. Seton Hall Pirates Mens Basketball

Cirque Dreams Holidaze

Quinn Sullivan

The Uncle Louie Variety Show

Show - The Bit Players

Tragedy: A Metal Tribute to the Bee Gees

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Bristol Featured Events

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.