(mongo) 6 queries took 68 ms
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | db.towns.find( {"sef_url":"baltimore-md"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 6 |
| 2 | db.pages.find( {"type":"town","slug":{"$in":["local-businesses","local-businesses\/real-estate"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.towns.find( {"sef_url":"baltimore-md"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","md","baltimore-city-county-md","baltimore-md"]}}, [] ).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":"baltimore-md","tags":"real-estate","group_type":"business"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 ) | | 0 | 1 | 54 |
HTTP_HOST: www.devel1.americantowns.com
SERVER_NAME: www.devel1.americantowns.com
