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	3
3	db.tokens.find( {"sef_url":{"$in":["usa","il","kane-county-il","batavia-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	4
4	db.events_cache.find( {"_id":"3ef5ccf3ec7ba11f7348419acdc21329"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"d4b3bda171ac8560a5374f7708f94078"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"batavia-il","start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768284000)"}} )	1	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.30449676513672,41.850101470947266],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	1	20
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.30449676513672,41.850101470947266],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	1	21
9	db.events_radius_cache.count( {"_id":"d4b3bda171ac8560a5374f7708f94078"} )	0	1
10	db.events_radius_cache.insert( {"_id":"d4b3bda171ac8560a5374f7708f94078","radius":25,"modified":"MongoDate(0.21400000 1767722282)","created":"MongoDate(0.21400000 1767722282)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767679200)"},"tags":"arts-and-entertainment","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	19
12	db.events_cache.count( {"_id":"3ef5ccf3ec7ba11f7348419acdc21329"} )	0	1
13	db.events_cache.count( {"_id":"3ef5ccf3ec7ba11f7348419acdc21329"} )	0	2
14	db.events_cache.insert( {"_id":"3ef5ccf3ec7ba11f7348419acdc21329","town_sef_url":"batavia-il","data_key":["68a75b7003a70639b6cf76f8","68a75b7003a70639b6cf791a","68a75b7003a70639b6cf79e8","68a75b7003a70639b6cf7bff","6933210a4389be6be5657046","6933210b4389be6be565717e","6933210b4389be6be565726d","68a75b7103a70639b6cf7f56","6933210b4389be6be565750d","68a75b7103a70639b6cf8198","6933210b4389be6be565766f","6933210b4389be6be565774f","68a75b7103a70639b6cf83ab","68a75b7103a70639b6cf844f","6933210b4389be6be56578bd"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Batavia Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"arts-and-entertainment\",\"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.31000000 1767722282)","created":"MongoDate(0.31000000 1767722282)"} , true)	0	2

Batavia

Illinois

Batavia Featured Events
Arts And Entertainment

Sister Act at Drury Lane

Sister Act at Drury Lane

Sister Act at Drury Lane

Sister Act at Drury Lane

Jamie Kennedy

John Roy

Jamie Kennedy

Sister Act at Drury Lane

Jamie Kennedy

Sister Act at Drury Lane

John Roy

Jamie Kennedy

Sister Act at Drury Lane

Sister Act at Drury Lane

Jamie Kennedy

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 EventsArts And Entertainment

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.

Batavia Featured Events
Arts And Entertainment

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