Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"deerfield-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
3	db.towns.find( {"sef_url":"deerfield-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","il","lake-county-il","deerfield-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"deerfield-il","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	7	9
6	db.events_cache.find( {"_id":"abaca7604f4635bf998cb8078122e0b2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"544d701260ba46ba40de959c3def9344"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"deerfield-il","start":{"$gte":"MongoDate(0.00000000 1766728800)","$lt":"MongoDate(0.00000000 1767333600)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.84439849853516,42.167301177978516],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766728800)","$lt":"MongoDate(0.00000000 1767592800)"}} )	13	26
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.84439849853516,42.167301177978516],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766728800)","$lt":"MongoDate(0.00000000 1767592800)"}} )	61	26
11	db.events_radius_cache.count( {"_id":"544d701260ba46ba40de959c3def9344"} )	0	1
12	db.events_radius_cache.insert( {"_id":"544d701260ba46ba40de959c3def9344","radius":15,"modified":"MongoDate(0.59100000 1766797987)","created":"MongoDate(0.59100000 1766797987)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766728800)"},"geo":{"$geoWithin":{"$center":[[-87.84439849853516,42.167301177978516],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( 11 ).skip( 0 )	11	56
14	db.events_cache.count( {"_id":"abaca7604f4635bf998cb8078122e0b2"} )	0	1
15	db.events_cache.count( {"_id":"abaca7604f4635bf998cb8078122e0b2"} )	0	1
16	db.events_cache.insert( {"_id":"abaca7604f4635bf998cb8078122e0b2","town_sef_url":"deerfield-il","data_key":["68a75b6803a70639b6cf44ce","69036ae54389be6be5f61e52","68a75b6803a70639b6cf4623","68a75b6903a70639b6cf4727","69036ae64389be6be5f620b5","69036ae64389be6be5f62153","69036ae64389be6be5f6216d","69036ae64389be6be5f621f7","693321054389be6be5654f3e","69036ae64389be6be5f62205"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":42.167301177978516,\"lng\":-87.84439849853516,\"latlng\":\"42.167301177979,-87.844398498535\",\"city\":\"Deerfield\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.66900000 1766797987)","created":"MongoDate(0.66900000 1766797987)"} , true)	0	1

Deerfield

Illinois

Deerfield Groups and Organizations

Deerfield High School

Deerfield Montessori School

Deerfield Public Library

Deerfield Public Schools District 109

Friends of the Deerfield Public Library

Riverwoods Montessori School

Trinity International University

Local Events

Million Dollar Quartet Christmas

Trans-Siberian Orchestra - The Ghosts Of Christmas Eve

Music Theater Works Presents: Annie

Million Dollar Quartet Christmas

Northlight Theatre Presents: Gaslight

Trans-Siberian Orchestra - The Ghosts Of Christmas Eve

BoDeans

Our Name is Jonas (Weezer Tribute) + Funky Monks (Red Hot Chili Peppers Tribute)

Ouray

Dueling Pianos with Rock It Man Entertainment

COVID-19 Resources