Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"port-royal-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/the-nutcracker-2025-12-12-waterville-me.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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.events_cache.find( {"_id":"456842ab1d21065693fcfa5b8e9ce5c0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"fc90aaab3c77136c0ed8f0f47fab9836"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"port-royal-pa","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.38839721679688,40.53229904174805],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	49
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.38839721679688,40.53229904174805],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	48
10	db.events_radius_cache.count( {"_id":"fc90aaab3c77136c0ed8f0f47fab9836"} )	0	1
11	db.events_radius_cache.insert( {"_id":"fc90aaab3c77136c0ed8f0f47fab9836","radius":25,"modified":"MongoDate(0.39700000 1765792596)","created":"MongoDate(0.39700000 1765792596)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"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( 16 ).skip( 0 )	13	279
13	db.events_cache.count( {"_id":"456842ab1d21065693fcfa5b8e9ce5c0"} )	0	1
14	db.events_cache.count( {"_id":"456842ab1d21065693fcfa5b8e9ce5c0"} )	0	1
15	db.events_cache.insert( {"_id":"456842ab1d21065693fcfa5b8e9ce5c0","town_sef_url":"port-royal-pa","data_key":["68a75b5f03a70639b6cf0c42","68a75b6103a70639b6cf16c9","68a75b6203a70639b6cf1ef2","68a75b6603a70639b6cf381a","68a75b6803a70639b6cf43ab","68a75b6903a70639b6cf4940","68a75b7003a70639b6cf7949","68a75b7903a70639b6cfba3a","69036b034389be6be5f6eada","69036b1e4389be6be5f79d3c","69036b234389be6be5f7bf52","693321344389be6be566b18f","693321354389be6be566b481"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Port Royal Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"the-nutcracker-2025-12-12-waterville-me.html\",\"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\":40.53229904174805,\"lng\":-77.38839721679688,\"latlng\":\"40.532299041748,-77.388397216797\",\"city\":\"Port Royal\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.69700000 1765792596)","created":"MongoDate(0.69700000 1765792596)"} , true)	0	1

Port Royal

Pennsylvania

Port Royal Featured Events

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

Country Line Dancing

Winter Basketball League 2024

Country Line Dancing

Winter Basketball League 2024

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.

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