Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"calvin-nd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	31
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
3	db.towns.find( {"sef_url":"carol-stream-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"bb68a502f1f3c8283677c3a2e95ceb4a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"0a060b8513040b62d8ad2700acd4e41d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-88.12059783935547,41.91889953613281],0.21739130434782608]}}}, ["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	157
9	db.events_cache.count( {"_id":"bb68a502f1f3c8283677c3a2e95ceb4a"} )	0	3
10	db.events_cache.count( {"_id":"bb68a502f1f3c8283677c3a2e95ceb4a"} )	0	21
11	db.events_cache.insert( {"_id":"bb68a502f1f3c8283677c3a2e95ceb4a","town_sef_url":"carol-stream-il","data_key":["687f4f95fb5e4bed1f73da88","6901b76d6be57e660e0f2518","68c26ae7c3af739f25d457ad","68d74abdc3af739f25e1e410","687f4f95fb5e4bed1f73db13","685d0877fb5e4bed1f1a0dd9","687f4f96fb5e4bed1f73dcbe","687f4f97fb5e4bed1f73ddd7","6939d022de4ae56f5abc302f","687f4f98fb5e4bed1f73deff","6933cbd7de4ae56f5a4a65f3","687f4f98fb5e4bed1f73dfcb","692e4d91de4ae56f5ae92be3","68e1d6a0c3af739f25678c67","69129e16de4ae56f5aa313b8"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Carol Stream Featured Events\",\"keyword\":\"\",\"radius\":15,\"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.91889953613281,\"lng\":-88.12059783935547,\"latlng\":\"41.918899536133,-88.120597839355\",\"city\":\"Carol Stream\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.89100000 1766380206)","created":"MongoDate(0.89100000 1766380206)"} , true)	0	9
12	db.towns.find( {"sef_url":"carol-stream-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	23
13	db.tokens.find( {"sef_url":{"$in":["usa","il","dupage-county-il","carol-stream-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4

Carol Stream

Illinois

Carol Stream Featured Events

Sister Act at Drury Lane

Holly Jolly Hops Holiday Market at Ike and Oak Brewing

Sara Evans

Sara Evans

Sister Act at Drury Lane

Open Mic Night

Sister Act at Drury Lane

Sister Act at Drury Lane

St. Thomas the Apostle announces Christmas holiday Mass schedule

Sister Act at Drury Lane

Bella’s Second Shot Band

Sister Act at Drury Lane

Dean Edwards

CG's Year End Comedy Allstars

Hi Infidelity

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.

Carol Stream Featured Events

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.