Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"box-elder-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"box-elder-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","sd","pennington-county-sd","box-elder-sd"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	4
5	db.events_cache.find( {"_id":"b99711848021ea0704179769a9310abd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"c43cf632d72a40220a97c2f3c7e0b3b5"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"box-elder-sd","start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768456800)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-103.08899688720703,44.11759948730469],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768716000)"}} )	0	21
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-103.08899688720703,44.11759948730469],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768716000)"}} )	3	20
10	db.events_radius_cache.count( {"_id":"c43cf632d72a40220a97c2f3c7e0b3b5"} )	0	1
11	db.events_radius_cache.insert( {"_id":"c43cf632d72a40220a97c2f3c7e0b3b5","radius":25,"modified":"MongoDate(0.80000000 1767912366)","created":"MongoDate(0.80000000 1767912366)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767852000)"},"geo":{"$geoWithin":{"$center":[[-103.08899688720703,44.11759948730469],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	6
13	db.events_cache.count( {"_id":"b99711848021ea0704179769a9310abd"} )	0	1
14	db.events_cache.count( {"_id":"b99711848021ea0704179769a9310abd"} )	0	1
15	db.events_cache.insert( {"_id":"b99711848021ea0704179769a9310abd","town_sef_url":"box-elder-sd","data_key":["68a75b7003a70639b6cf7c71","68a75b7103a70639b6cf805b","68a75b7103a70639b6cf8424","68a75b7503a70639b6cf9c26","68a75b7503a70639b6cfa0a6","68a75b7603a70639b6cfa40a","68a75b7b03a70639b6cfcd9a","68a75b7b03a70639b6cfd135","69036b034389be6be5f6ed0e","69036b044389be6be5f6f3b2","69036b064389be6be5f6ff80","6933211a4389be6be565f232","69036b104389be6be5f73a9c","69036b114389be6be5f7452c","69036b124389be6be5f74dc3"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Box Elder 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\":44.11759948730469,\"lng\":-103.08899688720703,\"latlng\":\"44.117599487305,-103.08899688721\",\"city\":\"Box Elder\",\"state\":\"SD\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.82600000 1767912366)","created":"MongoDate(0.82600000 1767912366)"} , true)	0	2

Box Elder

South Dakota

Box Elder Featured Events

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

Rapid City Rush vs. Utah Grizzlies

Rapid City Rush vs. Tahoe Knight Monsters

Rapid City Rush vs. Tahoe Knight Monsters

Rapid City Rush vs. Worcester Railers

Rapid City Rush vs. Worcester Railers

Rapid City Rush vs. Worcester Railers

The Black Jacket Symphony Pres. Pink Floyd's The Dark Side of the Moon

Rapid City Rush vs. Wheeling Nailers

Rapid City Rush vs. Wheeling Nailers

Rapid City Rush vs. Wheeling Nailers

COVID-19 Resources

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.

Box Elder Featured Events

COVID-19 Resources

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.