Symfony Profiler

Query Metrics

2 Database Queries

7.97 ms Execution Time

4.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

3.51 ms

1.00 ms

#▲	Execution Time	Query Time	Info
1	3.51 ms	1.00 ms	{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12} Path: at_product_dev/_search Query: Method: POST (Http on elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200) Item count: 0 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "483" ] } } } } ] } }, { "bool": { "must": [ { "terms": { "manufacturer": [ 17 ] } }, { "terms": { "productClass": [ 80 ] } } ] } } ] } }, "sort": { "categories.position": { "nested": { "path": "categories", "filter": { "terms": { "categories.id": [ 483 ] } } } } }, "aggs": { "category": { "global": {}, "aggs": { "category_nested": { "nested": { "path": "categories" }, "aggs": { "category_filter": { "filter": { "terms": { "categories.id": [ 483 ] } }, "aggs": { "category_global": { "reverse_nested": {}, "aggs": { "price_min": { "min": { "field": "price" } }, "price_max": { "max": { "field": "price" } }, "dimensions": { "nested": { "path": "attributes" }, "aggs": { "width_min": { "min": { "field": "attributes.width" } }, "width_max": { "max": { "field": "attributes.width" } }, "height_min": { "min": { "field": "attributes.height" } }, "height_max": { "max": { "field": "attributes.height" } }, "power_min": { "min": { "field": "attributes.power" } }, "power_max": { "max": { "field": "attributes.power" } } } } } } } } } } } }, "manufacturer": { "terms": { "field": "manufacturer", "size": 100 } }, "product_class": { "terms": { "field": "productClass", "size": 100 } }, "price": { "range": { "field": "price", "ranges": [ { "to": 500, "key": "cheap" }, { "from": 500, "to": 1500, "key": "average" }, { "from": 1500, "key": "expensive" } ] } }, "attribute": { "nested": { "path": "attributes" }, "aggs": { "attributes_filter": { "filter": { "terms": { "attributes.id": [ 30, 91, 85 ] } }, "aggs": { "attributes": { "terms": { "field": "attributes.option", "size": 250 } } } } } } }, "_source": false, "from": 0, "size": 12 } curl -XPOST 'http://elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200/at_product_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12}' #0 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/ElasticaSearchProvider.php(50): Elastica\Search->search() #4 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/SearchProviderResolver.php(51): App\Search\Provider\ElasticaSearchProvider->search() #5 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/SearchProviderResolver.php(41): App\Search\Provider\SearchProviderResolver->search() #6 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/FilterManager.php(62): App\Search\Provider\SearchProviderResolver->getAggregates() #7 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/FilterManager.php(38): App\Search\FilterManager->processFilterForm() #8 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Controller/Content/ProductClass.php(49): App\Search\FilterManager->process() #9 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\Content\ProductClass->filter() #10 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #11 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #12 /var/www/vhosts/dobraklima.sk/sandbox.klimapro.at/public/index.php(30): Symfony\Component\HttpKernel\Kernel->handle() #13 {main}
2	4.45 ms	3.00 ms	{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12} Path: at_product_dev/_search Query: Method: POST (Http on elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200) Item count: 0 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "categories", "query": { "terms": { "categories.id": [ "483" ] } } } } ] } }, { "bool": { "must": [ { "terms": { "manufacturer": [ 17 ] } }, { "terms": { "productClass": [ 80 ] } } ] } } ] } }, "sort": { "categories.position": { "nested": { "path": "categories", "filter": { "terms": { "categories.id": [ 483 ] } } } } }, "aggs": { "category": { "global": {}, "aggs": { "category_nested": { "nested": { "path": "categories" }, "aggs": { "category_filter": { "filter": { "terms": { "categories.id": [ 483 ] } }, "aggs": { "category_global": { "reverse_nested": {}, "aggs": { "price_min": { "min": { "field": "price" } }, "price_max": { "max": { "field": "price" } }, "dimensions": { "nested": { "path": "attributes" }, "aggs": { "width_min": { "min": { "field": "attributes.width" } }, "width_max": { "max": { "field": "attributes.width" } }, "height_min": { "min": { "field": "attributes.height" } }, "height_max": { "max": { "field": "attributes.height" } }, "power_min": { "min": { "field": "attributes.power" } }, "power_max": { "max": { "field": "attributes.power" } } } } } } } } } } } }, "manufacturer": { "terms": { "field": "manufacturer", "size": 100 } }, "product_class": { "terms": { "field": "productClass", "size": 100 } }, "price": { "range": { "field": "price", "ranges": [ { "to": 500, "key": "cheap" }, { "from": 500, "to": 1500, "key": "average" }, { "from": 1500, "key": "expensive" } ] } }, "attribute": { "nested": { "path": "attributes" }, "aggs": { "attributes_filter": { "filter": { "terms": { "attributes.id": [ 30, 91, 85 ] } }, "aggs": { "attributes": { "terms": { "field": "attributes.option", "size": 250 } } } } } } }, "_source": false, "from": 0, "size": 12 } curl -XPOST 'http://elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200/at_product_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12}' #0 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/ElasticaSearchProvider.php(50): Elastica\Search->search() #4 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/SearchProviderResolver.php(51): App\Search\Provider\ElasticaSearchProvider->search() #5 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/EventSubscriber/ExecuteFilter.php(22): App\Search\Provider\SearchProviderResolver->search() #6 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(116): App\Search\EventSubscriber\ExecuteFilter->onExecute() #7 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke() #8 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #9 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(139): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #10 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/FilterManager.php(42): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch() #11 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Controller/Content/ProductClass.php(49): App\Search\FilterManager->process() #12 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\Content\ProductClass->filter() #13 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #14 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #15 /var/www/vhosts/dobraklima.sk/sandbox.klimapro.at/public/index.php(30): Symfony\Component\HttpKernel\Kernel->handle() #16 {main}

