Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"derby-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/capitals-vs-blue-jackets-trapper-hat-giveaway-2025-12-07-tm-washington-dc.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"derby-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","derby-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"f8d7e8f39cb17daad667abfc2a79c10a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"b4aade0f94a5bc8d853610fb1cd9cf4b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
7	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	116
8	db.events_cache.count( {"_id":"f8d7e8f39cb17daad667abfc2a79c10a"} )	0	1
9	db.events_cache.insert( {"_id":"f8d7e8f39cb17daad667abfc2a79c10a","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\":\"capitals-vs-blue-jackets-trapper-hat-giveaway-2025-12-07-tm-washington-dc.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.75600000 1765366331)","created":"MongoDate(0.75600000 1765366331)"} , true)	0	3

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.