Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"saint-charles-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"saint-charles-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.tokens.find( {"sef_url":{"$in":["usa","il","kane-county-il","saint-charles-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"2eed46c8c6ec0588076e5c65a3b24db6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"8469c9f7b7f2289e31564de9fa7a515a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-88.31749725341797,41.916900634765625],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	158
7	db.events_cache.count( {"_id":"2eed46c8c6ec0588076e5c65a3b24db6"} )	0	1
8	db.events_cache.insert( {"_id":"2eed46c8c6ec0588076e5c65a3b24db6","town_sef_url":"saint-charles-il","data_key":["68a75b5e03a70639b6cf0b5b","68a75b5f03a70639b6cf0cd6","69036ade4389be6be5f5f051","69036ade4389be6be5f5f055","68a75b6003a70639b6cf1373","69036ade4389be6be5f5f468","693321024389be6be5653630","69036adf4389be6be5f5fb1e","68a75b6203a70639b6cf1a46","693321034389be6be5653bcb","68a75b6203a70639b6cf1cfb","693321034389be6be5653dc4","68a75b6403a70639b6cf27f5","693321034389be6be5653ed3","69036ae24389be6be5f608a4"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Saint Charles 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.916900634765625,\"lng\":-88.31749725341797,\"latlng\":\"41.916900634766,-88.317497253418\",\"city\":\"Saint Charles\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.63600000 1766017209)","created":"MongoDate(0.63600000 1766017209)"} , true)	0	2

Saint Charles

Illinois

Saint Charles Featured Events

Million Dollar Quartet

Million Dollar Quartet

Steel Panther

Steel Panther

Million Dollar Quartet

Handguns, Carousel Kings and more

Jack Frost

Terrapin Flyer

Million Dollar Quartet

Jack Frost

Warrant

Santa Visits Emagine Batavia

Million Dollar Quartet

Jack Frost

Teenage Bottlerocket, Boris the Sprinkler and more

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.

Saint Charles 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.