POST http://viki.ukkera.com/api/graphql

Command metrics

5 Database commands
23.156 ms Command time

Commands

# Time Database Info
1 0.803 ms viki {"find":"apps__app","filter":{"_id":"hr_manager"},"limit":{"$numberInt":"1"},"$db":"viki"}
2 0.431 ms viki {"find":"apps__app","filter":{"main_app":"hr_manager"},"$db":"viki"}
3 0.953 ms viki {"find":"auth__user","filter":{"_id":"268fdf09a7f23a16aefdf9e8d0251d2d"},"limit":{"$numberInt":"1"},"$db":"viki"}
4 0.848 ms viki {"find":"auth__account","filter":{"user":"268fdf09a7f23a16aefdf9e8d0251d2d","app":"hr_manager"},"limit":{"$numberInt":"1"},"$db":"viki"}
5 20.121 ms viki {"aggregate":"employee__skill","pipeline":[{"$lookup":{"from":"employee__level","as":"__level","localField":"level","foreignField":"_id"}},{"$unwind":{"path":"$level","preserveNullAndEmptyArrays":true}},{"$match":{"$or":[{"name":{"$regularExpression":{"pattern":"personnel flo","options":"i"}}},{"type":{"$regularExpression":{"pattern":"personnel flo","options":"i"}}},{"__level.name":{"$regularExpression":{"pattern":"personnel flo","options":"i"}}},{"__level.code":{"$regularExpression":{"pattern":"personnel flo","options":"i"}}}]}},{"$match":{"$and":[{"org":"o_em_dt","company":"c_em_dt_eg"}]}},{"$facet":{"results":[{"$skip":{"$numberInt":"0"}},{"$limit":{"$numberInt":"100"}}],"count":[{"$count":"count"}]}}],"cursor":{},"$db":"viki"}