Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"smithfield-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	2
3	db.towns.find( {"sef_url":"smithfield-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","smithfield-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	4
5	db.events_cache.find( {"_id":"3af16d506225202e809bdec886144fb2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"4fe75d7d7d941c417d63159132020e5b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-71.54959869384766,41.922000885009766],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	110
8	db.events_cache.count( {"_id":"3af16d506225202e809bdec886144fb2"} )	0	2
9	db.events_cache.insert( {"_id":"3af16d506225202e809bdec886144fb2","town_sef_url":"smithfield-ri","data_key":["69036ae34389be6be5f60ed5","69036ae34389be6be5f60f84","69036ae34389be6be5f60ff1","69036ae34389be6be5f60fcc","69036ae34389be6be5f61109","693321044389be6be565456e","69036ae34389be6be5f6121f","69036ae44389be6be5f613e8","69036ae44389be6be5f613d4","68a75b6603a70639b6cf3461","693321044389be6be56547b4","68a75b6703a70639b6cf3dfa","68a75b6803a70639b6cf41b7","69036ae54389be6be5f61d1a","69036ae64389be6be5f61f03"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Smithfield 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.922000885009766,\"lng\":-71.54959869384766,\"latlng\":\"41.92200088501,-71.549598693848\",\"city\":\"Smithfield\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.66500000 1766357534)","created":"MongoDate(0.66500000 1766357534)"} , true)	0	2

Smithfield

Rhode Island

Smithfield 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

Southwick's Zoo Winter Wonderland

Holiday Lights Spectacular at Roger Williams Park Zoo

The 133 Club Blues and Jazz Series

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.

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