Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"vance-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"charlton-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"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.events_cache.find( {"_id":"64d76afee1c3ab20ab6002af0094ac66"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	6
7	db.events_radius_cache.find( {"_id":"075dbc9e8fc8bd2e66cee355a94ce82f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-71.96990203857422,42.13589859008789],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( 16 ).skip( 0 )	16	307
9	db.events_cache.count( {"_id":"64d76afee1c3ab20ab6002af0094ac66"} )	0	3
10	db.events_cache.count( {"_id":"64d76afee1c3ab20ab6002af0094ac66"} )	0	1
11	db.events_cache.insert( {"_id":"64d76afee1c3ab20ab6002af0094ac66","town_sef_url":"charlton-ma","data_key":["68b1e6a0c3af739f25bf4076","68c9a099c3af739f25e176f4","6933cbd6de4ae56f5a4a5e94","691e7b96de4ae56f5a80fa71","691605f6de4ae56f5a7f0102","69191cfbde4ae56f5af1cb19","691d9a92de4ae56f5a6a8415","69191cfbde4ae56f5af1cb1e","6933cbd6de4ae56f5a4a5fa1","68b6552ac3af739f25c023f1","687925aafb5e4bed1f25534c","68b6552ac3af739f25c0246a","690ce415de4ae56f5a0bd558","69096398de4ae56f5a1c02e1","69266492de4ae56f5ae48469"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Charlton Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"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\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":42.13589859008789,\"lng\":-71.96990203857422,\"latlng\":\"42.135898590088,-71.969902038574\",\"city\":\"Charlton\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.39800000 1765688695)","created":"MongoDate(0.39800000 1765688695)"} , true)	0	1
12	db.towns.find( {"sef_url":"charlton-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ma","worcester-county-ma","charlton-ma"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Charlton

Massachusetts

Charlton Featured Events

Auburn Recreation and Culture Holiday Craft Fair

Red Solo Cup: A Tribute to The Legendary Toby Keith

Four Year Strong

Favela Encantada Worcester ( All Ages ) Dec 13 | Saturday 9PM

Breakfast With Santa

"The Nutcracker" Presented by Dance Prism Ballet

Dance Prism Ballet's The Nutcracker

"The Nutcracker" Presented by Dance Prism Ballet

Four Year Strong

Worcester Railers vs. Norfolk Admirals | WORCESTER WEDNESDAY

Silverstein, Thursday and more

Worcester Railers vs. Norfolk Admirals | NURSES APPRECIATION NIGHT

Comedy Night at Slater's with Kelly MacFarland & Guests

Blue Light Bandits

Sea of Giants, Between 3 & 4, & Odacova

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Charlton Featured Events

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.