Symfony Profiler

Query Metrics

3 Database Queries

2.40 ms Execution Time

0.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

1.03 ms

0.00 ms

#▲	Execution Time	Info
1	1.03 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["womens_jeans"]}}]}},"size":20} Path: bitbag_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 3 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons": [ "womens_jeans" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["womens_jeans"]}}]}},"size":20}'` #0 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search() #5 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon() #8 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/QueryBuilder/FormQueryBuilder/TaxonFacetsQueryBuilder.php(35): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData() #9 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Form/Resolver/ProductsFilterFacetResolver.php(30): BitBag\SyliusElasticsearchPlugin\QueryBuilder\FormQueryBuilder\TaxonFacetsQueryBuilder->getQuery() #10 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(44): BitBag\SyliusElasticsearchPlugin\Form\Resolver\ProductsFilterFacetResolver->resolveFacets() #11 /var/www/demo/sylius/production/releases/11/vendor/symfony/event-dispatcher/EventDispatcher.php(220): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets() #12 /var/www/demo/sylius/production/releases/11/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #13 /var/www/demo/sylius/production/releases/11/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(30): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #14 /var/www/demo/sylius/production/releases/11/vendor/symfony/form/Form.php(482): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch() #15 /var/www/demo/sylius/production/releases/11/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit() #16 /var/www/demo/sylius/production/releases/11/vendor/symfony/form/Form.php(420): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest() #17 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest() #18 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke() #19 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #20 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #21 /var/www/demo/sylius/production/releases/11/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #22 /var/www/demo/sylius/production/releases/11/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #23 /var/www/demo/sylius/production/releases/11/public/index.php(5): require_once('...') #24 {main}
2	0.68 ms	{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["womens_jeans"]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_en_US.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_en_US.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_en_US.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_en_US.keyword"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_en_US.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_en_US.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_en_US.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_en_US.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_en_US.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_en_US.keyword"}},"length":{"terms":{"field":"attribute_length_en_US.keyword"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_en_US.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_en_US.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_en_US.keyword"}},"t_shirt_size":{"terms":{"field":"option_t_shirt_size.keyword"}},"dress_size":{"terms":{"field":"option_dress_size.keyword"}},"dress_height":{"terms":{"field":"option_dress_height.keyword"}},"jeans_size":{"terms":{"field":"option_jeans_size.keyword"}}},"size":0} Path: bitbag_shop_products_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 4 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "term": { "enabled": { "value": true, "boost": 1 } } }, { "terms": { "channels": [ "fashion_web" ] } }, { "terms": { "product_taxons": [ "womens_jeans" ] } } ] } }, "aggs": { "t_shirt_brand": { "terms": { "field": "attribute_t_shirt_brand_en_US.keyword" } }, "t_shirt_collection": { "terms": { "field": "attribute_t_shirt_collection_en_US.keyword" } }, "t_shirt_material": { "terms": { "field": "attribute_t_shirt_material_en_US.keyword" } }, "damage_reduction": { "terms": { "field": "attribute_damage_reduction_en_US.keyword" } }, "cap_brand": { "terms": { "field": "attribute_cap_brand_en_US.keyword" } }, "cap_collection": { "terms": { "field": "attribute_cap_collection_en_US.keyword" } }, "cap_material": { "terms": { "field": "attribute_cap_material_en_US.keyword" } }, "dress_brand": { "terms": { "field": "attribute_dress_brand_en_US.keyword" } }, "dress_collection": { "terms": { "field": "attribute_dress_collection_en_US.keyword" } }, "dress_material": { "terms": { "field": "attribute_dress_material_en_US.keyword" } }, "length": { "terms": { "field": "attribute_length_en_US.keyword" } }, "jeans_brand": { "terms": { "field": "attribute_jeans_brand_en_US.keyword" } }, "jeans_collection": { "terms": { "field": "attribute_jeans_collection_en_US.keyword" } }, "jeans_material": { "terms": { "field": "attribute_jeans_material_en_US.keyword" } }, "t_shirt_size": { "terms": { "field": "option_t_shirt_size.keyword" } }, "dress_size": { "terms": { "field": "option_dress_size.keyword" } }, "dress_height": { "terms": { "field": "option_dress_height.keyword" } }, "jeans_size": { "terms": { "field": "option_jeans_size.keyword" } } }, "size": 0 } curl -XPOST 'http://localhost:9200/bitbag_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["womens_jeans"]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_en_US.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_en_US.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_en_US.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_en_US.keyword"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_en_US.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_en_US.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_en_US.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_en_US.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_en_US.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_en_US.keyword"}},"length":{"terms":{"field":"attribute_length_en_US.keyword"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_en_US.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_en_US.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_en_US.keyword"}},"t_shirt_size":{"terms":{"field":"option_t_shirt_size.keyword"}},"dress_size":{"terms":{"field":"option_dress_size.keyword"}},"dress_height":{"terms":{"field":"option_dress_height.keyword"}},"jeans_size":{"terms":{"field":"option_jeans_size.keyword"}}},"size":0}' #0 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search() #5 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations() #6 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(59): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations() #7 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(46): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->modifyForm() #8 /var/www/demo/sylius/production/releases/11/vendor/symfony/event-dispatcher/EventDispatcher.php(220): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets() #9 /var/www/demo/sylius/production/releases/11/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #10 /var/www/demo/sylius/production/releases/11/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(30): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #11 /var/www/demo/sylius/production/releases/11/vendor/symfony/form/Form.php(482): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch() #12 /var/www/demo/sylius/production/releases/11/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit() #13 /var/www/demo/sylius/production/releases/11/vendor/symfony/form/Form.php(420): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest() #14 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest() #15 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke() #16 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #17 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #18 /var/www/demo/sylius/production/releases/11/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #19 /var/www/demo/sylius/production/releases/11/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #20 /var/www/demo/sylius/production/releases/11/public/index.php(5): require_once('...') #21 {main}
3	0.69 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["womens_jeans"]}}]}},"size":20} Path: bitbag_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 3 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons": [ "womens_jeans" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["womens_jeans"]}}]}},"size":20}'` #0 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search() #5 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon() #8 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/TaxonDataHandler.php(27): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData() #9 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(37): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\TaxonDataHandler->retrieveData() #10 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke() #11 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #12 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #13 /var/www/demo/sylius/production/releases/11/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #14 /var/www/demo/sylius/production/releases/11/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #15 /var/www/demo/sylius/production/releases/11/public/index.php(5): require_once('...') #16 {main}

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

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


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

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

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

