Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"pawtucket-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/fruit-bats-2026-02-04-jb-portland-or.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"pawtucket-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","pawtucket-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"0b4af61c54d60583f8f5a1b09d6e9253"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"918d42f2af2b4d21447b4ee761d3e051"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"pawtucket-ri","start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766728800)"}} )	2	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.37300109863281,41.87779998779297],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766988000)"}} )	28	46
9	db.events_radius_cache.count( {"_id":"918d42f2af2b4d21447b4ee761d3e051"} )	0	1
10	db.events_radius_cache.insert( {"_id":"918d42f2af2b4d21447b4ee761d3e051","radius":7,"modified":"MongoDate(0.10900000 1766205008)","created":"MongoDate(0.10900000 1766205008)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)"},"geo":{"$geoWithin":{"$center":[[-71.37300109863281,41.87779998779297],0.10144927536231885]}}}, ["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	116
12	db.events_cache.count( {"_id":"0b4af61c54d60583f8f5a1b09d6e9253"} )	0	1
13	db.events_cache.count( {"_id":"0b4af61c54d60583f8f5a1b09d6e9253"} )	0	1
14	db.events_cache.insert( {"_id":"0b4af61c54d60583f8f5a1b09d6e9253","town_sef_url":"pawtucket-ri","data_key":["69036adf4389be6be5f5f9f2","68a75b6103a70639b6cf198e","69036adf4389be6be5f5fae8","693321024389be6be5653aa5","69036ae04389be6be5f5ff7d","693321024389be6be5653b74","69036ae04389be6be5f6022b","69036ae14389be6be5f6024b","69036ae14389be6be5f602d1","69036ae14389be6be5f60363","69036ae14389be6be5f605b0","69036ae24389be6be5f60936","693321044389be6be56542b0","68a75b6403a70639b6cf2d8b","69036ae34389be6be5f60f84"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Pawtucket Featured Events\",\"keyword\":\"\",\"radius\":7,\"limit\":15,\"page\":1,\"sef\":\"fruit-bats-2026-02-04-jb-portland-or.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.87779998779297,\"lng\":-71.37300109863281,\"latlng\":\"41.877799987793,-71.373001098633\",\"city\":\"Pawtucket\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.26200000 1766205008)","created":"MongoDate(0.26200000 1766205008)"} , true)	0	2

Pawtucket

Rhode Island

Pawtucket Featured Events

Providence College Friars Mens Basketball vs. Seton Hall Pirates Mens Basketball

Paint with Us!

Cirque Dreams Holidaze

Riffmas Rager

Tragedy: A Metal Tribute to the Bee Gees

Plight, Ghosts in the Snow, Goodall, Weatherman, & Galeer

Hope International Market

Cultural Survival Bazaar

Cirque Dreams Holidaze

Holly Jolly Holiday Stroll Craft Fair

Cirque Dreams Holidaze

Providence Bruins vs. Syracuse Crunch

Winter Solstice XVII

Mark Cutler and the Men of Great Courage

Cultural Survival Bazaar on December 21

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.

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