Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"spokane-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"spokane-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","wa","spokane-county-wa","spokane-wa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.places.find( {"address.town_sef_url":"spokane-wa","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	138
5	db.events_cache.find( {"_id":"2536f7b96411457aec022022e0daef26"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"a8650dfedbb218ce3cdbdff669deedd7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"spokane-wa","start":{"$gte":"MongoDate(0.00000000 1767592800)","$lt":"MongoDate(0.00000000 1768197600)"}} )	3	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-117.41100311279297,47.653499603271484],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767592800)","$lt":"MongoDate(0.00000000 1768456800)"}} )	3	26
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-117.41100311279297,47.653499603271484],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767592800)","$lt":"MongoDate(0.00000000 1768456800)"}} )	3	13
10	db.events_radius_cache.count( {"_id":"a8650dfedbb218ce3cdbdff669deedd7"} )	0	5
11	db.events_radius_cache.insert( {"_id":"a8650dfedbb218ce3cdbdff669deedd7","radius":25,"modified":"MongoDate(0.84900000 1767610854)","created":"MongoDate(0.84900000 1767610854)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767592800)"},"geo":{"$geoWithin":{"$center":[[-117.41100311279297,47.653499603271484],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( 11 ).skip( 0 )	11	8
13	db.events_cache.count( {"_id":"2536f7b96411457aec022022e0daef26"} )	0	1
14	db.events_cache.count( {"_id":"2536f7b96411457aec022022e0daef26"} )	0	1
15	db.events_cache.insert( {"_id":"2536f7b96411457aec022022e0daef26","town_sef_url":"spokane-wa","data_key":["69036aef4389be6be5f65084","69036aef4389be6be5f65383","69036af04389be6be5f657b2","69036af34389be6be5f66d26","69036af44389be6be5f6781f","6933210e4389be6be56590bc","68a75b7503a70639b6cf9a47","68a75b7503a70639b6cf9b6a","69036af54389be6be5f6848d","69036af64389be6be5f688aa"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":47.653499603271484,\"lng\":-117.41100311279297,\"latlng\":\"47.653499603271,-117.41100311279\",\"city\":\"Spokane\",\"state\":\"WA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.88300000 1767610854)","created":"MongoDate(0.88300000 1767610854)"} , true)	0	2

Spokane

Washington

Spokane Groups and Organizations

Argonne Branch Library

East Side Branch Library

East Valley School District No. 361

Gonzaga University

Great Northern School District

HOPE School

Indian Trail Branch Library

Mentoring Children of Promise

Moran Prairie Branch Library

North Spokane Branch Library

Orchard Prairie School District

Shadle Branch Library

South Hill Branch Library

Spokane Community College

Spokane County Library District

Spokane Falls Community College

Spokane HOPE School (Hearing-Oral Program of Excellence)

Spokane Public Library

Spokane Public Library - Downtown Branch

Spokane Public Library - Hillyard Branch

Local Events

Combo Ticket - PBR Pendleton Whisky Velocity Tour

Professional Bull Riders

Professional Bull Riders

Spokane Chiefs vs. Moose Jaw Warriors

The Offspring: SUPERCHARGED Worldwide In '26

Dexter & The Moonrocks, Girl Tones

Jade Eagleson - Coming to a HonkyTonk Near You Tour

Brad Williams: The Tall Tales Tour

Kansas

Spokane Chiefs vs. Kamloops Blazers

COVID-19 Resources