Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sherrill-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"sherrill-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
4	db.tokens.find( {"sef_url":{"$in":["usa","ia","dubuque-county-ia","sherrill-ia"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	3
5	db.places.find( {"address.town_sef_url":"sherrill-ia"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	5	2
6	db.events_cache.find( {"_id":"f5d74e27c37005944a786994dab98c92"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"1de41ef7a5a378f7616a8e109c19c858"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766037600)"},"geo":{"$geoWithin":{"$center":[[-90.78489685058594,42.60390090942383],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	318
9	db.events_cache.count( {"_id":"f5d74e27c37005944a786994dab98c92"} )	0	9
10	db.events_cache.insert( {"_id":"f5d74e27c37005944a786994dab98c92","town_sef_url":"sherrill-ia","data_key":["68a75b4503a70639b6ce7195","68a75b6b03a70639b6cf540d","68a75b6e03a70639b6cf67b5","68a75b6e03a70639b6cf6951","68a75b6e03a70639b6cf6d72","68a75b7003a70639b6cf7c77","68a75b7103a70639b6cf805f","68a75b7503a70639b6cf9c2c","68a75b7503a70639b6cfa0ad","68a75b7703a70639b6cfae28"],"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\":42.60390090942383,\"lng\":-90.78489685058594,\"latlng\":\"42.603900909424,-90.784896850586\",\"city\":\"Sherrill\",\"state\":\"IA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.46400000 1766089590)","created":"MongoDate(0.46400000 1766089590)"} , true)	0	2

Sherrill

Iowa

Sherrill Groups and Organizations

Dubuque Renaissance Faire

DubuqueLand Chapter - Pheasants Forever

Fall Harvest Days and Pumpkin Festival

Finley's Landing Park

Sherrill United Methodist Church

Local Events

The Pork Tornadoes

Dubuque Fighting Saints vs. Green Bay Gamblers

Dubuque Fighting Saints vs. Cedar Rapids Roughriders

SHADY

Dubuque Fighting Saints vs. Chicago Steel

Dubuque Fighting Saints vs. Team Usa U17 Hockey

Dubuque Fighting Saints vs. Team Usa U17 Hockey

Dubuque Fighting Saints vs. Sioux Falls Stampede

Dubuque Fighting Saints vs. Sioux Falls Stampede

Dubuque Fighting Saints vs. Cedar Rapids Roughriders

COVID-19 Resources