Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"springfield-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"springfield-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","mo","greene-county-mo","springfield-mo"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"59012238c5a0b337cb325fb0ae4cab32"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"5dedec1924c957f62200dd2630cdb623"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events.count( {"address.town_sef_url":"springfield-mo","start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766469600)"}} )	4	3
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.28710174560547,37.196800231933594],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	5	38
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.28710174560547,37.196800231933594],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	5	40
10	db.events_radius_cache.count( {"_id":"5dedec1924c957f62200dd2630cdb623"} )	0	1
11	db.events_radius_cache.insert( {"_id":"5dedec1924c957f62200dd2630cdb623","radius":25,"modified":"MongoDate(0.14600000 1765915081)","created":"MongoDate(0.14600000 1765915081)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-93.28710174560547,37.196800231933594],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	325
13	db.events_cache.count( {"_id":"59012238c5a0b337cb325fb0ae4cab32"} )	0	1
14	db.events_cache.count( {"_id":"59012238c5a0b337cb325fb0ae4cab32"} )	0	2
15	db.events_cache.insert( {"_id":"59012238c5a0b337cb325fb0ae4cab32","town_sef_url":"springfield-mo","data_key":["68a75b5d03a70639b6cf0576","68a75b5f03a70639b6cf0f2c","68a75b6003a70639b6cf14e7","68a75b6203a70639b6cf20af","68a75b6703a70639b6cf3a53","68a75b6903a70639b6cf4aef","68a75b6d03a70639b6cf604a","68a75b7003a70639b6cf74f3","68a75b7203a70639b6cf8632","68a75b7403a70639b6cf9559","68a75b7603a70639b6cfa5d5","693321114389be6be565a724","68a75b7803a70639b6cfb7bd","69036afc4389be6be5f6b59a","69036afd4389be6be5f6c0a1"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Springfield 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.196800231933594,\"lng\":-93.28710174560547,\"latlng\":\"37.196800231934,-93.287101745605\",\"city\":\"Springfield\",\"state\":\"MO\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.50100000 1765915081)","created":"MongoDate(0.50100000 1765915081)"} , true)	0	2

Springfield

Missouri

Springfield Featured Events

TOPS Chapter Meeting

Arkansauce

Ancient Aliens Live

Greater Springfield Farmer's Market

TOPS Chapter Meeting

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

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.

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