Query | Affected | Num. rows | Took (ms) | Actions |
---|
db.regions.find( {"lang_code":"vi","_id":ObjectId ("5555bee2c4a1608e6e9a1610")}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 1 | |
db.hotels.find( {"status":2,"lang_code":"vi","_id":ObjectId ("57334bd3887b66344f28aec4")}, ["room_sale_pct","room_price","room_sale_price","room_sale_retain","id","name","address","short_description","description","email","website","tel","file_uris","loc","standard_rate","location","facilities","rating","import_source","source"] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 1 | |
db.streamings.find( {"object_type":ObjectId ("55502527a37d739c0b000029"),"object_id":ObjectId ("57334bd3887b66344f28aec4")}, ["id","name","file_path","file_size","duration","resolution_w","resolution_h","bitrate","file_mime","file_uris"] ).sort( [] ).limit( 0 ).skip( 0 ) | | | 2 | maybe slow |
db.weathers.find( {"region":ObjectId ("5555bef3c4a1608e6e9a1644")}, ["type","informations","current"] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 1 | |
db.weather_descriptions.find( {"code":"39"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 1 | |
db.weather_descriptions.find( {"code":"39"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 1 | 1 | |
db.facilities.find( {"_id":{"$in":[ObjectId ("5577f22ac4a160c5f7554a74"),ObjectId ("5577f2c5c4a160dafb554a75"),ObjectId ("557fa43b887b6671541130f6"),ObjectId ("5577f311c4a160e0f8554a75"),ObjectId ("5577f327c4a16047fb554a74"),ObjectId ("5577f350c4a16041f6554a75"),ObjectId ("5577f361c4a160d5f8554a75"),ObjectId ("5577f3b0c4a160d1f4554a74"),ObjectId ("5577f3e5c4a16090fb554a75"),ObjectId ("5577f3f5c4a160eff8554a75"),ObjectId ("5577f41ac4a16090fb554a76"),ObjectId ("5577f441c4a160d1f4554a75"),ObjectId ("5577f4f7c4a16090fb554a78"),ObjectId ("5577f528c4a16041f6554a76"),ObjectId ("5577f539c4a160a0fb554a75"),ObjectId ("5577f5c6c4a160bcf8554a75"),ObjectId ("5577f5e4c4a160eff8554a78")]}}, ["name","file_uris","id"] ).sort( [] ).limit( 0 ).skip( 0 ) | | 17 | 1 | maybe slow |
db.hotels.count( {"status":2,"loc":{"$near":{"$geometry":{"type":"Point","coordinates":[105.690823,18.673877]},"$maxDistance":2000}},"lang_code":"vi","_id":{"$ne":ObjectId ("57334bd3887b66344f28aec4")}} ) | | 15 | 1 | maybe slow |