Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"graham-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"graham-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","wa","pierce-county-wa","graham-wa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	17
5	db.events_cache.find( {"_id":"2a789644308e4a02d49ed44e0988e4c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	19
6	db.events_radius_cache.find( {"_id":"fd7e78f7bfbf8ac262b313c7a060ece2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events.count( {"address.town_sef_url":"graham-wa","start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768284000)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-122.29499816894531,47.0531005859375],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	0	20
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-122.29499816894531,47.0531005859375],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	0	17
10	db.events_radius_cache.count( {"_id":"fd7e78f7bfbf8ac262b313c7a060ece2"} )	0	1
11	db.events_radius_cache.insert( {"_id":"fd7e78f7bfbf8ac262b313c7a060ece2","radius":25,"modified":"MongoDate(0.09800000 1767716407)","created":"MongoDate(0.09800000 1767716407)"} , true)	0	13
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767679200)"},"geo":{"$geoWithin":{"$center":[[-122.29499816894531,47.0531005859375],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	19
13	db.events_cache.count( {"_id":"2a789644308e4a02d49ed44e0988e4c8"} )	0	2
14	db.events_cache.count( {"_id":"2a789644308e4a02d49ed44e0988e4c8"} )	0	2
15	db.events_cache.insert( {"_id":"2a789644308e4a02d49ed44e0988e4c8","town_sef_url":"graham-wa","data_key":["6933210b4389be6be56571a8","69036af24389be6be5f66759","69036af24389be6be5f667f6","69036af24389be6be5f6664f","69036af24389be6be5f66bcd","69036af34389be6be5f66d1a","69036af34389be6be5f66e15","69036af34389be6be5f6730d","69036af34389be6be5f67471","69036af54389be6be5f67e60","69036af54389be6be5f680c9","69036af54389be6be5f681cd","68a75b7503a70639b6cfa0dc","693321104389be6be5659a13","68a75b7503a70639b6cfa36a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Graham 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\":47.0531005859375,\"lng\":-122.29499816894531,\"latlng\":\"47.053100585938,-122.29499816895\",\"city\":\"Graham\",\"state\":\"WA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.16500000 1767716407)","created":"MongoDate(0.16500000 1767716407)"} , true)	0	2

Graham

Washington

Graham Featured Events

Mickey Avalon, Indica Jones and more

Monster Jam

Seattle Thunderbirds vs. Moose Jaw Warriors

Pat Travers Band

Monster Jam

Seattle Thunderbirds vs. Portland Winterhawks

Monster Jam

Monster Jam

Monster Jam

Anjelah Johnson-Reyes: The Family Reunion Tour

Tom Papa: Grateful Bread Tour

Seattle Thunderbirds vs. Kelowna Rockets

Northwest Sinfonietta: WAYFARER

Shady B, Just Cos and more

Northwest Sinfonietta: WAYFARER

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.

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