Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

89.72 ms Execution Time

85.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

89.72 ms

85.00 ms

#▲	Execution Time	Query Time	Info
1	89.72 ms	85.00 ms	{"query":{"bool":{"must":[{"term":{"id":1435}},{"nested":{"path":"pages","query":{"bool":{"should":[{"match_phrase":{"pages.content":{"query":"eau"}}},{"match":{"pages.content":{"query":"eau"}}}]}},"inner_hits":{"highlight":{"pre_tags":["<strong>"],"post_tags":["<\/strong>"],"fields":{"pages.content":{}}},"_source":["pages.id"],"size":100}}}]}}} Path: app/magazines/_search Query: Method: GET (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "term": { "id": 1435 } }, { "nested": { "path": "pages", "query": { "bool": { "should": [ { "match_phrase": { "pages.content": { "query": "eau" } } }, { "match": { "pages.content": { "query": "eau" } } } ] } }, "inner_hits": { "highlight": { "pre_tags": [ "<strong>" ], "post_tags": [ "<\/strong>" ], "fields": { "pages.content": {} } }, "_source": [ "pages.id" ], "size": 100 } } } ] } } }` `curl -XGET 'http://localhost:9200/app/magazines/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"id":1435}},{"nested":{"path":"pages","query":{"bool":{"should":[{"match_phrase":{"pages.content":{"query":"eau"}}},{"match":{"pages.content":{"query":"eau"}}}]}},"inner_hits":{"highlight":{"pre_tags":["<strong>"],"post_tags":["<\/strong>"],"fields":{"pages.content":{}}},"_source":["pages.id"],"size":100}}}]}}}'` #0 /home/octopouce/www/mrmagz/backend/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /home/octopouce/www/mrmagz/backend/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /home/octopouce/www/mrmagz/backend/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request() #3 /home/octopouce/www/mrmagz/backend/src/Controller/View/ElasticSearch/SearchController.php(195): Elastica\Search->search() #4 /home/octopouce/www/mrmagz/backend/vendor/symfony/http-kernel/HttpKernel.php(158): App\Controller\View\ElasticSearch\SearchController->getMagazinesAction() #5 /home/octopouce/www/mrmagz/backend/vendor/symfony/http-kernel/HttpKernel.php(80): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #6 /home/octopouce/www/mrmagz/backend/vendor/symfony/http-kernel/Kernel.php(201): Symfony\Component\HttpKernel\HttpKernel->handle() #7 /home/octopouce/www/mrmagz/backend/public/index.php(26): Symfony\Component\HttpKernel\Kernel->handle() #8 {main}

{"query":{"bool":{"must":[{"term":{"id":1435}},{"nested":{"path":"pages","query":{"bool":{"should":[{"match_phrase":{"pages.content":{"query":"eau"}}},{"match":{"pages.content":{"query":"eau"}}}]}},"inner_hits":{"highlight":{"pre_tags":["<strong>"],"post_tags":["<\/strong>"],"fields":{"pages.content":{}}},"_source":["pages.id"],"size":100}}}]}}}

Path: app/magazines/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 1
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "term": {
                        "id": 1435
                    }
                },
                {
                    "nested": {
                        "path": "pages",
                        "query": {
                            "bool": {
                                "should": [
                                    {
                                        "match_phrase": {
                                            "pages.content": {
                                                "query": "eau"
                                            }
                                        }
                                    },
                                    {
                                        "match": {
                                            "pages.content": {
                                                "query": "eau"
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "inner_hits": {
                            "highlight": {
                                "pre_tags": [
                                    "<strong>"
                                ],
                                "post_tags": [
                                    "<\/strong>"
                                ],
                                "fields": {
                                    "pages.content": {}
                                }
                            },
                            "_source": [
                                "pages.id"
                            ],
                            "size": 100
                        }
                    }
                }
            ]
        }
    }
}

curl -XGET 'http://localhost:9200/app/magazines/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"id":1435}},{"nested":{"path":"pages","query":{"bool":{"should":[{"match_phrase":{"pages.content":{"query":"eau"}}},{"match":{"pages.content":{"query":"eau"}}}]}},"inner_hits":{"highlight":{"pre_tags":["<strong>"],"post_tags":["<\/strong>"],"fields":{"pages.content":{}}},"_source":["pages.id"],"size":100}}}]}}}'

#0 /home/octopouce/www/mrmagz/backend/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /home/octopouce/www/mrmagz/backend/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /home/octopouce/www/mrmagz/backend/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /home/octopouce/www/mrmagz/backend/src/Controller/View/ElasticSearch/SearchController.php(195): Elastica\Search->search()
#4 /home/octopouce/www/mrmagz/backend/vendor/symfony/http-kernel/HttpKernel.php(158): App\Controller\View\ElasticSearch\SearchController->getMagazinesAction()
#5 /home/octopouce/www/mrmagz/backend/vendor/symfony/http-kernel/HttpKernel.php(80): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#6 /home/octopouce/www/mrmagz/backend/vendor/symfony/http-kernel/Kernel.php(201): Symfony\Component\HttpKernel\HttpKernel->handle()
#7 /home/octopouce/www/mrmagz/backend/public/index.php(26): Symfony\Component\HttpKernel\Kernel->handle()
#8 {main}

Symfony Profiler

https://preprod.mrmagz.com/view/search/nos-essentiels-op-29?q=Eau

Configuration Settings

Theme

Page Width

Query Metrics

Queries