Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mashantucket-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"ware-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	2
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":"f49aac53eb744be437129d3d515e86e7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"5dcd801d5ca5515d889e3789e6b251e6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-72.24819946289062,42.257598876953125],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( 16 ).skip( 0 )	16	343
9	db.events_cache.count( {"_id":"f49aac53eb744be437129d3d515e86e7"} )	0	5
10	db.events_cache.count( {"_id":"f49aac53eb744be437129d3d515e86e7"} )	0	1
11	db.events_cache.insert( {"_id":"f49aac53eb744be437129d3d515e86e7","town_sef_url":"ware-ma","data_key":["6871e66d7573f16cf8571ef0","6930b867de4ae56f5a4054cd","69200554de4ae56f5af2c668","6930b868de4ae56f5a4057ad","6871e66d7573f16cf8571ef1","6871e66d7573f16cf8571ef2","6871e66d7573f16cf8571ef3","6871e66e7573f16cf8571ef4","690d9057de4ae56f5a18df34","689ab73ffb5e4bed1fded84e","68f9c9dfc3af739f25850fd5","689ab73ffb5e4bed1fdeda26","68e8a65fc3af739f255b9084","689ab73ffb5e4bed1fdedd0a","69103358de4ae56f5a26051d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Ware Featured Events\",\"keyword\":\"\",\"radius\":25,\"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.257598876953125,\"lng\":-72.24819946289062,\"latlng\":\"42.257598876953,-72.248199462891\",\"city\":\"Ware\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.07100000 1765722117)","created":"MongoDate(0.07100000 1765722117)"} , true)	0	1
12	db.towns.find( {"sef_url":"ware-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ma","hampshire-county-ma","ware-ma"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
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	1
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

Ware

Massachusetts

Ware Featured Events

Transcendent Ink - The Nature Of Queer Belonging

Christmas Sing by the Fanfare Brass

Karrin Allyson

Christmas/Holiday Sing along

Transcendent Ink - The Nature Of Queer Belonging

Transcendent Ink - The Nature Of Queer Belonging

Transcendent Ink - The Nature Of Queer Belonging

Transcendent Ink - The Nature Of Queer Belonging

Mind Left Body and The Giant’s Harp

UMass Minutemen Hockey vs. Boston University Terriers Mens Ice Hockey

Joey Harkum and Bumpin Uglies

UMass Minutemen Hockey vs. Merrimack Warriors Hockey

Night Moves and Johnny Delaware

UMass Minutemen Hockey vs. Northeastern Huskies Hockey

The Missing Peace, Cheem and more

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.

Ware 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.