Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sinclair-me"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"glocester-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"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":"fee03fbb7076e112a9236e5f68277bbc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	17
7	db.events_radius_cache.find( {"_id":"0737c47a7628d8607222a8a136ffc0a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"glocester-ri","start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770271200)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.6812973022461,41.898799896240234],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} )	0	34
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.6812973022461,41.898799896240234],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} )	2	34
11	db.events_radius_cache.count( {"_id":"0737c47a7628d8607222a8a136ffc0a1"} )	0	1
12	db.events_radius_cache.count( {"_id":"0737c47a7628d8607222a8a136ffc0a1"} )	0	1
13	db.events_radius_cache.insert( {"_id":"0737c47a7628d8607222a8a136ffc0a1","radius":25,"modified":"MongoDate(0.03100000 1769688847)","created":"MongoDate(0.03100000 1769688847)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)"},"geo":{"$geoWithin":{"$center":[[-71.6812973022461,41.898799896240234],0.36231884057971014]}}}, ["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	86
15	db.events_cache.count( {"_id":"fee03fbb7076e112a9236e5f68277bbc"} )	0	1
16	db.events_cache.count( {"_id":"fee03fbb7076e112a9236e5f68277bbc"} )	0	1
17	db.events_cache.insert( {"_id":"fee03fbb7076e112a9236e5f68277bbc","town_sef_url":"glocester-ri","data_key":["692f6e55de4ae56f5af58d4e","68ef3dddc3af739f2585ae9e","689e67d5fb5e4bed1f3b3320","6916cad7de4ae56f5a4f4c5a","692f6e55de4ae56f5af58d94","68911579fb5e4bed1fbe4ad7","68bf8fa6c3af739f25b380eb","6916097cde4ae56f5a88a310","689e67d5fb5e4bed1f3b3330","68cba56ac3af739f25f718b8","693911d3de4ae56f5a25e6a4","68bf8fa6c3af739f25b38156","6913ef96de4ae56f5a16bb6b","68bf8fa6c3af739f25b381b2","689e67d5fb5e4bed1f3b3346"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Glocester Featured Events\",\"keyword\":\"\",\"radius\":25,\"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.898799896240234,\"lng\":-71.6812973022461,\"latlng\":\"41.89879989624,-71.681297302246\",\"city\":\"Glocester\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.14400000 1769688847)","created":"MongoDate(0.14400000 1769688847)"} , true)	0	1
18	db.towns.find( {"sef_url":"glocester-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","glocester-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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

Glocester

Rhode Island

Glocester Featured Events

Traces and Transitions, work of Henry Ferreira and Julia Shepley

Handsome Dick Manitoba

The Roommate

Lee Brice

Traces and Transitions, work of Henry Ferreira and Julia Shepley

Paint with Us!

Monster Jam

Rebecca Anne LoCicero: Psychic Medium

The Roommate

Boogie Wonder Band

The Broken Hearts – Tom Petty Tribute

Monster Jam

Providence College Friars Womens Basketball vs. UConn Huskies Womens Basketball

Monster Jam

The Roommate

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.

Glocester Featured Events

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.