Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"saint-charles-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/billy-gibbons-2026-02-01-tm-saint-charles-il.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"saint-charles-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","il","kane-county-il","saint-charles-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"774581ec7d404375550cf4cce0502aa0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-88.31749725341797,41.916900634765625],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	84
7	db.events_cache.count( {"_id":"774581ec7d404375550cf4cce0502aa0"} )	0	1
8	db.events_cache.insert( {"_id":"774581ec7d404375550cf4cce0502aa0","town_sef_url":"saint-charles-il","data_key":["68a75b6803a70639b6cf451a","68a75b6903a70639b6cf466a","693321054389be6be5654e7f","69036ae64389be6be5f62190","693321064389be6be5654fa8","693321064389be6be5654ffa","68a75b6a03a70639b6cf514c","69036ae74389be6be5f62612","693321064389be6be56551a8","693321064389be6be565525c","68a75b6b03a70639b6cf5345","69036ae84389be6be5f6295e","69036ae84389be6be5f628c5","69036ae84389be6be5f62a98","693321064389be6be565546a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Saint Charles Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"billy-gibbons-2026-02-01-tm-saint-charles-il.html\",\"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.02100000 1766565776)","created":"MongoDate(0.02100000 1766565776)"} , true)	0	2

Saint Charles

Illinois

Saint Charles Featured Events

Million Dollar Quartet

Million Dollar Quartet

Dean Edwards

CG's Year End Comedy Allstars

Hi Infidelity

Dean Edwards

Million Dollar Quartet

AEW Presents Worlds End

Killer of Giants, Night Songs (Tribute to Cinderella) and more

Dean Edwards

Million Dollar Quartet

CG's Year End Comedy Allstars

BoDeans

Pearlsnap Live at Saddle Up @ Q

Dean Edwards

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.