Symfony Profiler

Settings

Command metrics

22 Database commands

9.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"
}
{
    "find": "Tag",
    "filter": {
        "url": "interior-design"
    },
    "limit": {
        "$numberInt": "1"
    },
    "$db": "decostore"
}
{
    "aggregate": "Article",
    "pipeline": [
        {
            "$match": {
                "active": true,
                "tags": {
                    "$oid": "64491b4b97b17276ba075182"
                }
            }
        },
        {
            "$count": "_rowcount"
        }
    ],
    "allowDiskUse": true,
    "cursor": {},
    "$db": "decostore"
}
{
    "aggregate": "Article",
    "pipeline": [
        {
            "$match": {
                "active": true,
                "tags": {
                    "$oid": "64491b4b97b17276ba075182"
                }
            }
        },
        {
            "$sort": {
                "date": {
                    "$numberInt": "-1"
                }
            }
        },
        {
            "$project": {
                "_id": {
                    "$numberInt": "1"
                }
            }
        },
        {
            "$limit": {
                "$numberInt": "6"
            }
        }
    ],
    "allowDiskUse": true,
    "cursor": {},
    "$db": "decostore"
}
{
    "find": "Article",
    "filter": {
        "_id": {
            "$in": [
                {
                    "$oid": "65aec5949e3cb106b0034a2c"
                },
                {
                    "$oid": "65a19365a46e9900d106cbfb"
                },
                {
                    "$oid": "655b3fac7a56b4a5ba0a7b2f"
                },
                {
                    "$oid": "644b8ba7cfc066ed55065c4a"
                },
                {
                    "$oid": "644a846eff772bfcc9073a46"
                }
            ]
        }
    },
    "$db": "decostore"
}
{
    "find": "Article",
    "filter": {
        "active": true,
        "tags": {
            "$oid": "64491b4b97b17276ba075182"
        }
    },
    "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.772 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.418 ms	decostore	{"find":"Config","filter":{},"limit":{"$numberInt":"1"},"$db":"decostore"} View formatted query { "find": "Config", "filter": {}, "limit": { "$numberInt": "1" }, "$db": "decostore" }
3	0.401 ms	decostore	{"find":"Tag","filter":{"url":"interior-design"},"limit":{"$numberInt":"1"},"$db":"decostore"} View formatted query { "find": "Tag", "filter": { "url": "interior-design" }, "limit": { "$numberInt": "1" }, "$db": "decostore" }
4	0.603 ms	decostore	{"aggregate":"Article","pipeline":[{"$match":{"active":true,"tags":{"$oid":"64491b4b97b17276ba075182"}}},{"$count":"_rowcount"}],"allowDiskUse":true,"cursor":{},"$db":"decostore"} View formatted query { "aggregate": "Article", "pipeline": [ { "$match": { "active": true, "tags": { "$oid": "64491b4b97b17276ba075182" } } }, { "$count": "_rowcount" } ], "allowDiskUse": true, "cursor": {}, "$db": "decostore" }
5	0.399 ms	decostore	{"aggregate":"Article","pipeline":[{"$match":{"active":true,"tags":{"$oid":"64491b4b97b17276ba075182"}}},{"$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, "tags": { "$oid": "64491b4b97b17276ba075182" } } }, { "$sort": { "date": { "$numberInt": "-1" } } }, { "$project": { "_id": { "$numberInt": "1" } } }, { "$limit": { "$numberInt": "6" } } ], "allowDiskUse": true, "cursor": {}, "$db": "decostore" }
6	0.393 ms	decostore	{"find":"Article","filter":{"_id":{"$in":[{"$oid":"65aec5949e3cb106b0034a2c"},{"$oid":"65a19365a46e9900d106cbfb"},{"$oid":"655b3fac7a56b4a5ba0a7b2f"},{"$oid":"644b8ba7cfc066ed55065c4a"},{"$oid":"644a846eff772bfcc9073a46"}]}},"$db":"decostore"} View formatted query { "find": "Article", "filter": { "_id": { "$in": [ { "$oid": "65aec5949e3cb106b0034a2c" }, { "$oid": "65a19365a46e9900d106cbfb" }, { "$oid": "655b3fac7a56b4a5ba0a7b2f" }, { "$oid": "644b8ba7cfc066ed55065c4a" }, { "$oid": "644a846eff772bfcc9073a46" } ] } }, "$db": "decostore" }
7	0.561 ms	decostore	{"find":"Article","filter":{"active":true,"tags":{"$oid":"64491b4b97b17276ba075182"}},"sort":{"date":{"$numberInt":"-1"}},"limit":{"$numberInt":"4"},"$db":"decostore"} View formatted query { "find": "Article", "filter": { "active": true, "tags": { "$oid": "64491b4b97b17276ba075182" } }, "sort": { "date": { "$numberInt": "-1" } }, "limit": { "$numberInt": "4" }, "$db": "decostore" }
8	0.244 ms	decostore	{"find":"Tag","filter":{},"sort":{"name":{"$numberInt":"1"}},"$db":"decostore"} View formatted query { "find": "Tag", "filter": {}, "sort": { "name": { "$numberInt": "1" } }, "$db": "decostore" }
9	0.522 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" }
10	0.484 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" }
11	0.470 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" }
12	0.360 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" }
13	0.378 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" }
14	0.401 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" }
15	0.290 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" }
16	0.455 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" }
17	0.437 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" }
18	0.355 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" }
19	0.285 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" }
20	0.319 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" }
21	0.379 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" }
22	0.317 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?tag=interior-design

Configuration Settings

Theme

Page Width

Command metrics

Commands