(mongo) 7 queries took 40 ms
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | db.towns.find( {"sef_url":"philadelphia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.towns.find( {"sef_url":"roseville-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.pages.find( {"type":"town","slug":{"$in":["local-businesses","local-businesses\/business-and-professional"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 11 |
| 4 | db.towns.find( {"sef_url":"roseville-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.tokens.find( {"sef_url":{"$in":["usa","ca","placer-county-ca","roseville-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
| 6 | db.categories.find( {"group_type":"business"}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 7 |
| 7 | db.places.find( {"address.town_sef_url":"roseville-ca","tags":"business-and-professional","group_type":"business"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 ) | | 0 | 2 | 14 |
HTTP_HOST: www.devel1.americantowns.com
SERVER_NAME: www.devel1.americantowns.com
