(mongo) 12 queries took 186 ms
Nr | Query | Error | Affected | Num. rows | Took (ms) |
1 | db.sites.find( {"hostname":{"$in":["bestthingsct.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 7 |
2 | db.towns.find( {"sef_url":"east-killingly-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
3 | db.pages.find( {"type":"town","slug":{"$in":["cross-country-skiing-trail"]},"site.hostname":"bestthingsct.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
4 | db.modules.find( {"name":{"$in":["BTS - Main Header","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
5 | db.places.find( {"geo":{"$near":[-71.8197021484375,41.849098205566406],"$maxDistance":1.4492753623188406},"tags":"ski-resorts","address.state":"CT"}, [] ).sort( [] ).limit( 16 ).skip( 0 ) | | 0 | 3 | 164 |
6 | db.modules.find( {"name":"BTS - Town Page - Find it Fast"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
7 | db.modules.find( {"name":"BTS - State Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
8 | db.states.find( {"sef_url":"ct"}, ["name","sef_url","towns"] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
9 | db.modules.find( {"name":"BTS - Ad"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
10 | db.modules.find( {"name":"footer menu"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
11 | db.modules.find( {"name":"BTS - State List"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
12 | db.states.find( {"state":{"$nin":["DC"]}}, ["sef_url","name"] ).sort( {"name":1} ).limit( 0 ).skip( 0 ) | | 0 | 50 | 2 |
HTTP_HOST: bestthingsct.com.devel4.localword.com
SERVER_NAME: bestthingsct.com.devel4.localword.com