(mongo) 8 queries took 25 ms
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
| 1 | db.towns.find( {"sef_url":"huston-id"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.events.find( {"sef_tail":"pittsburgh-pirates-vs-cincinnati-reds-2026-05-02-tm-pittsburgh-pa.html"}, [] ).sort( [] ).limit( 2 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"sef_tail":{"$ne":"pittsburgh-pirates-vs-cincinnati-reds-2026-05-02-tm-pittsburgh-pa.html"},"title":"Pittsburgh Pirates vs. Cincinnati Reds","venue_name":"PNC Park","address.city":"Pittsburgh","address.state":"PA"}, ["start","date_string","sef_tail","tags"] ).sort( {"start":1} ).limit( 0 ).skip( 0 ) | | 0 | 2 | 2 |
| 4 | db.pages.find( {"type":"content","slug":{"$in":["event-detail","event-detail\/pittsburgh-pirates-vs-cincinnati-reds-2026-05-02-tm-pittsburgh-pa.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 13 |
| 5 | db.towns.find( {"sef_url":"huston-id"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 6 | db.tokens.find( {"sef_url":{"$in":["usa","id","canyon-county-id","huston-id"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 7 | db.venues.find( {"venue_id":613044}, [] ).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