Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sugar-grove-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
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":"sugar-grove-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","il","kane-county-il","sugar-grove-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.places.find( {"address.town_sef_url":"sugar-grove-il"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	20	3
6	db.events_cache.find( {"_id":"2c08c9894eb02c3c10e4fb17fef530b7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"2106abe98477a8a09039e27050896451"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767160800)"},"geo":{"$geoWithin":{"$center":[[-88.48509979248047,41.76369857788086],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	236
9	db.events_cache.count( {"_id":"2c08c9894eb02c3c10e4fb17fef530b7"} )	0	1
10	db.events_cache.insert( {"_id":"2c08c9894eb02c3c10e4fb17fef530b7","town_sef_url":"sugar-grove-il","data_key":["68a75b6e03a70639b6cf66d4","68a75b6e03a70639b6cf6809","68a75b6e03a70639b6cf6a99","68a75b6e03a70639b6cf6cf4","68a75b6f03a70639b6cf6fbd","68a75b6f03a70639b6cf708a","68a75b6f03a70639b6cf7288","68a75b6f03a70639b6cf736e","68a75b7003a70639b6cf74ad","68a75b7203a70639b6cf85d2"],"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\":41.76369857788086,\"lng\":-88.48509979248047,\"latlng\":\"41.763698577881,-88.48509979248\",\"city\":\"Sugar Grove\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.06300000 1767191793)","created":"MongoDate(0.06300000 1767191793)"} , true)	0	2

Sugar Grove

Illinois

Sugar Grove Groups and Organizations

Aurora Skyhaven Flying Club

Bliss Creek Golf Course

Girl Scouts of Northern Illinois

John Shields Elementary School

Spring Bluff Nursery

Sugar Grove Chamber of Commerce & Industry

Sugar Grove Corn Boil

Sugar Grove Corn Boil Festival

Sugar Grove Family Fun Center

Sugar Grove French Market

Sugar Grove Government

Sugar Grove Historical Society

Sugar Grove Park District

Sugar Grove Public Library

Sugar Grove Pumpkin Farm

Sugar Grove United Methodist Church

Valley Education For Employment System

Village Bible Church

Waubonsee Community College

Waubonsee Community College

Local Events

Million Dollar Quartet

Million Dollar Quartet

Million Dollar Quartet

Million Dollar Quartet

Million Dollar Quartet

Million Dollar Quartet

Million Dollar Quartet

Million Dollar Quartet

Open Mic Night

Open Mic Night

COVID-19 Resources