Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"waterloo-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"waterloo-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ia","black-hawk-county-ia","waterloo-ia"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"0d90f3983fc5f157c52b966557d6854d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767592800)"},"geo":{"$geoWithin":{"$center":[[-92.34559631347656,42.4906005859375],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 )	15	5
7	db.events_cache.count( {"_id":"0d90f3983fc5f157c52b966557d6854d"} )	0	1
8	db.events_cache.insert( {"_id":"0d90f3983fc5f157c52b966557d6854d","town_sef_url":"waterloo-ia","data_key":["68a75b7003a70639b6cf7b7b","68a75b7103a70639b6cf7fa8","68a75b7503a70639b6cf9b28","68a75b7503a70639b6cf9fe6","68a75b7703a70639b6cfad3e","68a75b7703a70639b6cfb1d2","68a75b7a03a70639b6cfccde","68a75b7b03a70639b6cfd0d9","69036b044389be6be5f6f188","69036b064389be6be5f6fdfa","69036b0d4389be6be5f7265d","69036b164389be6be5f7652a","69036b194389be6be5f77a20","69036b1f4389be6be5f7a546","69036b204389be6be5f7ad5c"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Waterloo 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\":42.4906005859375,\"lng\":-92.34559631347656,\"latlng\":\"42.490600585938,-92.345596313477\",\"city\":\"Waterloo\",\"state\":\"IA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.45200000 1767623267)","created":"MongoDate(0.45200000 1767623267)"} , true)	0	2

Waterloo

Iowa

Waterloo Featured Events

Waterloo Black Hawks vs. Madison Capitols

Waterloo Black Hawks vs. Omaha Lancers

Waterloo Black Hawks vs. Tri-City Storm

Waterloo Black Hawks vs. Tri-City Storm

Waterloo Black Hawks vs. Sioux Falls Stampede

Waterloo Black Hawks vs. Sioux Falls Stampede

Waterloo Black Hawks vs. Chicago Steel

Waterloo Black Hawks vs. Cedar Rapids Roughriders

Waterloo Black Hawks vs. Youngstown Phantoms

Waterloo Black Hawks vs. Youngstown Phantoms

Waterloo Black Hawks vs. Dubuque Fighting Saints

Waterloo Black Hawks vs. Des Moines Buccaneers

Waterloo Black Hawks vs. Dubuque Fighting Saints

Waterloo Black Hawks vs. Omaha Lancers

Waterloo Black Hawks vs. Cedar Rapids Roughriders

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.

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