(mongo) 8 queries took 25 ms
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | db.events.find( {"sef_tail":"the-magical-music-of-harry-potter-live-in-concert-2026-04-05-tm-dubuque-ia.html"}, [] ).sort( [] ).limit( 2 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"sef_tail":{"$ne":"the-magical-music-of-harry-potter-live-in-concert-2026-04-05-tm-dubuque-ia.html"},"title":"The Magical Music of Harry Potter - Live in Concert","venue_name":"Five Flags Center","address.city":"Dubuque","address.state":"IA"}, ["start","date_string","sef_tail","tags"] ).sort( {"start":1} ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 3 | db.towns.find( {"sef_url":"dubuque-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"content","slug":{"$in":["event-detail","event-detail\/the-magical-music-of-harry-potter-live-in-concert-2026-04-05-tm-dubuque-ia.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 11 |
| 5 | db.towns.find( {"sef_url":"dubuque-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 6 | db.tokens.find( {"sef_url":{"$in":["usa","ia","dubuque-county-ia","dubuque-ia"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
| 7 | db.venues.find( {"venue_id":188163}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 8 | db.modules.find( {"name":"Share Module"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
HTTP_HOST: www.devel1.americantowns.com
SERVER_NAME: www.devel1.americantowns.com
