Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"bethlehem-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"spokane-wa"}, [] ).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	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"35531e18b4f1f204e68e3914cb271929"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"a8650dfedbb218ce3cdbdff669deedd7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"spokane-wa","start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770616800)"}} )	14	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-117.41100311279297,47.653499603271484],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770876000)"}} )	17	28
10	db.events_radius_cache.count( {"_id":"a8650dfedbb218ce3cdbdff669deedd7"} )	0	1
11	db.events_radius_cache.count( {"_id":"a8650dfedbb218ce3cdbdff669deedd7"} )	0	1
12	db.events_radius_cache.insert( {"_id":"a8650dfedbb218ce3cdbdff669deedd7","radius":7,"modified":"MongoDate(0.18000000 1770027097)","created":"MongoDate(0.18000000 1770027097)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1770012000)"},"geo":{"$geoWithin":{"$center":[[-117.41100311279297,47.653499603271484],0.10144927536231885]}}}, ["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	12
14	db.events_cache.count( {"_id":"35531e18b4f1f204e68e3914cb271929"} )	0	1
15	db.events_cache.count( {"_id":"35531e18b4f1f204e68e3914cb271929"} )	0	1
16	db.events_cache.insert( {"_id":"35531e18b4f1f204e68e3914cb271929","town_sef_url":"spokane-wa","data_key":["693a2b13de4ae56f5a8b0d78","68c0e125c3af739f253dd239","69211e9bde4ae56f5af9cdaf","693a2b13de4ae56f5a8b0d9b","693a2b13de4ae56f5a8b0de3","68bd24e6c3af739f25f54b30","68c4d5a8c3af739f2596e71b","693a2b13de4ae56f5a8b0e3d","695dc38eb1faf7c56a6c0cec","693a2b13de4ae56f5a8b0e7a","693a2b13de4ae56f5a8b0eac","692f9f13de4ae56f5a52377a","693a2b13de4ae56f5a8b0ef0","693a2b13de4ae56f5a8b0f22","68c0e125c3af739f253dd3d6"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Spokane Featured Events\",\"keyword\":\"\",\"radius\":7,\"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.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.22700000 1770027097)","created":"MongoDate(0.22700000 1770027097)"} , true)	0	2
17	db.towns.find( {"sef_url":"spokane-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
18	db.tokens.find( {"sef_url":{"$in":["usa","wa","spokane-county-wa","spokane-wa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Spokane

Washington

Spokane Featured Events

The Lion King (Touring)

Spokane Chiefs vs. Penticton Vees

Whitey Morgan and the 78's

The Lion King (Touring)

The Lion King (Touring)

Vitamin String Quartet

Vitamin String Quartet: The Music of Billie Eilish, Bridgerton and Beyond

The Lion King (Touring)

Stan Society Presents Justin Bieber Night

The Lion King (Touring)

The Lion King (Touring)

The Expendables

The Lion King (Touring)

The Lion King (Touring)

Spokane Chiefs vs. Seattle Thunderbirds

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.

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