Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"raleigh-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
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"]},"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":"a8a9b148e4307a409250c9a9b6e04149"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"cb9f305dadaef92bc392d7d8c210c5bb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"geo":{"$geoWithin":{"$center":[[-88.12580108642578,42.04520034790039],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	36
9	db.events_cache.count( {"_id":"a8a9b148e4307a409250c9a9b6e04149"} )	0	1
10	db.events_cache.count( {"_id":"a8a9b148e4307a409250c9a9b6e04149"} )	0	1
11	db.events_cache.insert( {"_id":"a8a9b148e4307a409250c9a9b6e04149","town_sef_url":"hoffman-estates-il","data_key":["68917cc1fb5e4bed1f590125","68c8ca22c3af739f25291f10","68917cc1fb5e4bed1f5903dd","696ee714b1faf7c56a4d4f55","6892ce40fb5e4bed1f90b1f0","6892ce41fb5e4bed1f90b481","68c8ca22c3af739f25291f66","68ccbea9c3af739f2529564b","691bd895de4ae56f5a7c0fb2","68981448fb5e4bed1f561451","68ccbea9c3af739f252956d8","691bd895de4ae56f5a7c100a","689965cffb5e4bed1f95447d","691bd896de4ae56f5a7c1037","689ab740fb5e4bed1fdee2d0"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hoffman Estates Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"\",\"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.38300000 1769923275)","created":"MongoDate(0.38300000 1769923275)"} , true)	0	2
12	db.towns.find( {"sef_url":"hoffman-estates-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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	2
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

Oliver

Professional Championship Bull Riders

Oliver

Alfredo and the Made Men

Sunday Church Service

Oliver

Professional Championship Bull Riders

Windy City Bulls vs. Long Island Nets

T.J. Miller

Oliver

Windy City Bulls vs. Long Island Nets

T.J. Miller

Oliver

T.J. Miller

Oliver

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.