(mongo) 7 queries took 17 ms
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | db.towns.find( {"sef_url":"swayzee-in"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 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":"swayzee-in"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","in","grant-county-in","swayzee-in"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 5 | db.places.find( {"address.town_sef_url":"swayzee-in"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 ) | | 0 | 2 | 2 |
| 6 | db.events_cache.find( {"_id":"f74f8c9347a1765b59303223d37b2b67"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 7 | db.events.find( {"_id":{"$in":[ObjectId ("69036ade4389be6be5f5f384"),ObjectId ("68a75b6203a70639b6cf1a8b"),ObjectId ("693321044389be6be56541ac"),ObjectId ("6933210d4389be6be565853b"),ObjectId ("693321114389be6be565a5d4"),ObjectId ("693321124389be6be565ad01"),ObjectId ("693321134389be6be565b5b3"),ObjectId ("68a75b7b03a70639b6cfce26"),ObjectId ("693321184389be6be565e3ca"),ObjectId ("69036b174389be6be5f7702e")]}}, [] ).sort( {"start":1} ).limit( 11 ).skip( 0 ) | | 0 | 10 | 3 |
HTTP_HOST: www.devel1.americantowns.com
SERVER_NAME: www.devel1.americantowns.com
Read More »
Read More »