Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gettysburg-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"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	1
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","adams-county-pa","gettysburg-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"gettysburg-pa"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
6	db.events_cache.find( {"_id":"96fca2c4d5997b8eebda4f4b7ec99894"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"cd1d67a78f1a0181dd2e16fedb6482c6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"gettysburg-pa","start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1765778400)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766037600)"}} )	0	46
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766037600)"}} )	2	45
11	db.events_radius_cache.count( {"_id":"cd1d67a78f1a0181dd2e16fedb6482c6"} )	0	2
12	db.events_radius_cache.insert( {"_id":"cd1d67a78f1a0181dd2e16fedb6482c6","radius":25,"modified":"MongoDate(0.88700000 1765191535)","created":"MongoDate(0.88700000 1765191535)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765173600)"},"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( 11 ).skip( 0 )	11	341
14	db.events_cache.count( {"_id":"96fca2c4d5997b8eebda4f4b7ec99894"} )	0	1
15	db.events_cache.count( {"_id":"96fca2c4d5997b8eebda4f4b7ec99894"} )	0	1
16	db.events_cache.insert( {"_id":"96fca2c4d5997b8eebda4f4b7ec99894","town_sef_url":"gettysburg-pa","data_key":["68a75b5703a70639b6cedfe2","69036ad64389be6be5f5c46d","69036ad84389be6be5f5cec5","68a75b5803a70639b6cee656","69036ad84389be6be5f5cff6","68a75b5a03a70639b6cef0d2","693320ff4389be6be56527b6","68a75b5d03a70639b6cf06ff","693321024389be6be56537d5","68a75b6203a70639b6cf1ed4"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"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.25300000 1765191536)","created":"MongoDate(0.25300000 1765191536)"} , true)	0	2
17	db.modules.find( {"name":"AT - Covid Resource Links"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Gettysburg

Pennsylvania

Gettysburg Groups and Organizations

4civilrights

A Gettysburgs Christmas Festival

A Rotary Oktoberfest

Adams County Arts Council

Adams County Farmers Market

Adams County Historical Society

Adams County Irish Festival

Adams County Library System - Gettysburg Library

Adams County Longbeards - National Wild Turkey Federation

Adams County Office For Aging

Adams County State Health Center

Adams County Winery - Gettysburg

America's National Community Theatre Festival

American Civil War Museum

American Legion Post 202 Gettysburg

American Red Cross Of Adams County

Annual July 4th Concert and Fireworks

Appalachian Brewing Company Gettysburg

Battlefield Brew Works

Bethel Mennonite Church

Local 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

COVID-19 Resources