Symfony Profiler

Command metrics

14 Database commands

9.276 ms Command time

Commands


{
    "find": "auth__account_role",
    "filter": {
        "_id": "69f8d93458bb8cc596e20d48"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "apps__app",
    "filter": {
        "_id": "safety_manager"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "apps__app",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "main_app": "safety"
                    }
                ]
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__user",
    "filter": {
        "_id": "69f8d93458bb8cc596e20d48"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "auth__account",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "app": {
                            "$in": [
                                "safety_manager",
                                "safety_app",
                                "safety_manager"
                            ]
                        }
                    },
                    {
                        "user": "69f8d93458bb8cc596e20d48",
                        "app": "safety_manager"
                    }
                ]
            }
        },
        {
            "$limit": {
                "$numberInt": "1"
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account_role",
    "filter": {
        "user": "69f8d93458bb8cc596e20d48"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "updated_at": {
            "$numberInt": "-1"
        }
    },
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "safety__user_certificate",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "org": "a078791ce5833e8f8583ad0111073df1"
                    }
                ]
            }
        },
        {
            "$sort": {
                "_id": {
                    "$numberInt": "-1"
                }
            }
        },
        {
            "$limit": {
                "$numberInt": "101"
            }
        },
        {
            "$facet": {
                "results": [
                    {
                        "$limit": {
                            "$numberInt": "100"
                        }
                    }
                ],
                "count": [
                    {
                        "$count": "count"
                    }
                ]
            }
        },
        {
            "$addFields": {
                "__api_first_result__": {
                    "$literal": {
                        "$numberInt": "0"
                    }
                },
                "__api_max_results__": {
                    "$literal": {
                        "$numberInt": "100"
                    }
                }
            }
        }
    ],
    "allowDiskUse": true,
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "safety__certificate",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "org": "a078791ce5833e8f8583ad0111073df1"
                    },
                    {
                        "_id": {
                            "$in": [
                                "safety_cert_2",
                                "safety_cert_4",
                                "safety_cert_3",
                                "safety_cert_1",
                                "73189ab9cce834058e5d99ada29d115d",
                                "6a09a7f96680e981f5b7e2e8"
                            ]
                        }
                    }
                ]
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "safety__profile",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "org": "a078791ce5833e8f8583ad0111073df1"
                    },
                    {
                        "_id": {
                            "$in": [
                                "6a31320ae530f4aacf9fea22",
                                "6a09bb6dfaee056375a5f67f"
                            ]
                        }
                    }
                ]
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "org__company",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "app": {
                            "$in": [
                                "safety_manager",
                                "safety_app",
                                "safety_manager"
                            ]
                        },
                        "org": "a078791ce5833e8f8583ad0111073df1"
                    },
                    {
                        "_id": {
                            "$in": [
                                "6a034bc7b09c52e34c235447"
                            ]
                        }
                    }
                ]
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a31320ae530f4aacf9fea22"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account_role",
    "filter": {
        "user": "6a31320ae530f4aacf9fea22"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "updated_at": {
            "$numberInt": "-1"
        }
    },
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a045a57a8a66d37ae2d54e8"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account_role",
    "filter": {
        "user": "6a045a57a8a66d37ae2d54e8"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "updated_at": {
            "$numberInt": "-1"
        }
    },
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "9LbpGLwtRDaFiRcbmERyxA==",
                "subType": "04"
            }
        }
    }
}

