| 1 | db.towns.find( {"sef_url":"hamill-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.towns.find( {"sef_url":"hamill-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.tokens.find( {"sef_url":{"$in":["usa","sd","tripp-county-sd","hamill-sd"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 4 | db.ttd_towns.find( {"town_sef_url":"hamill-sd","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 5 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 6 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-99.67970275878906,43.59349822998047],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"SD"}}},{"$project":{"title":1,"homepage_title":1,"tags":1,"image_url":1,"distance":1,"page_path":1,"path":1,"article_hostname":1,"text":1,"publish_date":1,"site_canonical":1,"sections.title":1,"sections.geo":1,"sections.text":1}},{"$addFields":{"days_since":{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766774825825)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766774825825)","$publish_date"]},86400000]}]}}},{"$sort":{"relevance_score":1,"_id":1}},{"$skip":0},{"$limit":11}]}, ["article_id","title","homepage_title","tags","image_url","path","article_hostname","sef_tail","page_path","text","publish_date","site_canonical","sections.title","sections.text"] ).sort( {"relevance_score":1,"_id":1} ).limit( 11 ).skip( 0 ) | | 0 | 11 | 81 |
| 7 | db.ttd_towns.find( {"town_sef_url":"hamill-sd","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 8 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.events_cache.find( {"_id":"aba4d0e7d942f4998042f128d5b30ac3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.events_cache.find( {"_id":"4658b6b58204f93508e07546769537d3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 11 | db.events_cache.find( {"_id":"131460693afa4d086d299fff5fc36c0e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 12 | db.events_cache.find( {"_id":"7039d3761bfc99510a187c8e71569dc5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"c50fa080b3f508193369429f42826571"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 14 | db.events_cache.find( {"_id":"a35ce25dd690d6d1ee23d5ad03c66bdb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 15 | db.events_cache.find( {"_id":"919ee9aa22f06fd6ac71022272d9e818"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 16 | db.events_cache.find( {"_id":"1a03e4b5478deb3ee55e94d7684993ec"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 17 | db.events_cache.find( {"_id":"c1ba5a8d1a81d9da23e768333e08686c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 18 | db.events_cache.find( {"_id":"1eee8cd02e4cdf033686694494ef8bfc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 19 | db.events_cache.find( {"_id":"f7da8f9be1bc4eb78ed675b893a1367f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 20 | db.events_cache.find( {"_id":"59b1fea68f9794645048bb8664e7196f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 21 | db.events_cache.find( {"_id":"6941ab516f306100c9bb3fdfdb284a2c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 22 | db.places.find( {"geo":{"$near":[-99.67970275878906,43.59349822998047],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 0 | 2 |
| 23 | db.events_cache.find( {"_id":"bda60217b3b28cb38cb23fe12053d2d5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 24 | db.news.find( {"broadcast":{"$in":["usa","hamill-sd","sd","tripp-county-sd"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 3 |
| 25 | db.places.find( {"address.town_sef_url":"hamill-sd","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 0 | 2 |