0.68 ms

0.00 ms

{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["womens_jeans"]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_en_US.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_en_US.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_en_US.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_en_US.keyword"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_en_US.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_en_US.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_en_US.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_en_US.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_en_US.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_en_US.keyword"}},"length":{"terms":{"field":"attribute_length_en_US.keyword"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_en_US.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_en_US.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_en_US.keyword"}},"t_shirt_size":{"terms":{"field":"option_t_shirt_size.keyword"}},"dress_size":{"terms":{"field":"option_dress_size.keyword"}},"dress_height":{"terms":{"field":"option_dress_height.keyword"}},"jeans_size":{"terms":{"field":"option_jeans_size.keyword"}}},"size":0}

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


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "term": {
                        "enabled": {
                            "value": true,
                            "boost": 1
                        }
                    }
                },
                {
                    "terms": {
                        "channels": [
                            "fashion_web"
                        ]
                    }
                },
                {
                    "terms": {
                        "product_taxons": [
                            "womens_jeans"
                        ]
                    }
                }
            ]
        }
    },
    "aggs": {
        "t_shirt_brand": {
            "terms": {
                "field": "attribute_t_shirt_brand_en_US.keyword"
            }
        },
        "t_shirt_collection": {
            "terms": {
                "field": "attribute_t_shirt_collection_en_US.keyword"
            }
        },
        "t_shirt_material": {
            "terms": {
                "field": "attribute_t_shirt_material_en_US.keyword"
            }
        },
        "damage_reduction": {
            "terms": {
                "field": "attribute_damage_reduction_en_US.keyword"
            }
        },
        "cap_brand": {
            "terms": {
                "field": "attribute_cap_brand_en_US.keyword"
            }
        },
        "cap_collection": {
            "terms": {
                "field": "attribute_cap_collection_en_US.keyword"
            }
        },
        "cap_material": {
            "terms": {
                "field": "attribute_cap_material_en_US.keyword"
            }
        },
        "dress_brand": {
            "terms": {
                "field": "attribute_dress_brand_en_US.keyword"
            }
        },
        "dress_collection": {
            "terms": {
                "field": "attribute_dress_collection_en_US.keyword"
            }
        },
        "dress_material": {
            "terms": {
                "field": "attribute_dress_material_en_US.keyword"
            }
        },
        "length": {
            "terms": {
                "field": "attribute_length_en_US.keyword"
            }
        },
        "jeans_brand": {
            "terms": {
                "field": "attribute_jeans_brand_en_US.keyword"
            }
        },
        "jeans_collection": {
            "terms": {
                "field": "attribute_jeans_collection_en_US.keyword"
            }
        },
        "jeans_material": {
            "terms": {
                "field": "attribute_jeans_material_en_US.keyword"
            }
        },
        "t_shirt_size": {
            "terms": {
                "field": "option_t_shirt_size.keyword"
            }
        },
        "dress_size": {
            "terms": {
                "field": "option_dress_size.keyword"
            }
        },
        "dress_height": {
            "terms": {
                "field": "option_dress_height.keyword"
            }
        },
        "jeans_size": {
            "terms": {
                "field": "option_jeans_size.keyword"
            }
        }
    },
    "size": 0
}

curl -XPOST 'http://localhost:9200/bitbag_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["womens_jeans"]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_en_US.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_en_US.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_en_US.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_en_US.keyword"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_en_US.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_en_US.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_en_US.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_en_US.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_en_US.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_en_US.keyword"}},"length":{"terms":{"field":"attribute_length_en_US.keyword"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_en_US.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_en_US.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_en_US.keyword"}},"t_shirt_size":{"terms":{"field":"option_t_shirt_size.keyword"}},"dress_size":{"terms":{"field":"option_dress_size.keyword"}},"dress_height":{"terms":{"field":"option_dress_height.keyword"}},"jeans_size":{"terms":{"field":"option_jeans_size.keyword"}}},"size":0}'

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

0.69 ms

0.00 ms

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

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


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

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

#0 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /var/www/demo/sylius/production/releases/11/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search()
#5 /var/www/demo/sylius/production/releases/11/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search()
#6 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find()
#7 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon()
#8 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/TaxonDataHandler.php(27): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData()
#9 /var/www/demo/sylius/production/releases/11/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(37): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\TaxonDataHandler->retrieveData()
#10 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke()
#11 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#12 /var/www/demo/sylius/production/releases/11/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#13 /var/www/demo/sylius/production/releases/11/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#14 /var/www/demo/sylius/production/releases/11/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#15 /var/www/demo/sylius/production/releases/11/public/index.php(5): require_once('...')
#16 {main}

Symfony Profiler

GET https://sylius.demo.wilma.dev/en_US/_partial/taxons/by-slug/jeans/women?template=%40SyliusShop%2FTaxon%2F_header.html.twig

Configuration Settings

Theme

Page Width

Query Metrics

Queries