Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rousseau-ky"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.towns.find( {"sef_url":"spring-brook-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	3
6	db.events_cache.find( {"_id":"ee2da617882b90c853ffbf6c7f61f204"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"32d422362812bcd0b8a53f509f3adcb9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"spring-brook-ny","start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766296800)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.67530059814453,42.81800079345703],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} )	1	44
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.67530059814453,42.81800079345703],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} )	35	28
11	db.events_radius_cache.count( {"_id":"32d422362812bcd0b8a53f509f3adcb9"} )	0	1
12	db.events_radius_cache.count( {"_id":"32d422362812bcd0b8a53f509f3adcb9"} )	0	1
13	db.events_radius_cache.insert( {"_id":"32d422362812bcd0b8a53f509f3adcb9","radius":15,"modified":"MongoDate(0.30700000 1765722842)","created":"MongoDate(0.30700000 1765722842)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-78.67530059814453,42.81800079345703],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	106
15	db.events_cache.count( {"_id":"ee2da617882b90c853ffbf6c7f61f204"} )	0	1
16	db.events_cache.count( {"_id":"ee2da617882b90c853ffbf6c7f61f204"} )	0	1
17	db.events_cache.insert( {"_id":"ee2da617882b90c853ffbf6c7f61f204","town_sef_url":"spring-brook-ny","data_key":["685bb754fb5e4bed1fb69c37","69266492de4ae56f5ae4829b","68527ca0fb5e4bed1f029807","68a95e68c3af739f256266ee","69266492de4ae56f5ae482b2","690e51b4de4ae56f5a44b263","690e51b4de4ae56f5a44b267","687f4f90fb5e4bed1f73d141","690e51b4de4ae56f5a44b27e","685bb756fb5e4bed1fb69f4a","6878b7eafb5e4bed1fd985d1","687f4f91fb5e4bed1f73d401","690e51b4de4ae56f5a44b2a1","68d74abcc3af739f25e1e264","685bb757fb5e4bed1fb69fec"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Spring Brook 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\":42.81800079345703,\"lng\":-78.67530059814453,\"latlng\":\"42.818000793457,-78.675300598145\",\"city\":\"Spring Brook\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.45000000 1765722842)","created":"MongoDate(0.45000000 1765722842)"} , true)	0	1
18	db.towns.find( {"sef_url":"spring-brook-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","spring-brook-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4

Spring Brook

New York

Spring Brook Featured Events

White Christmas

Impulse Dance Force Fall Showcase

John Crist: Jokes for Humans

Bumpin Uglies and Ballyhoo!

Impulse Dance Force Fall Showcase

Annual Studio Artist Show and Sale

Annual Studio Artist Show and Sale

'Twas the Night Before... by Cirque du Soleil

Annual Studio Artist Show and Sale

White Christmas

Buffalo Sabres vs. Philadelphia Flyers

'Twas the Night Before... by Cirque du Soleil

Annual Studio Artist Show and Sale

Canisius University Women's Basketball vs Saint Peter's

White Christmas

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.

Spring Brook 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.