Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"waterford-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"bristol-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"86f46ae2e2c7d8d3faffc60f2bbc3619"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"d3278c47e79378362dbc82355114bc4f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769320800)"},"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	68
9	db.events_cache.count( {"_id":"86f46ae2e2c7d8d3faffc60f2bbc3619"} )	0	1
10	db.events_cache.count( {"_id":"86f46ae2e2c7d8d3faffc60f2bbc3619"} )	0	1
11	db.events_cache.insert( {"_id":"86f46ae2e2c7d8d3faffc60f2bbc3619","town_sef_url":"bristol-ri","data_key":["68bf8fa6c3af739f25b37f89","690ea998de4ae56f5ac2868c","68bf8fa6c3af739f25b37fae","69540e02de4ae56f5a80766f","690c3edade4ae56f5afb9eb7","689e67d5fb5e4bed1f3b3307","692f6e55de4ae56f5af58d4e","68ef3dddc3af739f2585ae9e","689e67d5fb5e4bed1f3b3320","68eb495dc3af739f25ce1cd3","692f6e55de4ae56f5af58d94","68bf8fa6c3af739f25b380eb","689e67d5fb5e4bed1f3b3330","68f483ddc3af739f25f392a3","68bf8fa6c3af739f25b38156"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Bristol Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"\",\"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.25500000 1769383394)","created":"MongoDate(0.25500000 1769383394)"} , true)	0	2
12	db.towns.find( {"sef_url":"bristol-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ri","bristol-county-ri","bristol-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Bristol

Rhode Island

Bristol Featured Events

Suffs (Touring)

Providence Bruins vs. Toronto Marlies

Suffs (Touring)

FREE BCBA CEU: How Instructive Feedback Drives Emergent Skills in Autism

G. Love & Special Sauce

The Roommate

Traces and Transitions, work of Henry Ferreira and Julia Shepley

Handsome Dick Manitoba

The Roommate

Jesse Cook

Traces and Transitions, work of Henry Ferreira and Julia Shepley

Monster Jam

The Roommate

Ward Hayden & The Outliers

Monster Jam

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

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.