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

Movie Timesfor Nipomo, CA

Regal Edwards Santa Maria & RPX