Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"warrenville-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"warrenville-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","il","dupage-county-il","warrenville-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"ec5bee97d49610de470280a5ca1499b5"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"3576039c169cf3f96c6ae3a87f9d8f89"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"warrenville-il","start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768370400)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.18479919433594,41.823299407958984],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768629600)"}} )	0	21
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.18479919433594,41.823299407958984],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768629600)"}} )	4	19
10	db.events_radius_cache.count( {"_id":"3576039c169cf3f96c6ae3a87f9d8f89"} )	0	1
11	db.events_radius_cache.insert( {"_id":"3576039c169cf3f96c6ae3a87f9d8f89","radius":25,"modified":"MongoDate(0.12900000 1767847826)","created":"MongoDate(0.12900000 1767847826)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767765600)"},"geo":{"$geoWithin":{"$center":[[-88.18479919433594,41.823299407958984],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	6
13	db.events_cache.count( {"_id":"ec5bee97d49610de470280a5ca1499b5"} )	0	1
14	db.events_cache.count( {"_id":"ec5bee97d49610de470280a5ca1499b5"} )	0	1
15	db.events_cache.insert( {"_id":"ec5bee97d49610de470280a5ca1499b5","town_sef_url":"warrenville-il","data_key":["68a75b7003a70639b6cf76f8","68a75b7003a70639b6cf791a","68a75b7003a70639b6cf79e8","69036aee4389be6be5f64f1d","68a75b7003a70639b6cf7bff","6933210a4389be6be5657046","6933210b4389be6be565717e","6933210b4389be6be565726d","68a75b7103a70639b6cf7f56","69036af04389be6be5f65751","69036af04389be6be5f657bb","6933210b4389be6be565750d","68a75b7103a70639b6cf8198","6933210b4389be6be565766f","6933210b4389be6be565774f"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Warrenville 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\":41.823299407958984,\"lng\":-88.18479919433594,\"latlng\":\"41.823299407959,-88.184799194336\",\"city\":\"Warrenville\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.18300000 1767847826)","created":"MongoDate(0.18300000 1767847826)"} , true)	0	1

Warrenville

Illinois

Warrenville Featured Events

Sister Act at Drury Lane

Sister Act at Drury Lane

Sister Act at Drury Lane

Windy City Bulls vs. Delaware Blue Coats

Sister Act at Drury Lane

Jamie Kennedy

John Roy

Jamie Kennedy

Sister Act at Drury Lane

Chicago Wolves v. Texas Stars

Windy City Bulls vs. Delaware Blue Coats

Jamie Kennedy

Sister Act at Drury Lane

John Roy

Jamie Kennedy

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.

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