Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"goodview-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	30
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"goodview-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
4	db.tokens.find( {"sef_url":{"$in":["usa","va","bedford-county-va","goodview-va"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"goodview-va"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	3	3
6	db.events_cache.find( {"_id":"9cb6bef14333d5be58deb7a533d044ea"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	54
7	db.events_radius_cache.find( {"_id":"72b190fbd33f55c0af0fa76d825584b8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-79.72550201416016,37.21440124511719],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	202
9	db.events_cache.count( {"_id":"9cb6bef14333d5be58deb7a533d044ea"} )	0	4
10	db.events_cache.insert( {"_id":"9cb6bef14333d5be58deb7a533d044ea","town_sef_url":"goodview-va","data_key":["68a75b6703a70639b6cf3c6e","693321064389be6be565526f","68a75b6b03a70639b6cf5580","68a75b6d03a70639b6cf6231","693321084389be6be5655da1","69036aeb4389be6be5f63a55","69036aeb4389be6be5f63c6f","69036aec4389be6be5f64077","69036aed4389be6be5f6456a","6933210a4389be6be5656ded"],"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\":37.21440124511719,\"lng\":-79.72550201416016,\"latlng\":\"37.214401245117,-79.72550201416\",\"city\":\"Goodview\",\"state\":\"VA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.00500000 1766531142)","created":"MongoDate(0.00500000 1766531142)"} , true)	0	2

Goodview

Virginia

Goodview Groups and Organizations

Goodview Elementary School

Sandy Level Baptist Church

Triple M Farms

Local Events

West End Farmers Market

Roanoke Rail Yard Dawgs vs. Knoxville Ice Bears

Sicard Hollow and Jacoozy

West End Farmers Market

Roanoke Rail Yard Dawgs vs. Fayetteville Marksmen

Same As It Ever Was – The Ultimate Talking Heads Tribute

Grace Potter and Holy Roller

Partzilla Arenacross Series

Partzilla Arenacross Series

Roanoke Rail Yard Dawgs vs. Birmingham Bulls

COVID-19 Resources