Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"batavia-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"batavia-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.tokens.find( {"sef_url":{"$in":["usa","il","kane-county-il","batavia-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"13a625fa4d70f7dc8dabdd11878907c9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	6
5	db.events_radius_cache.find( {"_id":"622e2bb5660f0e66c2cfc6f63179d6a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"batavia-il","start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768024800)"}} )	1	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.30449676513672,41.850101470947266],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768284000)"}} )	6	22
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.30449676513672,41.850101470947266],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768284000)"}} )	6	19
9	db.events_radius_cache.count( {"_id":"622e2bb5660f0e66c2cfc6f63179d6a1"} )	0	1
10	db.events_radius_cache.insert( {"_id":"622e2bb5660f0e66c2cfc6f63179d6a1","radius":25,"modified":"MongoDate(0.95000000 1767420693)","created":"MongoDate(0.95000000 1767420693)"} , true)	0	1
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767420000)"},"geo":{"$geoWithin":{"$center":[[-88.30449676513672,41.850101470947266],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	83
12	db.events_cache.count( {"_id":"13a625fa4d70f7dc8dabdd11878907c9"} )	0	1
13	db.events_cache.count( {"_id":"13a625fa4d70f7dc8dabdd11878907c9"} )	0	1
14	db.events_cache.insert( {"_id":"13a625fa4d70f7dc8dabdd11878907c9","town_sef_url":"batavia-il","data_key":["68a75b6f03a70639b6cf6fbd","68a75b6f03a70639b6cf7021","68a75b6f03a70639b6cf708a","68a75b6f03a70639b6cf70c0","69036aed4389be6be5f6456d","68a75b6f03a70639b6cf71a7","693321094389be6be5656702","68a75b6f03a70639b6cf71d4","68a75b6f03a70639b6cf720c","68a75b6f03a70639b6cf7288","68a75b6f03a70639b6cf72f6","68a75b6f03a70639b6cf736e","68a75b6f03a70639b6cf7380","68a75b7003a70639b6cf74ad","68a75b7003a70639b6cf76f8"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Batavia Featured Events\",\"keyword\":\"\",\"radius\":25,\"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\":41.850101470947266,\"lng\":-88.30449676513672,\"latlng\":\"41.850101470947,-88.304496765137\",\"city\":\"Batavia\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.07100000 1767420694)","created":"MongoDate(0.07100000 1767420694)"} , true)	0	1

Batavia

Illinois

Batavia Featured Events

Million Dollar Quartet

Sister Act at Drury Lane

Million Dollar Quartet

Steve Trevino

Windy City Bulls vs. Osceola Magic

Sister Act at Drury Lane

CG's Comedy All-Stars

Steve Trevino

Sunday Church Service

Million Dollar Quartet

Sister Act at Drury Lane

Million Dollar Quartet

Sister Act at Drury Lane

Open Mic Night

Sister Act at Drury Lane

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.

Batavia 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.