Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"providence-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
3	db.towns.find( {"sef_url":"providence-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","providence-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"44fbd3ea4c8ee77f879186bc717dfb59"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-71.40869903564453,41.82699966430664],0.07246376811594203]}}}, ["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	101
7	db.events_cache.count( {"_id":"44fbd3ea4c8ee77f879186bc717dfb59"} )	0	1
8	db.events_cache.insert( {"_id":"44fbd3ea4c8ee77f879186bc717dfb59","town_sef_url":"providence-ri","data_key":["693320fe4389be6be5651fda","69036ad94389be6be5f5d58d","69036ad94389be6be5f5d566","693320fe4389be6be5652222","68a75b5b03a70639b6cef55b","68a75b5b03a70639b6cef515","68a75b5b03a70639b6cef518","68a75b5b03a70639b6cef6d6","68a75b5b03a70639b6cef6f0","68a75b5b03a70639b6cef605","68a75b5b03a70639b6cef803","69036adb4389be6be5f5e0cb","68a75b5c03a70639b6cefe84","69036adc4389be6be5f5e471","68a75b5c03a70639b6ceffe7"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Providence Featured Events\",\"keyword\":\"\",\"radius\":5,\"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.82699966430664,\"lng\":-71.40869903564453,\"latlng\":\"41.826999664307,-71.408699035645\",\"city\":\"Providence\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.01800000 1765648909)","created":"MongoDate(0.01800000 1765648909)"} , true)	0	1

Providence

Rhode Island

Providence Featured Events

Providence College Friars Womens Basketball vs. Stonehill Skyhawks Womens Basketball

Holiday Lights Spectacular at Roger Williams Park Zoo

screenager, Flake and more

Pigeons Playing Ping Pong

Carnivale Moliere

Goosemas 2025

Goosemas 2025 2-Day Ticket 12/12/25 & 12/13/25

Boston Pops

Boston Pops

The Sixties Show

Live Music - Tanya Mcintyre and the Professors

Flea at Farm Fresh

Carnivale Moliere

Handel's Messiah

The 133 Club Blues and Jazz Series

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.

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