Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"elgin-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/the-price-is-right-live-on-stage-2026-04-26-tm-bristol-va.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"elgin-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","il","kane-county-il","elgin-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"c82583cd9fa84e2484c3fb11ee007c50"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"5beb9bda8f81dd6af2af5b222f764b93"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"elgin-il","start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766210400)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.28099822998047,42.03730010986328],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766469600)"}} )	6	45
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.28099822998047,42.03730010986328],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766469600)"}} )	17	32
10	db.events_radius_cache.count( {"_id":"5beb9bda8f81dd6af2af5b222f764b93"} )	0	1
11	db.events_radius_cache.insert( {"_id":"5beb9bda8f81dd6af2af5b222f764b93","radius":15,"modified":"MongoDate(0.40000000 1765616982)","created":"MongoDate(0.40000000 1765616982)"} , true)	0	1
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-88.28099822998047,42.03730010986328],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	191
13	db.events_cache.count( {"_id":"c82583cd9fa84e2484c3fb11ee007c50"} )	0	1
14	db.events_cache.count( {"_id":"c82583cd9fa84e2484c3fb11ee007c50"} )	0	1
15	db.events_cache.insert( {"_id":"c82583cd9fa84e2484c3fb11ee007c50","town_sef_url":"elgin-il","data_key":["69036ad94389be6be5f5d3ee","693320fe4389be6be565202c","69036ada4389be6be5f5d813","68a75b5b03a70639b6cefb39","693321004389be6be5652936","68a75b5d03a70639b6cf045b","69036ade4389be6be5f5f055","69036ade4389be6be5f5f051","69036ade4389be6be5f5f468","68a75b6203a70639b6cf1cfb","693321034389be6be5653dc4","69036ae24389be6be5f608a4","68a75b6503a70639b6cf3066","69036ae44389be6be5f613ab","69036ae34389be6be5f613a4"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Elgin Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"the-price-is-right-live-on-stage-2026-04-26-tm-bristol-va.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.03730010986328,\"lng\":-88.28099822998047,\"latlng\":\"42.037300109863,-88.28099822998\",\"city\":\"Elgin\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.61700000 1765616982)","created":"MongoDate(0.61700000 1765616982)"} , true)	0	1

Elgin

Illinois

Elgin Featured Events

Lights and Flights Craft Beer Festival

A Live Old Time Holiday Radio Show!

Just Surrender, Freshman 15 and more

Sunday Church Service

A Live Old Time Holiday Radio Show!

Open Mic Night

Steel Panther

Steel Panther

Handguns, Carousel Kings and more

Warrant

Santa Visits Emagine Batavia

Teenage Bottlerocket, Boris the Sprinkler and more

Sunday Church Service

Sara Evans

Sara Evans

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.

Elgin 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.