(mongo) 7 queries took 15 ms
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | db.towns.find( {"sef_url":"mammoth-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/shops-and-stores"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"mammoth-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","pa","westmoreland-county-pa","mammoth-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 5 | db.places.find( {"address.town_sef_url":"mammoth-pa","tags":"shops-and-stores"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 ) | | 0 | 0 | 2 |
| 6 | db.events_cache.find( {"_id":"d8dadcd2c392d9e6ee8c958d0447d3e8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 7 | db.events.find( {"_id":{"$in":[ObjectId ("68a75b7003a70639b6cf7857"),ObjectId ("68a75b7203a70639b6cf84ec"),ObjectId ("68a75b7203a70639b6cf899d"),ObjectId ("68a75b7403a70639b6cf9450"),ObjectId ("68a75b7403a70639b6cf9804"),ObjectId ("68a75b7603a70639b6cfa4c1"),ObjectId ("68a75b7703a70639b6cfa966"),ObjectId ("68a75b7803a70639b6cfb68a"),ObjectId ("68a75b7903a70639b6cfbb83"),ObjectId ("68a75b7a03a70639b6cfc6ca")]}}, [] ).sort( {"start":1} ).limit( 11 ).skip( 0 ) | | 0 | 10 | 3 |
HTTP_HOST: www.devel1.americantowns.com
SERVER_NAME: www.devel1.americantowns.com
