Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"basking-ridge-nj"}, [] ).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":"warren-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":"30d1aa10c8df9ef883eacf419a8c4ad9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"19030bee61abfa07c880d5b8fdb0a713"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)"},"geo":{"$geoWithin":{"$center":[[-71.28260040283203,41.73040008544922],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	62
9	db.events_cache.count( {"_id":"30d1aa10c8df9ef883eacf419a8c4ad9"} )	0	1
10	db.events_cache.count( {"_id":"30d1aa10c8df9ef883eacf419a8c4ad9"} )	0	1
11	db.events_cache.insert( {"_id":"30d1aa10c8df9ef883eacf419a8c4ad9","town_sef_url":"warren-ri","data_key":["692f6e55de4ae56f5af58d4e","68ef3dddc3af739f2585ae9e","689e67d5fb5e4bed1f3b3320","68eb495dc3af739f25ce1cd3","692f6e55de4ae56f5af58d94","68911579fb5e4bed1fbe4ad7","68bf8fa6c3af739f25b380eb","689e67d5fb5e4bed1f3b3330","68f483ddc3af739f25f392a3","693911d3de4ae56f5a25e6a4","68bf8fa6c3af739f25b38156","6913ef96de4ae56f5a16bb6b","68bf8fa6c3af739f25b381b2","689e67d5fb5e4bed1f3b3346","69509491de4ae56f5a6f4c9a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Warren 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.73040008544922,\"lng\":-71.28260040283203,\"latlng\":\"41.730400085449,-71.282600402832\",\"city\":\"Warren\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.55200000 1769686862)","created":"MongoDate(0.55200000 1769686862)"} , true)	0	1
12	db.towns.find( {"sef_url":"warren-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ri","bristol-county-ri","warren-ri"]}}, [] ).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	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

Warren

Rhode Island

Warren Featured Events

Traces and Transitions, work of Henry Ferreira and Julia Shepley

Handsome Dick Manitoba

The Roommate

Jesse Cook

Traces and Transitions, work of Henry Ferreira and Julia Shepley

Paint with Us!

Monster Jam

The Roommate

Ward Hayden & The Outliers

The Broken Hearts – Tom Petty Tribute

Monster Jam

Providence College Friars Womens Basketball vs. UConn Huskies Womens Basketball

Monster Jam

The Roommate

Jetty, John Fox, & Beyond Gravity

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.

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