Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"shonto-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"middletown-ri"}, [] ).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":"9a7847f5bcc43f98e216e880df1864d3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"59c8deefb7743973082d216bc3f0302c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-71.29180145263672,41.5452995300293],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	318
9	db.events_cache.count( {"_id":"9a7847f5bcc43f98e216e880df1864d3"} )	0	2
10	db.events_cache.count( {"_id":"9a7847f5bcc43f98e216e880df1864d3"} )	0	1
11	db.events_cache.insert( {"_id":"9a7847f5bcc43f98e216e880df1864d3","town_sef_url":"middletown-ri","data_key":["68e6a3b0c863fab8a2052e7b","68bd24e5c3af739f25f5488e","68e6b2a0da3e0489fb066fa2","685913b2fb5e4bed1fd9ab32","689bc948f957a70c3306db2f","68a80cebc3af739f25c638bc","68e6b2a0da3e0489fb066fa3","685a65bafb5e4bed1f65a841","68a80cecc3af739f25c63909","69200555de4ae56f5af2c938","68e6a421f957a70c3306dcd2","68e6b2a0da3e0489fb066fa4","68f284fccf29e58a420c4cd5","689bc9e2c4766aed420de8d1","68e6a422f957a70c3306dcd3"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Middletown 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\":41.5452995300293,\"lng\":-71.29180145263672,\"latlng\":\"41.545299530029,-71.291801452637\",\"city\":\"Middletown\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.03900000 1765825493)","created":"MongoDate(0.03900000 1765825493)"} , true)	0	1
12	db.towns.find( {"sef_url":"middletown-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ri","newport-county-ri","middletown-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
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	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

Middletown

Rhode Island

Middletown Featured Events

Sparkling Lights at The Breakers

Bywater Call

Holiday Lantern Tour

Show - The Bit Players

The Uncle Louie Variety Show

Quinn Sullivan

Holiday Lantern Tour

Show - The Bit Players

Quinn Sullivan

Almost Queen

Sparkling Lights at The Breakers

Holiday Lantern Tour

Night Magic!

Christmas with The Celts

Sparkling Lights at The Breakers

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.

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