Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"kings-park-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"halltown-mo"}, [] ).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":"0a832fba32ff576c37b8da5526ac9468"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"b76f92a328cde4a693649aea7afbcdc4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"halltown-mo","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.62529754638672,37.19340133666992],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	0	19
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.62529754638672,37.19340133666992],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	0	18
11	db.events_radius_cache.count( {"_id":"b76f92a328cde4a693649aea7afbcdc4"} )	0	1
12	db.events_radius_cache.count( {"_id":"b76f92a328cde4a693649aea7afbcdc4"} )	0	1
13	db.events_radius_cache.insert( {"_id":"b76f92a328cde4a693649aea7afbcdc4","radius":25,"modified":"MongoDate(0.15000000 1766423738)","created":"MongoDate(0.15100000 1766423738)"} , true)	0	2
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-93.62529754638672,37.19340133666992],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	198
15	db.events_cache.count( {"_id":"0a832fba32ff576c37b8da5526ac9468"} )	0	1
16	db.events_cache.count( {"_id":"0a832fba32ff576c37b8da5526ac9468"} )	0	1
17	db.events_cache.insert( {"_id":"0a832fba32ff576c37b8da5526ac9468","town_sef_url":"halltown-mo","data_key":["685e5a0ffb5e4bed1f6210eb","68639fe7fb5e4bed1fa5cd6d","68679452fb5e4bed1f097e88","6870cf2afb5e4bed1f090dd7","687a097cfb5e4bed1ff194c2","68834432fb5e4bed1f22690d","6933cbd8de4ae56f5a4a74b1","688c10c4fb5e4bed1f0bf899","6933cbd9de4ae56f5a4a78cc","691d6255de4ae56f5ae88cad","6895714afb5e4bed1fd777bc","68ef05a0c3af739f254c09f0","68cf99e5c3af739f25419c49","689eabbefb5e4bed1f7b424b","68f08f62c3af739f25cf315e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Halltown 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.19340133666992,\"lng\":-93.62529754638672,\"latlng\":\"37.19340133667,-93.625297546387\",\"city\":\"Halltown\",\"state\":\"MO\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.44500000 1766423738)","created":"MongoDate(0.44500000 1766423738)"} , true)	0	2
18	db.towns.find( {"sef_url":"halltown-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","mo","lawrence-county-mo","halltown-mo"]}}, [] ).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

Halltown

Missouri

Halltown Featured Events

TOPS Chapter Meeting

Greater Springfield Farmer's Market

TOPS Chapter Meeting

TOPS Chapter Meeting

TOPS Chapter Meeting

TOPS Chapter Meeting

Playstation the Concert

TOPS Chapter Meeting

The Barricade Boys

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

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.

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