{"t":{"$date":"2023-08-26T10:25:19.017+00:00"},"s":"I", "c":"NETWORK", "id":4915701, "ctx":"-","msg":"Initialized wire specification","attr":{"spec":{"incomingExternalClient":{"minWireVersion":0,"maxWireVersion":17},"incomingInternalClient":{"minWireVersion":0,"maxWireVersion":17},"outgoing":{"minWireVersion":6,"maxWireVersion":17},"isInternalClient":true}}} {"t":{"$date":"2023-08-26T10:25:19.019+00:00"},"s":"I", "c":"CONTROL", "id":23285, "ctx":"-","msg":"Automatically disabling TLS 1.0, to force-enable TLS 1.0 specify --sslDisabledProtocols 'none'"} {"t":{"$date":"2023-08-26T10:25:19.020+00:00"},"s":"I", "c":"NETWORK", "id":4648601, "ctx":"main","msg":"Implicit TCP FastOpen unavailable. If TCP FastOpen is required, set tcpFastOpenServer, tcpFastOpenClient, and tcpFastOpenQueueSize."} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"REPL", "id":5123008, "ctx":"main","msg":"Successfully registered PrimaryOnlyService","attr":{"service":"TenantMigrationDonorService","namespace":"config.tenantMigrationDonors"}} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"REPL", "id":5123008, "ctx":"main","msg":"Successfully registered PrimaryOnlyService","attr":{"service":"TenantMigrationRecipientService","namespace":"config.tenantMigrationRecipients"}} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"REPL", "id":5123008, "ctx":"main","msg":"Successfully registered PrimaryOnlyService","attr":{"service":"ShardSplitDonorService","namespace":"config.tenantSplitDonors"}} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"CONTROL", "id":5945603, "ctx":"main","msg":"Multi threading initialized"} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"CONTROL", "id":4615611, "ctx":"initandlisten","msg":"MongoDB starting","attr":{"pid":157236,"port":27017,"dbPath":"/data/db","architecture":"64-bit","host":"ams-db-01"}} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"CONTROL", "id":23403, "ctx":"initandlisten","msg":"Build Info","attr":{"buildInfo":{"version":"6.0.9","gitVersion":"90c65f9cc8fc4e6664a5848230abaa9b3f3b02f7","openSSLVersion":"OpenSSL 1.1.1k FIPS 25 Mar 2021","modules":[],"allocator":"tcmalloc","environment":{"distmod":"rhel80","distarch":"x86_64","target_arch":"x86_64"}}}} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"CONTROL", "id":51765, "ctx":"initandlisten","msg":"Operating System","attr":{"os":{"name":"CentOS Stream release 8","version":"Kernel 4.18.0-500.el8.x86_64"}}} {"t":{"$date":"2023-08-26T10:25:19.132+00:00"},"s":"I", "c":"CONTROL", "id":21951, "ctx":"initandlisten","msg":"Options set by command line","attr":{"options":{"config":"/etc/mongod.conf","net":{"bindIp":"0.0.0.0","port":27017},"processManagement":{"timeZoneInfo":"/usr/share/zoneinfo"},"security":{"authorization":"enabled"},"storage":{"dbPath":"/data/db","journal":{"enabled":true},"wiredTiger":{"engineConfig":{"cacheSizeGB":2}}},"systemLog":{"destination":"file","logAppend":true,"path":"/var/log/mongodb/mongod.log"}}}} {"t":{"$date":"2023-08-26T10:25:19.136+00:00"},"s":"I", "c":"STORAGE", "id":22270, "ctx":"initandlisten","msg":"Storage engine to use detected by data files","attr":{"dbpath":"/data/db","storageEngine":"wiredTiger"}} {"t":{"$date":"2023-08-26T10:25:19.136+00:00"},"s":"I", "c":"STORAGE", "id":22315, "ctx":"initandlisten","msg":"Opening WiredTiger","attr":{"config":"create,cache_size=2048M,session_max=33000,eviction=(threads_min=4,threads_max=4),config_base=false,statistics=(fast),log=(enabled=true,remove=true,path=journal,compressor=snappy),builtin_extension_config=(zstd=(compression_level=6)),file_manager=(close_idle_time=600,close_scan_interval=10,close_handle_minimum=2000),statistics_log=(wait=0),json_output=(error,message),verbose=[recovery_progress:1,checkpoint_progress:1,compact_progress:1,backup:0,checkpoint:0,compact:0,evict:0,history_store:0,recovery:0,rts:0,salvage:0,tiered:0,timestamp:0,transaction:0,verify:0,log:0],"}} {"t":{"$date":"2023-08-26T10:25:20.051+00:00"},"s":"I", "c":"STORAGE", "id":4795906, "ctx":"initandlisten","msg":"WiredTiger opened","attr":{"durationMillis":915}} {"t":{"$date":"2023-08-26T10:25:20.052+00:00"},"s":"I", "c":"RECOVERY", "id":23987, "ctx":"initandlisten","msg":"WiredTiger recoveryTimestamp","attr":{"recoveryTimestamp":{"$timestamp":{"t":0,"i":0}}}} {"t":{"$date":"2023-08-26T10:25:20.082+00:00"},"s":"W", "c":"CONTROL", "id":22178, "ctx":"initandlisten","msg":"/sys/kernel/mm/transparent_hugepage/enabled is 'always'. We suggest setting it to 'never'","tags":["startupWarnings"]} {"t":{"$date":"2023-08-26T10:25:20.082+00:00"},"s":"W", "c":"CONTROL", "id":5123300, "ctx":"initandlisten","msg":"vm.max_map_count is too low","attr":{"currentValue":65530,"recommendedMinimum":102400,"maxConns":51200},"tags":["startupWarnings"]} {"t":{"$date":"2023-08-26T10:25:20.102+00:00"},"s":"I", "c":"NETWORK", "id":4915702, "ctx":"initandlisten","msg":"Updated wire specification","attr":{"oldSpec":{"incomingExternalClient":{"minWireVersion":0,"maxWireVersion":17},"incomingInternalClient":{"minWireVersion":0,"maxWireVersion":17},"outgoing":{"minWireVersion":6,"maxWireVersion":17},"isInternalClient":true},"newSpec":{"incomingExternalClient":{"minWireVersion":0,"maxWireVersion":17},"incomingInternalClient":{"minWireVersion":17,"maxWireVersion":17},"outgoing":{"minWireVersion":17,"maxWireVersion":17},"isInternalClient":true}}} {"t":{"$date":"2023-08-26T10:25:20.102+00:00"},"s":"I", "c":"REPL", "id":5853300, "ctx":"initandlisten","msg":"current featureCompatibilityVersion value","attr":{"featureCompatibilityVersion":"6.0","context":"startup"}} {"t":{"$date":"2023-08-26T10:25:20.103+00:00"},"s":"I", "c":"STORAGE", "id":5071100, "ctx":"initandlisten","msg":"Clearing temp directory"} {"t":{"$date":"2023-08-26T10:25:20.164+00:00"},"s":"I", "c":"CONTROL", "id":20536, "ctx":"initandlisten","msg":"Flow Control is enabled on this deployment"} {"t":{"$date":"2023-08-26T10:25:20.164+00:00"},"s":"I", "c":"FTDC", "id":20625, "ctx":"initandlisten","msg":"Initializing full-time diagnostic data capture","attr":{"dataDirectory":"/data/db/diagnostic.data"}} {"t":{"$date":"2023-08-26T10:25:20.179+00:00"},"s":"I", "c":"REPL", "id":6015317, "ctx":"initandlisten","msg":"Setting new configuration state","attr":{"newState":"ConfigReplicationDisabled","oldState":"ConfigPreStart"}} {"t":{"$date":"2023-08-26T10:25:20.180+00:00"},"s":"I", "c":"STORAGE", "id":22262, "ctx":"initandlisten","msg":"Timestamp monitor starting"} {"t":{"$date":"2023-08-26T10:25:20.183+00:00"},"s":"I", "c":"NETWORK", "id":23015, "ctx":"listener","msg":"Listening on","attr":{"address":"/tmp/mongodb-27017.sock"}} {"t":{"$date":"2023-08-26T10:25:20.183+00:00"},"s":"I", "c":"NETWORK", "id":23015, "ctx":"listener","msg":"Listening on","attr":{"address":"0.0.0.0"}} {"t":{"$date":"2023-08-26T10:25:20.183+00:00"},"s":"I", "c":"NETWORK", "id":23016, "ctx":"listener","msg":"Waiting for connections","attr":{"port":27017,"ssl":"off"}} {"t":{"$date":"2023-08-26T10:25:20.525+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:56754","uuid":"87f47647-f868-4617-9e89-e100a8de4a54","connectionId":1,"connectionCount":1}} {"t":{"$date":"2023-08-26T10:25:20.526+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn1","msg":"client metadata","attr":{"remote":"10.0.0.254:56754","client":"conn1","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:20.532+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:56768","uuid":"4161eda6-5f2b-40e2-8e89-67255b2ffa94","connectionId":2,"connectionCount":2}} {"t":{"$date":"2023-08-26T10:25:20.532+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn2","msg":"client metadata","attr":{"remote":"10.0.0.254:56768","client":"conn2","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:20.548+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn2","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:56768","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:20.648+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:56770","uuid":"9a44e109-e102-458a-a8f3-e87317d51a8a","connectionId":3,"connectionCount":3}} {"t":{"$date":"2023-08-26T10:25:20.648+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn3","msg":"client metadata","attr":{"remote":"10.0.0.254:56770","client":"conn3","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:20.655+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:56786","uuid":"3fa15f56-aca8-477d-911b-11ebd3c89be7","connectionId":4,"connectionCount":4}} {"t":{"$date":"2023-08-26T10:25:20.655+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn4","msg":"client metadata","attr":{"remote":"10.0.0.254:56786","client":"conn4","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:20.658+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn4","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:56786","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:20.661+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:56794","uuid":"71c51f6f-dc51-4ec8-9797-773a6436ed6f","connectionId":5,"connectionCount":5}} {"t":{"$date":"2023-08-26T10:25:20.662+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn5","msg":"client metadata","attr":{"remote":"10.0.0.254:56794","client":"conn5","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:20.664+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn5","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:56794","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:21.010+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn4","msg":"Slow query","attr":{"type":"command","ns":"mspretro.chatlogs","appName":"App Service","command":{"insert":"chatlogs","documents":[{"ActorId":26020,"LogId":728151,"RoomId":36835,"Date":{"$date":"2023-08-26T10:25:20.660Z"},"IPId":119334,"Message":"swearing at me isnt going to help u","_id":{"$oid":"64e9d310f52dc2de618eb2a3"},"__v":0}],"ordered":true,"lsid":{"id":{"$uuid":"1014a7bb-d128-4d9c-92ab-cb65239c4719"}},"$db":"mspretro"},"ninserted":1,"keysInserted":4,"numYields":0,"reslen":45,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":1}},"FeatureCompatibilityVersion":{"acquireCount":{"w":1}},"ReplicationStateTransition":{"acquireCount":{"w":1}},"Global":{"acquireCount":{"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"w":1}},"Mutex":{"acquireCount":{"r":1}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{"data":{"bytesRead":9734855,"timeReadingMicros":26751},"timeWaitingMicros":{"handleLock":3,"schemaLock":9503}},"remote":"10.0.0.254:56786","protocol":"op_msg","durationMillis":344}} {"t":{"$date":"2023-08-26T10:25:21.013+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.chatlogs","appName":"App Service","command":{"insert":"chatlogs","documents":[{"ActorId":36835,"LogId":728150,"RoomId":26020,"Date":{"$date":"2023-08-26T10:25:20.561Z"},"IPId":119335,"Message":":D","_id":{"$oid":"64e9d3107b13b450f8733b39"},"__v":0}],"ordered":true,"lsid":{"id":{"$uuid":"bd5c20e6-070b-42c3-a78c-b27cd5d6bf7e"}},"$db":"mspretro"},"ninserted":1,"keysInserted":4,"numYields":0,"reslen":45,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":1}},"FeatureCompatibilityVersion":{"acquireCount":{"w":1}},"ReplicationStateTransition":{"acquireCount":{"w":1}},"Global":{"acquireCount":{"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"w":1}},"Mutex":{"acquireCount":{"r":1}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{"data":{"bytesRead":11695261,"timeReadingMicros":392880},"timeWaitingMicros":{"schemaLock":42591}},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":449}} {"t":{"$date":"2023-08-26T10:25:21.013+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn5","msg":"Slow query","attr":{"type":"command","ns":"mspretro.users","appName":"App Service","command":{"find":"users","filter":{"ActorId":26475},"projection":{},"limit":1,"singleBatch":true,"batchSize":1,"lsid":{"id":{"$uuid":"de7dec14-1e53-47b5-8bc0-41d7c1655b63"}},"$db":"mspretro"},"planSummary":"IXSCAN { ActorId: 1 }","keysExamined":1,"docsExamined":1,"cursorExhausted":true,"numYields":0,"nreturned":1,"queryHash":"91B0FB0A","planCacheKey":"3E8553B7","queryFramework":"classic","reslen":6452,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1}},"Global":{"acquireCount":{"r":1}},"Mutex":{"acquireCount":{"r":1}}},"storage":{"data":{"bytesRead":437190,"timeReadingMicros":4832},"timeWaitingMicros":{"schemaLock":333669}},"remote":"10.0.0.254:56794","protocol":"op_msg","durationMillis":346}} {"t":{"$date":"2023-08-26T10:25:21.615+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.comments_movies","appName":"App Service","command":{"find":"comments_movies","filter":{"MovieId":133523,"ActorId":19111,"Score":{"$ne":-1}},"projection":{},"limit":1,"singleBatch":true,"batchSize":1,"lsid":{"id":{"$uuid":"bd5c20e6-070b-42c3-a78c-b27cd5d6bf7e"}},"$db":"mspretro"},"planSummary":"IXSCAN { MovieId: 1 }","keysExamined":4,"docsExamined":4,"fromMultiPlanner":true,"cursorExhausted":true,"numYields":2,"nreturned":0,"queryHash":"CFD54C68","planCacheKey":"A2108E63","queryFramework":"classic","reslen":113,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":3}},"Global":{"acquireCount":{"r":3}},"Mutex":{"acquireCount":{"r":1}}},"storage":{"data":{"bytesRead":4497680,"timeReadingMicros":104290},"timeWaitingMicros":{"schemaLock":135521}},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":251}} {"t":{"$date":"2023-08-26T10:25:21.651+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn5","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"RequesterId":26475},{"ReceiverId":26475}],"Status":1}},{"$group":{"_id":1,"n":{"$sum":1}}}],"cursor":{},"lsid":{"id":{"$uuid":"de7dec14-1e53-47b5-8bc0-41d7c1655b63"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":1178,"docsExamined":1178,"fromMultiPlanner":true,"cursorExhausted":true,"numYields":3,"nreturned":1,"queryHash":"2D851592","planCacheKey":"5307B030","queryFramework":"classic","reslen":129,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":5}},"Global":{"acquireCount":{"r":5}},"Mutex":{"acquireCount":{"r":2}}},"storage":{"data":{"bytesRead":28221621,"timeReadingMicros":437534},"timeWaitingMicros":{"schemaLock":92973}},"remote":"10.0.0.254:56794","protocol":"op_msg","durationMillis":572}} {"t":{"$date":"2023-08-26T10:25:21.804+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn5","msg":"Slow query","attr":{"type":"command","ns":"mspretro.boyfriends","appName":"App Service","command":{"find":"boyfriends","filter":{"$or":[{"RequesterId":26475,"Status":2},{"ReceiverId":26475,"Status":2}]},"projection":{},"limit":1,"singleBatch":true,"batchSize":1,"lsid":{"id":{"$uuid":"de7dec14-1e53-47b5-8bc0-41d7c1655b63"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":6,"docsExamined":6,"cursorExhausted":true,"numYields":2,"nreturned":1,"queryHash":"5EE12CE3","planCacheKey":"6036D102","queryFramework":"classic","reslen":187,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":3}},"Global":{"acquireCount":{"r":3}},"Mutex":{"acquireCount":{"r":1}}},"storage":{"data":{"bytesRead":810674,"timeReadingMicros":16508},"timeWaitingMicros":{"schemaLock":111212}},"remote":"10.0.0.254:56794","protocol":"op_msg","durationMillis":150}} {"t":{"$date":"2023-08-26T10:25:27.156+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn5","msg":"Slow query","attr":{"type":"command","ns":"mspretro.users","appName":"App Service","command":{"aggregate":"users","pipeline":[{"$match":{"ActorId":40886}},{"$lookup":{"from":"rellids_clothes","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$eq":["$ActorId","$$actorId"]},{"$eq":["$IsWearing",1]}]}}},{"$lookup":{"from":"clothes","localField":"ClothId","foreignField":"ClothesId","as":"cloth"}},{"$unwind":"$cloth"},{"$project":{"_id":0,"ActorClothesRelId":"$ClothesRellId","ActorId":"$ActorId","ClothesId":"$ClothId","Color":"$Colors","IsWearing":"$IsWearing","x":"$x","y":"$y","Cloth":{"ClothesId":"$ClothId","Name":"$cloth.Name","SWF":"$cloth.SWF","ClothesCategoryId":"$cloth.ClothesCategoryId","Price":"$cloth.Price","ShopId":"$cloth.ShopId","SkinId":"$cloth.SkinId","Filename":"$cloth.Filename","Scale":"$cloth.Scale","Vip":"$cloth.Vip","RegNewUser":"$cloth.RegNewUser","sortorder":"$cloth.Sortorder","New":"$cloth.New","Discount":"$cloth.Discount","ClothesCategory":{"ClothesCategoryId":"$cloth.ClothesCategoryId","Name":"$cloth.ClothesCategoryName","SlotTypeId":"$cloth.SlotTypeId","SlotType":{"SlotTypeId":"$cloth.SlotTypeId","Name":"$cloth.ClothesCategoryName"}}}}}],"as":"ActorClothesRels"}},{"$lookup":{"from":"friends","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$RequesterId","$$actorId"]},{"$eq":["$ReceiverId","$$actorId"]}]},{"$eq":["$Status",1]}]}}},{"$count":"friendCount"}],"as":"friendCount"}},{"$unwind":{"path":"$friendCount","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"eyes","localField":"Clinic.EyeId","foreignField":"EyeId","pipeline":[{"$project":{"_id":0,"EyeId":"$EyeId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"eye"}},{"$unwind":{"path":"$eye","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"noses","localField":"Clinic.NoseId","foreignField":"NoseId","pipeline":[{"$project":{"_id":0,"NoseId":"$NoseId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"nose"}},{"$unwind":{"path":"$nose","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"mouths","localField":"Clinic.MouthId","foreignField":"MouthId","pipeline":[{"$project":{"_id":0,"MouthId":"$MouthId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"mouth"}},{"$unwind":{"path":"$mouth","preserveNullAndEmptyArrays":true}},{"$addFields":{"moderator":{"$cond":{"if":{"$ne":["$LevelModerator",0]},"then":1,"else":0}}}},{"$project":{"_id":0,"ActorId":1,"Name":1,"SkinSWF":"$Clinic.SkinSWF","SkinColor":"$Clinic.SkinColor","NoseId":"$Clinic.NoseId","EyeId":"$Clinic.EyeId","MouthId":"$Clinic.MouthId","Money":"$Progression.Money","EyeColors":"$Clinic.EyeColors","MouthColors":"$Clinic.MouthColors","Fame":"$Progression.Fame","Fortune":"$Progression.Fortune","FriendCount":"$friendCount.friendCount","IsExtra":"$Extra.IsExtra","InvitedByActorId":"$Extra.InvitedByActorId","Moderator":"$moderator","ValueOfGiftsReceived":"$Gifts.ValueOfGiftsReceived","ValueOfGiftsGiven":"$Gifts.ValueOfGiftsGiven","NumberOfAutographsReceived":"$Autographs.NumberOfAutographsReceived","NumberOfAutographsGiven":"$Autographs.NumberOfAutographsGiven","TimeOfLastAutographGiven":"$Autographs.TimeOfLastAutographGiven","MembershipPurchasedDate":"$VIP.MembershipPurchasedDate","MembershipTimeoutDate":"$VIP.MembershipTimeoutDate","MembershipGiftRecievedDate":"$VIP.MembershipGiftRecievedDate","TotalVipDays":"$VIP.TotalVipDays","FacebookId":"$Extra.FacebookId","ActorClothesRels":"$ActorClothesRels","BoyfriendData":"$boyfriendData","Eye":"$eye","Nose":"$nose","Mouth":"$mouth"}}],"cursor":{},"lsid":{"id":{"$uuid":"de7dec14-1e53-47b5-8bc0-41d7c1655b63"}},"$db":"mspretro"},"planSummary":"IXSCAN { ActorId: 1 }","keysExamined":100,"docsExamined":100,"cursorExhausted":true,"numYields":4,"nreturned":1,"queryHash":"79063C1E","planCacheKey":"AE7214E5","queryFramework":"classic","reslen":4301,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":30}},"Global":{"acquireCount":{"r":30}},"Mutex":{"acquireCount":{"r":26}}},"storage":{"data":{"bytesRead":6706305,"timeReadingMicros":263345}},"remote":"10.0.0.254:56794","protocol":"op_msg","durationMillis":328}} {"t":{"$date":"2023-08-26T10:25:28.314+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"127.0.0.1:56588","uuid":"760e0646-cd07-405d-8675-4683740ec6c8","connectionId":6,"connectionCount":6}} {"t":{"$date":"2023-08-26T10:25:28.316+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn6","msg":"client metadata","attr":{"remote":"127.0.0.1:56588","client":"conn6","doc":{"application":{"name":"Beauty Clinic"},"driver":{"name":"nodejs|Mongoose","version":"4.16.0|6.11.1"},"platform":"Node.js v18.17.1, LE","os":{"name":"linux","architecture":"x64","version":"4.18.0-500.el8.x86_64","type":"Linux"}}}} {"t":{"$date":"2023-08-26T10:25:28.410+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"127.0.0.1:56604","uuid":"3d1fba19-facc-4582-a925-6b1c80050d79","connectionId":7,"connectionCount":7}} {"t":{"$date":"2023-08-26T10:25:28.411+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn7","msg":"client metadata","attr":{"remote":"127.0.0.1:56604","client":"conn7","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"4.18.0-500.el8.x86_64"},"platform":"Node.js v18.17.1, LE (unified)","version":"4.5.0|6.3.5"}}} {"t":{"$date":"2023-08-26T10:25:31.033+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:51374","uuid":"f5af3f7f-4c02-41f9-b966-1d3ca8340ffd","connectionId":8,"connectionCount":8}} {"t":{"$date":"2023-08-26T10:25:31.033+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn8","msg":"client metadata","attr":{"remote":"10.0.0.254:51374","client":"conn8","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:31.160+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:51384","uuid":"3332f779-e449-440f-9737-cf97bebf3272","connectionId":9,"connectionCount":9}} {"t":{"$date":"2023-08-26T10:25:31.161+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn9","msg":"client metadata","attr":{"remote":"10.0.0.254:51384","client":"conn9","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:32.194+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.todos","appName":"App Service","command":{"insert":"todos","documents":[{"TodoId":463975,"ActorId":40236,"Type":3,"Deadline":"false","FriendId":36807,"MovieId":0,"ContestId":0,"MovieCompetitionId":0,"GiftId":0,"_id":{"$oid":"64e9d31b7b13b450f8733b5e"},"__v":0}],"ordered":true,"lsid":{"id":{"$uuid":"bd5c20e6-070b-42c3-a78c-b27cd5d6bf7e"}},"$db":"mspretro"},"ninserted":1,"keysInserted":4,"numYields":0,"reslen":45,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":1}},"FeatureCompatibilityVersion":{"acquireCount":{"w":1}},"ReplicationStateTransition":{"acquireCount":{"w":1}},"Global":{"acquireCount":{"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"w":1}},"Mutex":{"acquireCount":{"r":1}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{"data":{"bytesRead":16255484,"timeReadingMicros":252879}},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":276}} {"t":{"$date":"2023-08-26T10:25:35.400+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.users","appName":"App Service","command":{"aggregate":"users","pipeline":[{"$match":{"ActorId":15788}},{"$lookup":{"from":"rellids_clothes","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$eq":["$ActorId","$$actorId"]},{"$eq":["$IsWearing",1]}]}}},{"$lookup":{"from":"clothes","localField":"ClothId","foreignField":"ClothesId","as":"cloth"}},{"$unwind":"$cloth"},{"$project":{"_id":0,"ActorClothesRelId":"$ClothesRellId","ActorId":"$ActorId","ClothesId":"$ClothId","Color":"$Colors","IsWearing":"$IsWearing","x":"$x","y":"$y","Cloth":{"ClothesId":"$ClothId","Name":"$cloth.Name","SWF":"$cloth.SWF","ClothesCategoryId":"$cloth.ClothesCategoryId","Price":"$cloth.Price","ShopId":"$cloth.ShopId","SkinId":"$cloth.SkinId","Filename":"$cloth.Filename","Scale":"$cloth.Scale","Vip":"$cloth.Vip","RegNewUser":"$cloth.RegNewUser","sortorder":"$cloth.Sortorder","New":"$cloth.New","Discount":"$cloth.Discount","ClothesCategory":{"ClothesCategoryId":"$cloth.ClothesCategoryId","Name":"$cloth.ClothesCategoryName","SlotTypeId":"$cloth.SlotTypeId","SlotType":{"SlotTypeId":"$cloth.SlotTypeId","Name":"$cloth.ClothesCategoryName"}}}}}],"as":"ActorClothesRels"}},{"$lookup":{"from":"friends","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$RequesterId","$$actorId"]},{"$eq":["$ReceiverId","$$actorId"]}]},{"$eq":["$Status",1]}]}}},{"$count":"friendCount"}],"as":"friendCount"}},{"$unwind":{"path":"$friendCount","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"eyes","localField":"Clinic.EyeId","foreignField":"EyeId","pipeline":[{"$project":{"_id":0,"EyeId":"$EyeId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"eye"}},{"$unwind":{"path":"$eye","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"noses","localField":"Clinic.NoseId","foreignField":"NoseId","pipeline":[{"$project":{"_id":0,"NoseId":"$NoseId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"nose"}},{"$unwind":{"path":"$nose","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"mouths","localField":"Clinic.MouthId","foreignField":"MouthId","pipeline":[{"$project":{"_id":0,"MouthId":"$MouthId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"mouth"}},{"$unwind":{"path":"$mouth","preserveNullAndEmptyArrays":true}},{"$addFields":{"moderator":{"$cond":{"if":{"$ne":["$LevelModerator",0]},"then":1,"else":0}}}},{"$project":{"_id":0,"ActorId":1,"Name":1,"SkinSWF":"$Clinic.SkinSWF","SkinColor":"$Clinic.SkinColor","NoseId":"$Clinic.NoseId","EyeId":"$Clinic.EyeId","MouthId":"$Clinic.MouthId","Money":"$Progression.Money","EyeColors":"$Clinic.EyeColors","MouthColors":"$Clinic.MouthColors","Fame":"$Progression.Fame","Fortune":"$Progression.Fortune","FriendCount":"$friendCount.friendCount","IsExtra":"$Extra.IsExtra","InvitedByActorId":"$Extra.InvitedByActorId","Moderator":"$moderator","ValueOfGiftsReceived":"$Gifts.ValueOfGiftsReceived","ValueOfGiftsGiven":"$Gifts.ValueOfGiftsGiven","NumberOfAutographsReceived":"$Autographs.NumberOfAutographsReceived","NumberOfAutographsGiven":"$Autographs.NumberOfAutographsGiven","TimeOfLastAutographGiven":"$Autographs.TimeOfLastAutographGiven","MembershipPurchasedDate":"$VIP.MembershipPurchasedDate","MembershipTimeoutDate":"$VIP.MembershipTimeoutDate","MembershipGiftRecievedDate":"$VIP.MembershipGiftRecievedDate","TotalVipDays":"$VIP.TotalVipDays","FacebookId":"$Extra.FacebookId","ActorClothesRels":"$ActorClothesRels","BoyfriendData":"$boyfriendData","Eye":"$eye","Nose":"$nose","Mouth":"$mouth"}}],"cursor":{},"lsid":{"id":{"$uuid":"bd5c20e6-070b-42c3-a78c-b27cd5d6bf7e"}},"$db":"mspretro"},"planSummary":"IXSCAN { ActorId: 1 }","keysExamined":2916,"docsExamined":2916,"cursorExhausted":true,"numYields":15,"nreturned":1,"queryHash":"79063C1E","planCacheKey":"AE7214E5","queryFramework":"classic","reslen":5259,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":45}},"Global":{"acquireCount":{"r":45}},"Mutex":{"acquireCount":{"r":30}}},"storage":{"data":{"bytesRead":23981692,"timeReadingMicros":124688}},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":189}} {"t":{"$date":"2023-08-26T10:25:36.742+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:39306","uuid":"75b0094d-0e6f-483e-b812-ad40ee6ec419","connectionId":10,"connectionCount":10}} {"t":{"$date":"2023-08-26T10:25:36.743+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn10","msg":"client metadata","attr":{"remote":"10.0.0.254:39306","client":"conn10","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:36.746+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn10","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:39306","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:37.267+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:39318","uuid":"66a7b809-63c0-464d-94ab-a627b80cf720","connectionId":11,"connectionCount":11}} {"t":{"$date":"2023-08-26T10:25:37.268+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:39320","uuid":"ec588629-6b5f-461b-9151-8c1cb0ad31f7","connectionId":12,"connectionCount":12}} {"t":{"$date":"2023-08-26T10:25:37.268+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn11","msg":"client metadata","attr":{"remote":"10.0.0.254:39318","client":"conn11","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:37.268+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn12","msg":"client metadata","attr":{"remote":"10.0.0.254:39320","client":"conn12","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:37.271+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn11","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:39318","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:37.271+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn12","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:39320","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:37.287+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:39334","uuid":"8b0b3229-5161-434b-8161-f8e2032573d3","connectionId":13,"connectionCount":13}} {"t":{"$date":"2023-08-26T10:25:37.288+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:39344","uuid":"a9d44b50-c3ad-428f-9b74-546fd79d51ad","connectionId":14,"connectionCount":14}} {"t":{"$date":"2023-08-26T10:25:37.288+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn14","msg":"client metadata","attr":{"remote":"10.0.0.254:39344","client":"conn14","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:37.290+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn13","msg":"client metadata","attr":{"remote":"10.0.0.254:39334","client":"conn13","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:37.290+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn14","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:39344","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:37.302+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn13","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:39334","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:37.312+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:39354","uuid":"78bffa05-93e8-455b-a338-6e25a0ca8fc3","connectionId":15,"connectionCount":15}} {"t":{"$date":"2023-08-26T10:25:37.314+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn15","msg":"client metadata","attr":{"remote":"10.0.0.254:39354","client":"conn15","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:37.319+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn15","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:39354","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:38.592+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.users","appName":"App Service","command":{"aggregate":"users","pipeline":[{"$match":{"ActorId":1}},{"$lookup":{"from":"rellids_clothes","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$eq":["$ActorId","$$actorId"]},{"$eq":["$IsWearing",1]}]}}},{"$lookup":{"from":"clothes","localField":"ClothId","foreignField":"ClothesId","as":"cloth"}},{"$unwind":"$cloth"},{"$project":{"_id":0,"ActorClothesRelId":"$ClothesRellId","ActorId":"$ActorId","ClothesId":"$ClothId","Color":"$Colors","IsWearing":"$IsWearing","x":"$x","y":"$y","Cloth":{"ClothesId":"$ClothId","Name":"$cloth.Name","SWF":"$cloth.SWF","ClothesCategoryId":"$cloth.ClothesCategoryId","Price":"$cloth.Price","ShopId":"$cloth.ShopId","SkinId":"$cloth.SkinId","Filename":"$cloth.Filename","Scale":"$cloth.Scale","Vip":"$cloth.Vip","RegNewUser":"$cloth.RegNewUser","sortorder":"$cloth.Sortorder","New":"$cloth.New","Discount":"$cloth.Discount","ClothesCategory":{"ClothesCategoryId":"$cloth.ClothesCategoryId","Name":"$cloth.ClothesCategoryName","SlotTypeId":"$cloth.SlotTypeId","SlotType":{"SlotTypeId":"$cloth.SlotTypeId","Name":"$cloth.ClothesCategoryName"}}}}}],"as":"ActorClothesRels"}},{"$lookup":{"from":"friends","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$RequesterId","$$actorId"]},{"$eq":["$ReceiverId","$$actorId"]}]},{"$eq":["$Status",1]}]}}},{"$count":"friendCount"}],"as":"friendCount"}},{"$unwind":{"path":"$friendCount","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"eyes","localField":"Clinic.EyeId","foreignField":"EyeId","pipeline":[{"$project":{"_id":0,"EyeId":"$EyeId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"eye"}},{"$unwind":{"path":"$eye","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"noses","localField":"Clinic.NoseId","foreignField":"NoseId","pipeline":[{"$project":{"_id":0,"NoseId":"$NoseId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"nose"}},{"$unwind":{"path":"$nose","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"mouths","localField":"Clinic.MouthId","foreignField":"MouthId","pipeline":[{"$project":{"_id":0,"MouthId":"$MouthId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"mouth"}},{"$unwind":{"path":"$mouth","preserveNullAndEmptyArrays":true}},{"$addFields":{"moderator":{"$cond":{"if":{"$ne":["$LevelModerator",0]},"then":1,"else":0}}}},{"$project":{"_id":0,"ActorId":1,"Name":1,"SkinSWF":"$Clinic.SkinSWF","SkinColor":"$Clinic.SkinColor","NoseId":"$Clinic.NoseId","EyeId":"$Clinic.EyeId","MouthId":"$Clinic.MouthId","Money":"$Progression.Money","EyeColors":"$Clinic.EyeColors","MouthColors":"$Clinic.MouthColors","Fame":"$Progression.Fame","Fortune":"$Progression.Fortune","FriendCount":"$friendCount.friendCount","IsExtra":"$Extra.IsExtra","InvitedByActorId":"$Extra.InvitedByActorId","Moderator":"$moderator","ValueOfGiftsReceived":"$Gifts.ValueOfGiftsReceived","ValueOfGiftsGiven":"$Gifts.ValueOfGiftsGiven","NumberOfAutographsReceived":"$Autographs.NumberOfAutographsReceived","NumberOfAutographsGiven":"$Autographs.NumberOfAutographsGiven","TimeOfLastAutographGiven":"$Autographs.TimeOfLastAutographGiven","MembershipPurchasedDate":"$VIP.MembershipPurchasedDate","MembershipTimeoutDate":"$VIP.MembershipTimeoutDate","MembershipGiftRecievedDate":"$VIP.MembershipGiftRecievedDate","TotalVipDays":"$VIP.TotalVipDays","FacebookId":"$Extra.FacebookId","ActorClothesRels":"$ActorClothesRels","BoyfriendData":"$boyfriendData","Eye":"$eye","Nose":"$nose","Mouth":"$mouth"}}],"cursor":{},"lsid":{"id":{"$uuid":"deba3505-ac0b-41ae-b380-26348c124cfb"}},"$db":"mspretro"},"planSummary":"IXSCAN { ActorId: 1 }","keysExamined":8,"docsExamined":8,"cursorExhausted":true,"numYields":55,"nreturned":1,"queryHash":"79063C1E","planCacheKey":"AE7214E5","queryFramework":"classic","reslen":2781,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":75}},"Global":{"acquireCount":{"r":75}},"Mutex":{"acquireCount":{"r":20}}},"storage":{"data":{"bytesRead":3995397,"timeReadingMicros":3800}},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":113}} {"t":{"$date":"2023-08-26T10:25:43.181+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.users","appName":"App Service","command":{"aggregate":"users","pipeline":[{"$match":{"ActorId":1}},{"$lookup":{"from":"rellids_clothes","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$eq":["$ActorId","$$actorId"]},{"$eq":["$IsWearing",1]}]}}},{"$lookup":{"from":"clothes","localField":"ClothId","foreignField":"ClothesId","as":"cloth"}},{"$unwind":"$cloth"},{"$project":{"_id":0,"ActorClothesRelId":"$ClothesRellId","ActorId":"$ActorId","ClothesId":"$ClothId","Color":"$Colors","IsWearing":"$IsWearing","x":"$x","y":"$y","Cloth":{"ClothesId":"$ClothId","Name":"$cloth.Name","SWF":"$cloth.SWF","ClothesCategoryId":"$cloth.ClothesCategoryId","Price":"$cloth.Price","ShopId":"$cloth.ShopId","SkinId":"$cloth.SkinId","Filename":"$cloth.Filename","Scale":"$cloth.Scale","Vip":"$cloth.Vip","RegNewUser":"$cloth.RegNewUser","sortorder":"$cloth.Sortorder","New":"$cloth.New","Discount":"$cloth.Discount","ClothesCategory":{"ClothesCategoryId":"$cloth.ClothesCategoryId","Name":"$cloth.ClothesCategoryName","SlotTypeId":"$cloth.SlotTypeId","SlotType":{"SlotTypeId":"$cloth.SlotTypeId","Name":"$cloth.ClothesCategoryName"}}}}}],"as":"ActorClothesRels"}},{"$lookup":{"from":"friends","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$RequesterId","$$actorId"]},{"$eq":["$ReceiverId","$$actorId"]}]},{"$eq":["$Status",1]}]}}},{"$count":"friendCount"}],"as":"friendCount"}},{"$unwind":{"path":"$friendCount","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"eyes","localField":"Clinic.EyeId","foreignField":"EyeId","pipeline":[{"$project":{"_id":0,"EyeId":"$EyeId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"eye"}},{"$unwind":{"path":"$eye","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"noses","localField":"Clinic.NoseId","foreignField":"NoseId","pipeline":[{"$project":{"_id":0,"NoseId":"$NoseId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"nose"}},{"$unwind":{"path":"$nose","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"mouths","localField":"Clinic.MouthId","foreignField":"MouthId","pipeline":[{"$project":{"_id":0,"MouthId":"$MouthId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"mouth"}},{"$unwind":{"path":"$mouth","preserveNullAndEmptyArrays":true}},{"$addFields":{"moderator":{"$cond":{"if":{"$ne":["$LevelModerator",0]},"then":1,"else":0}}}},{"$project":{"_id":0,"ActorId":1,"Name":1,"SkinSWF":"$Clinic.SkinSWF","SkinColor":"$Clinic.SkinColor","NoseId":"$Clinic.NoseId","EyeId":"$Clinic.EyeId","MouthId":"$Clinic.MouthId","Money":"$Progression.Money","EyeColors":"$Clinic.EyeColors","MouthColors":"$Clinic.MouthColors","Fame":"$Progression.Fame","Fortune":"$Progression.Fortune","FriendCount":"$friendCount.friendCount","IsExtra":"$Extra.IsExtra","InvitedByActorId":"$Extra.InvitedByActorId","Moderator":"$moderator","ValueOfGiftsReceived":"$Gifts.ValueOfGiftsReceived","ValueOfGiftsGiven":"$Gifts.ValueOfGiftsGiven","NumberOfAutographsReceived":"$Autographs.NumberOfAutographsReceived","NumberOfAutographsGiven":"$Autographs.NumberOfAutographsGiven","TimeOfLastAutographGiven":"$Autographs.TimeOfLastAutographGiven","MembershipPurchasedDate":"$VIP.MembershipPurchasedDate","MembershipTimeoutDate":"$VIP.MembershipTimeoutDate","MembershipGiftRecievedDate":"$VIP.MembershipGiftRecievedDate","TotalVipDays":"$VIP.TotalVipDays","FacebookId":"$Extra.FacebookId","ActorClothesRels":"$ActorClothesRels","BoyfriendData":"$boyfriendData","Eye":"$eye","Nose":"$nose","Mouth":"$mouth"}}],"cursor":{},"lsid":{"id":{"$uuid":"deba3505-ac0b-41ae-b380-26348c124cfb"}},"$db":"mspretro"},"planSummary":"IXSCAN { ActorId: 1 }","keysExamined":8,"docsExamined":8,"cursorExhausted":true,"numYields":55,"nreturned":1,"queryHash":"79063C1E","planCacheKey":"AE7214E5","queryFramework":"classic","reslen":2781,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":75}},"Global":{"acquireCount":{"r":75}},"Mutex":{"acquireCount":{"r":20}}},"storage":{},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":102}} {"t":{"$date":"2023-08-26T10:25:44.852+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn5","msg":"Slow query","attr":{"type":"command","ns":"mspretro.tickets","appName":"App Service","command":{"insert":"tickets","documents":[{"ActorId":2,"Date":"1693131944574","Disable":false,"IPId":76826,"_id":{"$oid":"64e9d328f52dc2de618eb33b"},"__v":0}],"ordered":true,"lsid":{"id":{"$uuid":"ac9468bd-74e6-4e87-b52e-d1cd748b4d4c"}},"$db":"mspretro"},"ninserted":1,"keysInserted":4,"numYields":0,"reslen":45,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":1}},"FeatureCompatibilityVersion":{"acquireCount":{"w":1}},"ReplicationStateTransition":{"acquireCount":{"w":1}},"Global":{"acquireCount":{"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"w":1}},"Mutex":{"acquireCount":{"r":1}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{"data":{"bytesRead":7299204,"timeReadingMicros":255926}},"remote":"10.0.0.254:56794","protocol":"op_msg","durationMillis":273}} {"t":{"$date":"2023-08-26T10:25:45.338+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:49214","uuid":"e1968be8-fc5f-4416-976a-1b31865059d6","connectionId":16,"connectionCount":16}} {"t":{"$date":"2023-08-26T10:25:45.345+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn16","msg":"client metadata","attr":{"remote":"10.0.0.254:49214","client":"conn16","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:45.348+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn16","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:49214","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:45.363+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:49228","uuid":"8f29a82f-6808-4b10-9f88-d58b33a9b306","connectionId":17,"connectionCount":17}} {"t":{"$date":"2023-08-26T10:25:45.364+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn17","msg":"client metadata","attr":{"remote":"10.0.0.254:49228","client":"conn17","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:45.367+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn17","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:49228","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:45.377+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"10.0.0.254:49238","uuid":"ccd2e9d1-a70e-4473-8494-6c5194dc97be","connectionId":18,"connectionCount":18}} {"t":{"$date":"2023-08-26T10:25:45.379+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn18","msg":"client metadata","attr":{"remote":"10.0.0.254:49238","client":"conn18","doc":{"driver":{"name":"nodejs|Mongoose","version":"4.5.0"},"os":{"type":"Linux","name":"linux","architecture":"x64","version":"5.15.116.1-1.cm2"},"platform":"Node.js v18.16.1, LE (unified)","version":"4.5.0|6.3.6","application":{"name":"App Service"}}}} {"t":{"$date":"2023-08-26T10:25:45.382+00:00"},"s":"I", "c":"ACCESS", "id":20250, "ctx":"conn18","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"mspretro","authenticationDatabase":"admin","remote":"10.0.0.254:49238","extraInfo":{}}} {"t":{"$date":"2023-08-26T10:25:46.320+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn5","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"RequesterId":2},{"ReceiverId":2}],"Status":1}},{"$lookup":{"from":"users","let":{"requester":"$RequesterId","receiver":"$ReceiverId"},"pipeline":[{"$match":{"$expr":{"$or":[{"$eq":["$$requester","$ActorId"]},{"$eq":["$$receiver","$ActorId"]}]}}},{"$project":{"_id":0,"actorId":"$ActorId","name":"$Name"}}],"as":"user"}},{"$unwind":"$user"},{"$group":{"_id":"$user.actorId","actorId":{"$first":"$user.actorId"},"name":{"$first":"$user.name"}}},{"$match":{"actorId":{"$ne":2}}},{"$project":{"_id":0,"actorId":1,"name":1}}],"cursor":{},"lsid":{"id":{"$uuid":"de7dec14-1e53-47b5-8bc0-41d7c1655b63"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","cursorid":1893158138558689362,"keysExamined":3050,"docsExamined":1844,"fromMultiPlanner":true,"numYields":0,"nreturned":101,"queryHash":"0E5FD200","planCacheKey":"CD8E4A45","queryFramework":"classic","reslen":4283,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1212}},"Global":{"acquireCount":{"r":1212}},"Mutex":{"acquireCount":{"r":1212}}},"storage":{"data":{"bytesRead":23847963,"timeReadingMicros":262134}},"remote":"10.0.0.254:56794","protocol":"op_msg","durationMillis":412}} {"t":{"$date":"2023-08-26T10:25:48.875+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn15","msg":"Slow query","attr":{"type":"command","ns":"mspretro.users","appName":"App Service","command":{"aggregate":"users","pipeline":[{"$match":{"ActorId":1}},{"$lookup":{"from":"rellids_clothes","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$eq":["$ActorId","$$actorId"]},{"$eq":["$IsWearing",1]}]}}},{"$lookup":{"from":"clothes","localField":"ClothId","foreignField":"ClothesId","as":"cloth"}},{"$unwind":"$cloth"},{"$project":{"_id":0,"ActorClothesRelId":"$ClothesRellId","ActorId":"$ActorId","ClothesId":"$ClothId","Color":"$Colors","IsWearing":"$IsWearing","x":"$x","y":"$y","Cloth":{"ClothesId":"$ClothId","Name":"$cloth.Name","SWF":"$cloth.SWF","ClothesCategoryId":"$cloth.ClothesCategoryId","Price":"$cloth.Price","ShopId":"$cloth.ShopId","SkinId":"$cloth.SkinId","Filename":"$cloth.Filename","Scale":"$cloth.Scale","Vip":"$cloth.Vip","RegNewUser":"$cloth.RegNewUser","sortorder":"$cloth.Sortorder","New":"$cloth.New","Discount":"$cloth.Discount","ClothesCategory":{"ClothesCategoryId":"$cloth.ClothesCategoryId","Name":"$cloth.ClothesCategoryName","SlotTypeId":"$cloth.SlotTypeId","SlotType":{"SlotTypeId":"$cloth.SlotTypeId","Name":"$cloth.ClothesCategoryName"}}}}}],"as":"ActorClothesRels"}},{"$lookup":{"from":"friends","let":{"actorId":"$ActorId"},"pipeline":[{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$RequesterId","$$actorId"]},{"$eq":["$ReceiverId","$$actorId"]}]},{"$eq":["$Status",1]}]}}},{"$count":"friendCount"}],"as":"friendCount"}},{"$unwind":{"path":"$friendCount","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"eyes","localField":"Clinic.EyeId","foreignField":"EyeId","pipeline":[{"$project":{"_id":0,"EyeId":"$EyeId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"eye"}},{"$unwind":{"path":"$eye","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"noses","localField":"Clinic.NoseId","foreignField":"NoseId","pipeline":[{"$project":{"_id":0,"NoseId":"$NoseId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"nose"}},{"$unwind":{"path":"$nose","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"mouths","localField":"Clinic.MouthId","foreignField":"MouthId","pipeline":[{"$project":{"_id":0,"MouthId":"$MouthId","Name":"$Name","SWF":"$SWF","SkinId":"$SkinId"}}],"as":"mouth"}},{"$unwind":{"path":"$mouth","preserveNullAndEmptyArrays":true}},{"$addFields":{"moderator":{"$cond":{"if":{"$ne":["$LevelModerator",0]},"then":1,"else":0}}}},{"$project":{"_id":0,"ActorId":1,"Name":1,"SkinSWF":"$Clinic.SkinSWF","SkinColor":"$Clinic.SkinColor","NoseId":"$Clinic.NoseId","EyeId":"$Clinic.EyeId","MouthId":"$Clinic.MouthId","Money":"$Progression.Money","EyeColors":"$Clinic.EyeColors","MouthColors":"$Clinic.MouthColors","Fame":"$Progression.Fame","Fortune":"$Progression.Fortune","FriendCount":"$friendCount.friendCount","IsExtra":"$Extra.IsExtra","InvitedByActorId":"$Extra.InvitedByActorId","Moderator":"$moderator","ValueOfGiftsReceived":"$Gifts.ValueOfGiftsReceived","ValueOfGiftsGiven":"$Gifts.ValueOfGiftsGiven","NumberOfAutographsReceived":"$Autographs.NumberOfAutographsReceived","NumberOfAutographsGiven":"$Autographs.NumberOfAutographsGiven","TimeOfLastAutographGiven":"$Autographs.TimeOfLastAutographGiven","MembershipPurchasedDate":"$VIP.MembershipPurchasedDate","MembershipTimeoutDate":"$VIP.MembershipTimeoutDate","MembershipGiftRecievedDate":"$VIP.MembershipGiftRecievedDate","TotalVipDays":"$VIP.TotalVipDays","FacebookId":"$Extra.FacebookId","ActorClothesRels":"$ActorClothesRels","BoyfriendData":"$boyfriendData","Eye":"$eye","Nose":"$nose","Mouth":"$mouth"}}],"cursor":{},"lsid":{"id":{"$uuid":"1c19e4f5-c5b9-4b62-923d-92d5a239cfe6"}},"$db":"mspretro"},"planSummary":"IXSCAN { ActorId: 1 }","keysExamined":8,"docsExamined":8,"cursorExhausted":true,"numYields":55,"nreturned":1,"queryHash":"79063C1E","planCacheKey":"AE7214E5","queryFramework":"classic","reslen":2781,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":75}},"Global":{"acquireCount":{"r":75}},"Mutex":{"acquireCount":{"r":20}}},"storage":{},"remote":"10.0.0.254:39354","protocol":"op_msg","durationMillis":104}} {"t":{"$date":"2023-08-26T10:25:50.104+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn4","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"ReceiverId":40756,"Status":1},{"RequesterId":40756,"Status":1}]}},{"$set":{"fieldResult":{"$cond":{"if":{"$eq":["$ReceiverId",40756]},"then":"$RequesterId","else":"$ReceiverId"}}}},{"$lookup":{"from":"movies","localField":"fieldResult","foreignField":"ActorId","pipeline":[{"$match":{"State":100}}],"as":"movie"}},{"$unwind":{"path":"$movie","preserveNullAndEmptyArrays":true}},{"$match":{"movie":{"$exists":true}}},{"$project":{"MovieId":"$movie.MovieId","Name":"$movie.Name","ActorId":"$movie.ActorId","Guid":"$movie.Guid","State":"$movie.State","WatchedTotalCount":"$movie.WatchedTotalCount","WatchedActorCount":"$movie.WatchedActorCount","RatedCount":"$movie.RatedCount","RatedTotalScore":"$movie.RatedTotalScore","AverageRating":"$movie.AverageRating","CreatedDate":"$movie.CreatedDate","PublishedDate":"$movie.PublishedDate","StarCoinsEarned":"$movie.StarCoinsEarned","MovieData":"$movie.MovieData","Complexity":"$movie.Complexity","CompetitionDate":"$movie.CompetitionDate","CompetitionId":"$movie.CompetitionId","CompetitionVotes":"$movie.CompetitionVotes","ActorClothesData":"$movie.ActorClothesData","MovieActorRels":"$movie.MovieActorRels","Scenes":"$movie.Scenes","ActorWatched":"$movie.ActorWatched"}},{"$sort":{"PublishedDate":-1}},{"$skip":0},{"$limit":4}],"cursor":{},"lsid":{"id":{"$uuid":"1014a7bb-d128-4d9c-92ab-cb65239c4719"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":12234,"docsExamined":12234,"hasSortStage":true,"cursorExhausted":true,"numYields":232,"nreturned":4,"queryHash":"66386607","planCacheKey":"B7D2A098","queryFramework":"classic","reslen":53025,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":342}},"Global":{"acquireCount":{"r":342}},"Mutex":{"acquireCount":{"r":110}}},"storage":{"data":{"bytesRead":40534967,"timeReadingMicros":1076638}},"remote":"10.0.0.254:56786","protocol":"op_msg","durationMillis":3916}} {"t":{"$date":"2023-08-26T10:25:50.107+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn16","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"ReceiverId":40756,"Status":1},{"RequesterId":40756,"Status":1}]}},{"$set":{"fieldResult":{"$cond":{"if":{"$eq":["$ReceiverId",40756]},"then":"$RequesterId","else":"$ReceiverId"}}}},{"$lookup":{"from":"movies","localField":"fieldResult","foreignField":"ActorId","pipeline":[{"$match":{"State":100,"MovieActorRels.ActorId":40756}}],"as":"movie"}},{"$unwind":{"path":"$movie","preserveNullAndEmptyArrays":true}},{"$match":{"movie":{"$exists":true}}},{"$project":{"MovieId":"$movie.MovieId","Name":"$movie.Name","ActorId":"$movie.ActorId","Guid":"$movie.Guid","State":"$movie.State","WatchedTotalCount":"$movie.WatchedTotalCount","WatchedActorCount":"$movie.WatchedActorCount","RatedCount":"$movie.RatedCount","RatedTotalScore":"$movie.RatedTotalScore","AverageRating":"$movie.AverageRating","CreatedDate":"$movie.CreatedDate","PublishedDate":"$movie.PublishedDate","StarCoinsEarned":"$movie.StarCoinsEarned","MovieData":"$movie.MovieData","Complexity":"$movie.Complexity","CompetitionDate":"$movie.CompetitionDate","CompetitionId":"$movie.CompetitionId","CompetitionVotes":"$movie.CompetitionVotes","ActorClothesData":"$movie.ActorClothesData","MovieActorRels":"$movie.MovieActorRels","Scenes":"$movie.Scenes","ActorWatched":"$movie.ActorWatched"}},{"$sort":{"PublishedDate":-1}},{"$skip":0},{"$limit":4}],"cursor":{},"lsid":{"id":{"$uuid":"ac9468bd-74e6-4e87-b52e-d1cd748b4d4c"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":12234,"docsExamined":12234,"hasSortStage":true,"cursorExhausted":true,"numYields":247,"nreturned":4,"queryHash":"66386607","planCacheKey":"B7D2A098","queryFramework":"classic","reslen":44487,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":333}},"Global":{"acquireCount":{"r":333}},"Mutex":{"acquireCount":{"r":86}}},"storage":{"data":{"bytesRead":83808742,"timeReadingMicros":1835820}},"remote":"10.0.0.254:49214","protocol":"op_msg","durationMillis":3921}} {"t":{"$date":"2023-08-26T10:25:50.333+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn4","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"ReceiverId":40756,"Status":1},{"RequesterId":40756,"Status":1}]}},{"$set":{"fieldResult":{"$cond":{"if":{"$eq":["$ReceiverId",40756]},"then":"$RequesterId","else":"$ReceiverId"}}}},{"$lookup":{"from":"movies","localField":"fieldResult","foreignField":"ActorId","pipeline":[{"$match":{"State":100}}],"as":"movie"}},{"$unwind":{"path":"$movie","preserveNullAndEmptyArrays":true}},{"$match":{"movie":{"$exists":true}}},{"$project":{"MovieId":"$movie.MovieId","Name":"$movie.Name","ActorId":"$movie.ActorId","Guid":"$movie.Guid","State":"$movie.State","WatchedTotalCount":"$movie.WatchedTotalCount","WatchedActorCount":"$movie.WatchedActorCount","RatedCount":"$movie.RatedCount","RatedTotalScore":"$movie.RatedTotalScore","AverageRating":"$movie.AverageRating","CreatedDate":"$movie.CreatedDate","PublishedDate":"$movie.PublishedDate","StarCoinsEarned":"$movie.StarCoinsEarned","MovieData":"$movie.MovieData","Complexity":"$movie.Complexity","CompetitionDate":"$movie.CompetitionDate","CompetitionId":"$movie.CompetitionId","CompetitionVotes":"$movie.CompetitionVotes","ActorClothesData":"$movie.ActorClothesData","MovieActorRels":"$movie.MovieActorRels","Scenes":"$movie.Scenes","ActorWatched":"$movie.ActorWatched"}},{"$group":{"_id":null,"count":{"$sum":1}}}],"cursor":{},"lsid":{"id":{"$uuid":"1014a7bb-d128-4d9c-92ab-cb65239c4719"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":12412,"docsExamined":12412,"cursorExhausted":true,"numYields":18,"nreturned":1,"queryHash":"66386607","planCacheKey":"B7D2A098","queryFramework":"classic","reslen":129,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":128}},"Global":{"acquireCount":{"r":128}},"Mutex":{"acquireCount":{"r":110}}},"storage":{},"remote":"10.0.0.254:56786","protocol":"op_msg","durationMillis":222}} {"t":{"$date":"2023-08-26T10:25:52.079+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"ReceiverId":13169,"Status":1},{"RequesterId":13169,"Status":1}]}},{"$set":{"fieldResult":{"$cond":{"if":{"$eq":["$ReceiverId",13169]},"then":"$RequesterId","else":"$ReceiverId"}}}},{"$lookup":{"from":"movies","localField":"fieldResult","foreignField":"ActorId","pipeline":[{"$match":{"State":100,"MovieActorRels.ActorId":13169}}],"as":"movie"}},{"$unwind":{"path":"$movie","preserveNullAndEmptyArrays":true}},{"$match":{"movie":{"$exists":true}}},{"$project":{"MovieId":"$movie.MovieId","Name":"$movie.Name","ActorId":"$movie.ActorId","Guid":"$movie.Guid","State":"$movie.State","WatchedTotalCount":"$movie.WatchedTotalCount","WatchedActorCount":"$movie.WatchedActorCount","RatedCount":"$movie.RatedCount","RatedTotalScore":"$movie.RatedTotalScore","AverageRating":"$movie.AverageRating","CreatedDate":"$movie.CreatedDate","PublishedDate":"$movie.PublishedDate","StarCoinsEarned":"$movie.StarCoinsEarned","MovieData":"$movie.MovieData","Complexity":"$movie.Complexity","CompetitionDate":"$movie.CompetitionDate","CompetitionId":"$movie.CompetitionId","CompetitionVotes":"$movie.CompetitionVotes","ActorClothesData":"$movie.ActorClothesData","MovieActorRels":"$movie.MovieActorRels","Scenes":"$movie.Scenes","ActorWatched":"$movie.ActorWatched"}},{"$sort":{"PublishedDate":-1}},{"$skip":0},{"$limit":4}],"cursor":{},"lsid":{"id":{"$uuid":"deba3505-ac0b-41ae-b380-26348c124cfb"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":52594,"docsExamined":52594,"hasSortStage":true,"cursorExhausted":true,"numYields":514,"nreturned":4,"queryHash":"66386607","planCacheKey":"B7D2A098","queryFramework":"classic","reslen":68556,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1616}},"Global":{"acquireCount":{"r":1616}},"Mutex":{"acquireCount":{"r":1102}}},"storage":{"data":{"bytesRead":588419237,"timeReadingMicros":3997364}},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":8597}} {"t":{"$date":"2023-08-26T10:25:52.090+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"ReceiverId":13169,"Status":1},{"RequesterId":13169,"Status":1}]}},{"$set":{"fieldResult":{"$cond":{"if":{"$eq":["$ReceiverId",13169]},"then":"$RequesterId","else":"$ReceiverId"}}}},{"$lookup":{"from":"movies","localField":"fieldResult","foreignField":"ActorId","pipeline":[{"$match":{"State":100}}],"as":"movie"}},{"$unwind":{"path":"$movie","preserveNullAndEmptyArrays":true}},{"$match":{"movie":{"$exists":true}}},{"$project":{"MovieId":"$movie.MovieId","Name":"$movie.Name","ActorId":"$movie.ActorId","Guid":"$movie.Guid","State":"$movie.State","WatchedTotalCount":"$movie.WatchedTotalCount","WatchedActorCount":"$movie.WatchedActorCount","RatedCount":"$movie.RatedCount","RatedTotalScore":"$movie.RatedTotalScore","AverageRating":"$movie.AverageRating","CreatedDate":"$movie.CreatedDate","PublishedDate":"$movie.PublishedDate","StarCoinsEarned":"$movie.StarCoinsEarned","MovieData":"$movie.MovieData","Complexity":"$movie.Complexity","CompetitionDate":"$movie.CompetitionDate","CompetitionId":"$movie.CompetitionId","CompetitionVotes":"$movie.CompetitionVotes","ActorClothesData":"$movie.ActorClothesData","MovieActorRels":"$movie.MovieActorRels","Scenes":"$movie.Scenes","ActorWatched":"$movie.ActorWatched"}},{"$sort":{"PublishedDate":-1}},{"$skip":0},{"$limit":4}],"cursor":{},"lsid":{"id":{"$uuid":"d4655d1a-c242-4efe-9d03-f01c1eb65d6f"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":52594,"docsExamined":52594,"hasSortStage":true,"cursorExhausted":true,"numYields":485,"nreturned":4,"queryHash":"66386607","planCacheKey":"B7D2A098","queryFramework":"classic","reslen":55951,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1667}},"Global":{"acquireCount":{"r":1667}},"Mutex":{"acquireCount":{"r":1182}}},"storage":{"data":{"bytesRead":259187209,"timeReadingMicros":3016304}},"remote":"10.0.0.254:39318","protocol":"op_msg","durationMillis":8591}} {"t":{"$date":"2023-08-26T10:25:52.517+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"ReceiverId":13169,"Status":1},{"RequesterId":13169,"Status":1}]}},{"$set":{"fieldResult":{"$cond":{"if":{"$eq":["$ReceiverId",13169]},"then":"$RequesterId","else":"$ReceiverId"}}}},{"$lookup":{"from":"movies","localField":"fieldResult","foreignField":"ActorId","pipeline":[{"$match":{"State":100,"MovieActorRels.ActorId":13169}}],"as":"movie"}},{"$unwind":{"path":"$movie","preserveNullAndEmptyArrays":true}},{"$match":{"movie":{"$exists":true}}},{"$project":{"MovieId":"$movie.MovieId","Name":"$movie.Name","ActorId":"$movie.ActorId","Guid":"$movie.Guid","State":"$movie.State","WatchedTotalCount":"$movie.WatchedTotalCount","WatchedActorCount":"$movie.WatchedActorCount","RatedCount":"$movie.RatedCount","RatedTotalScore":"$movie.RatedTotalScore","AverageRating":"$movie.AverageRating","CreatedDate":"$movie.CreatedDate","PublishedDate":"$movie.PublishedDate","StarCoinsEarned":"$movie.StarCoinsEarned","MovieData":"$movie.MovieData","Complexity":"$movie.Complexity","CompetitionDate":"$movie.CompetitionDate","CompetitionId":"$movie.CompetitionId","CompetitionVotes":"$movie.CompetitionVotes","ActorClothesData":"$movie.ActorClothesData","MovieActorRels":"$movie.MovieActorRels","Scenes":"$movie.Scenes","ActorWatched":"$movie.ActorWatched"}},{"$group":{"_id":null,"count":{"$sum":1}}}],"cursor":{},"lsid":{"id":{"$uuid":"deba3505-ac0b-41ae-b380-26348c124cfb"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":52655,"docsExamined":52655,"cursorExhausted":true,"numYields":95,"nreturned":1,"queryHash":"66386607","planCacheKey":"B7D2A098","queryFramework":"classic","reslen":129,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1197}},"Global":{"acquireCount":{"r":1197}},"Mutex":{"acquireCount":{"r":1102}}},"storage":{},"remote":"10.0.0.254:56768","protocol":"op_msg","durationMillis":430}} {"t":{"$date":"2023-08-26T10:25:52.930+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"mspretro.friends","appName":"App Service","command":{"aggregate":"friends","pipeline":[{"$match":{"$or":[{"ReceiverId":13169,"Status":1},{"RequesterId":13169,"Status":1}]}},{"$set":{"fieldResult":{"$cond":{"if":{"$eq":["$ReceiverId",13169]},"then":"$RequesterId","else":"$ReceiverId"}}}},{"$lookup":{"from":"movies","localField":"fieldResult","foreignField":"ActorId","pipeline":[{"$match":{"State":100}}],"as":"movie"}},{"$unwind":{"path":"$movie","preserveNullAndEmptyArrays":true}},{"$match":{"movie":{"$exists":true}}},{"$project":{"MovieId":"$movie.MovieId","Name":"$movie.Name","ActorId":"$movie.ActorId","Guid":"$movie.Guid","State":"$movie.State","WatchedTotalCount":"$movie.WatchedTotalCount","WatchedActorCount":"$movie.WatchedActorCount","RatedCount":"$movie.RatedCount","RatedTotalScore":"$movie.RatedTotalScore","AverageRating":"$movie.AverageRating","CreatedDate":"$movie.CreatedDate","PublishedDate":"$movie.PublishedDate","StarCoinsEarned":"$movie.StarCoinsEarned","MovieData":"$movie.MovieData","Complexity":"$movie.Complexity","CompetitionDate":"$movie.CompetitionDate","CompetitionId":"$movie.CompetitionId","CompetitionVotes":"$movie.CompetitionVotes","ActorClothesData":"$movie.ActorClothesData","MovieActorRels":"$movie.MovieActorRels","Scenes":"$movie.Scenes","ActorWatched":"$movie.ActorWatched"}},{"$group":{"_id":null,"count":{"$sum":1}}}],"cursor":{},"lsid":{"id":{"$uuid":"d4655d1a-c242-4efe-9d03-f01c1eb65d6f"}},"$db":"mspretro"},"planSummary":"IXSCAN { ReceiverId: 1 }, IXSCAN { RequesterId: 1 }","keysExamined":52655,"docsExamined":52655,"cursorExhausted":true,"numYields":37,"nreturned":1,"queryHash":"66386607","planCacheKey":"B7D2A098","queryFramework":"classic","reslen":129,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1219}},"Global":{"acquireCount":{"r":1219}},"Mutex":{"acquireCount":{"r":1182}}},"storage":{},"remote":"10.0.0.254:39318","protocol":"op_msg","durationMillis":833}}