Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"dewitt-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"cranston-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":"f5f2ad691fc993e9014b82bf8b9dfe2d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"2011cbbbc4352d9e7e0dafea51810517"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-71.47859954833984,41.73939895629883],0.10144927536231885]}}}, ["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	39
9	db.events_cache.count( {"_id":"f5f2ad691fc993e9014b82bf8b9dfe2d"} )	0	1
10	db.events_cache.count( {"_id":"f5f2ad691fc993e9014b82bf8b9dfe2d"} )	0	1
11	db.events_cache.insert( {"_id":"f5f2ad691fc993e9014b82bf8b9dfe2d","town_sef_url":"cranston-ri","data_key":["68fd1a15410059e7d104a3d9","68db17fc695f30aa8809bb51","68f93c9952e7405887004346","68f9476e8248d952cc0d23b1","68fd07c552e7405887004364","689bc9e2c4766aed420de8d1","68fd1a15410059e7d104a3da","68fd07c552e7405887004365","68fd1a15410059e7d104a3db","68fd07c552e7405887004366","692f9f11de4ae56f5a522eba","68fd1a15410059e7d104a3dc","68fd07c552e7405887004367","68c26ae8c3af739f25d458a5","6944b710de4ae56f5ab9631a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Cranston Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":7,\"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.73939895629883,\"lng\":-71.47859954833984,\"latlng\":\"41.739398956299,-71.47859954834\",\"city\":\"Cranston\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.79200000 1766332509)","created":"MongoDate(0.79200000 1766332509)"} , true)	0	1
12	db.towns.find( {"sef_url":"cranston-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","cranston-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Cranston

Rhode Island

Cranston Featured Events
Arts And Entertainment

Rhode Island Holiday Light Show

Flea at Farm Fresh

Fall and Holiday Markets at Farm Fresh

A Christmas Carol

Holiday Lights Spectacular at Roger Williams Park Zoo

Christmas with The Celts

Rhode Island Holiday Light Show

Holiday Lights Spectacular at Roger Williams Park Zoo

Rhode Island Holiday Light Show

Holiday Lights Spectacular at Roger Williams Park Zoo

Day Trill

Rhode Island Holiday Light Show

Holiday Lights Spectacular at Roger Williams Park Zoo

Deer Tick

Everybody Wins Presents: New Years Squiddening

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.

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

Cranston Featured Events
Arts And Entertainment

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