Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"guilford-in"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events-this-weekend"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.events_cache.find( {"_id":"a6b724732dac3335bc75851f6fd7a470"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
4	db.events_radius_cache.find( {"_id":"32ac9677f37a9749b22e238bacacc41a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
5	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761886800)","$lt":"MongoDate(0.00000000 1762149599)"},"geo":{"$geoWithin":{"$center":[[-84.90879821777344,39.170799255371094],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 )	3	50
6	db.events_cache.count( {"_id":"a6b724732dac3335bc75851f6fd7a470"} )	0	11
7	db.events_cache.insert( {"_id":"a6b724732dac3335bc75851f6fd7a470","town_sef_url":"guilford-in","data_key":["6834104a7573f112322504bc","68bf8fa1c3af739f25b34333","68bf8fa1c3af739f25b34491"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"this-weekend\",\"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,\"title\":\"{local_city} Events for 10\\\/31\\\/2025 to 11\\\/2\\\/2025\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2025-10-31\",\"searchenddate\":\"2025-11-02\",\"lat\":39.170799255371094,\"lng\":-84.90879821777344,\"latlng\":\"39.170799255371,-84.908798217773\",\"city\":\"Guilford\",\"state\":\"IN\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.11400000 1761810329)","created":"MongoDate(0.11400000 1761810329)"} , true)	0	2

Guilford

Indiana

Guilford Events for 10/31/2025 to 11/2/2025

Boone County Farmers Market

Miami of Ohio Redhawks Hockey vs. Arizona State Sun Devils Hockey

Miami of Ohio Redhawks Hockey vs. Arizona State Sun Devils Hockey

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.

Guilford Events for 10/31/2025 to 11/2/2025

Boone County Farmers Market

Miami of Ohio Redhawks Hockey vs. Arizona State Sun Devils Hockey

Miami of Ohio Redhawks Hockey vs. Arizona State Sun Devils Hockey

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.