Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"jefferson-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"grantham-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/sports-and-recreation"]},"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	1
6	db.places.find( {"address.town_sef_url":"grantham-nh","tags":"sports-and-recreation"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	3	2
7	db.events_cache.find( {"_id":"99bd23414711a092208fb4c54d02b220"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
8	db.events_radius_cache.find( {"_id":"4663693ecd35c6096bc61711650375e9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-72.13700103759766,43.48929977416992],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( 11 ).skip( 0 )	11	266
10	db.events_cache.count( {"_id":"99bd23414711a092208fb4c54d02b220"} )	0	30
11	db.events_cache.count( {"_id":"99bd23414711a092208fb4c54d02b220"} )	0	5
12	db.events_cache.insert( {"_id":"99bd23414711a092208fb4c54d02b220","town_sef_url":"grantham-nh","data_key":["68fd3adc34c9e7cdf6042e70","68fd3b32b968d244290c2f07","68e71ca0c3af739f25e5974c","68fd3b79c863fab8a2052f05","68e71ca0c3af739f25e597fc","68e71ca1c3af739f25e59b14","68e71ca1c3af739f25e59cb4","68e71ca1c3af739f25e59d69","68e71ca1c3af739f25e5a17b","68e71ca1c3af739f25e5a201"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"sports-and-recreation\",\"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\":43.48929977416992,\"lng\":-72.13700103759766,\"latlng\":\"43.48929977417,-72.137001037598\",\"city\":\"Grantham\",\"state\":\"NH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.83600000 1766402358)","created":"MongoDate(0.83600000 1766402358)"} , true)	0	2
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	15
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	13
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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	8
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2

Grantham

New Hampshire

Grantham Groups and Organizations

Eastman Cross Country

Eastman Golf Links

YMCA Camp Coniston

Local Events

Peter and Wendy

Peter and Wendy

Dartmouth Big Green Hockey vs. Arizona State Sun Devils Hockey

Peter and Wendy

Dartmouth Big Green Hockey vs. Arizona State Sun Devils Hockey

Dartmouth Big Green Hockey vs. Harvard Crimson Hockey

Dartmouth Big Green Hockey vs. Clarkson Golden Knights Mens Hockey

Dartmouth Big Green Hockey vs. St. Lawrence Saints Hockey

Dartmouth Big Green Hockey vs. Union College Garnet Chargers Hockey

Dartmouth Big Green Hockey vs. Rensselaer Polytechnic Engineers Mens Hockey