Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rogers-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"rogers-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","ct","windham-county-ct","rogers-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"7a84ca833522f5f755a2fa3c8930cd04"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"b2f578c2f9d99bf3fbb3aa0dc40a43b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766037600)"},"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	230
8	db.events_cache.count( {"_id":"7a84ca833522f5f755a2fa3c8930cd04"} )	0	1
9	db.events_cache.insert( {"_id":"7a84ca833522f5f755a2fa3c8930cd04","town_sef_url":"rogers-ct","data_key":["693321024389be6be5653a4c","69036aea4389be6be5f63658","69036aeb4389be6be5f63885","69036aed4389be6be5f648d1","69036aef4389be6be5f65416","6933210b4389be6be5657602","69036af14389be6be5f66401","69036af24389be6be5f665ed","69036af24389be6be5f66b14","6933210d4389be6be565856c","69036af44389be6be5f6767a","693321104389be6be56599eb","69036af84389be6be5f69441","69036af84389be6be5f69775","693321114389be6be565a4d6"],"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.74100000 1766074390)","created":"MongoDate(0.74100000 1766074390)"} , true)	0	2

Rogers

Connecticut

Rogers Featured Events

Comedy Night at Slater's with Kelly MacFarland & Guests

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

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.