Symfony Profiler

Settings

Command metrics

21 Database commands

10.243 ms Command time

Commands


{
    "find": "Page",
    "filter": {
        "url": "blog",
        "active": true
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "decostore"
}
{
    "find": "Config",
    "filter": {},
    "limit": {
        "$numberInt": "1"
    },
    "$db": "decostore"
}
{
    "aggregate": "Article",
    "pipeline": [
        {
            "$match": {
                "active": true
            }
        },
        {
            "$count": "_rowcount"
        }
    ],
    "allowDiskUse": true,
    "cursor": {},
    "$db": "decostore"
}
{
    "aggregate": "Article",
    "pipeline": [
        {
            "$match": {
                "active": true
            }
        },
        {
            "$sort": {
                "date": {
                    "$numberInt": "-1"
                }
            }
        },
        {
            "$project": {
                "_id": {
                    "$numberInt": "1"
                }
            }
        },
        {
            "$limit": {
                "$numberInt": "6"
            }
        }
    ],
    "allowDiskUse": true,
    "cursor": {},
    "$db": "decostore"
}
{
    "find": "Article",
    "filter": {
        "_id": {
            "$in": [
                {
                    "$oid": "664e63c59e98c6e1160d9e92"
                },
                {
                    "$oid": "65aec5949e3cb106b0034a2c"
                },
                {
                    "$oid": "65a90096808c44b3b809d9e3"
                },
                {
                    "$oid": "65a196c6a36e0e3d870a04fe"
                },
                {
                    "$oid": "65a19365a46e9900d106cbfb"
                },
                {
                    "$oid": "65a18fe5a46e9900d106cbf9"
                }
            ]
        }
    },
    "$db": "decostore"
}
{
    "find": "Article",
    "filter": {
        "active": true
    },
    "sort": {
        "date": {
            "$numberInt": "-1"
        }
    },
    "limit": {
        "$numberInt": "4"
    },
    "$db": "decostore"
}
{
    "find": "Tag",
    "filter": {},
    "sort": {
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "active": true,
        "parent": null
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "651ec2dfa3a7b635d80b8297"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "6439458300e2b3060b06660c"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "643945b200e2b3060b066767"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "643951304a354872db47e7f6"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "64394dd34a354872db47c596"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "6439465a00e2b3060b067028"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "643947b100e2b3060b067c8a"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "64394bdd4a354872db47a20e"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "643946da00e2b3060b06772d"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "643942a953438624ea0f73ce"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "643942a653438624ea0f73bd"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "64393d6f03a9533244014f87"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}
{
    "find": "Category",
    "filter": {
        "$and": [
            {
                "parent": {
                    "$oid": "65157cf1fb8c92a5270c6b08"
                }
            },
            {
                "active": true
            }
        ]
    },
    "sort": {
        "orderNumber": {
            "$numberInt": "1"
        },
        "name": {
            "$numberInt": "1"
        }
    },
    "$db": "decostore"
}

#	Time	Database	Info
1	0.647 ms	decostore	{"find":"Page","filter":{"url":"blog","active":true},"limit":{"$numberInt":"1"},"$db":"decostore"} View formatted query { "find": "Page", "filter": { "url": "blog", "active": true }, "limit": { "$numberInt": "1" }, "$db": "decostore" }
2	0.440 ms	decostore	{"find":"Config","filter":{},"limit":{"$numberInt":"1"},"$db":"decostore"} View formatted query { "find": "Config", "filter": {}, "limit": { "$numberInt": "1" }, "$db": "decostore" }
3	0.692 ms	decostore	{"aggregate":"Article","pipeline":[{"$match":{"active":true}},{"$count":"_rowcount"}],"allowDiskUse":true,"cursor":{},"$db":"decostore"} View formatted query { "aggregate": "Article", "pipeline": [ { "$match": { "active": true } }, { "$count": "_rowcount" } ], "allowDiskUse": true, "cursor": {}, "$db": "decostore" }
4	0.464 ms	decostore	{"aggregate":"Article","pipeline":[{"$match":{"active":true}},{"$sort":{"date":{"$numberInt":"-1"}}},{"$project":{"_id":{"$numberInt":"1"}}},{"$limit":{"$numberInt":"6"}}],"allowDiskUse":true,"cursor":{},"$db":"decostore"} View formatted query { "aggregate": "Article", "pipeline": [ { "$match": { "active": true } }, { "$sort": { "date": { "$numberInt": "-1" } } }, { "$project": { "_id": { "$numberInt": "1" } } }, { "$limit": { "$numberInt": "6" } } ], "allowDiskUse": true, "cursor": {}, "$db": "decostore" }
5	0.465 ms	decostore	{"find":"Article","filter":{"_id":{"$in":[{"$oid":"664e63c59e98c6e1160d9e92"},{"$oid":"65aec5949e3cb106b0034a2c"},{"$oid":"65a90096808c44b3b809d9e3"},{"$oid":"65a196c6a36e0e3d870a04fe"},{"$oid":"65a19365a46e9900d106cbfb"},{"$oid":"65a18fe5a46e9900d106cbf9"}]}},"$db":"decostore"} View formatted query { "find": "Article", "filter": { "_id": { "$in": [ { "$oid": "664e63c59e98c6e1160d9e92" }, { "$oid": "65aec5949e3cb106b0034a2c" }, { "$oid": "65a90096808c44b3b809d9e3" }, { "$oid": "65a196c6a36e0e3d870a04fe" }, { "$oid": "65a19365a46e9900d106cbfb" }, { "$oid": "65a18fe5a46e9900d106cbf9" } ] } }, "$db": "decostore" }
6	0.551 ms	decostore	{"find":"Article","filter":{"active":true},"sort":{"date":{"$numberInt":"-1"}},"limit":{"$numberInt":"4"},"$db":"decostore"} View formatted query { "find": "Article", "filter": { "active": true }, "sort": { "date": { "$numberInt": "-1" } }, "limit": { "$numberInt": "4" }, "$db": "decostore" }
7	0.624 ms	decostore	{"find":"Tag","filter":{},"sort":{"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Tag", "filter": {}, "sort": { "name": { "$numberInt": "1" } }, "$db": "decostore" }
8	0.921 ms	decostore	{"find":"Category","filter":{"active":true,"parent":null},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "active": true, "parent": null }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
9	0.570 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"651ec2dfa3a7b635d80b8297"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "651ec2dfa3a7b635d80b8297" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
10	0.472 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"6439458300e2b3060b06660c"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "6439458300e2b3060b06660c" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
11	0.447 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"643945b200e2b3060b066767"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "643945b200e2b3060b066767" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
12	0.385 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"643951304a354872db47e7f6"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "643951304a354872db47e7f6" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
13	0.347 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"64394dd34a354872db47c596"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "64394dd34a354872db47c596" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
14	0.347 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"6439465a00e2b3060b067028"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "6439465a00e2b3060b067028" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
15	0.299 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"643947b100e2b3060b067c8a"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "643947b100e2b3060b067c8a" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
16	0.428 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"64394bdd4a354872db47a20e"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "64394bdd4a354872db47a20e" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
17	0.620 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"643946da00e2b3060b06772d"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "643946da00e2b3060b06772d" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
18	0.415 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"643942a953438624ea0f73ce"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "643942a953438624ea0f73ce" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
19	0.314 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"643942a653438624ea0f73bd"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "643942a653438624ea0f73bd" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
20	0.406 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"64393d6f03a9533244014f87"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "64393d6f03a9533244014f87" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }
21	0.389 ms	decostore	{"find":"Category","filter":{"$and":[{"parent":{"$oid":"65157cf1fb8c92a5270c6b08"}},{"active":true}]},"sort":{"orderNumber":{"$numberInt":"1"},"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Category", "filter": { "$and": [ { "parent": { "$oid": "65157cf1fb8c92a5270c6b08" } }, { "active": true } ] }, "sort": { "orderNumber": { "$numberInt": "1" }, "name": { "$numberInt": "1" } }, "$db": "decostore" }

Symfony Profiler

http://decostore.ru/blog

Configuration Settings

Theme

Page Width

Command metrics

Commands