Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"red-hill-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":"red-hill-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	14
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","montgomery-county-pa","red-hill-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	4
5	db.places.find( {"address.town_sef_url":"red-hill-pa"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	7	2
6	db.events_cache.find( {"_id":"2a739aa645c15e709adf1eb8c8a259fe"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"8da3bb5175fcbb0e6dfc7e4de56e4eb0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	4
8	db.events.count( {"address.town_sef_url":"red-hill-pa","start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	6
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.48320007324219,40.37739944458008],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	0	37
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.48320007324219,40.37739944458008],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	11	32
11	db.events_radius_cache.count( {"_id":"8da3bb5175fcbb0e6dfc7e4de56e4eb0"} )	0	2
12	db.events_radius_cache.insert( {"_id":"8da3bb5175fcbb0e6dfc7e4de56e4eb0","radius":25,"modified":"MongoDate(0.69700000 1766861701)","created":"MongoDate(0.69700000 1766861701)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"geo":{"$geoWithin":{"$center":[[-75.48320007324219,40.37739944458008],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	136
14	db.events_cache.count( {"_id":"2a739aa645c15e709adf1eb8c8a259fe"} )	0	1
15	db.events_cache.count( {"_id":"2a739aa645c15e709adf1eb8c8a259fe"} )	0	7
16	db.events_cache.insert( {"_id":"2a739aa645c15e709adf1eb8c8a259fe","town_sef_url":"red-hill-pa","data_key":["68a75b6903a70639b6cf48ee","68a75b6903a70639b6cf49dc","68a75b6903a70639b6cf49df","68a75b6903a70639b6cf4c1f","68a75b6a03a70639b6cf4e46","68a75b6a03a70639b6cf4e55","693321064389be6be56550e6","693321064389be6be56550ff","69036ae74389be6be5f62556","69036ae84389be6be5f627d3"],"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.37739944458008,\"lng\":-75.48320007324219,\"latlng\":\"40.37739944458,-75.483200073242\",\"city\":\"Red Hill\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.89800000 1766861701)","created":"MongoDate(0.89800000 1766861701)"} , true)	0	3

Red Hill

Pennsylvania

Red Hill Groups and Organizations

Borough of Red Hill

Friends Of The Upper Perkiomen Valley Library

Hope Valley Community Church

Red Hill Christian School

Upper Perkiomen High School

Upper Perkiomen Sportsmen Association

Upper Perkiomen Valley Library

Local Events

Pippin

Allentown Fairgrounds Farmers Market

Renninger's Antique and Farmer's Market

Quakertown Farmers Market and Flea Market

Malvern Farmers Market

Phoenixville Farmers' Market

LEHIGH VALLEY STAND DOWN (BETHLEHEM, PA) - VALOR Clinic Foundation

LEHIGH VALLEY STAND DOWN (Allentown, PA) - VALOR Clinic Foundation

Winter Light Spectacular

Lehigh Valley Phantoms vs. Charlotte Checkers

COVID-19 Resources