(mongo) 7 queries took 21 ms
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | db.towns.find( {"sef_url":"mesa-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.towns.find( {"sef_url":"mesa-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 3 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","wa","franklin-county-wa","mesa-wa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
| 5 | db.places.find( {"address.town_sef_url":"mesa-wa"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 ) | | 0 | 2 | 2 |
| 6 | db.events_cache.find( {"_id":"99f38311f1c466bee65c69aad8cf99bb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 7 | db.events.find( {"_id":{"$in":[ObjectId ("69036b234389be6be5f7c1ae"),ObjectId ("69036b244389be6be5f7c627"),ObjectId ("69036b254389be6be5f7ccae"),ObjectId ("69036b2a4389be6be5f7eb9e"),ObjectId ("69036b2a4389be6be5f7edab"),ObjectId ("69036b2b4389be6be5f7f123"),ObjectId ("69036b2c4389be6be5f7f4eb"),ObjectId ("69036b2d4389be6be5f7f9dc"),ObjectId ("69036b2e4389be6be5f80074"),ObjectId ("69036b314389be6be5f81b80")]}}, [] ).sort( {"start":1} ).limit( 11 ).skip( 0 ) | | 0 | 10 | 6 |
HTTP_HOST: www.devel1.americantowns.com
SERVER_NAME: www.devel1.americantowns.com
Read More »