Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"alvin-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"stafford-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"c6c4c363f20f9712ead9c86113cbfe96"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	16
7	db.events_radius_cache.find( {"_id":"1d88088a0e5d2c0ad097022a2a489662"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-72.28980255126953,41.98460006713867],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	379
9	db.events_cache.count( {"_id":"c6c4c363f20f9712ead9c86113cbfe96"} )	0	5
10	db.events_cache.count( {"_id":"c6c4c363f20f9712ead9c86113cbfe96"} )	0	9
11	db.events_cache.insert( {"_id":"c6c4c363f20f9712ead9c86113cbfe96","town_sef_url":"stafford-ct","data_key":["6930b868de4ae56f5a4057ad","69008b97410059e7d104a40a","69338d03de4ae56f5add7596","685913b3fb5e4bed1fd9ac5c","69338d04de4ae56f5add75d1","69008b97410059e7d104a40b","69338d04de4ae56f5add75f9","69200555de4ae56f5af2c8b2","685a65aefb5e4bed1f65923c","69338d04de4ae56f5add7627","68d838e8c863fab8a2052e2c","69008b97410059e7d104a40c","69338201de4ae56f5ac5535c","685bb770fb5e4bed1fb6d1bb","69008b97410059e7d104a40d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Stafford 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.98460006713867,\"lng\":-72.28980255126953,\"latlng\":\"41.984600067139,-72.28980255127\",\"city\":\"Stafford\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.30200000 1765983372)","created":"MongoDate(0.30200000 1765983372)"} , true)	0	10
12	db.towns.find( {"sef_url":"stafford-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
13	db.tokens.find( {"sef_url":{"$in":["usa","ct","tolland-county-ct","stafford-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	6
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	41
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	24
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	27
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	27
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5

Stafford

Connecticut

Stafford Featured Events

Christmas/Holiday Sing along

Winterfest and the Tunnel of Lights

Comedy Night at the Hartford Funny Bone with Tacarra Williams

ROAR! Comedy: Trixx

Comedy Night at the Hartford Funny Bone with Tacarra Williams

Winterfest and the Tunnel of Lights

Comedy Night at the Hartford Funny Bone with Tacarra Williams

The Blind Boys of Alabama

ROAR! Comedy: Trixx

Comedy Night at the Hartford Funny Bone with Tacarra Williams

Coventry Winter Farmer's Market

Winterfest and the Tunnel of Lights

Comedy Night at the Hartford Funny Bone with Anthony Fuentes

Aaron Lewis and The Stateliners: American As It Gets Tour

Winterfest and the Tunnel of Lights

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.

Stafford Featured Events

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.