Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rogers-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"rogers-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ct","windham-county-ct","rogers-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"7a84ca833522f5f755a2fa3c8930cd04"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"b2f578c2f9d99bf3fbb3aa0dc40a43b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"rogers-ct","start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766815200)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.9052963256836,41.84830093383789],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	25
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.9052963256836,41.84830093383789],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	22
9	db.events_radius_cache.count( {"_id":"b2f578c2f9d99bf3fbb3aa0dc40a43b1"} )	0	1
10	db.events_radius_cache.insert( {"_id":"b2f578c2f9d99bf3fbb3aa0dc40a43b1","radius":25,"modified":"MongoDate(0.89600000 1766252632)","created":"MongoDate(0.89700000 1766252632)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-71.9052963256836,41.84830093383789],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	277
12	db.events_cache.count( {"_id":"7a84ca833522f5f755a2fa3c8930cd04"} )	0	1
13	db.events_cache.count( {"_id":"7a84ca833522f5f755a2fa3c8930cd04"} )	0	1
14	db.events_cache.insert( {"_id":"7a84ca833522f5f755a2fa3c8930cd04","town_sef_url":"rogers-ct","data_key":["69036aea4389be6be5f63658","69036aeb4389be6be5f63885","69036aed4389be6be5f648d1","69036aef4389be6be5f65416","6933210b4389be6be5657602","69036af14389be6be5f66401","69036af24389be6be5f665ed","69036af24389be6be5f66b14","6933210d4389be6be565856c","69036af44389be6be5f6767a","693321104389be6be56599eb","69036af84389be6be5f69441","69036af84389be6be5f69775","693321114389be6be565a4d6","693321124389be6be565ac81"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Rogers 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.84830093383789,\"lng\":-71.9052963256836,\"latlng\":\"41.848300933838,-71.905296325684\",\"city\":\"Rogers\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.20300000 1766252633)","created":"MongoDate(0.20400000 1766252633)"} , true)	0	1

Rogers

Connecticut

Rogers Featured Events

UConn Huskies Hockey vs. LIU Sharks Mens Ice Hockey

NEW YEAR'S EVE 2025

UConn Huskies Mens Basketball vs. Marquette Golden Eagles Mens Basketball

Elvis Presley's 91st Birthday Celebration

Frank Santos Jr Hypnotist/Comedian

UConn Huskies Womens Basketball vs. Villanova Wildcats Womens Basketball

UConn Huskies Hockey vs. Vermont Catamounts Hockey

UConn Huskies Hockey vs. Vermont Catamounts Hockey

Comedy Night at Slater's with Brian “B.Glow” Glowacki & Guests

UConn Huskies Womens Basketball vs. Notre Dame Fighting Irish Womens Basketball

The Fools

UConn Huskies Mens Basketball vs. Providence College Friars Mens Basketball

UConn Huskies Womens Basketball vs. Xavier Musketeers Womens Basketball

Rebecca Anne LoCicero: Psychic Medium

The Banging 88s Dueling Pianos

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.

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