Symfony Profiler

Command metrics

26 Database commands

17.871 ms Command time

Commands


{
    "find": "auth__account_role",
    "filter": {
        "_id": "69f8d93458bb8cc596e20d48"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "apps__app",
    "filter": {
        "_id": "safety_manager"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "apps__app",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "main_app": "safety"
                    }
                ]
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__user",
    "filter": {
        "_id": "69f8d93458bb8cc596e20d48"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "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": "iyq8FtBER+Wta8XLAvpaBQ==",
                "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": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "safety__violation",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "org": "a078791ce5833e8f8583ad0111073df1"
                    }
                ]
            }
        },
        {
            "$sort": {
                "_id": {
                    "$numberInt": "-1"
                }
            }
        },
        {
            "$limit": {
                "$numberInt": "1001"
            }
        },
        {
            "$facet": {
                "results": [
                    {
                        "$limit": {
                            "$numberInt": "1000"
                        }
                    }
                ],
                "count": [
                    {
                        "$count": "count"
                    }
                ]
            }
        },
        {
            "$addFields": {
                "__api_first_result__": {
                    "$literal": {
                        "$numberInt": "0"
                    }
                },
                "__api_max_results__": {
                    "$literal": {
                        "$numberInt": "1000"
                    }
                }
            }
        }
    ],
    "allowDiskUse": true,
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "auth__account",
    "pipeline": [
        {
            "$match": {
                "$and": [
                    {
                        "app": {
                            "$in": [
                                "safety_manager",
                                "safety_app",
                                "safety_manager"
                            ]
                        }
                    },
                    {
                        "_id": {
                            "$in": [
                                "6a09bb6dfaee056375a5f67f"
                            ]
                        }
                    }
                ]
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "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": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "auth__account",
    "filter": {
        "_id": "6a09bb6dfaee056375a5f67f"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "safety__violation",
    "pipeline": [
        {
            "$lookup": {
                "from": "files__file",
                "as": "images_lkup",
                "localField": "images",
                "foreignField": "_id"
            }
        },
        {
            "$match": {
                "_id": "6a0ae0f73f5927c8bff03c78"
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "files__file",
    "pipeline": [
        {
            "$match": {
                "_id": {
                    "$in": []
                }
            }
        },
        {
            "$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": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "safety__violation",
    "pipeline": [
        {
            "$lookup": {
                "from": "files__file",
                "as": "images_lkup",
                "localField": "images",
                "foreignField": "_id"
            }
        },
        {
            "$match": {
                "_id": "45c2bc1b9858328980d5d307d247bd97"
            }
        }
    ],
    "cursor": {},
    "$db": "viki",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "files__file",
    "pipeline": [
        {
            "$match": {
                "_id": {
                    "$in": []
                }
            }
        },
        {
            "$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": "iyq8FtBER+Wta8XLAvpaBQ==",
                "subType": "04"
            }
        }
    }
}

#	Time	Database	Info
1	0.582 ms	viki	{"find":"auth__account_role","filter":{"_id":"69f8d93458bb8cc596e20d48"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account_role", "filter": { "_id": "69f8d93458bb8cc596e20d48" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
2	0.655 ms	viki	{"find":"apps__app","filter":{"_id":"safety_manager"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "apps__app", "filter": { "_id": "safety_manager" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
3	0.642 ms	viki	{"aggregate":"apps__app","pipeline":[{"$match":{"$and":[{"main_app":"safety"}]}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "aggregate": "apps__app", "pipeline": [ { "$match": { "$and": [ { "main_app": "safety" } ] } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
4	0.619 ms	viki	{"find":"auth__user","filter":{"_id":"69f8d93458bb8cc596e20d48"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__user", "filter": { "_id": "69f8d93458bb8cc596e20d48" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
5	1.028 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":"iyq8FtBER+Wta8XLAvpaBQ==","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": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
6	2.400 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":"iyq8FtBER+Wta8XLAvpaBQ==","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": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
7	1.293 ms	viki	{"aggregate":"safety__violation","pipeline":[{"$match":{"$and":[{"org":"a078791ce5833e8f8583ad0111073df1"}]}},{"$sort":{"_id":{"$numberInt":"-1"}}},{"$limit":{"$numberInt":"1001"}},{"$facet":{"results":[{"$limit":{"$numberInt":"1000"}}],"count":[{"$count":"count"}]}},{"$addFields":{"__api_first_result__":{"$literal":{"$numberInt":"0"}},"__api_max_results__":{"$literal":{"$numberInt":"1000"}}}}],"allowDiskUse":true,"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "aggregate": "safety__violation", "pipeline": [ { "$match": { "$and": [ { "org": "a078791ce5833e8f8583ad0111073df1" } ] } }, { "$sort": { "_id": { "$numberInt": "-1" } } }, { "$limit": { "$numberInt": "1001" } }, { "$facet": { "results": [ { "$limit": { "$numberInt": "1000" } } ], "count": [ { "$count": "count" } ] } }, { "$addFields": { "__api_first_result__": { "$literal": { "$numberInt": "0" } }, "__api_max_results__": { "$literal": { "$numberInt": "1000" } } } } ], "allowDiskUse": true, "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
8	0.588 ms	viki	{"aggregate":"auth__account","pipeline":[{"$match":{"$and":[{"app":{"$in":["safety_manager","safety_app","safety_manager"]}},{"_id":{"$in":["6a09bb6dfaee056375a5f67f"]}}]}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "aggregate": "auth__account", "pipeline": [ { "$match": { "$and": [ { "app": { "$in": [ "safety_manager", "safety_app", "safety_manager" ] } }, { "_id": { "$in": [ "6a09bb6dfaee056375a5f67f" ] } } ] } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
9	0.440 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":"iyq8FtBER+Wta8XLAvpaBQ==","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": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
10	0.834 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
11	0.445 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
12	0.380 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
13	0.734 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
14	0.381 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
15	0.308 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
16	0.374 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
17	0.234 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
18	0.242 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
19	0.587 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
20	0.207 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
21	0.192 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
22	1.173 ms	viki	{"find":"auth__account","filter":{"_id":"6a09bb6dfaee056375a5f67f"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "find": "auth__account", "filter": { "_id": "6a09bb6dfaee056375a5f67f" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
23	0.772 ms	viki	{"aggregate":"safety__violation","pipeline":[{"$lookup":{"from":"files__file","as":"images_lkup","localField":"images","foreignField":"_id"}},{"$match":{"_id":"6a0ae0f73f5927c8bff03c78"}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "aggregate": "safety__violation", "pipeline": [ { "$lookup": { "from": "files__file", "as": "images_lkup", "localField": "images", "foreignField": "_id" } }, { "$match": { "_id": "6a0ae0f73f5927c8bff03c78" } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
24	0.578 ms	viki	{"aggregate":"files__file","pipeline":[{"$match":{"_id":{"$in":[]}}},{"$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":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "aggregate": "files__file", "pipeline": [ { "$match": { "_id": { "$in": [] } } }, { "$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": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
25	0.836 ms	viki	{"aggregate":"safety__violation","pipeline":[{"$lookup":{"from":"files__file","as":"images_lkup","localField":"images","foreignField":"_id"}},{"$match":{"_id":"45c2bc1b9858328980d5d307d247bd97"}}],"cursor":{},"$db":"viki","lsid":{"id":{"$binary":{"base64":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "aggregate": "safety__violation", "pipeline": [ { "$lookup": { "from": "files__file", "as": "images_lkup", "localField": "images", "foreignField": "_id" } }, { "$match": { "_id": "45c2bc1b9858328980d5d307d247bd97" } } ], "cursor": {}, "$db": "viki", "lsid": { "id": { "$binary": { "base64": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }
26	1.347 ms	viki	{"aggregate":"files__file","pipeline":[{"$match":{"_id":{"$in":[]}}},{"$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":"iyq8FtBER+Wta8XLAvpaBQ==","subType":"04"}}}} View formatted query { "aggregate": "files__file", "pipeline": [ { "$match": { "_id": { "$in": [] } } }, { "$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": "iyq8FtBER+Wta8XLAvpaBQ==", "subType": "04" } } } }

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Command metrics

Commands