Symfony Profiler

Query Metrics

3 Database Queries

14.43 ms Execution Time

6.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

4.49 ms

1.00 ms

#▲	Execution Time	Query Time	Info
1	4.49 ms	1.00 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20} Path: normadoc_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 11 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons": [ "taxon_5736" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/normadoc_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20}'` #0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_attrib...', 'POST', Array, 0.0044939517974854, Array, Array, 1, 11) #1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_attrib...', 'POST', Array, Array, 0.0044939517974854, 1, 11) #2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('normadoc_attrib...', 'POST', Array, Array) #3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST') #4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search(Object(Elastica\Query), Array) #5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search(Object(Elastica\Query\BoolQuery), 20, Array) #6 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find(Object(Elastica\Query\BoolQuery), 20) #7 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon(Object(App\Entity\Taxonomy\Taxon)) #8 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/QueryBuilder/FormQueryBuilder/TaxonFacetsQueryBuilder.php(35): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData(Array) #9 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/Resolver/ProductsFilterFacetResolver.php(30): BitBag\SyliusElasticsearchPlugin\QueryBuilder\FormQueryBuilder\TaxonFacetsQueryBuilder->getQuery(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'name') #10 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(44): BitBag\SyliusElasticsearchPlugin\Form\Resolver\ProductsFilterFacetResolver->resolveFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'name') #11 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(220): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher)) #12 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent)) #13 /home/normadev/dev/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(30): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #14 /home/normadev/dev/vendor/symfony/form/Form.php(482): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #15 /home/normadev/dev/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true) #16 /home/normadev/dev/vendor/symfony/form/Form.php(420): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request)) #17 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request)) #18 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request)) #19 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #20 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #23 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...') #24 {main}
2	5.66 ms	4.00 ms	{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"terms":{"product_taxons":["taxon_5736"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword"}},"available_in_subscription":{"terms":{"field":"attribute_available_in_subscription_en_US"}},"state":{"terms":{"field":"attribute_state_en_US.keyword"}},"most_recent":{"terms":{"field":"attribute_most_recent_en_US.keyword"}},"confirmed":{"terms":{"field":"attribute_confirmed_en_US"}},"has_draft":{"terms":{"field":"attribute_has_draft_en_US"}},"modified":{"terms":{"field":"attribute_modified_en_US"}},"new":{"terms":{"field":"attribute_new_en_US"}},"type":{"terms":{"field":"attribute_type_en_US.keyword"}},"edition":{"terms":{"field":"attribute_edition_en_US.keyword"}},"published_at":{"terms":{"field":"attribute_published_at_en_US"}},"keywords":{"terms":{"field":"attribute_keywords_en_US.keyword"}},"themes":{"terms":{"field":"attribute_themes_en_US.keyword"}},"supplier":{"terms":{"field":"attribute_supplier_en_US.keyword"}},"format":{"terms":{"field":"option_format.keyword"}},"languages":{"terms":{"field":"option_languages.keyword"}},"multi_user":{"terms":{"field":"option_multi_user.keyword"}},"red_line":{"terms":{"field":"option_red_line.keyword"}}},"size":0} Path: normadoc_shop_products_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 2700 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "term": { "enabled": { "value": true, "boost": 1 } } }, { "terms": { "channels": [ "default" ] } }, { "terms": { "product_taxons": [ "taxon_5736" ] } } ] } }, "aggs": { "taxon": { "terms": { "field": "product_taxons.keyword" } }, "available_in_subscription": { "terms": { "field": "attribute_available_in_subscription_en_US" } }, "state": { "terms": { "field": "attribute_state_en_US.keyword" } }, "most_recent": { "terms": { "field": "attribute_most_recent_en_US.keyword" } }, "confirmed": { "terms": { "field": "attribute_confirmed_en_US" } }, "has_draft": { "terms": { "field": "attribute_has_draft_en_US" } }, "modified": { "terms": { "field": "attribute_modified_en_US" } }, "new": { "terms": { "field": "attribute_new_en_US" } }, "type": { "terms": { "field": "attribute_type_en_US.keyword" } }, "edition": { "terms": { "field": "attribute_edition_en_US.keyword" } }, "published_at": { "terms": { "field": "attribute_published_at_en_US" } }, "keywords": { "terms": { "field": "attribute_keywords_en_US.keyword" } }, "themes": { "terms": { "field": "attribute_themes_en_US.keyword" } }, "supplier": { "terms": { "field": "attribute_supplier_en_US.keyword" } }, "format": { "terms": { "field": "option_format.keyword" } }, "languages": { "terms": { "field": "option_languages.keyword" } }, "multi_user": { "terms": { "field": "option_multi_user.keyword" } }, "red_line": { "terms": { "field": "option_red_line.keyword" } } }, "size": 0 } curl -XPOST 'http://localhost:9200/normadoc_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"terms":{"product_taxons":["taxon_5736"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword"}},"available_in_subscription":{"terms":{"field":"attribute_available_in_subscription_en_US"}},"state":{"terms":{"field":"attribute_state_en_US.keyword"}},"most_recent":{"terms":{"field":"attribute_most_recent_en_US.keyword"}},"confirmed":{"terms":{"field":"attribute_confirmed_en_US"}},"has_draft":{"terms":{"field":"attribute_has_draft_en_US"}},"modified":{"terms":{"field":"attribute_modified_en_US"}},"new":{"terms":{"field":"attribute_new_en_US"}},"type":{"terms":{"field":"attribute_type_en_US.keyword"}},"edition":{"terms":{"field":"attribute_edition_en_US.keyword"}},"published_at":{"terms":{"field":"attribute_published_at_en_US"}},"keywords":{"terms":{"field":"attribute_keywords_en_US.keyword"}},"themes":{"terms":{"field":"attribute_themes_en_US.keyword"}},"supplier":{"terms":{"field":"attribute_supplier_en_US.keyword"}},"format":{"terms":{"field":"option_format.keyword"}},"languages":{"terms":{"field":"option_languages.keyword"}},"multi_user":{"terms":{"field":"option_multi_user.keyword"}},"red_line":{"terms":{"field":"option_red_line.keyword"}}},"size":0}' #0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_shop_p...', 'POST', Array, 0.0056638717651367, Array, Array, 4, 2700) #1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_shop_p...', 'POST', Array, Array, 0.0056638717651367, 4, 2700) #2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('normadoc_shop_p...', 'POST', Array, Array) #3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST') #4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search(Object(Elastica\Query)) #5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations() #6 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(59): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations() #7 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(46): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->modifyForm(Object(Symfony\Component\Form\Form), Object(FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter)) #8 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(220): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher)) #9 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent)) #10 /home/normadev/dev/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(30): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #11 /home/normadev/dev/vendor/symfony/form/Form.php(482): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #12 /home/normadev/dev/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true) #13 /home/normadev/dev/vendor/symfony/form/Form.php(420): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request)) #14 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request)) #15 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request)) #16 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #17 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #20 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...') #21 {main}
3	4.27 ms	1.00 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20} Path: normadoc_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 11 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons": [ "taxon_5736" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/normadoc_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20}'` #0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_attrib...', 'POST', Array, 0.0042741298675537, Array, Array, 1, 11) #1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_attrib...', 'POST', Array, Array, 0.0042741298675537, 1, 11) #2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('normadoc_attrib...', 'POST', Array, Array) #3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST') #4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search(Object(Elastica\Query), Array) #5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search(Object(Elastica\Query\BoolQuery), 20, Array) #6 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find(Object(Elastica\Query\BoolQuery), 20) #7 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon(Object(App\Entity\Taxonomy\Taxon)) #8 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/TaxonDataHandler.php(27): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData(Array) #9 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(37): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\TaxonDataHandler->retrieveData(Array) #10 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request)) #11 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #12 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #14 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #15 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...') #16 {main}

