Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rodney-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
3	db.towns.find( {"sef_url":"harmony-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/arts-and-entertainment"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"4dc4df841567eeb053452b04f940aca6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
7	db.events_radius_cache.find( {"_id":"14de2d596c093a3101d98faddc7c72a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"harmony-ri","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	10
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.59380340576172,41.88719940185547],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	82
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.59380340576172,41.88719940185547],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	30	39
11	db.events_radius_cache.count( {"_id":"14de2d596c093a3101d98faddc7c72a1"} )	0	5
12	db.events_radius_cache.count( {"_id":"14de2d596c093a3101d98faddc7c72a1"} )	0	6
13	db.events_radius_cache.insert( {"_id":"14de2d596c093a3101d98faddc7c72a1","radius":15,"modified":"MongoDate(0.83500000 1766296926)","created":"MongoDate(0.83500000 1766296926)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-71.59380340576172,41.88719940185547],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	18
15	db.events_cache.count( {"_id":"4dc4df841567eeb053452b04f940aca6"} )	0	1
16	db.events_cache.count( {"_id":"4dc4df841567eeb053452b04f940aca6"} )	0	1
17	db.events_cache.insert( {"_id":"4dc4df841567eeb053452b04f940aca6","town_sef_url":"harmony-ri","data_key":["68fd1a15410059e7d104a3d9","6900bd3fc3af739f2529d1f5","68db17fc695f30aa8809bb51","68f93c9952e7405887004346","68c8ca21c3af739f25291262","68f94393843db913e8072f51","68f9476e8248d952cc0d23b1","68fd07c552e7405887004364","69020d52315a2fa2aa0b3ea8","690c3ed8de4ae56f5afb9a1e","68fd1a15410059e7d104a3da","68fd07c552e7405887004365","68624e91fb5e4bed1f2f7819","693911d2de4ae56f5a25e0f4","68fd1a15410059e7d104a3db"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Harmony Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"arts-and-entertainment\",\"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.88719940185547,\"lng\":-71.59380340576172,\"latlng\":\"41.887199401855,-71.593803405762\",\"city\":\"Harmony\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.91300000 1766296926)","created":"MongoDate(0.91300000 1766296926)"} , true)	0	1
18	db.towns.find( {"sef_url":"harmony-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
19	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","harmony-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Harmony

Rhode Island

Harmony Featured Events
Arts And Entertainment

Rhode Island Holiday Light Show

Cultural Survival Bazaar on December 21

Flea at Farm Fresh

Fall and Holiday Markets at Farm Fresh

Cirque Dreams Holidaze

A Christmas Carol

A Christmas Carol

Holiday Lights Spectacular at Roger Williams Park Zoo

Southwick's Zoo Winter Wonderland

The Kilograms

Rhode Island Holiday Light Show

Holiday Lights Spectacular at Roger Williams Park Zoo

Paint with Us!

lespecial and Leon Trout

Rhode Island Holiday Light Show

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.

Harmony Featured EventsArts And Entertainment

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.

Harmony Featured Events
Arts And Entertainment

20 million people
rely on AmericanTowns each year to find & share local information.