Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"colden-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"colden-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","colden-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"d911e98f57e15e5b77eeba6a06ce5472"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"892280c86b5e32a7eaa7c325824cd62a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"colden-ny","start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766556000)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.68479919433594,42.64419937133789],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766815200)"}} )	0	34
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.68479919433594,42.64419937133789],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766815200)"}} )	1	35
10	db.events_radius_cache.count( {"_id":"892280c86b5e32a7eaa7c325824cd62a"} )	0	1
11	db.events_radius_cache.insert( {"_id":"892280c86b5e32a7eaa7c325824cd62a","radius":25,"modified":"MongoDate(0.69600000 1766006003)","created":"MongoDate(0.69600000 1766006003)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-78.68479919433594,42.64419937133789],0.36231884057971014]}}}, ["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	93
13	db.events_cache.count( {"_id":"d911e98f57e15e5b77eeba6a06ce5472"} )	0	8
14	db.events_cache.count( {"_id":"d911e98f57e15e5b77eeba6a06ce5472"} )	0	8
15	db.events_cache.insert( {"_id":"d911e98f57e15e5b77eeba6a06ce5472","town_sef_url":"colden-ny","data_key":["693321014389be6be5653145","68a75b5f03a70639b6cf0df8","69036ade4389be6be5f5f217","693321014389be6be56533ee","693321024389be6be565343e","68a75b6003a70639b6cf153a","68a75b6003a70639b6cf13ee","68a75b6003a70639b6cf150d","69036adf4389be6be5f5f7df","693321024389be6be56537cd","69036adf4389be6be5f5f9e8","68a75b6203a70639b6cf1bd3","68a75b6203a70639b6cf1c14","693321024389be6be5653b83","693321034389be6be5653da5"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Colden Featured Events\",\"keyword\":\"\",\"radius\":25,\"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.64419937133789,\"lng\":-78.68479919433594,\"latlng\":\"42.644199371338,-78.684799194336\",\"city\":\"Colden\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.87100000 1766006003)","created":"MongoDate(0.87100000 1766006003)"} , true)	0	2

Colden

New York

Colden Featured Events

Annual Studio Artist Show and Sale

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

Holiday Pops

Annual Studio Artist Show and Sale

Bricks and Brews

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

Buffalo Sabres vs. Philadelphia Flyers

White Christmas

Holiday Pops

Annual Studio Artist Show and Sale

Canisius University Women's Basketball vs Saint Peter's

White Christmas

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

Shai Hulud

Annual Studio Artist Show and Sale

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.

Colden 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.