{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20}

Path: normadoc_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 11
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "attribute_taxons": [
                            "taxon_5736"
                        ]
                    }
                }
            ]
        }
    },
    "size": 20
}

curl -XPOST 'http://localhost:9200/normadoc_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20}'

#0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_attrib...', 'POST', Array, 0.0044939517974854, Array, Array, 1, 11)
#1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_attrib...', 'POST', Array, Array, 0.0044939517974854, 1, 11)
#2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('normadoc_attrib...', 'POST', Array, Array)
#3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search(Object(Elastica\Query), Array)
#5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search(Object(Elastica\Query\BoolQuery), 20, Array)
#6 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find(Object(Elastica\Query\BoolQuery), 20)
#7 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon(Object(App\Entity\Taxonomy\Taxon))
#8 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/QueryBuilder/FormQueryBuilder/TaxonFacetsQueryBuilder.php(35): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData(Array)
#9 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/Resolver/ProductsFilterFacetResolver.php(30): BitBag\SyliusElasticsearchPlugin\QueryBuilder\FormQueryBuilder\TaxonFacetsQueryBuilder->getQuery(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'name')
#10 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(44): BitBag\SyliusElasticsearchPlugin\Form\Resolver\ProductsFilterFacetResolver->resolveFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'name')
#11 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(220): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher))
#12 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent))
#13 /home/normadev/dev/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(30): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#14 /home/normadev/dev/vendor/symfony/form/Form.php(482): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#15 /home/normadev/dev/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true)
#16 /home/normadev/dev/vendor/symfony/form/Form.php(420): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request))
#17 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request))
#18 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#19 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#20 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#21 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#22 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#23 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...')
#24 {main}

