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