Symfony Profiler

Command metrics

20 Database commands

20.435 ms Command time

Commands


{
    "find": "Configuration",
    "filter": {
        "dbName": {
            "$exists": true
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "createdAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "User",
    "filter": {
        "_id": {
            "$oid": "692451425e49662fa1004c82"
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Import",
    "filter": {
        "_id": {
            "$numberInt": "1"
        },
        "type": "dynamic"
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Configuration",
    "filter": {
        "dbName": {
            "$exists": true
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "createdAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Configuration",
    "filter": {
        "dbName": {
            "$exists": true
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "createdAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "aggregate": "Element",
    "pipeline": [
        {
            "$project": {
                "props": {
                    "$objectToArray": "$data"
                }
            }
        },
        {
            "$unwind": "$props"
        },
        {
            "$group": {
                "_id": null,
                "allKeys": {
                    "$addToSet": "$props.k"
                }
            }
        },
        {
            "$project": {
                "_id": {
                    "$numberInt": "0"
                },
                "allKeys": {
                    "$numberInt": "1"
                }
            }
        }
    ],
    "cursor": {},
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Configuration",
    "filter": {
        "dbName": {
            "$exists": true
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "createdAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Option",
    "filter": {},
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "updatedAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Category",
    "filter": {},
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "updatedAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Element",
    "filter": {
        "sourceKey": "bonnetable"
    },
    "projection": {
        "_id": {
            "$numberInt": "1"
        },
        "oldId": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "getMore": {
        "$numberLong": "958104863171269596"
    },
    "collection": "Element",
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "TileLayer",
    "filter": {
        "_id": {
            "$numberInt": "1"
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "User",
    "filter": {
        "$or": [
            {
                "roles": {
                    "$exists": true
                }
            },
            {
                "groups": {
                    "$exists": true
                }
            }
        ]
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Option",
    "filter": {},
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "GoGoLog",
    "filter": {
        "_id": {
            "$in": [
                {
                    "$numberInt": "7"
                },
                {
                    "$numberInt": "9"
                },
                {
                    "$numberInt": "11"
                },
                {
                    "$numberInt": "13"
                },
                {
                    "$numberInt": "16"
                },
                {
                    "$numberInt": "18"
                },
                {
                    "$numberInt": "19"
                },
                {
                    "$numberInt": "20"
                }
            ]
        }
    },
    "sort": {},
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Configuration",
    "filter": {
        "dbName": {
            "$exists": true
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "createdAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Configuration",
    "filter": {
        "dbName": {
            "$exists": true
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "createdAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Configuration",
    "filter": {
        "dbName": {
            "$exists": true
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "singleBatch": true,
    "sort": {
        "createdAt": {
            "$numberInt": "-1"
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "GoGoLog",
    "filter": {
        "type": "update",
        "hidden": false
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "GoGoLog",
    "filter": {
        "level": "error",
        "hidden": false,
        "type": {
            "$in": [
                "standard",
                "import",
                "update",
                null
            ]
        }
    },
    "$db": "testvf",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "GMFqgoUgT7+T+nAluQ87Qw==",
                "subType": "04"
            }
        }
    }
}

#	Time	Database	Info
1	0.866 ms	testvf	{"find":"Configuration","filter":{"dbName":{"$exists":true}},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"createdAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Configuration", "filter": { "dbName": { "$exists": true } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "createdAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
2	0.482 ms	testvf	{"find":"User","filter":{"_id":{"$oid":"692451425e49662fa1004c82"}},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "User", "filter": { "_id": { "$oid": "692451425e49662fa1004c82" } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
3	0.613 ms	testvf	{"find":"Import","filter":{"_id":{"$numberInt":"1"},"type":"dynamic"},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Import", "filter": { "_id": { "$numberInt": "1" }, "type": "dynamic" }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
4	0.476 ms	testvf	{"find":"Configuration","filter":{"dbName":{"$exists":true}},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"createdAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Configuration", "filter": { "dbName": { "$exists": true } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "createdAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
5	0.458 ms	testvf	{"find":"Configuration","filter":{"dbName":{"$exists":true}},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"createdAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Configuration", "filter": { "dbName": { "$exists": true } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "createdAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
6	6.184 ms	testvf	{"aggregate":"Element","pipeline":[{"$project":{"props":{"$objectToArray":"$data"}}},{"$unwind":"$props"},{"$group":{"_id":null,"allKeys":{"$addToSet":"$props.k"}}},{"$project":{"_id":{"$numberInt":"0"},"allKeys":{"$numberInt":"1"}}}],"cursor":{},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "aggregate": "Element", "pipeline": [ { "$project": { "props": { "$objectToArray": "$data" } } }, { "$unwind": "$props" }, { "$group": { "_id": null, "allKeys": { "$addToSet": "$props.k" } } }, { "$project": { "_id": { "$numberInt": "0" }, "allKeys": { "$numberInt": "1" } } } ], "cursor": {}, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
7	0.556 ms	testvf	{"find":"Configuration","filter":{"dbName":{"$exists":true}},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"createdAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Configuration", "filter": { "dbName": { "$exists": true } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "createdAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
8	0.489 ms	testvf	{"find":"Option","filter":{},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"updatedAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Option", "filter": {}, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "updatedAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
9	0.451 ms	testvf	{"find":"Category","filter":{},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"updatedAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Category", "filter": {}, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "updatedAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
10	2.095 ms	testvf	{"find":"Element","filter":{"sourceKey":"bonnetable"},"projection":{"_id":{"$numberInt":"1"},"oldId":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Element", "filter": { "sourceKey": "bonnetable" }, "projection": { "_id": { "$numberInt": "1" }, "oldId": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
11	2.143 ms	testvf	{"getMore":{"$numberLong":"958104863171269596"},"collection":"Element","$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "getMore": { "$numberLong": "958104863171269596" }, "collection": "Element", "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
12	0.479 ms	testvf	{"find":"TileLayer","filter":{"_id":{"$numberInt":"1"}},"limit":{"$numberInt":"1"},"singleBatch":true,"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "TileLayer", "filter": { "_id": { "$numberInt": "1" } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
13	1.014 ms	testvf	{"find":"User","filter":{"$or":[{"roles":{"$exists":true}},{"groups":{"$exists":true}}]},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "User", "filter": { "$or": [ { "roles": { "$exists": true } }, { "groups": { "$exists": true } } ] }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
14	0.465 ms	testvf	{"find":"Option","filter":{},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Option", "filter": {}, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
15	0.999 ms	testvf	{"find":"GoGoLog","filter":{"_id":{"$in":[{"$numberInt":"7"},{"$numberInt":"9"},{"$numberInt":"11"},{"$numberInt":"13"},{"$numberInt":"16"},{"$numberInt":"18"},{"$numberInt":"19"},{"$numberInt":"20"}]}},"sort":{},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "GoGoLog", "filter": { "_id": { "$in": [ { "$numberInt": "7" }, { "$numberInt": "9" }, { "$numberInt": "11" }, { "$numberInt": "13" }, { "$numberInt": "16" }, { "$numberInt": "18" }, { "$numberInt": "19" }, { "$numberInt": "20" } ] } }, "sort": {}, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
16	0.573 ms	testvf	{"find":"Configuration","filter":{"dbName":{"$exists":true}},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"createdAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Configuration", "filter": { "dbName": { "$exists": true } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "createdAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
17	0.510 ms	testvf	{"find":"Configuration","filter":{"dbName":{"$exists":true}},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"createdAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Configuration", "filter": { "dbName": { "$exists": true } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "createdAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
18	0.506 ms	testvf	{"find":"Configuration","filter":{"dbName":{"$exists":true}},"limit":{"$numberInt":"1"},"singleBatch":true,"sort":{"createdAt":{"$numberInt":"-1"}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "Configuration", "filter": { "dbName": { "$exists": true } }, "limit": { "$numberInt": "1" }, "singleBatch": true, "sort": { "createdAt": { "$numberInt": "-1" } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
19	0.513 ms	testvf	{"find":"GoGoLog","filter":{"type":"update","hidden":false},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "GoGoLog", "filter": { "type": "update", "hidden": false }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }
20	0.563 ms	testvf	{"find":"GoGoLog","filter":{"level":"error","hidden":false,"type":{"$in":["standard","import","update",null]}},"$db":"testvf","lsid":{"id":{"$binary":{"base64":"GMFqgoUgT7+T+nAluQ87Qw==","subType":"04"}}}} View formatted query { "find": "GoGoLog", "filter": { "level": "error", "hidden": false, "type": { "$in": [ "standard", "import", "update", null ] } }, "$db": "testvf", "lsid": { "id": { "$binary": { "base64": "GMFqgoUgT7+T+nAluQ87Qw==", "subType": "04" } } } }

Symfony Profiler

GET https://testvf.gogocarto.eu/admin/app/importdynamic/1/edit

Configuration Settings

Theme

Page Width

Command metrics

Commands