Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"fanshawe-ok"}, [] ).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":"west-warwick-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/lab-theater-project-presents-the-world-premiere-of-green-cheese-by-guy-r-newsham-2026-03-05-tampa-fl.html"]},"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.towns.find( {"sef_url":"west-warwick-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
7	db.tokens.find( {"sef_url":{"$in":["usa","ri","kent-county-ri","west-warwick-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	6
8	db.events_cache.find( {"_id":"e8783d20aa9dca8400d2c2ccfb718702"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
9	db.events_radius_cache.find( {"_id":"b5fdab2ab536cb5375b7e2cf316ac319"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
10	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-71.52210235595703,41.695701599121094],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	89
11	db.events_cache.count( {"_id":"e8783d20aa9dca8400d2c2ccfb718702"} )	0	1
12	db.events_cache.insert( {"_id":"e8783d20aa9dca8400d2c2ccfb718702","town_sef_url":"west-warwick-ri","data_key":["69036ae34389be6be5f60ed5","69036ae34389be6be5f60f84","69036ae34389be6be5f60ff1","69036ae34389be6be5f60fcc","69036ae34389be6be5f61109","693321044389be6be565456e","69036ae34389be6be5f61222","68a75b6603a70639b6cf3461","69036ae44389be6be5f613d4","68a75b6603a70639b6cf35bf","693321044389be6be56547b4","68a75b6703a70639b6cf3dfa","68a75b6803a70639b6cf41b7","69036ae54389be6be5f61d1a","69036ae64389be6be5f61f03"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"West Warwick Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"lab-theater-project-presents-the-world-premiere-of-green-cheese-by-guy-r-newsham-2026-03-05-tampa-fl.html\",\"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.695701599121094,\"lng\":-71.52210235595703,\"latlng\":\"41.695701599121,-71.522102355957\",\"city\":\"West Warwick\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.29100000 1766303972)","created":"MongoDate(0.29100000 1766303972)"} , true)	0	2

West Warwick

Rhode Island

West Warwick Featured Events

Rhode Island Holiday Light Show

Cultural Survival Bazaar on December 21

Fall and Holiday Markets at Farm Fresh

Flea at Farm Fresh

Cirque Dreams Holidaze

Providence College Friars Womens Basketball vs. Georgetown Hoyas Womens Basketball

A Christmas Carol

The 133 Club Blues and Jazz Series

Holiday Lights Spectacular at Roger Williams Park Zoo

Christmas with The Celts

The Kilograms

Live Music - Matt Martin and the Daydrinkers

Live Music - Dan Lilley and The Keepers

Rhode Island Holiday Light Show

Holiday Lights Spectacular at Roger Williams Park Zoo

COVID-19 Resources

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.

West Warwick Featured Events

COVID-19 Resources

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.