Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"anchorage-ak"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	29
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"suffield-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/clubs-and-organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.places.find( {"address.town_sef_url":"suffield-ct","tags":"clubs-and-organizations"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	11	16
7	db.events_cache.find( {"_id":"eab3ad6a11abc36704d3d0c2b1336a62"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
8	db.events_radius_cache.find( {"_id":"56455aafa24bb8169076b4f4b707e56c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-72.6510009765625,41.98210144042969],0.21739130434782608]}}}, ["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( 11 ).skip( 0 )	11	293
10	db.events_cache.count( {"_id":"eab3ad6a11abc36704d3d0c2b1336a62"} )	0	24
11	db.events_cache.count( {"_id":"eab3ad6a11abc36704d3d0c2b1336a62"} )	0	8
12	db.events_cache.insert( {"_id":"eab3ad6a11abc36704d3d0c2b1336a62","town_sef_url":"suffield-ct","data_key":["69008b97410059e7d104a40d","692a5912de4ae56f5a9b77d3","68d204a5c3af739f25f51e15","69008b98410059e7d104a40e","68941fc0fb5e4bed1fb94560","68d204a5c3af739f25f51e3a","692a5912de4ae56f5a9b7828","68941fc0fb5e4bed1fb94597","69008b98410059e7d104a40f","69008b94d749a9cd1b06ef5d"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"clubs-and-organizations\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":41.98210144042969,\"lng\":-72.6510009765625,\"latlng\":\"41.98210144043,-72.651000976562\",\"city\":\"Suffield\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.92900000 1766418569)","created":"MongoDate(0.92900000 1766418569)"} , true)	0	9
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	24
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	13
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10

Suffield

Connecticut

Suffield Groups and Organizations

Breezy View Christmas Tree Farm

Friends of Suffield

Friends of the Farm at Hilltop

Oxen Hill Farm CSA

Phelps-Hatheway House and Garden

Rotary Club of Suffield

Suffield Chamber Of Commerce

Suffield Farmers Market

Suffield Historical Society

Suffield Land Conservancy

The Northern Connecticut Vegetarian Society

Local Events

Winterfest and the Tunnel of Lights

ROAR! Comedy: New England's Funniest

Harlem Globetrotters

Winterfest and the Tunnel of Lights

Springfield Thunderbirds vs. Providence Bruins

Harlem Globetrotters

ROAR! Comedy: New England's Funniest

Springfield Thunderbirds vs. Bridgeport Islanders

Winterfest and the Tunnel of Lights

Winterfest and the Tunnel of Lights