Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"grafton-wi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.towns.find( {"sef_url":"grafton-wi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
3	db.tokens.find( {"sef_url":{"$in":["usa","wi","ozaukee-county-wi","grafton-wi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"bebc8625dcf94d9f9834bda19dade106"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	9
5	db.events_radius_cache.find( {"_id":"838df49777a9e7fa1d87050fec31f99b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	11
6	db.events.count( {"address.town_sef_url":"grafton-wi","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	12
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.95179748535156,43.31990051269531],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	1	36
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.95179748535156,43.31990051269531],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	1	37
9	db.events_radius_cache.count( {"_id":"838df49777a9e7fa1d87050fec31f99b"} )	0	10
10	db.events_radius_cache.insert( {"_id":"838df49777a9e7fa1d87050fec31f99b","radius":25,"modified":"MongoDate(0.86900000 1766373006)","created":"MongoDate(0.86900000 1766373006)"} , true)	0	9
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-87.95179748535156,43.31990051269531],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	107
12	db.events_cache.count( {"_id":"bebc8625dcf94d9f9834bda19dade106"} )	0	2
13	db.events_cache.count( {"_id":"bebc8625dcf94d9f9834bda19dade106"} )	0	2
14	db.events_cache.insert( {"_id":"bebc8625dcf94d9f9834bda19dade106","town_sef_url":"grafton-wi","data_key":["68a75b6503a70639b6cf3224","69036ae34389be6be5f6113d","693321044389be6be5654575","69036ae34389be6be5f61267","68a75b6603a70639b6cf33f1","693321044389be6be5654605","68a75b6603a70639b6cf34fc","69036ae44389be6be5f61712","68a75b6703a70639b6cf3944","68a75b6703a70639b6cf3e4d","68a75b6803a70639b6cf404f","68a75b6803a70639b6cf452b","68a75b6903a70639b6cf4750","68a75b3b03a70639b6ce31b2","693321064389be6be5654fa4"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Grafton 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\":43.31990051269531,\"lng\":-87.95179748535156,\"latlng\":\"43.319900512695,-87.951797485352\",\"city\":\"Grafton\",\"state\":\"WI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.04900000 1766373007)","created":"MongoDate(0.04900000 1766373007)"} , true)	0	2

Grafton

Wisconsin

Grafton Featured Events

Milwaukee Ballet's The Nutcracker

Kansas Ballet Presents The Nutcracker Featuring The Topeka Symphony

“Let There Be Light!” 44th Annual Christmas Concert

Hometown Holiday Pops

Mannheim Steamroller Christmas

Water Street Dance Milwaukee presents "Solstice X"

Milwaukee Ballet's The Nutcracker

The Sleighriders XLIII

Milwaukee Ballet's The Nutcracker

Milwaukee Ballet's The Nutcracker

Milwaukee Ballet's The Nutcracker

Milwaukee Ballet's The Nutcracker

Milwaukee Ballet's The Nutcracker

Miles Nielsen & The Rusted Hearts

Mowiah and R3ALGRL

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.

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