Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"black-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"bothell-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/clubs-and-organizations"]},"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.places.find( {"address.town_sef_url":"bothell-wa","tags":"clubs-and-organizations"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	14	2
7	db.events_cache.find( {"_id":"2b6e52bd3175025321e959fc20d54526"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"2b7ab3a7d41a86f68052fc515e8e3d03"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-122.20700073242188,47.7598991394043],0.21739130434782608]}}}, ["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	29
10	db.events_cache.count( {"_id":"2b6e52bd3175025321e959fc20d54526"} )	0	1
11	db.events_cache.count( {"_id":"2b6e52bd3175025321e959fc20d54526"} )	0	1
12	db.events_cache.insert( {"_id":"2b6e52bd3175025321e959fc20d54526","town_sef_url":"bothell-wa","data_key":["691c7616ec25c3702a0045c4","68fd53781838ffc2f0001ea9","686f7d65fb5e4bed1fed3250","68edb41cc3af739f2514bd13","685e5a1cfb5e4bed1f6227d9","68fb1b5cc3af739f2516536c","691c7616ec25c3702a0045c5","685fab7afb5e4bed1fb55733","686f7d65fb5e4bed1fed330f","68fd5eec293763705803efaf"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"clubs-and-organizations\",\"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.7598991394043,\"lng\":-122.20700073242188,\"latlng\":\"47.759899139404,-122.20700073242\",\"city\":\"Bothell\",\"state\":\"WA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.60900000 1766496164)","created":"MongoDate(0.60900000 1766496164)"} , true)	0	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Bothell

Washington

Bothell Groups and Organizations

Beardslee Public House

Bothell American Legion Post 127

Canyon Ridge Farm

Donna's Trees

Eastside Runners-Bothell Landing

Foggy Noggin Brewing

Greater Bothell Chamber Of Commerce

Greater Bothell Chamber Of Commerce

McMenamin's - Anderson School

MediaPro, Inc.

Northshore Rotary Club

Northshore Senior Center

Open Road Wine Company

Watts Brewing Company

Local Events

Seattle Christmas Market

WildLanterns - A New Lights Festival

The Jinkx & DeLa Holiday Show

Seattle Torrent vs. Montréal Victoire

Disney Presents The Lion King (Touring)

13 ‘Til Midnight (Tribute to Taylor Swift)

Seattle Christmas Market

Disney Presents The Lion King (Touring)

The Jinkx & DeLa Holiday Show

Sheraton Grand Seattle Gingerbread Village