| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| db.seo_routers.find( [], [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 1254 | 0 | |
| db.banners.find( {"status":2}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 4 | 1 | maybe slow |
| db.regions.find( {"parent":{"$ne":""}}, ["code","name"] ).sort( {"code":1} ).limit( 0 ).skip( 0 ) | | 37 | 1 | |
| db.region_weekly_spins.find( {"region_code":"matran"}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 7 | 1 | maybe slow |
| db.regions.find( {"code":"mientrung"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 0 | |
| db.date_results.find( {"region_code":"mientrung","date":20190425}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | | 1 | maybe slow |
| db.regions.find( {"code":"mientrung"}, ["weekly_spin_details"] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 0 | |
| db.regions.find( {"code":"mientrung"}, ["weekly_spin_details","code"] ).sort( {"weight":1} ).limit( 0 ).skip( 0 ) | | 1 | 0 | |
| db.date_results.find( {"region_code":{"$in":["binhdinh","danang","daclac","dacnong","gialai","khanhhoa","kontum","ninhthuan","phuyen","quangbinh","quangngai","quangnam","quangtri","thuathienhue"]},"date":20190425}, ["date","region_code","numbers","lotos","realtime_numbers"] ).sort( {"date":-1} ).limit( 0 ).skip( 0 ) | | 3 | 1 | maybe slow |
| db.date_results.find( {"region_code":{"$in":["binhdinh","danang","daclac","dacnong","gialai","khanhhoa","kontum","ninhthuan","phuyen","quangbinh","quangngai","quangnam","quangtri","thuathienhue"]},"date":20190424}, ["date","region_code","numbers","lotos","realtime_numbers"] ).sort( {"date":-1} ).limit( 0 ).skip( 0 ) | | 2 | 1 | maybe slow |
| db.date_results.find( {"region_code":{"$in":["binhdinh","danang","daclac","dacnong","gialai","khanhhoa","kontum","ninhthuan","phuyen","quangbinh","quangngai","quangnam","quangtri","thuathienhue"]},"date":20190423}, ["date","region_code","numbers","lotos","realtime_numbers"] ).sort( {"date":-1} ).limit( 0 ).skip( 0 ) | | 2 | 1 | maybe slow |
| db.themes.find( {"status":2,"type":"WAP"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 1 | |
| db.tag_counters.find( [], ["id","name_ascii"] ).sort( {"count":-1} ).limit( 10 ).skip( 0 ) | | 10 | 0 | |
| db.menu_links.find( {"status":1,"menu_code":{"$in":["TOP_WAP","BOTTOM_WAP","LEFT_WAP"]},"$or":[{"parent":null},{"parent":""}]}, [] ).sort( {"weight":1} ).limit( 0 ).skip( 0 ) | | 24 | 1 | |
| db.menu_links.find( {"parent":"598a66623407152d6dd1b0e9","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5c0095d769e8b64ea454f5ae","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"57849786781ecff8f3ef470f","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"572c0d4c742a88fc1b00002a","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5c0095d769e8b64ea454f5ab","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5784982c781ecf7423ef43a5","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5c0095d769e8b64ea454f5ac","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5cc0348c340715ed4ed384fa","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5cc035043407152c43d384f3","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"584b67873407150a3462860d","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 1 | maybe slow |
| db.menu_links.find( {"parent":"584b6b3f3407150b09628607","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"56b05180781ecfb4acb054ad","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 1 | maybe slow |
| db.menu_links.find( {"parent":"5812af8a34071584565eb888","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5c0095d769e8b64ea454f5ad","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"57849a21781ecff5f3ef466c","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"598a64d83407150b29d1b0e9","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 6 | 0 | |
| db.menu_links.find( {"parent":"5bffb704340715ee3f7fdf7c","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"56c7cf79781ecfde77b05475","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 5 | 0 | |
| db.menu_links.find( {"parent":"56b0879f781ecfc8bcb05cc2","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 1 | maybe slow |
| db.menu_links.find( {"parent":"56b087c3781ecfa9b2b054d9","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"5abc6f253407157a6c2ce64a","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"57859f09742a888c1a000029","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"57849aff781ecf5125ef43ff","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"parent":"592be1edc236bb081a0000ca","status":1}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 0 | |
| db.menu_links.find( {"seo_url":"\/xsvn\/xsmt.html"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | | 0 | |
CTKM
