Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"waterville-wa"}, [] ).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":"southborough-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":"southborough-ma","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	6	2
7	db.events_cache.find( {"_id":"296ff2ba5ef4abd61ab6f2f3547e4228"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"d16cace9db26b07bc145f4558de84691"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-71.52940368652344,42.30580139160156],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	139
10	db.events_cache.count( {"_id":"296ff2ba5ef4abd61ab6f2f3547e4228"} )	0	1
11	db.events_cache.count( {"_id":"296ff2ba5ef4abd61ab6f2f3547e4228"} )	0	1
12	db.events_cache.insert( {"_id":"296ff2ba5ef4abd61ab6f2f3547e4228","town_sef_url":"southborough-ma","data_key":["685e5a1bfb5e4bed1f6225df","692f15f5de4ae56f5a5cc2b8","6933cbd7de4ae56f5a4a65fd","692a5912de4ae56f5a9b77d9","68b6552ac3af739f25c02656","68c65f66c3af739f25e1eb4b","69081218de4ae56f5af7c35a","688b2cd0fb5e4bed1f075939","68b6552ac3af739f25c02678","690a24f9de4ae56f5a915809"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"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.30580139160156,\"lng\":-71.52940368652344,\"latlng\":\"42.305801391602,-71.529403686523\",\"city\":\"Southborough\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.34200000 1766427174)","created":"MongoDate(0.34300000 1766427174)"} , true)	0	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	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	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Southborough

Massachusetts

Southborough Groups and Organizations

Margaret A. Neary Elementary School

Mary E. Finn Elementary School

P. Brent Trottier Middle School

Public Schools Of Northborough And Southborough

Southborough Library

Woodward Elementary School

Local Events

Boston Skyline Chorus Weekly Rehearsal

Holiday Carolers at University Station

Found Piece, Dream of Scipio and more

Thirty 6 Red

Worcester Railers vs. Adirondack Thunder | HOME FOR THE HOLIDAYS GAME1

John Cafferty & the Beaver Brown Band

Bellas Bartok w/ Woody & the Rebel Alliance

Madhouse

Worcester Railers vs. Adirondack Thunder | HOME FOR THE HOLIDAYS GAME2

Tantra Speed Date® - Boston (Watertown)! Meet Singles Speed Dating