Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"lagrange-wy"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"hoffman-estates-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/bob-schneider-2025-12-31-jb-austin-tx.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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":"1a123f21e00b8e0d812b89eb012e3b7f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"cb9f305dadaef92bc392d7d8c210c5bb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-88.12580108642578,42.04520034790039],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	30
9	db.events_cache.count( {"_id":"1a123f21e00b8e0d812b89eb012e3b7f"} )	0	1
10	db.events_cache.count( {"_id":"1a123f21e00b8e0d812b89eb012e3b7f"} )	0	1
11	db.events_cache.insert( {"_id":"1a123f21e00b8e0d812b89eb012e3b7f","town_sef_url":"hoffman-estates-il","data_key":["685d0877fb5e4bed1f1a0dd9","685e5a10fb5e4bed1f621260","687f4f96fb5e4bed1f73dcbe","685e5a19fb5e4bed1f6222c1","687f4f97fb5e4bed1f73ddd7","6939d022de4ae56f5abc302f","68624e8dfb5e4bed1f2f7008","687f4f98fb5e4bed1f73deff","68624e8efb5e4bed1f2f71ee","68b10f28c3af739f25c5c4dc","6933cbd7de4ae56f5a4a65f3","68624e93fb5e4bed1f2f7bb1","687f4f98fb5e4bed1f73dfcb","692e4d91de4ae56f5ae92be3","68624e95fb5e4bed1f2f7e68"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hoffman Estates Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"bob-schneider-2025-12-31-jb-austin-tx.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\":42.04520034790039,\"lng\":-88.12580108642578,\"latlng\":\"42.0452003479,-88.125801086426\",\"city\":\"Hoffman Estates\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.60200000 1766440758)","created":"MongoDate(0.60200000 1766440758)"} , true)	0	2
12	db.towns.find( {"sef_url":"hoffman-estates-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","il","cook-county-il","hoffman-estates-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Hoffman Estates

Illinois

Hoffman Estates Featured Events

Open Mic Night

Million Dollar Quartet Christmas

Sister Act at Drury Lane

Million Dollar Quartet Christmas

Sister Act at Drury Lane

St. Thomas the Apostle announces Christmas holiday Mass schedule

Million Dollar Quartet Christmas

Sister Act at Drury Lane

Million Dollar Quartet

Trans-Siberian Orchestra - The Ghosts Of Christmas Eve

Bella’s Second Shot Band

Million Dollar Quartet

Sister Act at Drury Lane

Dean Edwards

Million Dollar Quartet Christmas

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.

Hoffman Estates 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.