Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hope-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":"hope-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","hope-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"38ba5f12d119f6448ba2f0e1090f2bb4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"40d82c68ad1042308612d097318fb8da"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"hope-ri","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	3	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.56269836425781,41.73320007324219],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	5	26
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.56269836425781,41.73320007324219],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	22	24
10	db.events_radius_cache.count( {"_id":"40d82c68ad1042308612d097318fb8da"} )	0	1
11	db.events_radius_cache.insert( {"_id":"40d82c68ad1042308612d097318fb8da","radius":15,"modified":"MongoDate(0.68200000 1766365927)","created":"MongoDate(0.68200000 1766365927)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-71.56269836425781,41.73320007324219],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	119
13	db.events_cache.count( {"_id":"38ba5f12d119f6448ba2f0e1090f2bb4"} )	0	1
14	db.events_cache.count( {"_id":"38ba5f12d119f6448ba2f0e1090f2bb4"} )	0	1
15	db.events_cache.insert( {"_id":"38ba5f12d119f6448ba2f0e1090f2bb4","town_sef_url":"hope-ri","data_key":["69036ae34389be6be5f60ed5","69036ae34389be6be5f60f84","69036ae34389be6be5f60fcc","69036ae34389be6be5f60ff1","693321044389be6be565456e","69036ae34389be6be5f61109","69036ae34389be6be5f61222","69036ae44389be6be5f613d4","68a75b6603a70639b6cf3461","68a75b6603a70639b6cf35bf","693321044389be6be56547b4","68a75b6703a70639b6cf3dfa","68a75b6803a70639b6cf41b7","69036ae54389be6be5f61d1a","69036ae64389be6be5f61f03"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hope 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.73320007324219,\"lng\":-71.56269836425781,\"latlng\":\"41.733200073242,-71.562698364258\",\"city\":\"Hope\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.83800000 1766365927)","created":"MongoDate(0.83800000 1766365927)"} , true)	0	1

Hope

Rhode Island

Hope Featured Events

Rhode Island Holiday Light Show

Cultural Survival Bazaar on December 21

Flea at Farm Fresh

Fall and Holiday Markets at Farm Fresh

Providence College Friars Womens Basketball vs. Georgetown Hoyas Womens Basketball

Cirque Dreams Holidaze

A Christmas Carol

Holiday Lights Spectacular at Roger Williams Park Zoo

The 133 Club Blues and Jazz Series

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.

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