Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"conception-junction-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"keystone-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":"eea3f69f2726904ef3b04ad366fc2bd0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"ca379b06392e0fc33faa5751d94a326c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"keystone-sd","start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766469600)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-103.42500305175781,43.89360046386719],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	28
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-103.42500305175781,43.89360046386719],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	2	25
11	db.events_radius_cache.count( {"_id":"ca379b06392e0fc33faa5751d94a326c"} )	0	1
12	db.events_radius_cache.count( {"_id":"ca379b06392e0fc33faa5751d94a326c"} )	0	1
13	db.events_radius_cache.insert( {"_id":"ca379b06392e0fc33faa5751d94a326c","radius":25,"modified":"MongoDate(0.66600000 1765919233)","created":"MongoDate(0.66600000 1765919233)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-103.42500305175781,43.89360046386719],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	299
15	db.events_cache.count( {"_id":"eea3f69f2726904ef3b04ad366fc2bd0"} )	0	1
16	db.events_cache.count( {"_id":"eea3f69f2726904ef3b04ad366fc2bd0"} )	0	1
17	db.events_cache.insert( {"_id":"eea3f69f2726904ef3b04ad366fc2bd0","town_sef_url":"keystone-sd","data_key":["68f9673934c9e7cdf6042e5c","68f9673934c9e7cdf6042e5d","68fd07a5fd969f5f110551f7","68941fc0fb5e4bed1fb9451e","68fd0af6b968d244290c2f03","68fd07a5fd969f5f110551f8","68941fc0fb5e4bed1fb94577","68fd0af6b968d244290c2f04","68fd07a5fd969f5f110551f9","68941fc0fb5e4bed1fb94622","68941fc0fb5e4bed1fb946e7","68941fc1fb5e4bed1fb94760","68941fc1fb5e4bed1fb94766","68941fc1fb5e4bed1fb94878","68941fc1fb5e4bed1fb948fb"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Keystone 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.89360046386719,\"lng\":-103.42500305175781,\"latlng\":\"43.893600463867,-103.42500305176\",\"city\":\"Keystone\",\"state\":\"SD\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.07900000 1765919234)","created":"MongoDate(0.07900000 1765919234)"} , true)	0	1
18	db.towns.find( {"sef_url":"keystone-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
19	db.tokens.find( {"sef_url":{"$in":["usa","sd","pennington-county-sd","keystone-sd"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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

Keystone

South Dakota

Keystone Featured Events

Holiday Express

Holiday Express

Christmas Nights of Lights

Rapid City Rush vs. Tahoe Knight Monsters

Winter Express

Christmas Nights of Lights

Rapid City Rush vs. Tahoe Knight Monsters

Winter Express

Christmas Nights of Lights

Rapid City Rush vs. Tahoe Knight Monsters

Rapid City Rush vs. Indy Fuel

Rapid City Rush vs. Indy Fuel

Rapid City Rush vs. Indy Fuel

Rapid City Rush vs. Utah Grizzlies

Rapid City Rush vs. Utah Grizzlies

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.

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