Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"port-royal-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"port-royal-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","juniata-county-pa","port-royal-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"port-royal-pa"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	7	3
6	db.events_cache.find( {"_id":"b76dd46f7f438022ecb7ab97e17258ae"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"fc90aaab3c77136c0ed8f0f47fab9836"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-77.38839721679688,40.53229904174805],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	303
9	db.events_cache.count( {"_id":"b76dd46f7f438022ecb7ab97e17258ae"} )	0	1
10	db.events_cache.insert( {"_id":"b76dd46f7f438022ecb7ab97e17258ae","town_sef_url":"port-royal-pa","data_key":["68a75b5803a70639b6cee671","68a75b5f03a70639b6cf0c42","68a75b6103a70639b6cf16c9","68a75b6203a70639b6cf1ef2","68a75b6603a70639b6cf381a","68a75b6803a70639b6cf43ab","68a75b6903a70639b6cf4940","68a75b7003a70639b6cf7949","68a75b7903a70639b6cfba3a","69036b034389be6be5f6eada"],"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.53229904174805,\"lng\":-77.38839721679688,\"latlng\":\"40.532299041748,-77.388397216797\",\"city\":\"Port Royal\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.48400000 1765638909)","created":"MongoDate(0.48400000 1765638909)"} , true)	0	1

Port Royal

Pennsylvania

Port Royal Groups and Organizations

Big Tree Music and Art Festival

Brummer's Happy Breeze Farm

Jade Family Farm

Juniata County Fair

Juniata County State Health Center

Port Royal Speedway

Tuscarora Valley Elementary School

Local Events

Carlisle Country Market

Country Line Dancing

Carlisle Country Market

Carlisle Country Market

Open Cornhole

Carlisle Country Market

Carlisle Country Market

Winter Basketball League 2024

Country Line Dancing

Winter Basketball League 2024

COVID-19 Resources