Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"cedar-crest-nm"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"bismarck-nd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	5
6	db.events_cache.find( {"_id":"5acc7c1ba74d896c981c540234b35153"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"d38d79167510bd3af9058fd0ae0eebce"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"bismarck-nd","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	3	4
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-100.76899719238281,46.80839920043945],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	5	39
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-100.76899719238281,46.80839920043945],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	5	44
11	db.events_radius_cache.count( {"_id":"d38d79167510bd3af9058fd0ae0eebce"} )	0	1
12	db.events_radius_cache.count( {"_id":"d38d79167510bd3af9058fd0ae0eebce"} )	0	1
13	db.events_radius_cache.insert( {"_id":"d38d79167510bd3af9058fd0ae0eebce","radius":25,"modified":"MongoDate(0.74700000 1765786851)","created":"MongoDate(0.74700000 1765786851)"} , true)	0	4
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-100.76899719238281,46.80839920043945],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	454
15	db.events_cache.count( {"_id":"5acc7c1ba74d896c981c540234b35153"} )	0	1
16	db.events_cache.count( {"_id":"5acc7c1ba74d896c981c540234b35153"} )	0	1
17	db.events_cache.insert( {"_id":"5acc7c1ba74d896c981c540234b35153","town_sef_url":"bismarck-nd","data_key":["69200554de4ae56f5af2c637","69200554de4ae56f5af2c721","68f387ddfc7e88139004488a","6926b8f2de4ae56f5a8c12c2","6926b261de4ae56f5a814873","68d204a5c3af739f25f52023","6933cbd8de4ae56f5a4a6fe6","68d204a5c3af739f25f524f9","68d204a6c3af739f25f525c6","68d204a6c3af739f25f52bf3","68d204a6c3af739f25f52c95","68d204a6c3af739f25f52dd5","68d204a6c3af739f25f52e8a","69211e9cde4ae56f5af9d3a2","68d204a7c3af739f25f53152"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Bismarck 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\":46.80839920043945,\"lng\":-100.76899719238281,\"latlng\":\"46.808399200439,-100.76899719238\",\"city\":\"Bismarck\",\"state\":\"ND\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.62000000 1765786852)","created":"MongoDate(0.62000000 1765786852)"} , true)	0	2
18	db.towns.find( {"sef_url":"bismarck-nd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","nd","burleigh-county-nd","bismarck-nd"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	4
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
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	2

Bismarck

North Dakota

Bismarck Featured Events

Lorie Line

The Frontman

Winter Solstice Celebration

Christmas Eve Service - 3 pm

Christmas Eve Service - 4:30 pm

Bismarck Bobcats vs. Minot Minotauros

Riot V

Bismarck Bobcats vs. Austin Bruins

Bismarck Bobcats vs. Austin Bruins

Bismarck Bobcats vs. Watertown Shamrocks

Bismarck Bobcats vs. Watertown Shamrocks

Bismarck Bobcats vs. St. Cloud Norsemen

Bismarck Bobcats vs. St. Cloud Norsemen

The Black Jacket Symphony Pres. Pink Floyd's The Wall

Bismarck Bobcats vs. Minnesota Mallards

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.

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