Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"great-lakes-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
3	db.towns.find( {"sef_url":"great-lakes-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","il","lake-county-il","great-lakes-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"b21589681657249e6b9db53a6fd510dd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"8dc5ea7b9bba4106e387230ee6729426"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"great-lakes-il","start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766210400)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.86830139160156,42.299598693847656],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766469600)"}} )	5	39
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.86830139160156,42.299598693847656],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766469600)"}} )	27	47
10	db.events_radius_cache.count( {"_id":"8dc5ea7b9bba4106e387230ee6729426"} )	0	1
11	db.events_radius_cache.insert( {"_id":"8dc5ea7b9bba4106e387230ee6729426","radius":15,"modified":"MongoDate(0.25200000 1765648774)","created":"MongoDate(0.25200000 1765648774)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-87.86830139160156,42.299598693847656],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	326
13	db.events_cache.count( {"_id":"b21589681657249e6b9db53a6fd510dd"} )	0	1
14	db.events_cache.count( {"_id":"b21589681657249e6b9db53a6fd510dd"} )	0	1
15	db.events_cache.insert( {"_id":"b21589681657249e6b9db53a6fd510dd","town_sef_url":"great-lakes-il","data_key":["68a75b5903a70639b6ceed1a","69036ad84389be6be5f5d107","69036ad94389be6be5f5d3e9","68a75b5a03a70639b6cef0c0","69036ada4389be6be5f5da4d","68a75b5b03a70639b6cef4fc","68a75b5b03a70639b6cef60f","69036ada4389be6be5f5de6d","68a75b5c03a70639b6cefd20","69036adb4389be6be5f5e373","693321004389be6be5652959","693321004389be6be56529e7","68a75b5c03a70639b6ceffb5","69036adc4389be6be5f5e79e","68a75b5e03a70639b6cf0b40"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Great Lakes 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.299598693847656,\"lng\":-87.86830139160156,\"latlng\":\"42.299598693848,-87.868301391602\",\"city\":\"Great Lakes\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.61700000 1765648774)","created":"MongoDate(0.61700000 1765648774)"} , true)	0	1

Great Lakes

Illinois

Great Lakes Featured Events

Grayslake Farmers Market

Northbrook Holiday Craft Fair

As You Like It

Million Dollar Quartet Christmas

As You Like It

Lady A

Million Dollar Quartet Christmas

Tributes to Chris Stapleton and Eric Church: Tennessee Whiskey & Ultimate Eric Church Tribute

Million Dollar Quartet Christmas

As You Like It

The Way Out Quintet CD Release Concerts

Ron Hawking Celebrates The Holiday Spirit

Million Dollar Quartet Christmas

As You Like It

Million Dollar Quartet Christmas

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.

Great Lakes 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.