| 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 ("59c1421d887b66026be03dc6")}, ["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 ("59c1421d887b66026be03dc6")}, ["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 ("5555bee2c4a1608e6e9a1610")}, ["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.hotels.count( {"status":2,"loc":{"$near":{"$geometry":{"type":"Point","coordinates":[105.850525,21.031435]},"$maxDistance":2000}},"lang_code":"vi","_id":{"$ne":ObjectId ("59c1421d887b66026be03dc6")}} ) | | 378 | 11 | |
