Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"swarthmore-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"swarthmore-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","delaware-county-pa","swarthmore-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"b1d9db381ea00f8c2f988636249b6d9c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"34c281456c8b76e16b259a5e8ac1cbfd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"swarthmore-pa","start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768111200)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.35060119628906,39.902000427246094],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768370400)"}} )	7	14
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.35060119628906,39.902000427246094],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768370400)"}} )	40	16
9	db.events_radius_cache.count( {"_id":"34c281456c8b76e16b259a5e8ac1cbfd"} )	0	1
10	db.events_radius_cache.insert( {"_id":"34c281456c8b76e16b259a5e8ac1cbfd","radius":15,"modified":"MongoDate(0.92500000 1767522220)","created":"MongoDate(0.92500000 1767522220)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767506400)"},"tags":"shops-and-stores","geo":{"$geoWithin":{"$center":[[-75.35060119628906,39.902000427246094],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 )	5	8
12	db.events_cache.count( {"_id":"b1d9db381ea00f8c2f988636249b6d9c"} )	0	1
13	db.events_cache.count( {"_id":"b1d9db381ea00f8c2f988636249b6d9c"} )	0	1
14	db.events_cache.insert( {"_id":"b1d9db381ea00f8c2f988636249b6d9c","town_sef_url":"swarthmore-pa","data_key":["68a75b7103a70639b6cf7eb0","68a75b7b03a70639b6cfcfed","69036b174389be6be5f76bdc","69036b284389be6be5f7e01a","693321324389be6be566a455"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Swarthmore Featured Events<br>Shops And Stores\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"shops-and-stores\",\"tags\":\"shops-and-stores\",\"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.902000427246094,\"lng\":-75.35060119628906,\"latlng\":\"39.902000427246,-75.350601196289\",\"city\":\"Swarthmore\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.95600000 1767522220)","created":"MongoDate(0.95600000 1767522220)"} , true)	0	2

Swarthmore

Pennsylvania

Swarthmore Featured Events
Shops And Stores

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

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.

Swarthmore Featured EventsShops And Stores

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

Every second Saturday! Crafting hour with Pepper Lee Boutique!

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.

Swarthmore Featured Events
Shops And Stores

20 million people
rely on AmericanTowns each year to find & share local information.