Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"north-versailles-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.towns.find( {"sef_url":"north-versailles-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","allegheny-county-pa","north-versailles-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"7d4e00c86f8e6c054b34e85a62fbabfa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"9a0da9c2714f6908023d15fc5b594884"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"north-versailles-pa","start":{"$gte":"MongoDate(0.00000000 1765432800)","$lt":"MongoDate(0.00000000 1766037600)"}} )	0	1
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.81179809570312,40.38119888305664],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765432800)","$lt":"MongoDate(0.00000000 1766296800)"}} )	3	40
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.81179809570312,40.38119888305664],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765432800)","$lt":"MongoDate(0.00000000 1766296800)"}} )	79	40
9	db.events_radius_cache.count( {"_id":"9a0da9c2714f6908023d15fc5b594884"} )	0	1
10	db.events_radius_cache.insert( {"_id":"9a0da9c2714f6908023d15fc5b594884","radius":15,"modified":"MongoDate(0.77200000 1765518375)","created":"MongoDate(0.77200000 1765518375)"} , true)	0	5
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765432800)"},"tags":"clubs-and-organizations","geo":{"$geoWithin":{"$center":[[-79.81179809570312,40.38119888305664],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	18
12	db.events_cache.count( {"_id":"7d4e00c86f8e6c054b34e85a62fbabfa"} )	0	1
13	db.events_cache.count( {"_id":"7d4e00c86f8e6c054b34e85a62fbabfa"} )	0	1
14	db.events_cache.insert( {"_id":"7d4e00c86f8e6c054b34e85a62fbabfa","town_sef_url":"north-versailles-pa","data_key":["68a75b5803a70639b6cee64c","68a75b5b03a70639b6cefb1d","68a75b6203a70639b6cf1ec6","68a75b6503a70639b6cf304c","68a75b6903a70639b6cf491e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"North Versailles Featured Events<br>Clubs And Organizations\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"clubs-and-organizations\",\"tags\":\"clubs-and-organizations\",\"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.38119888305664,\"lng\":-79.81179809570312,\"latlng\":\"40.381198883057,-79.811798095703\",\"city\":\"North Versailles\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.82200000 1765518375)","created":"MongoDate(0.82200000 1765518375)"} , true)	0	1

North Versailles

Pennsylvania

North Versailles Featured Events
Clubs And Organizations

Farmers' Market Coop of East Liberty

Squirrel Hill Farmers' Market

Farmers' Market Coop of East Liberty

Squirrel Hill Farmers' Market

Farmers' Market Coop of East Liberty

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.

North Versailles Featured EventsClubs And Organizations

Farmers' Market Coop of East Liberty

Squirrel Hill Farmers' Market

Farmers' Market Coop of East Liberty

Squirrel Hill Farmers' Market

Farmers' Market Coop of East Liberty

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.

North Versailles Featured Events
Clubs And Organizations

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