Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"elgin-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/peoria-ballets-nutcracker-2025-12-14-tm-peoria-il.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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":"a2c4d6fad9d79928001557a4e5a01e5e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-88.28099822998047,42.03730010986328],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	119
7	db.events_cache.count( {"_id":"a2c4d6fad9d79928001557a4e5a01e5e"} )	0	1
8	db.events_cache.insert( {"_id":"a2c4d6fad9d79928001557a4e5a01e5e","town_sef_url":"elgin-il","data_key":["68a75b5b03a70639b6cefb39","68a75b5c03a70639b6cefd33","693321004389be6be5652936","68a75b5c03a70639b6ceffee","69036adc4389be6be5f5e5db","693321004389be6be5652b5c","68a75b5d03a70639b6cf045b","68a75b5e03a70639b6cf0b5b","68a75b5f03a70639b6cf0cd6","69036ade4389be6be5f5f055","69036ade4389be6be5f5f051","68a75b6003a70639b6cf1373","69036ade4389be6be5f5f468","693321024389be6be5653630","693321024389be6be5653820"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Elgin Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"peoria-ballets-nutcracker-2025-12-14-tm-peoria-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\":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.63200000 1765703054)","created":"MongoDate(0.63200000 1765703054)"} , true)	0	2

Elgin

Illinois

Elgin Featured Events

Sunday Church Service

Million Dollar Quartet

A Live Old Time Holiday Radio Show!

Million Dollar Quartet

Tommy Davidson

Voctave

Open Mic Night

Million Dollar Quartet

Million Dollar Quartet

Steel Panther

Steel Panther

Million Dollar Quartet

Handguns, Carousel Kings and more

Jack Frost

Libido Funk Circus and Drastik J

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.