Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"chatham-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"chatham-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
4	db.tokens.find( {"sef_url":{"$in":["usa","nh","carroll-county-nh","chatham-nh"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"chatham-nh"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	2	5
6	db.events_cache.find( {"_id":"b52ba55d14adef869ba805446ddc3dc7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
7	db.events.find( {"_id":{"$in":[ObjectId ("69036ade4389be6be5f5f502"),ObjectId ("69036adf4389be6be5f5fb2f"),ObjectId ("693321074389be6be5655c7e"),ObjectId ("69036af24389be6be5f66b63"),ObjectId ("69036af84389be6be5f698ed"),ObjectId ("69036b0d4389be6be5f72839"),ObjectId ("69036b124389be6be5f74eb1"),ObjectId ("69036b204389be6be5f7ad49"),ObjectId ("693321294389be6be5666bcc"),ObjectId ("693321334389be6be566a737")]}}, [] ).sort( {"start":1} ).limit( 11 ).skip( 0 )	10	3

Chatham

Chatham Groups and Organizations