Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"ariel-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"columbia-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":"8eee06bd11dd87bc26639cdac3578306"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"7eb546e6fbd28b2766d5b21e0063ee0c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	8
8	db.events.count( {"address.town_sef_url":"columbia-sd","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-98.31099700927734,45.61429977416992],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	36
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-98.31099700927734,45.61429977416992],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	36
11	db.events_radius_cache.count( {"_id":"7eb546e6fbd28b2766d5b21e0063ee0c"} )	0	1
12	db.events_radius_cache.count( {"_id":"7eb546e6fbd28b2766d5b21e0063ee0c"} )	0	1
13	db.events_radius_cache.insert( {"_id":"7eb546e6fbd28b2766d5b21e0063ee0c","radius":25,"modified":"MongoDate(0.94700000 1765864591)","created":"MongoDate(0.94700000 1765864591)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-98.31099700927734,45.61429977416992],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	237
15	db.events_cache.count( {"_id":"8eee06bd11dd87bc26639cdac3578306"} )	0	1
16	db.events_cache.count( {"_id":"8eee06bd11dd87bc26639cdac3578306"} )	0	1
17	db.events_cache.insert( {"_id":"8eee06bd11dd87bc26639cdac3578306","town_sef_url":"columbia-sd","data_key":["68d5f927c3af739f259337aa","68d5f927c3af739f259338aa","68d5f927c3af739f25933e1f","68d5f927c3af739f25933e7d","68d5f928c3af739f25933f94","68d5f928c3af739f25933fe8","68d5f928c3af739f259342d3","68d5f928c3af739f2593433d","68d5f928c3af739f25934479","68d5f928c3af739f259344ce","68d5f928c3af739f25934580","68d5f929c3af739f259349b1","68d5f929c3af739f25934a1b","68d9ce04c3af739f253a725c","68db1f7fc3af739f2545564a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Columbia 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\":45.61429977416992,\"lng\":-98.31099700927734,\"latlng\":\"45.61429977417,-98.310997009277\",\"city\":\"Columbia\",\"state\":\"SD\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.42700000 1765864592)","created":"MongoDate(0.42700000 1765864592)"} , true)	0	1
18	db.towns.find( {"sef_url":"columbia-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","sd","brown-county-sd","columbia-sd"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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

Columbia

South Dakota

Columbia Featured Events

Aberdeen Wings vs. Austin Bruins

Aberdeen Wings vs. Austin Bruins

Aberdeen Wings vs. North Iowa Bulls

Aberdeen Wings vs. North Iowa Bulls

Aberdeen Wings vs. Minnesota Mallards

Aberdeen Wings vs. Minnesota Mallards

Aberdeen Wings vs. Bismarck Bobcats

Aberdeen Wings vs. Bismarck Bobcats

Aberdeen Wings vs. Minot Minotauros

Aberdeen Wings vs. Minot Minotauros

Aberdeen Wings vs. Watertown Shamrocks

Aberdeen Wings vs. Austin Bruins

Aberdeen Wings vs. Austin Bruins

Aberdeen Wings vs. St. Cloud Norsemen

Aberdeen Wings vs. St. Cloud Norsemen

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.

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