Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"ola-id"}, [] ).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":"garretson-sd"}, [] ).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":"d038a11aa2b9a33699266273487cfa55"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"d3ed44c33be0d860b535ffe3499567e6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"garretson-sd","start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766469600)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-96.5114974975586,43.717201232910156],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	31
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-96.5114974975586,43.717201232910156],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	39
11	db.events_radius_cache.count( {"_id":"d3ed44c33be0d860b535ffe3499567e6"} )	0	1
12	db.events_radius_cache.count( {"_id":"d3ed44c33be0d860b535ffe3499567e6"} )	0	1
13	db.events_radius_cache.insert( {"_id":"d3ed44c33be0d860b535ffe3499567e6","radius":25,"modified":"MongoDate(0.68700000 1765932648)","created":"MongoDate(0.68700000 1765932648)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-96.5114974975586,43.717201232910156],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	341
15	db.events_cache.count( {"_id":"d038a11aa2b9a33699266273487cfa55"} )	0	1
16	db.events_cache.count( {"_id":"d038a11aa2b9a33699266273487cfa55"} )	0	1
17	db.events_cache.insert( {"_id":"d038a11aa2b9a33699266273487cfa55","town_sef_url":"garretson-sd","data_key":["68f95db3615aff3712043ce5","68f95fc5cbafdd55bb06c2f0","68f95db3615aff3712043ce6","68f95fc5cbafdd55bb06c2f1","68dcc8e0c3af739f25608d82","685a65b8fb5e4bed1f65a5d3","68f95e3cbf28de9b07092f66","68f95fc5cbafdd55bb06c2f2","68f95e6efd969f5f110551ce","68f95fc8fc7e881390044893","68fd16ed410059e7d104a3cf","68fd1a6a8675dc66050517fc","6863a000fb5e4bed1fa5ffc1","68fd17303af6aa547c083995","68ad1aa9c3af739f25f0a84a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Garretson 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\":43.717201232910156,\"lng\":-96.5114974975586,\"latlng\":\"43.71720123291,-96.511497497559\",\"city\":\"Garretson\",\"state\":\"SD\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.09400000 1765932649)","created":"MongoDate(0.09400000 1765932649)"} , true)	0	1
18	db.towns.find( {"sef_url":"garretson-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","sd","minnehaha-county-sd","garretson-sd"]}}, [] ).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

Garretson

South Dakota

Garretson Featured Events

Christmas at the Cathedral

Irving Berlin’s White Christmas

Christmas at the Cathedral

Irving Berlin’s White Christmas

Lonestar

Center of Sioux Falls Walking Tour

Christmas at the Cathedral

Irving Berlin’s White Christmas

Christmas at the Cathedral

Irving Berlin’s White Christmas

Dr. Seuss' How The Grinch Stole Christmas

Atrium Makers Market

South End Walking Food Tour

Dr. Seuss' How The Grinch Stole Christmas

Sioux Falls Stampede vs. Fargo Force

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.

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