Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"itta-bena-ms"}, [] ).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":"canton-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":"canton-ma","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	11	2
7	db.events_cache.find( {"_id":"48be6e77b4ec9d3cf6f6c9f9cb66f11d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"09743e927bc3c28ed7cca88e75094b44"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-71.1449966430664,42.15890121459961],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	37
10	db.events_cache.count( {"_id":"48be6e77b4ec9d3cf6f6c9f9cb66f11d"} )	0	1
11	db.events_cache.count( {"_id":"48be6e77b4ec9d3cf6f6c9f9cb66f11d"} )	0	1
12	db.events_cache.insert( {"_id":"48be6e77b4ec9d3cf6f6c9f9cb66f11d","town_sef_url":"canton-ma","data_key":["6914fb957aba785ac3061601","685670cefb5e4bed1f3b1806","685670d5fb5e4bed1f3b2799","6862edb67573f1bc700db03e","6870cf23fb5e4bed1f090525","68c8ca21c3af739f25290f44","685670d8fb5e4bed1f3b2e32","68b8f82ac3af739f2556833a","68c8ca21c3af739f25290f63","68ca53e4c3af739f254ff00b"],"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.15890121459961,\"lng\":-71.1449966430664,\"latlng\":\"42.1589012146,-71.144996643066\",\"city\":\"Canton\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.09200000 1765967291)","created":"MongoDate(0.09200000 1765967291)"} , true)	0	2
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	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	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Canton

Massachusetts

Canton Groups and Organizations

Canton Alliance For Public Education

Canton High School

Canton Public Library

Canton Public Schools

Galvin Middle School

John F. Kennedy Elementary School

Lt. Peter M. Hansen Elementary School

Senchant's Art of Teaching

The Canton Alliance for Public Education

The Canton Public Library

The Luce school

Local Events

SoWa Winter Festival

Harry Potter and the Cursed Child (Touring)

Harry Potter and the Cursed Child (Touring)

Opening Night Performance: Wonder

Christmas with CeCe Winans featuring Angie Winans & Debbie Winans

Public Works

Line Dancing, Btches 'n Boots

The Either/Orchestra

Elon Gold

Audrey Hobert