Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"middle-point-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"lincoln-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"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":"lincoln-ma","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	7	2
7	db.events_cache.find( {"_id":"0d9b594c51d09f04fba6b7d467b62f9c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"973ce224e5b4f6928d67281ff9fdce43"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-71.30390167236328,42.42580032348633],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	45
10	db.events_cache.count( {"_id":"0d9b594c51d09f04fba6b7d467b62f9c"} )	0	1
11	db.events_cache.count( {"_id":"0d9b594c51d09f04fba6b7d467b62f9c"} )	0	1
12	db.events_cache.insert( {"_id":"0d9b594c51d09f04fba6b7d467b62f9c","town_sef_url":"lincoln-ma","data_key":["685bb771fb5e4bed1fb6d352","69020910d749a9cd1b06ef76","6923cfb2de4ae56f5a6025ac","68e71ca0c3af739f25e59616","68f2fa1ec3af739f2533d38b","69254b57de4ae56f5a9f576f","6862ef067573f16caa45c427","68d4a7a4c3af739f25451396","68e71ca0c3af739f25e5962a","6862ee737573f1bc9119548f"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"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\":42.42580032348633,\"lng\":-71.30390167236328,\"latlng\":\"42.425800323486,-71.303901672363\",\"city\":\"Lincoln\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.42300000 1766304601)","created":"MongoDate(0.42300000 1766304601)"} , true)	0	2
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	12
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Lincoln

Massachusetts

Lincoln Groups and Organizations

Friends Of The Lincoln Public Library

Lincoln Public Library

Lincoln Public Schools

Magic Garden Children's Center

The Carroll School

The Magic Garden Children's Center

The Thoreau Institute at Walden Woods

Local Events

Charles River Farmers Market at Charles Hotel

Wellesley Festival of Trees

Santa's Brickmas Adventure at LEGO® Discovery Center Boston

Boston University Mens Basketball vs. Umass-Lowell Mens Basketball

Harvard Crimson Womens Basketball vs. Maine Black Bears Womens Basketball

Diamond Blues (A JGB Tribute)

Performance: Wonder

The Slutcracker

A Nat King Cole Christmas with Gordon Michaels

Performance: Wonder