Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"parks-ar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"shell-rock-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	6
6	db.events_cache.find( {"_id":"8011481b568bca0381a1ffa2ad7e048b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	14
7	db.events_radius_cache.find( {"_id":"be44540991c045db49b046b8d46da5f0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-92.58070373535156,42.71229934692383],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	400
9	db.events_cache.count( {"_id":"8011481b568bca0381a1ffa2ad7e048b"} )	0	45
10	db.events_cache.count( {"_id":"8011481b568bca0381a1ffa2ad7e048b"} )	0	3
11	db.events_cache.insert( {"_id":"8011481b568bca0381a1ffa2ad7e048b","town_sef_url":"shell-rock-ia","data_key":["69200555de4ae56f5af2c783","68941fc0fb5e4bed1fb94565","68941fc0fb5e4bed1fb945a2","68941fc0fb5e4bed1fb94610","68941fc0fb5e4bed1fb946cb","68941fc1fb5e4bed1fb9473d","68941fc1fb5e4bed1fb94870","68941fc1fb5e4bed1fb948ef","68941fc1fb5e4bed1fb94975","68941fc1fb5e4bed1fb949d2","68a2a04dfb5e4bed1fbe5976","68a3f1c4fb5e4bed1fd65194","68aba988c3af739f2572b913","68acfb09c3af739f25c89ec7","68b6358ac3af739f259e2b1d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Shell Rock 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\":42.71229934692383,\"lng\":-92.58070373535156,\"latlng\":\"42.712299346924,-92.580703735352\",\"city\":\"Shell Rock\",\"state\":\"IA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.13300000 1765870000)","created":"MongoDate(0.13300000 1765870000)"} , true)	0	9
12	db.towns.find( {"sef_url":"shell-rock-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
13	db.tokens.find( {"sef_url":{"$in":["usa","ia","butler-county-ia","shell-rock-ia"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Shell Rock

Iowa

Shell Rock Featured Events

Cherish the Ladies

Waterloo Black Hawks vs. Madison Capitols

Waterloo Black Hawks vs. Sioux City Musketeers

Waterloo Black Hawks vs. Des Moines Buccaneers

Waterloo Black Hawks vs. Madison Capitols

Waterloo Black Hawks vs. Omaha Lancers

Waterloo Black Hawks vs. Tri-City Storm

Waterloo Black Hawks vs. Tri-City Storm

Waterloo Black Hawks vs. Sioux Falls Stampede

Waterloo Black Hawks vs. Sioux Falls Stampede

Waterloo Black Hawks vs. Chicago Steel

Waterloo Black Hawks vs. Cedar Rapids Roughriders

Waterloo Black Hawks vs. Youngstown Phantoms

Waterloo Black Hawks vs. Youngstown Phantoms

Waterloo Black Hawks vs. Dubuque Fighting Saints

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.

Shell Rock 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.