Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"republic-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"republic-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","mo","greene-county-mo","republic-mo"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"008800483f0ed726149fd29abdf58372"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"bc42b771cca0e406bda0a005f8dac1a5"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.count( {"address.town_sef_url":"republic-mo","start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	3
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.47350311279297,37.1161994934082],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	0	32
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.47350311279297,37.1161994934082],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	2	29
9	db.events_radius_cache.count( {"_id":"bc42b771cca0e406bda0a005f8dac1a5"} )	0	1
10	db.events_radius_cache.insert( {"_id":"bc42b771cca0e406bda0a005f8dac1a5","radius":25,"modified":"MongoDate(0.39700000 1766882221)","created":"MongoDate(0.39700000 1766882221)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"geo":{"$geoWithin":{"$center":[[-93.47350311279297,37.1161994934082],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	305
12	db.events_cache.count( {"_id":"008800483f0ed726149fd29abdf58372"} )	0	1
13	db.events_cache.count( {"_id":"008800483f0ed726149fd29abdf58372"} )	0	1
14	db.events_cache.insert( {"_id":"008800483f0ed726149fd29abdf58372","town_sef_url":"republic-mo","data_key":["68a75b6903a70639b6cf4aef","68a75b6d03a70639b6cf604a","68a75b7003a70639b6cf74f3","68a75b7203a70639b6cf8632","68a75b7403a70639b6cf9559","68a75b7603a70639b6cfa5d5","693321114389be6be565a724","68a75b7803a70639b6cfb7bd","69036afc4389be6be5f6b59a","69036afd4389be6be5f6c0a1","68a75b7a03a70639b6cfc7a9","69036afe4389be6be5f6c93e","69036afe4389be6be5f6ca4b","69036b014389be6be5f6e0c4","69036b044389be6be5f6ee04"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Republic 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\":37.1161994934082,\"lng\":-93.47350311279297,\"latlng\":\"37.116199493408,-93.473503112793\",\"city\":\"Republic\",\"state\":\"MO\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.73200000 1766882221)","created":"MongoDate(0.73200000 1766882221)"} , true)	0	3

Republic

Missouri

Republic Featured Events

Greater Springfield Farmer's Market

TOPS Chapter Meeting

TOPS Chapter Meeting

TOPS Chapter Meeting

TOPS Chapter Meeting

TOPS Chapter Meeting

Van Full of Nuns and Offended By Everything

TOPS Chapter Meeting

Shlump: The Chronicles of Shlump Tour

49 Winchester and Cole Chaney

TOPS Chapter Meeting

The Last Revel

Sons Of Legion - Soul To Søl Tour

TOPS Chapter Meeting

No Resolve, Shallow Side and more

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.

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