{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12}

Path: at_product_dev/_search
Query:
Method: POST (Http on elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200)
Item count: 0
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "bool": {
                        "must": [
                            {
                                "nested": {
                                    "path": "categories",
                                    "query": {
                                        "terms": {
                                            "categories.id": [
                                                "483"
                                            ]
                                        }
                                    }
                                }
                            }
                        ]
                    }
                },
                {
                    "bool": {
                        "must": [
                            {
                                "terms": {
                                    "manufacturer": [
                                        17
                                    ]
                                }
                            },
                            {
                                "terms": {
                                    "productClass": [
                                        80
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": {
        "categories.position": {
            "nested": {
                "path": "categories",
                "filter": {
                    "terms": {
                        "categories.id": [
                            483
                        ]
                    }
                }
            }
        }
    },
    "aggs": {
        "category": {
            "global": {},
            "aggs": {
                "category_nested": {
                    "nested": {
                        "path": "categories"
                    },
                    "aggs": {
                        "category_filter": {
                            "filter": {
                                "terms": {
                                    "categories.id": [
                                        483
                                    ]
                                }
                            },
                            "aggs": {
                                "category_global": {
                                    "reverse_nested": {},
                                    "aggs": {
                                        "price_min": {
                                            "min": {
                                                "field": "price"
                                            }
                                        },
                                        "price_max": {
                                            "max": {
                                                "field": "price"
                                            }
                                        },
                                        "dimensions": {
                                            "nested": {
                                                "path": "attributes"
                                            },
                                            "aggs": {
                                                "width_min": {
                                                    "min": {
                                                        "field": "attributes.width"
                                                    }
                                                },
                                                "width_max": {
                                                    "max": {
                                                        "field": "attributes.width"
                                                    }
                                                },
                                                "height_min": {
                                                    "min": {
                                                        "field": "attributes.height"
                                                    }
                                                },
                                                "height_max": {
                                                    "max": {
                                                        "field": "attributes.height"
                                                    }
                                                },
                                                "power_min": {
                                                    "min": {
                                                        "field": "attributes.power"
                                                    }
                                                },
                                                "power_max": {
                                                    "max": {
                                                        "field": "attributes.power"
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        },
        "manufacturer": {
            "terms": {
                "field": "manufacturer",
                "size": 100
            }
        },
        "product_class": {
            "terms": {
                "field": "productClass",
                "size": 100
            }
        },
        "price": {
            "range": {
                "field": "price",
                "ranges": [
                    {
                        "to": 500,
                        "key": "cheap"
                    },
                    {
                        "from": 500,
                        "to": 1500,
                        "key": "average"
                    },
                    {
                        "from": 1500,
                        "key": "expensive"
                    }
                ]
            }
        },
        "attribute": {
            "nested": {
                "path": "attributes"
            },
            "aggs": {
                "attributes_filter": {
                    "filter": {
                        "terms": {
                            "attributes.id": [
                                30,
                                91,
                                85
                            ]
                        }
                    },
                    "aggs": {
                        "attributes": {
                            "terms": {
                                "field": "attributes.option",
                                "size": 250
                            }
                        }
                    }
                }
            }
        }
    },
    "_source": false,
    "from": 0,
    "size": 12
}

curl -XPOST 'http://elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200/at_product_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12}'

#0 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/ElasticaSearchProvider.php(50): Elastica\Search->search()
#4 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/SearchProviderResolver.php(51): App\Search\Provider\ElasticaSearchProvider->search()
#5 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/SearchProviderResolver.php(41): App\Search\Provider\SearchProviderResolver->search()
#6 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/FilterManager.php(62): App\Search\Provider\SearchProviderResolver->getAggregates()
#7 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/FilterManager.php(38): App\Search\FilterManager->processFilterForm()
#8 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Controller/Content/ProductClass.php(49): App\Search\FilterManager->process()
#9 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\Content\ProductClass->filter()
#10 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#11 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#12 /var/www/vhosts/dobraklima.sk/sandbox.klimapro.at/public/index.php(30): Symfony\Component\HttpKernel\Kernel->handle()
#13 {main}

4.45 ms

3.00 ms

{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12}

Path: at_product_dev/_search
Query:
Method: POST (Http on elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200)
Item count: 0
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "bool": {
                        "must": [
                            {
                                "nested": {
                                    "path": "categories",
                                    "query": {
                                        "terms": {
                                            "categories.id": [
                                                "483"
                                            ]
                                        }
                                    }
                                }
                            }
                        ]
                    }
                },
                {
                    "bool": {
                        "must": [
                            {
                                "terms": {
                                    "manufacturer": [
                                        17
                                    ]
                                }
                            },
                            {
                                "terms": {
                                    "productClass": [
                                        80
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": {
        "categories.position": {
            "nested": {
                "path": "categories",
                "filter": {
                    "terms": {
                        "categories.id": [
                            483
                        ]
                    }
                }
            }
        }
    },
    "aggs": {
        "category": {
            "global": {},
            "aggs": {
                "category_nested": {
                    "nested": {
                        "path": "categories"
                    },
                    "aggs": {
                        "category_filter": {
                            "filter": {
                                "terms": {
                                    "categories.id": [
                                        483
                                    ]
                                }
                            },
                            "aggs": {
                                "category_global": {
                                    "reverse_nested": {},
                                    "aggs": {
                                        "price_min": {
                                            "min": {
                                                "field": "price"
                                            }
                                        },
                                        "price_max": {
                                            "max": {
                                                "field": "price"
                                            }
                                        },
                                        "dimensions": {
                                            "nested": {
                                                "path": "attributes"
                                            },
                                            "aggs": {
                                                "width_min": {
                                                    "min": {
                                                        "field": "attributes.width"
                                                    }
                                                },
                                                "width_max": {
                                                    "max": {
                                                        "field": "attributes.width"
                                                    }
                                                },
                                                "height_min": {
                                                    "min": {
                                                        "field": "attributes.height"
                                                    }
                                                },
                                                "height_max": {
                                                    "max": {
                                                        "field": "attributes.height"
                                                    }
                                                },
                                                "power_min": {
                                                    "min": {
                                                        "field": "attributes.power"
                                                    }
                                                },
                                                "power_max": {
                                                    "max": {
                                                        "field": "attributes.power"
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        },
        "manufacturer": {
            "terms": {
                "field": "manufacturer",
                "size": 100
            }
        },
        "product_class": {
            "terms": {
                "field": "productClass",
                "size": 100
            }
        },
        "price": {
            "range": {
                "field": "price",
                "ranges": [
                    {
                        "to": 500,
                        "key": "cheap"
                    },
                    {
                        "from": 500,
                        "to": 1500,
                        "key": "average"
                    },
                    {
                        "from": 1500,
                        "key": "expensive"
                    }
                ]
            }
        },
        "attribute": {
            "nested": {
                "path": "attributes"
            },
            "aggs": {
                "attributes_filter": {
                    "filter": {
                        "terms": {
                            "attributes.id": [
                                30,
                                91,
                                85
                            ]
                        }
                    },
                    "aggs": {
                        "attributes": {
                            "terms": {
                                "field": "attributes.option",
                                "size": 250
                            }
                        }
                    }
                }
            }
        }
    },
    "_source": false,
    "from": 0,
    "size": 12
}

curl -XPOST 'http://elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200/at_product_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["483"]}}}}]}},{"bool":{"must":[{"terms":{"manufacturer":[17]}},{"terms":{"productClass":[80]}}]}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[483]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[483]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes_filter":{"filter":{"terms":{"attributes.id":[30,91,85]}},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}}}},"_source":false,"from":0,"size":12}'

#0 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/ElasticaSearchProvider.php(50): Elastica\Search->search()
#4 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/Provider/SearchProviderResolver.php(51): App\Search\Provider\ElasticaSearchProvider->search()
#5 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/EventSubscriber/ExecuteFilter.php(22): App\Search\Provider\SearchProviderResolver->search()
#6 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(116): App\Search\EventSubscriber\ExecuteFilter->onExecute()
#7 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
#8 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#9 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(139): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#10 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Search/FilterManager.php(42): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
#11 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/src/Controller/Content/ProductClass.php(49): App\Search\FilterManager->process()
#12 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\Content\ProductClass->filter()
#13 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#14 /var/www/vhosts/dobraklima.sk/sandbox.dobraklima.sk/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#15 /var/www/vhosts/dobraklima.sk/sandbox.klimapro.at/public/index.php(30): Symfony\Component\HttpKernel\Kernel->handle()
#16 {main}

Symfony Profiler

GET https://sandbox.klimapro.at/midea-breezeless

Configuration Settings

Theme

Page Width

Query Metrics

Queries