Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mammoth-cave-ky"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
3	db.towns.find( {"sef_url":"coldwater-ms"}, [] ).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	11
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	11
6	db.events_cache.find( {"_id":"8b388d0b5d315ca8b4a9e0a40ee1f7ab"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	7
7	db.events_radius_cache.find( {"_id":"edbc12a3e1bf6e733df3109b34a10ee3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-89.97470092773438,34.699798583984375],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	652
9	db.events_cache.count( {"_id":"8b388d0b5d315ca8b4a9e0a40ee1f7ab"} )	0	3
10	db.events_cache.count( {"_id":"8b388d0b5d315ca8b4a9e0a40ee1f7ab"} )	0	6
11	db.events_cache.insert( {"_id":"8b388d0b5d315ca8b4a9e0a40ee1f7ab","town_sef_url":"coldwater-ms","data_key":["68e5cb1fc3af739f25c77bcb","68e5cb1fc3af739f25c77c9f","68e5cb1fc3af739f25c78087","68e5cb1fc3af739f25c780ad","69339393de4ae56f5aea2c44","69339393de4ae56f5aea2c6d","68fb1b5dc3af739f251656c3","68e5cb1fc3af739f25c7848c","68e5cb20c3af739f25c787b2","68e5cb20c3af739f25c78900","68e5cb20c3af739f25c7895e","68e5cb20c3af739f25c789d0","69151362de4ae56f5a4fa359","69154118de4ae56f5aae02c7","68e5cb20c3af739f25c78cc8"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Coldwater 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\":34.699798583984375,\"lng\":-89.97470092773438,\"latlng\":\"34.699798583984,-89.974700927734\",\"city\":\"Coldwater\",\"state\":\"MS\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.05500000 1765801306)","created":"MongoDate(0.05500000 1765801306)"} , true)	0	11
12	db.towns.find( {"sef_url":"coldwater-ms"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	16
13	db.tokens.find( {"sef_url":{"$in":["usa","ms","tate-county-ms","coldwater-ms"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	4
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
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	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Coldwater

Mississippi

Coldwater Featured Events

Memphis Hustle vs. Valley Suns

Memphis Hustle vs. Valley Suns

Memphis Hustle vs. Sioux Falls Skyforce

Memphis Hustle vs. Texas Legends

Rodeo Of The Mid-South

Rodeo Of The Mid-South

Lorrie Morgan and Pam Tillis

Memphis Hustle vs. Stockton Kings

Memphis Hustle vs. San Diego Clippers

Memphis Hustle vs. San Diego Clippers

Memphis Hustle vs. Santa Cruz Warriors

Memphis Hustle vs. Santa Cruz Warriors

John Mulaney

John Mulaney: Mister Whatever

Memphis Hustle vs. Stockton Kings

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.

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