Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gettysburg-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events-this-weekend"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
3	db.towns.find( {"sef_url":"gettysburg-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","adams-county-pa","gettysburg-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	12
5	db.events_cache.find( {"_id":"d7f51854bda1869c5bf2b27e4a244cc8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	4
6	db.events_radius_cache.find( {"_id":"cd1d67a78f1a0181dd2e16fedb6482c6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1765778399)"},"geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],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 )	7	28
8	db.events_cache.count( {"_id":"d7f51854bda1869c5bf2b27e4a244cc8"} )	0	2
9	db.events_cache.insert( {"_id":"d7f51854bda1869c5bf2b27e4a244cc8","town_sef_url":"gettysburg-pa","data_key":["68a75b5703a70639b6cedfe2","69036ad64389be6be5f5c46d","69036ad84389be6be5f5cec5","68a75b5803a70639b6cee656","69036ad84389be6be5f5cff6","68a75b5a03a70639b6cef0d2","693320ff4389be6be56527b6"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"this-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\\\/12\\\/2025 to 12\\\/14\\\/2025\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2025-12-12\",\"searchenddate\":\"2025-12-14\",\"lat\":39.83089828491211,\"lng\":-77.2332992553711,\"latlng\":\"39.830898284912,-77.233299255371\",\"city\":\"Gettysburg\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.71800000 1765259161)","created":"MongoDate(0.71800000 1765259161)"} , true)	0	3

Gettysburg

Pennsylvania

Gettysburg Events for 12/12/2025 to 12/14/2025

Christkindlmarkt at Dills Tavern

Christmas Festival

Adams County Winery's Annual Wine and Cookie Pairing

Hanover Farmers' Market

Holiday Craft Bazaar

Christkindlmarkt at Dills Tavern

Holiday Open House Tour at Adams County Winery!

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.

Gettysburg Events for 12/12/2025 to 12/14/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.