Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hamlin-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"hamlin-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","wayne-county-pa","hamlin-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"df1bb25f8ffbb572ed12098d9cc28a03"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
5	db.events_radius_cache.find( {"_id":"abd11185ca1588859f22beb475e9f929"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"hamlin-pa","start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766815200)"}} )	0	1
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.37870025634766,40.45610046386719],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	32
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.37870025634766,40.45610046386719],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	2	28
9	db.events_radius_cache.count( {"_id":"abd11185ca1588859f22beb475e9f929"} )	0	1
10	db.events_radius_cache.insert( {"_id":"abd11185ca1588859f22beb475e9f929","radius":25,"modified":"MongoDate(0.89000000 1766241503)","created":"MongoDate(0.89000000 1766241503)"} , true)	0	1
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766728800)","$lt":"MongoDate(0.00000000 1766987999)"},"geo":{"$geoWithin":{"$center":[[-76.37870025634766,40.45610046386719],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 )	11	14
12	db.events_cache.count( {"_id":"df1bb25f8ffbb572ed12098d9cc28a03"} )	0	1
13	db.events_cache.count( {"_id":"df1bb25f8ffbb572ed12098d9cc28a03"} )	0	1
14	db.events_cache.insert( {"_id":"df1bb25f8ffbb572ed12098d9cc28a03","town_sef_url":"hamlin-pa","data_key":["68a75b6803a70639b6cf43c3","68a75b6803a70639b6cf43c6","693321054389be6be5654dc8","69036ae64389be6be5f61f84","68a75b6903a70639b6cf49e3","68a75b6903a70639b6cf49ea","68a75b6903a70639b6cf49ee","69036ae74389be6be5f6255a","69036ae84389be6be5f62929","69036ae94389be6be5f62e04","69036ae94389be6be5f62e3e"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"next-weekend\",\"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,\"title\":\"{local_city} Events for 12\\\/26\\\/2025 to 12\\\/28\\\/2025\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2025-12-26\",\"searchenddate\":\"2025-12-28\",\"lat\":40.45610046386719,\"lng\":-76.37870025634766,\"latlng\":\"40.456100463867,-76.378700256348\",\"city\":\"Hamlin\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.93100000 1766241503)","created":"MongoDate(0.93100000 1766241503)"} , true)	0	1

Hamlin

Pennsylvania

Hamlin Events for 12/26/2025 to 12/28/2025

Farmstead Farmers Market

Green Dragon Farmers Market

Refreshing Mountain Christmas Light Adventures

Koziar's Christmas Village

Lebanon Farmers Market

Mount Carmel Farmers Market

Farmstead Farmers Market

Koziar's Christmas Village

Christmas With Absolute Adele

Hershey Bears vs. Charlotte Checkers

Koziar's Christmas Village

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.

Hamlin Events for 12/26/2025 to 12/28/2025

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.