Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"saint-charles-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
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	2
3	db.towns.find( {"sef_url":"saint-charles-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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":"a214077b15a594db41d698511a313f56"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-88.31749725341797,41.916900634765625],0.07246376811594203]}}}, ["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	212
7	db.events_cache.count( {"_id":"a214077b15a594db41d698511a313f56"} )	0	1
8	db.events_cache.insert( {"_id":"a214077b15a594db41d698511a313f56","town_sef_url":"saint-charles-il","data_key":["69036ae84389be6be5f628c5","69036ae94389be6be5f62e08","68a75b6c03a70639b6cf5f36","68a75b7003a70639b6cf74ad","68a75b7203a70639b6cf85d2","68a75b7403a70639b6cf951f","68a75b7603a70639b6cfa57f","69036afa4389be6be5f6a6c0","693321124389be6be565af92","68a75b7803a70639b6cfb747","69036afc4389be6be5f6bafd","68a75b7a03a70639b6cfc75e","68a75b7c03a70639b6cfd616","69036b084389be6be5f70bc4","69036b0b4389be6be5f71b16"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Saint Charles Featured Events\",\"keyword\":\"\",\"radius\":5,\"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.21300000 1766543624)","created":"MongoDate(0.21300000 1766543624)"} , true)	0	2

Saint Charles

Illinois

Saint Charles Featured Events

BoDeans

The Association

Open Mic Night

Open Mic Night

Open Mic Night

Open Mic Night

Open Mic Night

Adrenalize (Def Leppard Tribute)

Billy Gibbons

Open Mic Night

The Lovin’ Spoonful and The Hollies

Open Mic Night

Open Mic Night

Open Mic Night

Steve Kimock, Jackie Greene 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.