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 ("573ed184887b6603452856a4")}, ["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 ("573ed184887b6603452856a4")}, ["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 ("5555beebc4a1608e6e9a162a")}, ["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 ("5577f2a6c4a1603cfb554a74"),ObjectId ("5577f2c5c4a160dafb554a75"),ObjectId ("5577f2e6c4a160a3fd554a75"),ObjectId ("557fa43b887b6671541130f6"),ObjectId ("5577f311c4a160e0f8554a75"),ObjectId ("5577f327c4a16047fb554a74"),ObjectId ("5577f339c4a160e4fc554a74"),ObjectId ("5577f350c4a16041f6554a75"),ObjectId ("5577f361c4a160d5f8554a75"),ObjectId ("5577f370c4a16063fd554a76"),ObjectId ("5577f391c4a160b6f6554a77"),ObjectId ("5577f3b0c4a160d1f4554a74"),ObjectId ("5577f3c3c4a160b2f8554a74"),ObjectId ("5577f3d3c4a160b6f6554a78"),ObjectId ("5577f3f5c4a160eff8554a75"),ObjectId ("5577f41ac4a16090fb554a76"),ObjectId ("5577f42ec4a160e0f8554a76"),ObjectId ("5577f441c4a160d1f4554a75"),ObjectId ("5577f480c4a160eff8554a76"),ObjectId ("5577f4b7c4a160a9f9554a76"),ObjectId ("5577f4cdc4a160a0fb554a74"),ObjectId ("5577f4f7c4a16090fb554a78"),ObjectId ("5577f528c4a16041f6554a76"),ObjectId ("5577f539c4a160a0fb554a75"),ObjectId ("5577f5e4c4a160eff8554a78"),ObjectId ("5577f5f1c4a160d5f8554a76")]}}, ["name","file_uris","id"] ).sort( [] ).limit( 0 ).skip( 0 ) | | 27 | 1 | |
db.hotels.count( {"status":2,"loc":{"$near":{"$geometry":{"type":"Point","coordinates":[107.006098,20.961735]},"$maxDistance":2000}},"lang_code":"vi","_id":{"$ne":ObjectId ("573ed184887b6603452856a4")}} ) | | 11 | 1 | maybe slow |