Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gettysburg-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
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":"gettysburg-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","adams-county-pa","gettysburg-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"f4ec89c421054ec2ffa5fa710f8d8d4b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"cd1d67a78f1a0181dd2e16fedb6482c6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events.count( {"address.town_sef_url":"gettysburg-pa","start":{"$gte":"MongoDate(0.00000000 1765260000)","$lt":"MongoDate(0.00000000 1765864800)"}} )	0	8
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765260000)","$lt":"MongoDate(0.00000000 1766124000)"}} )	0	70
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765260000)","$lt":"MongoDate(0.00000000 1766124000)"}} )	2	65
10	db.events_radius_cache.count( {"_id":"cd1d67a78f1a0181dd2e16fedb6482c6"} )	0	1
11	db.events_radius_cache.insert( {"_id":"cd1d67a78f1a0181dd2e16fedb6482c6","radius":25,"modified":"MongoDate(0.59100000 1765324080)","created":"MongoDate(0.59100000 1765324080)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765260000)"},"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 )	16	347
13	db.events_cache.count( {"_id":"f4ec89c421054ec2ffa5fa710f8d8d4b"} )	0	1
14	db.events_cache.count( {"_id":"f4ec89c421054ec2ffa5fa710f8d8d4b"} )	0	1
15	db.events_cache.insert( {"_id":"f4ec89c421054ec2ffa5fa710f8d8d4b","town_sef_url":"gettysburg-pa","data_key":["68a75b5703a70639b6cedfe2","69036ad64389be6be5f5c46d","69036ad84389be6be5f5cec5","68a75b5803a70639b6cee656","69036ad84389be6be5f5cff6","68a75b5a03a70639b6cef0d2","693320ff4389be6be56527b6","68a75b5d03a70639b6cf06ff","693321024389be6be56537d5","68a75b6203a70639b6cf1ed4","68a75b6903a70639b6cf492d","68a75b7403a70639b6cf95bb","69036b014389be6be5f6e16e","69036b194389be6be5f77a24","69036b2f4389be6be5f80667"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Gettysburg 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\":39.83089828491211,\"lng\":-77.2332992553711,\"latlng\":\"39.830898284912,-77.233299255371\",\"city\":\"Gettysburg\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.96700000 1765324080)","created":"MongoDate(0.96700000 1765324080)"} , true)	0	2

Gettysburg

Pennsylvania

Gettysburg Featured Events

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!

NAMI Family Support Group

National Ugly Sweater Day at Adams County Winery!

Hanover Farmers' Market

Hanover Farmers' Market

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

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