Symfony Profiler

Settings

Command metrics

11 Database commands

5.268 ms Command time

Commands


{
    "find": "MultimediaObject",
    "filter": {
        "$and": [
            {
                "_id": {
                    "$oid": "69fc398688186e03120bb2e2"
                }
            },
            {
                "tags.cod": "PUCHWEBTV",
                "status": {
                    "$in": [
                        {
                            "$numberInt": "0"
                        }
                    ]
                },
                "$or": [
                    {
                        "tracks": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        },
                        "properties.opencast": {
                            "$exists": false
                        }
                    },
                    {
                        "properties.opencast": {
                            "$exists": true
                        }
                    },
                    {
                        "external": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "documents": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "images": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "external": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    }
                ]
            }
        ]
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Series",
    "filter": {
        "$and": [
            {
                "_id": {
                    "$oid": "69faf26e0b7eb2039b00ce33"
                }
            },
            {
                "hide": false
            }
        ]
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Annotation",
    "filter": {
        "type": "paella\/marks",
        "multimediaObject": {
            "$oid": "69fc398688186e03120bb2e2"
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Annotation",
    "filter": {
        "type": "paella\/trimming",
        "multimediaObject": {
            "$oid": "69fc398688186e03120bb2e2"
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Series",
    "filter": {
        "$and": [
            {
                "_id": {
                    "$oid": "69faf26e0b7eb2039b00ce33"
                }
            },
            {
                "hide": false
            }
        ]
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Annotation",
    "filter": {
        "type": "paella\/marks",
        "multimediaObject": {
            "$oid": "69fc398688186e03120bb2e2"
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Annotation",
    "filter": {
        "type": "paella\/trimming",
        "multimediaObject": {
            "$oid": "69fc398688186e03120bb2e2"
        }
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Role",
    "filter": {
        "display": true
    },
    "sort": {
        "rank": {
            "$numberInt": "1"
        }
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "MultimediaObject",
    "filter": {
        "$and": [
            {
                "status": {
                    "$nin": [
                        {
                            "$numberInt": "-2"
                        },
                        {
                            "$numberInt": "-1"
                        }
                    ],
                    "$in": [
                        {
                            "$numberInt": "0"
                        }
                    ]
                },
                "type": {
                    "$ne": {
                        "$numberInt": "4"
                    }
                },
                "series": {
                    "$oid": "69faf26e0b7eb2039b00ce33"
                },
                "tags.cod": "PUCHWEBTV"
            },
            {
                "tags.cod": "PUCHWEBTV",
                "status": {
                    "$in": [
                        {
                            "$numberInt": "0"
                        }
                    ]
                },
                "$or": [
                    {
                        "tracks": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        },
                        "properties.opencast": {
                            "$exists": false
                        }
                    },
                    {
                        "properties.opencast": {
                            "$exists": true
                        }
                    },
                    {
                        "external": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "documents": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "images": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "external": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    }
                ]
            }
        ]
    },
    "skip": {
        "$numberInt": "0"
    },
    "sort": {
        "rank": {
            "$numberInt": "1"
        }
    },
    "limit": {
        "$numberInt": "12"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "Tag",
    "filter": {
        "cod": "UNESCO"
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}
{
    "find": "MultimediaObject",
    "filter": {
        "$and": [
            {
                "_id": {
                    "$ne": {
                        "$oid": "69fc398688186e03120bb2e2"
                    }
                },
                "series": {
                    "$ne": {
                        "$oid": "69faf26e0b7eb2039b00ce33"
                    }
                },
                "status": {
                    "$numberInt": "0"
                },
                "embeddedBroadcast.type": "public",
                "tags.cod": {
                    "$in": []
                }
            },
            {
                "tags.cod": "PUCHWEBTV",
                "status": {
                    "$in": [
                        {
                            "$numberInt": "0"
                        }
                    ]
                },
                "$or": [
                    {
                        "tracks": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        },
                        "properties.opencast": {
                            "$exists": false
                        }
                    },
                    {
                        "properties.opencast": {
                            "$exists": true
                        }
                    },
                    {
                        "external": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "documents": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "images": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    },
                    {
                        "external": {
                            "$elemMatch": {
                                "tags": "display",
                                "hide": false
                            }
                        }
                    }
                ]
            }
        ]
    },
    "sort": {
        "rank": {
            "$numberInt": "1"
        }
    },
    "limit": {
        "$numberInt": "20"
    },
    "$db": "pumukit",
    "lsid": {
        "id": {
            "$binary": {
                "base64": "U4oiXfzhRvCK4430OX8t9Q==",
                "subType": "04"
            }
        }
    }
}

#	Time	Database	Info
1	0.598 ms	pumukit	{"find":"MultimediaObject","filter":{"$and":[{"_id":{"$oid":"69fc398688186e03120bb2e2"}},{"tags.cod":"PUCHWEBTV","status":{"$in":[{"$numberInt":"0"}]},"$or":[{"tracks":{"$elemMatch":{"tags":"display","hide":false}},"properties.opencast":{"$exists":false}},{"properties.opencast":{"$exists":true}},{"external":{"$elemMatch":{"tags":"display","hide":false}}},{"documents":{"$elemMatch":{"tags":"display","hide":false}}},{"images":{"$elemMatch":{"tags":"display","hide":false}}},{"external":{"$elemMatch":{"tags":"display","hide":false}}}]}]},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "MultimediaObject", "filter": { "$and": [ { "_id": { "$oid": "69fc398688186e03120bb2e2" } }, { "tags.cod": "PUCHWEBTV", "status": { "$in": [ { "$numberInt": "0" } ] }, "$or": [ { "tracks": { "$elemMatch": { "tags": "display", "hide": false } }, "properties.opencast": { "$exists": false } }, { "properties.opencast": { "$exists": true } }, { "external": { "$elemMatch": { "tags": "display", "hide": false } } }, { "documents": { "$elemMatch": { "tags": "display", "hide": false } } }, { "images": { "$elemMatch": { "tags": "display", "hide": false } } }, { "external": { "$elemMatch": { "tags": "display", "hide": false } } } ] } ] }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
2	0.573 ms	pumukit	{"find":"Series","filter":{"$and":[{"_id":{"$oid":"69faf26e0b7eb2039b00ce33"}},{"hide":false}]},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Series", "filter": { "$and": [ { "_id": { "$oid": "69faf26e0b7eb2039b00ce33" } }, { "hide": false } ] }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
3	0.400 ms	pumukit	{"find":"Annotation","filter":{"type":"paella\/marks","multimediaObject":{"$oid":"69fc398688186e03120bb2e2"}},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Annotation", "filter": { "type": "paella\/marks", "multimediaObject": { "$oid": "69fc398688186e03120bb2e2" } }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
4	0.256 ms	pumukit	{"find":"Annotation","filter":{"type":"paella\/trimming","multimediaObject":{"$oid":"69fc398688186e03120bb2e2"}},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Annotation", "filter": { "type": "paella\/trimming", "multimediaObject": { "$oid": "69fc398688186e03120bb2e2" } }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
5	0.330 ms	pumukit	{"find":"Series","filter":{"$and":[{"_id":{"$oid":"69faf26e0b7eb2039b00ce33"}},{"hide":false}]},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Series", "filter": { "$and": [ { "_id": { "$oid": "69faf26e0b7eb2039b00ce33" } }, { "hide": false } ] }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
6	0.498 ms	pumukit	{"find":"Annotation","filter":{"type":"paella\/marks","multimediaObject":{"$oid":"69fc398688186e03120bb2e2"}},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Annotation", "filter": { "type": "paella\/marks", "multimediaObject": { "$oid": "69fc398688186e03120bb2e2" } }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
7	0.279 ms	pumukit	{"find":"Annotation","filter":{"type":"paella\/trimming","multimediaObject":{"$oid":"69fc398688186e03120bb2e2"}},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Annotation", "filter": { "type": "paella\/trimming", "multimediaObject": { "$oid": "69fc398688186e03120bb2e2" } }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
8	0.452 ms	pumukit	{"find":"Role","filter":{"display":true},"sort":{"rank":{"$numberInt":"1"}},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Role", "filter": { "display": true }, "sort": { "rank": { "$numberInt": "1" } }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
9	0.803 ms	pumukit	{"find":"MultimediaObject","filter":{"$and":[{"status":{"$nin":[{"$numberInt":"-2"},{"$numberInt":"-1"}],"$in":[{"$numberInt":"0"}]},"type":{"$ne":{"$numberInt":"4"}},"series":{"$oid":"69faf26e0b7eb2039b00ce33"},"tags.cod":"PUCHWEBTV"},{"tags.cod":"PUCHWEBTV","status":{"$in":[{"$numberInt":"0"}]},"$or":[{"tracks":{"$elemMatch":{"tags":"display","hide":false}},"properties.opencast":{"$exists":false}},{"properties.opencast":{"$exists":true}},{"external":{"$elemMatch":{"tags":"display","hide":false}}},{"documents":{"$elemMatch":{"tags":"display","hide":false}}},{"images":{"$elemMatch":{"tags":"display","hide":false}}},{"external":{"$elemMatch":{"tags":"display","hide":false}}}]}]},"skip":{"$numberInt":"0"},"sort":{"rank":{"$numberInt":"1"}},"limit":{"$numberInt":"12"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "MultimediaObject", "filter": { "$and": [ { "status": { "$nin": [ { "$numberInt": "-2" }, { "$numberInt": "-1" } ], "$in": [ { "$numberInt": "0" } ] }, "type": { "$ne": { "$numberInt": "4" } }, "series": { "$oid": "69faf26e0b7eb2039b00ce33" }, "tags.cod": "PUCHWEBTV" }, { "tags.cod": "PUCHWEBTV", "status": { "$in": [ { "$numberInt": "0" } ] }, "$or": [ { "tracks": { "$elemMatch": { "tags": "display", "hide": false } }, "properties.opencast": { "$exists": false } }, { "properties.opencast": { "$exists": true } }, { "external": { "$elemMatch": { "tags": "display", "hide": false } } }, { "documents": { "$elemMatch": { "tags": "display", "hide": false } } }, { "images": { "$elemMatch": { "tags": "display", "hide": false } } }, { "external": { "$elemMatch": { "tags": "display", "hide": false } } } ] } ] }, "skip": { "$numberInt": "0" }, "sort": { "rank": { "$numberInt": "1" } }, "limit": { "$numberInt": "12" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
10	0.517 ms	pumukit	{"find":"Tag","filter":{"cod":"UNESCO"},"limit":{"$numberInt":"1"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "Tag", "filter": { "cod": "UNESCO" }, "limit": { "$numberInt": "1" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }
11	0.562 ms	pumukit	{"find":"MultimediaObject","filter":{"$and":[{"_id":{"$ne":{"$oid":"69fc398688186e03120bb2e2"}},"series":{"$ne":{"$oid":"69faf26e0b7eb2039b00ce33"}},"status":{"$numberInt":"0"},"embeddedBroadcast.type":"public","tags.cod":{"$in":[]}},{"tags.cod":"PUCHWEBTV","status":{"$in":[{"$numberInt":"0"}]},"$or":[{"tracks":{"$elemMatch":{"tags":"display","hide":false}},"properties.opencast":{"$exists":false}},{"properties.opencast":{"$exists":true}},{"external":{"$elemMatch":{"tags":"display","hide":false}}},{"documents":{"$elemMatch":{"tags":"display","hide":false}}},{"images":{"$elemMatch":{"tags":"display","hide":false}}},{"external":{"$elemMatch":{"tags":"display","hide":false}}}]}]},"sort":{"rank":{"$numberInt":"1"}},"limit":{"$numberInt":"20"},"$db":"pumukit","lsid":{"id":{"$binary":{"base64":"U4oiXfzhRvCK4430OX8t9Q==","subType":"04"}}}} View formatted query { "find": "MultimediaObject", "filter": { "$and": [ { "_id": { "$ne": { "$oid": "69fc398688186e03120bb2e2" } }, "series": { "$ne": { "$oid": "69faf26e0b7eb2039b00ce33" } }, "status": { "$numberInt": "0" }, "embeddedBroadcast.type": "public", "tags.cod": { "$in": [] } }, { "tags.cod": "PUCHWEBTV", "status": { "$in": [ { "$numberInt": "0" } ] }, "$or": [ { "tracks": { "$elemMatch": { "tags": "display", "hide": false } }, "properties.opencast": { "$exists": false } }, { "properties.opencast": { "$exists": true } }, { "external": { "$elemMatch": { "tags": "display", "hide": false } } }, { "documents": { "$elemMatch": { "tags": "display", "hide": false } } }, { "images": { "$elemMatch": { "tags": "display", "hide": false } } }, { "external": { "$elemMatch": { "tags": "display", "hide": false } } } ] } ] }, "sort": { "rank": { "$numberInt": "1" } }, "limit": { "$numberInt": "20" }, "$db": "pumukit", "lsid": { "id": { "$binary": { "base64": "U4oiXfzhRvCK4430OX8t9Q==", "subType": "04" } } } }

Symfony Profiler

https://video-cms.ptbsp.com/video/69fc398688186e03120bb2e2?track_id=69fc58ba47eab5b993012cf2

Configuration Settings

Theme

Page Width

Command metrics

Commands