5.66 ms

4.00 ms

{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"terms":{"product_taxons":["taxon_5736"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword"}},"available_in_subscription":{"terms":{"field":"attribute_available_in_subscription_en_US"}},"state":{"terms":{"field":"attribute_state_en_US.keyword"}},"most_recent":{"terms":{"field":"attribute_most_recent_en_US.keyword"}},"confirmed":{"terms":{"field":"attribute_confirmed_en_US"}},"has_draft":{"terms":{"field":"attribute_has_draft_en_US"}},"modified":{"terms":{"field":"attribute_modified_en_US"}},"new":{"terms":{"field":"attribute_new_en_US"}},"type":{"terms":{"field":"attribute_type_en_US.keyword"}},"edition":{"terms":{"field":"attribute_edition_en_US.keyword"}},"published_at":{"terms":{"field":"attribute_published_at_en_US"}},"keywords":{"terms":{"field":"attribute_keywords_en_US.keyword"}},"themes":{"terms":{"field":"attribute_themes_en_US.keyword"}},"supplier":{"terms":{"field":"attribute_supplier_en_US.keyword"}},"format":{"terms":{"field":"option_format.keyword"}},"languages":{"terms":{"field":"option_languages.keyword"}},"multi_user":{"terms":{"field":"option_multi_user.keyword"}},"red_line":{"terms":{"field":"option_red_line.keyword"}}},"size":0}

Path: normadoc_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 2700
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "term": {
                        "enabled": {
                            "value": true,
                            "boost": 1
                        }
                    }
                },
                {
                    "terms": {
                        "channels": [
                            "default"
                        ]
                    }
                },
                {
                    "terms": {
                        "product_taxons": [
                            "taxon_5736"
                        ]
                    }
                }
            ]
        }
    },
    "aggs": {
        "taxon": {
            "terms": {
                "field": "product_taxons.keyword"
            }
        },
        "available_in_subscription": {
            "terms": {
                "field": "attribute_available_in_subscription_en_US"
            }
        },
        "state": {
            "terms": {
                "field": "attribute_state_en_US.keyword"
            }
        },
        "most_recent": {
            "terms": {
                "field": "attribute_most_recent_en_US.keyword"
            }
        },
        "confirmed": {
            "terms": {
                "field": "attribute_confirmed_en_US"
            }
        },
        "has_draft": {
            "terms": {
                "field": "attribute_has_draft_en_US"
            }
        },
        "modified": {
            "terms": {
                "field": "attribute_modified_en_US"
            }
        },
        "new": {
            "terms": {
                "field": "attribute_new_en_US"
            }
        },
        "type": {
            "terms": {
                "field": "attribute_type_en_US.keyword"
            }
        },
        "edition": {
            "terms": {
                "field": "attribute_edition_en_US.keyword"
            }
        },
        "published_at": {
            "terms": {
                "field": "attribute_published_at_en_US"
            }
        },
        "keywords": {
            "terms": {
                "field": "attribute_keywords_en_US.keyword"
            }
        },
        "themes": {
            "terms": {
                "field": "attribute_themes_en_US.keyword"
            }
        },
        "supplier": {
            "terms": {
                "field": "attribute_supplier_en_US.keyword"
            }
        },
        "format": {
            "terms": {
                "field": "option_format.keyword"
            }
        },
        "languages": {
            "terms": {
                "field": "option_languages.keyword"
            }
        },
        "multi_user": {
            "terms": {
                "field": "option_multi_user.keyword"
            }
        },
        "red_line": {
            "terms": {
                "field": "option_red_line.keyword"
            }
        }
    },
    "size": 0
}

