Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"goffstown-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"hanscom-afb-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.pages.find( {"type":"town","slug":{"$in":["movie-times"]},"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.towns.find( {"sef_url":"hanscom-afb-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
7	db.tokens.find( {"sef_url":{"$in":["usa","ma","middlesex-county-ma","hanscom-afb-ma"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
8	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
10	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
11	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
14	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Movie Timesfor Hanscom AFB, MA

Harvard Film Archive