Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"schaefferstown-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
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":"schaefferstown-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","lebanon-county-pa","schaefferstown-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.places.find( {"address.town_sef_url":"schaefferstown-pa"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	9	2
6	db.events_cache.find( {"_id":"f05196aefc84b262d466a11e806ca073"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"a8cf8688c67b2954695b01c3a514f2b3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-76.29350280761719,40.29800033569336],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	132
9	db.events_cache.count( {"_id":"f05196aefc84b262d466a11e806ca073"} )	0	3
10	db.events_cache.insert( {"_id":"f05196aefc84b262d466a11e806ca073","town_sef_url":"schaefferstown-pa","data_key":["68a75b6703a70639b6cf39f0","69036ae54389be6be5f618a2","693321054389be6be5654a26","69036ae54389be6be5f619ea","693321054389be6be5654b9d","68a75b6803a70639b6cf4209","693321054389be6be5654c91","68a75b6803a70639b6cf43a3","68a75b6803a70639b6cf43c3","68a75b6803a70639b6cf43c6"],"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\":40.29800033569336,\"lng\":-76.29350280761719,\"latlng\":\"40.298000335693,-76.293502807617\",\"city\":\"Schaefferstown\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.09700000 1766527756)","created":"MongoDate(0.09700000 1766527756)"} , true)	0	4

Schaefferstown

Pennsylvania

Schaefferstown Groups and Organizations

Distelfink Country Christmas Craft Show

Fall Harvest Fair And Early American Craft Show

Heidelberg Lion's Club

Historic Schaefferstown

Izaak Walton League of America Lancaster Red Rose Chapter

Saint Paul's United Church of Christ

Schaefferstown Fire Company Carnival

Schaefferstown Mennonite High School

Town Of Heidelberg

Local Events

Lancaster Central Market

Elf - The Musical

Refreshing Mountain Christmas Light Adventures

Elf - The Musical

Refreshing Mountain Christmas Light Adventures

Boscov's Fairgrounds Farmers Market

Refreshing Mountain Christmas Light Adventures

Lancaster Central Market

Farmstead Farmers Market

Green Dragon Farmers Market

COVID-19 Resources