Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"newtown-square-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.towns.find( {"sef_url":"newtown-square-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","delaware-county-pa","newtown-square-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"de5bd991552fb489ef0287aaf0ee585f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"9741645702744143cc8bdd5b90d50b00"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"newtown-square-pa","start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768456800)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.40070343017578,39.986900329589844],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768716000)"}} )	8	23
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.40070343017578,39.986900329589844],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768716000)"}} )	29	23
9	db.events_radius_cache.count( {"_id":"9741645702744143cc8bdd5b90d50b00"} )	0	1
10	db.events_radius_cache.insert( {"_id":"9741645702744143cc8bdd5b90d50b00","radius":15,"modified":"MongoDate(0.68200000 1767853971)","created":"MongoDate(0.68200000 1767853971)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767852000)"},"geo":{"$geoWithin":{"$center":[[-75.40070343017578,39.986900329589844],0.21739130434782608]}}}, ["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 )	16	23
12	db.events_cache.count( {"_id":"de5bd991552fb489ef0287aaf0ee585f"} )	0	1
13	db.events_cache.count( {"_id":"de5bd991552fb489ef0287aaf0ee585f"} )	0	1
14	db.events_cache.insert( {"_id":"de5bd991552fb489ef0287aaf0ee585f","town_sef_url":"newtown-square-pa","data_key":["68a75b7003a70639b6cf7893","6933210a4389be6be5656d29","69036aef4389be6be5f64fff","69036aef4389be6be5f65011","68a75b7003a70639b6cf7ad1","69036aef4389be6be5f653b6","6933210a4389be6be5657130","68a75b7103a70639b6cf7eb0","69036aef4389be6be5f65635","69036af04389be6be5f6594b","69036af04389be6be5f659c4","6933210b4389be6be56578f7","68a75b7203a70639b6cf8522","68a75b7203a70639b6cf8637","68a75b7203a70639b6cf87ea"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Newtown Square Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"\",\"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\":39.986900329589844,\"lng\":-75.40070343017578,\"latlng\":\"39.98690032959,-75.400703430176\",\"city\":\"Newtown Square\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.81700000 1767853971)","created":"MongoDate(0.81700000 1767853971)"} , true)	0	2

Newtown Square

Pennsylvania

Newtown Square Featured Events

Linvilla Orchard's Garden Center

Villanova Wildcats Womens Basketball vs. Xavier Musketeers Womens Basketball

Countdown to Ecstasy and Minute by Minute: Tribute to Michael McDonald & The Doobie Brothers

Space Antelope

Linvilla Orchard's Garden Center

Unforgettable Fire- Tribute to U2 and Athensville

Creem Circus and The Circus Hearts

Every second Saturday! Crafting hour with Pepper Lee Boutique!

St. Joseph's Hawks Womens Basketball vs. LaSalle Explorers Womens Basketball

Tell Me Lies – The Fleetwood Mac Experience

Kid Davis and the Bullets and Cordelia Blue

Luciano, The Tabernacle Reggae Band and more

Linvilla Orchard's Garden Center

Linvilla Orchard's Garden Center

Linvilla Orchard's Garden Center

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.

Newtown Square 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.