Nr	Query	Num. rows	Took (ms)
1	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.towns.find( {"sef_url":"haverhill-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.places.find( {"address.town_sef_url":"haverhill-ma","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	9	3
6	db.events_cache.find( {"_id":"f9482120b1ad9699921fc58d93c22296"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"45ef47ff09855a6caededc0d01a8e62c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"haverhill-ma","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.08650207519531,42.78379821777344],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	47
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.08650207519531,42.78379821777344],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	10	39
11	db.events_radius_cache.count( {"_id":"45ef47ff09855a6caededc0d01a8e62c"} )	0	1
12	db.events_radius_cache.count( {"_id":"45ef47ff09855a6caededc0d01a8e62c"} )	0	5
13	db.events_radius_cache.insert( {"_id":"45ef47ff09855a6caededc0d01a8e62c","radius":25,"modified":"MongoDate(0.33600000 1765860667)","created":"MongoDate(0.33600000 1765860667)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-71.08650207519531,42.78379821777344],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	200
15	db.events_cache.count( {"_id":"f9482120b1ad9699921fc58d93c22296"} )	0	2
16	db.events_cache.count( {"_id":"f9482120b1ad9699921fc58d93c22296"} )	0	1
17	db.events_cache.insert( {"_id":"f9482120b1ad9699921fc58d93c22296","town_sef_url":"haverhill-ma","data_key":["690ccb7ade4ae56f5ae996b8","69179dc4de4ae56f5af4f013","685670d9fb5e4bed1f3b318b","68e0bd60c3af739f257665db","692acd15de4ae56f5a86b7ec","6910b965de4ae56f5a22ce36","68e92bc5bf28de9b07092f10","690204aff632dfbd2b06998b","686c55dc7573f157ae4f64ab","691645b6de4ae56f5a1a0ff5"],"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.78379821777344,\"lng\":-71.08650207519531,\"latlng\":\"42.783798217773,-71.086502075195\",\"city\":\"Haverhill\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.60500000 1765860667)","created":"MongoDate(0.60500000 1765860667)"} , true)	0	3
18	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
22	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
23	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
24	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Haverhill

Massachusetts

Haverhill Groups and Organizations

Bradford Elementary School

Haverhill High School

Haverhill Public Library

Haverhill Public Schools

Northeast Technical Institute

Northern Essex Community College

St. Joseph School Of All Saints Parish

St. Joseph School of All Saints Parish

Zion Bible College

Local Events

Michael’s Harborside Hosts Free Music Bingo

Michael’s Harborside in Newburyport Hosts FREE Trivia Nights

Celtic Woman

Patti Smith

Winter Market and Drone Show at The Brook

Michael’s Harborside in Newburyport Presents FREE Live Music Nights

Live Freely Mini Winter Market

Winter Solstice Lantern Celebration

Live Music - Living on a Bad Name

Dance Prism Ballet Presents “The Nutcracker”