Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"providence-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
3	db.towns.find( {"sef_url":"providence-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","providence-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"80288fa78e80f42c095039cea920a4fd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-71.40869903564453,41.82699966430664],0.14492753623188406]}}}, ["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	99
7	db.events_cache.count( {"_id":"80288fa78e80f42c095039cea920a4fd"} )	0	1
8	db.events_cache.insert( {"_id":"80288fa78e80f42c095039cea920a4fd","town_sef_url":"providence-ri","data_key":["69036ad84389be6be5f5d273","693320fe4389be6be5651fda","69036ad94389be6be5f5d58d","69036ad94389be6be5f5d566","693320fe4389be6be5652222","68a75b5b03a70639b6cef515","68a75b5b03a70639b6cef55b","68a75b5b03a70639b6cef518","68a75b5b03a70639b6cef6d6","68a75b5b03a70639b6cef6f0","68a75b5b03a70639b6cef605","68a75b5b03a70639b6cef803","69036adb4389be6be5f5e0cb","69036adb4389be6be5f5e224","68a75b5c03a70639b6cefe84"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Providence Featured Events\",\"keyword\":\"\",\"radius\":10,\"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.11000000 1765629536)","created":"MongoDate(0.11000000 1765629536)"} , true)	0	2

Providence

Rhode Island

Providence Featured Events

Old-Fashioned Christmas Celebration - Self Guided Tour

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

Goosemas 2025

Carnivale Moliere

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

Old-Fashioned Christmas Celebration - Self Guided Tour

Carnivale Moliere

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.