curl -XPOST 'http://localhost:9200/normadoc_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"terms":{"product_taxons":["taxon_5736"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword"}},"available_in_subscription":{"terms":{"field":"attribute_available_in_subscription_en_US"}},"state":{"terms":{"field":"attribute_state_en_US.keyword"}},"most_recent":{"terms":{"field":"attribute_most_recent_en_US.keyword"}},"confirmed":{"terms":{"field":"attribute_confirmed_en_US"}},"has_draft":{"terms":{"field":"attribute_has_draft_en_US"}},"modified":{"terms":{"field":"attribute_modified_en_US"}},"new":{"terms":{"field":"attribute_new_en_US"}},"type":{"terms":{"field":"attribute_type_en_US.keyword"}},"edition":{"terms":{"field":"attribute_edition_en_US.keyword"}},"published_at":{"terms":{"field":"attribute_published_at_en_US"}},"keywords":{"terms":{"field":"attribute_keywords_en_US.keyword"}},"themes":{"terms":{"field":"attribute_themes_en_US.keyword"}},"supplier":{"terms":{"field":"attribute_supplier_en_US.keyword"}},"format":{"terms":{"field":"option_format.keyword"}},"languages":{"terms":{"field":"option_languages.keyword"}},"multi_user":{"terms":{"field":"option_multi_user.keyword"}},"red_line":{"terms":{"field":"option_red_line.keyword"}}},"size":0}'

#0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_shop_p...', 'POST', Array, 0.0056638717651367, Array, Array, 4, 2700)
#1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_shop_p...', 'POST', Array, Array, 0.0056638717651367, 4, 2700)
#2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('normadoc_shop_p...', 'POST', Array, Array)
#3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search(Object(Elastica\Query))
#5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations()
#6 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(59): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations()
#7 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(46): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->modifyForm(Object(Symfony\Component\Form\Form), Object(FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter))
#8 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(220): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher))
#9 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent))
#10 /home/normadev/dev/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(30): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#11 /home/normadev/dev/vendor/symfony/form/Form.php(482): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#12 /home/normadev/dev/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true)
#13 /home/normadev/dev/vendor/symfony/form/Form.php(420): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request))
#14 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request))
#15 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#16 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#17 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#19 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#20 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...')
#21 {main}

4.27 ms

1.00 ms

{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20}

Path: normadoc_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 11
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "attribute_taxons": [
                            "taxon_5736"
                        ]
                    }
                }
            ]
        }
    },
    "size": 20
}

curl -XPOST 'http://localhost:9200/normadoc_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5736"]}}]}},"size":20}'

#0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_attrib...', 'POST', Array, 0.0042741298675537, Array, Array, 1, 11)
#1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_attrib...', 'POST', Array, Array, 0.0042741298675537, 1, 11)
#2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('normadoc_attrib...', 'POST', Array, Array)
#3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search(Object(Elastica\Query), Array)
#5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search(Object(Elastica\Query\BoolQuery), 20, Array)
#6 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find(Object(Elastica\Query\BoolQuery), 20)
#7 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon(Object(App\Entity\Taxonomy\Taxon))
#8 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/TaxonDataHandler.php(27): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData(Array)
#9 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(37): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\TaxonDataHandler->retrieveData(Array)
#10 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#11 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#12 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#14 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#15 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...')
#16 {main}

Symfony Profiler

GET https://dev.normadoc.fr/products-list/main/technical-dossiers-526/asme-5736

Configuration Settings

Theme

Page Width

Query Metrics

Queries