Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"derby-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/sacramento-kings-vs-boston-celtics-2026-01-01-tm-sacramento-ca.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"derby-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","derby-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"1f4af33ddfc8058e63fa7906fce41860"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
6	db.events_radius_cache.find( {"_id":"b4aade0f94a5bc8d853610fb1cd9cf4b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"derby-ny","start":{"$gte":"MongoDate(0.00000000 1765346400)","$lt":"MongoDate(0.00000000 1765951200)"}} )	0	12
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.97579956054688,42.679100036621094],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765346400)","$lt":"MongoDate(0.00000000 1766210400)"}} )	0	49
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.97579956054688,42.679100036621094],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765346400)","$lt":"MongoDate(0.00000000 1766210400)"}} )	3	49
10	db.events_radius_cache.count( {"_id":"b4aade0f94a5bc8d853610fb1cd9cf4b"} )	0	1
11	db.events_radius_cache.insert( {"_id":"b4aade0f94a5bc8d853610fb1cd9cf4b","radius":25,"modified":"MongoDate(0.17500000 1765348821)","created":"MongoDate(0.17500000 1765348821)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765346400)"},"geo":{"$geoWithin":{"$center":[[-78.97579956054688,42.679100036621094],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	115
13	db.events_cache.count( {"_id":"1f4af33ddfc8058e63fa7906fce41860"} )	0	1
14	db.events_cache.count( {"_id":"1f4af33ddfc8058e63fa7906fce41860"} )	0	1
15	db.events_cache.insert( {"_id":"1f4af33ddfc8058e63fa7906fce41860","town_sef_url":"derby-ny","data_key":["693320fb4389be6be5650e64","68a75b5503a70639b6ced35b","693320fb4389be6be5651209","693320fb4389be6be5651279","68a75b5603a70639b6cedb12","693320fc4389be6be565169f","693320fc4389be6be5651743","693320fc4389be6be5651759","69036ad64389be6be5f5c549","69036ad64389be6be5f5c682","68a75b5703a70639b6cee2d0","69036ad74389be6be5f5cd9c","69036ad84389be6be5f5cedd","693320fd4389be6be5651da9","693320fe4389be6be5651ecf"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Derby Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"sacramento-kings-vs-boston-celtics-2026-01-01-tm-sacramento-ca.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\":42.679100036621094,\"lng\":-78.97579956054688,\"latlng\":\"42.679100036621,-78.975799560547\",\"city\":\"Derby\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.32300000 1765348821)","created":"MongoDate(0.32300000 1765348821)"} , true)	0	2

Derby

New York

Derby Featured Events

Annual Studio Artist Show and Sale

A Charlie Brown Christmas Tour Live On Stage

Annual Studio Artist Show and Sale

Bricks and Brews

White Christmas

JoAnn's Classical Christmas

Annual Studio Artist Show and Sale

Jingle Bell Jam

Canisius University Women's Basketball vs Wright State

IZAAK

White Christmas

Blissmas Eve with Atomic Rule

UB Wrestling/Kent/Gardner Webb

JoAnn's Classical Christmas

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.

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