#	Time	Database	Info
1	0.443 ms	viki	{"find":"auth__account_role","filter":{"_id":"69f8d93458bb8cc596e20d48"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "auth__account_role", "filter": { "_id": "69f8d93458bb8cc596e20d48" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
2	0.377 ms	viki	{"find":"apps__app","filter":{"_id":"safety_manager"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "apps__app", "filter": { "_id": "safety_manager" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
3	0.556 ms	viki	{"aggregate":"apps__app","pipeline":[{"$match":{"$and":[{"main_app":"safety"}]}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "aggregate": "apps__app", "pipeline": [ { "$match": { "$and": [ { "main_app": "safety" } ] } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
4	0.895 ms	viki	{"find":"auth__user","filter":{"_id":"69f8d93458bb8cc596e20d48"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "auth__user", "filter": { "_id": "69f8d93458bb8cc596e20d48" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
5	1.417 ms	viki	{"aggregate":"auth__account","pipeline":[{"$match":{"$and":[{"app":{"$in":["safety_manager","safety_app","safety_manager"]}},{"user":"69f8d93458bb8cc596e20d48","app":"safety_manager"}]}},{"$limit":{"$numberInt":"1"}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "aggregate": "auth__account", "pipeline": [ { "$match": { "$and": [ { "app": { "$in": [ "safety_manager", "safety_app", "safety_manager" ] } }, { "user": "69f8d93458bb8cc596e20d48", "app": "safety_manager" } ] } }, { "$limit": { "$numberInt": "1" } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
6	0.766 ms	viki	{"find":"auth__account_role","filter":{"user":"69f8d93458bb8cc596e20d48"},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"updated_at":{"$numberInt":"-1"}},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "auth__account_role", "filter": { "user": "69f8d93458bb8cc596e20d48" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "updated_at": { "$numberInt": "-1" } }, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
7	1.046 ms	viki	{"aggregate":"safety__user_certificate","pipeline":[{"$match":{"$and":[{"org":"a078791ce5833e8f8583ad0111073df1"}]}},{"$sort":{"_id":{"$numberInt":"-1"}}},{"$limit":{"$numberInt":"101"}},{"$facet":{"results":[{"$limit":{"$numberInt":"100"}}],"count":[{"$count":"count"}]}},{"$addFields":{"__api_first_result__":{"$literal":{"$numberInt":"0"}},"__api_max_results__":{"$literal":{"$numberInt":"100"}}}}],"allowDiskUse":true,"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "aggregate": "safety__user_certificate", "pipeline": [ { "$match": { "$and": [ { "org": "a078791ce5833e8f8583ad0111073df1" } ] } }, { "$sort": { "_id": { "$numberInt": "-1" } } }, { "$limit": { "$numberInt": "101" } }, { "$facet": { "results": [ { "$limit": { "$numberInt": "100" } } ], "count": [ { "$count": "count" } ] } }, { "$addFields": { "__api_first_result__": { "$literal": { "$numberInt": "0" } }, "__api_max_results__": { "$literal": { "$numberInt": "100" } } } } ], "allowDiskUse": true, "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
8	0.621 ms	viki	{"aggregate":"safety__certificate","pipeline":[{"$match":{"$and":[{"org":"a078791ce5833e8f8583ad0111073df1"},{"_id":{"$in":["safety_cert_2","safety_cert_4","safety_cert_3","safety_cert_1","73189ab9cce834058e5d99ada29d115d","6a09a7f96680e981f5b7e2e8"]}}]}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "aggregate": "safety__certificate", "pipeline": [ { "$match": { "$and": [ { "org": "a078791ce5833e8f8583ad0111073df1" }, { "_id": { "$in": [ "safety_cert_2", "safety_cert_4", "safety_cert_3", "safety_cert_1", "73189ab9cce834058e5d99ada29d115d", "6a09a7f96680e981f5b7e2e8" ] } } ] } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
9	0.451 ms	viki	{"aggregate":"safety__profile","pipeline":[{"$match":{"$and":[{"org":"a078791ce5833e8f8583ad0111073df1"},{"_id":{"$in":["6a31320ae530f4aacf9fea22","6a09bb6dfaee056375a5f67f"]}}]}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "aggregate": "safety__profile", "pipeline": [ { "$match": { "$and": [ { "org": "a078791ce5833e8f8583ad0111073df1" }, { "_id": { "$in": [ "6a31320ae530f4aacf9fea22", "6a09bb6dfaee056375a5f67f" ] } } ] } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
10	0.437 ms	viki	{"aggregate":"org__company","pipeline":[{"$match":{"$and":[{"app":{"$in":["safety_manager","safety_app","safety_manager"]},"org":"a078791ce5833e8f8583ad0111073df1"},{"_id":{"$in":["6a034bc7b09c52e34c235447"]}}]}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "aggregate": "org__company", "pipeline": [ { "$match": { "$and": [ { "app": { "$in": [ "safety_manager", "safety_app", "safety_manager" ] }, "org": "a078791ce5833e8f8583ad0111073df1" }, { "_id": { "$in": [ "6a034bc7b09c52e34c235447" ] } } ] } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
11	0.638 ms	viki	{"find":"auth__account","filter":{"_id":"6a31320ae530f4aacf9fea22"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a31320ae530f4aacf9fea22" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
12	0.785 ms	viki	{"find":"auth__account_role","filter":{"user":"6a31320ae530f4aacf9fea22"},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"updated_at":{"$numberInt":"-1"}},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "auth__account_role", "filter": { "user": "6a31320ae530f4aacf9fea22" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "updated_at": { "$numberInt": "-1" } }, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
13	0.338 ms	viki	{"find":"auth__account","filter":{"_id":"6a045a57a8a66d37ae2d54e8"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a045a57a8a66d37ae2d54e8" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }
14	0.506 ms	viki	{"find":"auth__account_role","filter":{"user":"6a045a57a8a66d37ae2d54e8"},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"updated_at":{"$numberInt":"-1"}},"$db":"viki","lsid":{"id":{"$binary":{"base64":"9LbpGLwtRDaFiRcbmERyxA==","subType":"04"}}}} View formatted query { "find": "auth__account_role", "filter": { "user": "6a045a57a8a66d37ae2d54e8" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "updated_at": { "$numberInt": "-1" } }, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "9LbpGLwtRDaFiRcbmERyxA==", "subType": "04" } } } }

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Command metrics

Commands