Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"dema-ky"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"elgin-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.pages.find( {"type":"town","slug":{"$in":["events","events\/sports-and-recreation"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.towns.find( {"sef_url":"elgin-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.tokens.find( {"sef_url":{"$in":["usa","il","kane-county-il","elgin-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"05649729234507bf0046884a9a865dc3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"3087bd3030abdf08cbd9a0e0e09fe0eb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"elgin-il","start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1766124000)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.28099822998047,42.03730010986328],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1766383200)"}} )	6	44
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.28099822998047,42.03730010986328],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1766383200)"}} )	18	42
11	db.events_radius_cache.count( {"_id":"3087bd3030abdf08cbd9a0e0e09fe0eb"} )	0	1
12	db.events_radius_cache.insert( {"_id":"3087bd3030abdf08cbd9a0e0e09fe0eb","radius":15,"modified":"MongoDate(0.00100000 1765586558)","created":"MongoDate(0.00100000 1765586558)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765519200)"},"tags":"sports-and-recreation","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	21
14	db.events_cache.count( {"_id":"05649729234507bf0046884a9a865dc3"} )	0	1
15	db.events_cache.count( {"_id":"05649729234507bf0046884a9a865dc3"} )	0	1
16	db.events_cache.insert( {"_id":"05649729234507bf0046884a9a865dc3","town_sef_url":"elgin-il","data_key":["69036ae74389be6be5f62612","69036aec4389be6be5f6407b","69036aed4389be6be5f6456d","69036aee4389be6be5f64f1d","69036af04389be6be5f657bb","69036af04389be6be5f65ce5","69036af54389be6be5f68233","69036af64389be6be5f686af","69036af64389be6be5f68abf","69036af74389be6be5f68eed","69036af94389be6be5f6a585","69036afa4389be6be5f6a95b","69036afb4389be6be5f6b32b","69036afc4389be6be5f6b75b","69036afe4389be6be5f6c8fe"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Elgin Featured Events<br>Sports And Recreation\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"sports-and-recreation\",\"tags\":\"sports-and-recreation\",\"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.06300000 1765586558)","created":"MongoDate(0.06300000 1765586558)"} , true)	0	1

Elgin

Illinois

Elgin Featured Events
Sports And Recreation

AEW Presents Worlds End

Windy City Bulls vs. Osceola Magic

Windy City Bulls vs. Osceola Magic

Windy City Bulls vs. Delaware Blue Coats

Windy City Bulls vs. Delaware Blue Coats

Windy City Bulls vs. Noblesville Boom

Hot Wheels Monster Trucks Live Glow-N-Fire

Hot Wheels Monster Trucks Live Glow-N-Fire

Hot Wheels Monster Trucks Live Glow-N-Fire

Hot Wheels Monster Trucks Live Glow-N-Fire

Professional Championship Bull Riders

Professional Championship Bull Riders

Windy City Bulls vs. Long Island Nets

Windy City Bulls vs. Long Island Nets

Windy City Bulls vs. Grand Rapids Gold

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 EventsSports And Recreation

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.

Elgin Featured Events
Sports And Recreation

20 million people
rely on AmericanTowns each year to find & share local information.