Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"verona-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"verona-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","allegheny-county-pa","verona-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"281f7daf20c649509870a04dc8ca5e61"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"20318b4d4b3ffe5325ea986165e05b00"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"verona-pa","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.84310150146484,40.50490188598633],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	0	32
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.84310150146484,40.50490188598633],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	11	30
9	db.events_radius_cache.count( {"_id":"20318b4d4b3ffe5325ea986165e05b00"} )	0	1
10	db.events_radius_cache.insert( {"_id":"20318b4d4b3ffe5325ea986165e05b00","radius":25,"modified":"MongoDate(0.15400000 1766408161)","created":"MongoDate(0.15400000 1766408161)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-79.84310150146484,40.50490188598633],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 )	16	89
12	db.events_cache.count( {"_id":"281f7daf20c649509870a04dc8ca5e61"} )	0	1
13	db.events_cache.count( {"_id":"281f7daf20c649509870a04dc8ca5e61"} )	0	1
14	db.events_cache.insert( {"_id":"281f7daf20c649509870a04dc8ca5e61","town_sef_url":"verona-pa","data_key":["693321044389be6be565486d","68a75b6803a70639b6cf416b","68a75b6903a70639b6cf4657","693321054389be6be5654f24","68a75b6903a70639b6cf488c","68a75b6903a70639b6cf491e","68a75b6b03a70639b6cf52ad","69036ae84389be6be5f62852","69036ae84389be6be5f629b6","68a75b6b03a70639b6cf55f9","68a75b6c03a70639b6cf5bad","68a75b6c03a70639b6cf5cb5","69036aea4389be6be5f63474","68a75b6e03a70639b6cf6897","69036aec4389be6be5f63e51"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Verona Featured Events\",\"keyword\":\"\",\"radius\":25,\"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\":40.50490188598633,\"lng\":-79.84310150146484,\"latlng\":\"40.504901885986,-79.843101501465\",\"city\":\"Verona\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.28500000 1766408161)","created":"MongoDate(0.28500000 1766408161)"} , true)	0	2

Verona

Pennsylvania

Verona Featured Events

Edgar Snyder & Associates Holiday Hoops Classic!

Karaoke with Big Al

Craig Shoemaker

Bill Deasy's Annual Boxing Day Show

Craig Shoemaker

Farmers' Market Coop of East Liberty

Craig Shoemaker

WWE Live Holiday Tour

The Commonheart

Craig Shoemaker

Craig Shoemaker

Karaoke with Big Al

Pittsburgh Penguins vs. Carolina Hurricanes

Karaoke with Big Al

Pittsburgh Penguins vs. Detroit Red Wings

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.

Verona 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.