Symfony Profiler

Query Metrics

3 Database Queries

6.18 ms Execution Time

0.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

2.80 ms

0.00 ms

#▲	Execution Time	Info
1	2.80 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["cadhoc"]}}]}},"size":20} Path: bitbag_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons.keyword": [ "cadhoc" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["cadhoc"]}}]}},"size":20}'` #0 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_attribut...', 'POST', Array, 0.0027961730957031, Array, Array, 0, 0) #1 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_attribut...', 'POST', Array, Array, 0.0027961730957031, 0, 0) #2 /srv/sylius/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('bitbag_attribut...', 'POST', Array, Array) #3 /srv/sylius/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST') #4 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search(Object(Elastica\Query), Array) #5 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search(Object(Elastica\Query\BoolQuery), 20, Array) #6 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find(Object(Elastica\Query\BoolQuery), 20) #7 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon(Object(App\Entity\Taxonomy\Taxon)) #8 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/QueryBuilder/FormQueryBuilder/TaxonFacetsQueryBuilder.php(35): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData(Array) #9 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Form/Resolver/ProductsFilterFacetResolver.php(30): BitBag\SyliusElasticsearchPlugin\QueryBuilder\FormQueryBuilder\TaxonFacetsQueryBuilder->getQuery(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'name') #10 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(44): BitBag\SyliusElasticsearchPlugin\Form\Resolver\ProductsFilterFacetResolver->resolveFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'name') #11 /srv/sylius/vendor/symfony/event-dispatcher/EventDispatcher.php(206): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher)) #12 /srv/sylius/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent)) #13 /srv/sylius/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(28): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #14 /srv/sylius/vendor/symfony/form/Form.php(480): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #15 /srv/sylius/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true) #16 /srv/sylius/vendor/symfony/form/Form.php(418): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request)) #17 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request)) #18 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(183): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request)) #19 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #20 /srv/sylius/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /srv/sylius/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 /srv/sylius/vendor/autoload_runtime.php(32): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #23 /srv/sylius/public/index.php(5): require_once('/srv/sylius/ven...') #24 {main}
2	1.67 ms	{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["cadhoc"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_fr_FR.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_fr_FR.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_fr_FR.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_fr_FR"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_fr_FR.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_fr_FR.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_fr_FR.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_fr_FR.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_fr_FR.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_fr_FR.keyword"}},"length":{"terms":{"field":"attribute_length_fr_FR"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_fr_FR.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_fr_FR.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_fr_FR.keyword"}},"Taille":{"terms":{"field":"attribute_taille_fr_FR.keyword"}},"Poids":{"terms":{"field":"attribute_poids_fr_FR.keyword"}},"Pays_fabrication":{"terms":{"field":"attribute_pays_fabrication_fr_FR.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"}},"Iphone-color":{"terms":{"field":"option_iphone-color.keyword"}},"grav":{"terms":{"field":"option_grav.keyword"}}},"size":0} Path: bitbag_shop_products_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "term": { "enabled": { "value": true, "boost": 1 } } }, { "terms": { "channels.keyword": [ "WEB_EUR" ] } }, { "terms": { "product_taxons.keyword": [ "cadhoc" ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "exists": { "field": "customer_groups" } }, { "exists": { "field": "organizations" } } ] } } ] } } ] } }, "aggs": { "t_shirt_brand": { "terms": { "field": "attribute_t_shirt_brand_fr_FR.keyword" } }, "t_shirt_collection": { "terms": { "field": "attribute_t_shirt_collection_fr_FR.keyword" } }, "t_shirt_material": { "terms": { "field": "attribute_t_shirt_material_fr_FR.keyword" } }, "damage_reduction": { "terms": { "field": "attribute_damage_reduction_fr_FR" } }, "cap_brand": { "terms": { "field": "attribute_cap_brand_fr_FR.keyword" } }, "cap_collection": { "terms": { "field": "attribute_cap_collection_fr_FR.keyword" } }, "cap_material": { "terms": { "field": "attribute_cap_material_fr_FR.keyword" } }, "dress_brand": { "terms": { "field": "attribute_dress_brand_fr_FR.keyword" } }, "dress_collection": { "terms": { "field": "attribute_dress_collection_fr_FR.keyword" } }, "dress_material": { "terms": { "field": "attribute_dress_material_fr_FR.keyword" } }, "length": { "terms": { "field": "attribute_length_fr_FR" } }, "jeans_brand": { "terms": { "field": "attribute_jeans_brand_fr_FR.keyword" } }, "jeans_collection": { "terms": { "field": "attribute_jeans_collection_fr_FR.keyword" } }, "jeans_material": { "terms": { "field": "attribute_jeans_material_fr_FR.keyword" } }, "Taille": { "terms": { "field": "attribute_taille_fr_FR.keyword" } }, "Poids": { "terms": { "field": "attribute_poids_fr_FR.keyword" } }, "Pays_fabrication": { "terms": { "field": "attribute_pays_fabrication_fr_FR.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" } }, "Iphone-color": { "terms": { "field": "option_iphone-color.keyword" } }, "grav": { "terms": { "field": "option_grav.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.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["cadhoc"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_fr_FR.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_fr_FR.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_fr_FR.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_fr_FR"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_fr_FR.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_fr_FR.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_fr_FR.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_fr_FR.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_fr_FR.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_fr_FR.keyword"}},"length":{"terms":{"field":"attribute_length_fr_FR"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_fr_FR.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_fr_FR.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_fr_FR.keyword"}},"Taille":{"terms":{"field":"attribute_taille_fr_FR.keyword"}},"Poids":{"terms":{"field":"attribute_poids_fr_FR.keyword"}},"Pays_fabrication":{"terms":{"field":"attribute_pays_fabrication_fr_FR.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"}},"Iphone-color":{"terms":{"field":"option_iphone-color.keyword"}},"grav":{"terms":{"field":"option_grav.keyword"}}},"size":0}' #0 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_shop_pro...', 'POST', Array, 0.0016701221466064, Array, Array, 0, 1) #1 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_shop_pro...', 'POST', Array, Array, 0.0016701221466064, 0, 1) #2 /srv/sylius/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('bitbag_shop_pro...', 'POST', Array, Array) #3 /srv/sylius/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST') #4 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search(Object(Elastica\Query)) #5 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations() #6 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(57): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations() #7 /srv/sylius/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 /srv/sylius/vendor/symfony/event-dispatcher/EventDispatcher.php(206): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher)) #9 /srv/sylius/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent)) #10 /srv/sylius/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(28): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #11 /srv/sylius/vendor/symfony/form/Form.php(480): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit') #12 /srv/sylius/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true) #13 /srv/sylius/vendor/symfony/form/Form.php(418): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request)) #14 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request)) #15 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(183): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request)) #16 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #17 /srv/sylius/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /srv/sylius/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 /srv/sylius/vendor/autoload_runtime.php(32): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #20 /srv/sylius/public/index.php(5): require_once('/srv/sylius/ven...') #21 {main}
3	1.72 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["cadhoc"]}}]}},"size":20} Path: bitbag_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons.keyword": [ "cadhoc" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["cadhoc"]}}]}},"size":20}'` #0 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_attribut...', 'POST', Array, 0.0017170906066895, Array, Array, 0, 0) #1 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_attribut...', 'POST', Array, Array, 0.0017170906066895, 0, 0) #2 /srv/sylius/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('bitbag_attribut...', 'POST', Array, Array) #3 /srv/sylius/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST') #4 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search(Object(Elastica\Query), Array) #5 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search(Object(Elastica\Query\BoolQuery), 20, Array) #6 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(38): FOS\ElasticaBundle\Finder\TransformedFinder->find(Object(Elastica\Query\BoolQuery), 20) #7 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(47): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon(Object(App\Entity\Taxonomy\Taxon)) #8 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/TaxonDataHandler.php(27): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData(Array) #9 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(37): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\TaxonDataHandler->retrieveData(Array) #10 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(183): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request)) #11 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #12 /srv/sylius/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /srv/sylius/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #14 /srv/sylius/vendor/autoload_runtime.php(32): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #15 /srv/sylius/public/index.php(5): require_once('/srv/sylius/ven...') #16 {main}

{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["cadhoc"]}}]}},"size":20}

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


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "attribute_taxons.keyword": [
                            "cadhoc"
                        ]
                    }
                }
            ]
        }
    },
    "size": 20
}

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

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

1.67 ms

0.00 ms

{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["cadhoc"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_fr_FR.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_fr_FR.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_fr_FR.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_fr_FR"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_fr_FR.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_fr_FR.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_fr_FR.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_fr_FR.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_fr_FR.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_fr_FR.keyword"}},"length":{"terms":{"field":"attribute_length_fr_FR"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_fr_FR.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_fr_FR.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_fr_FR.keyword"}},"Taille":{"terms":{"field":"attribute_taille_fr_FR.keyword"}},"Poids":{"terms":{"field":"attribute_poids_fr_FR.keyword"}},"Pays_fabrication":{"terms":{"field":"attribute_pays_fabrication_fr_FR.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"}},"Iphone-color":{"terms":{"field":"option_iphone-color.keyword"}},"grav":{"terms":{"field":"option_grav.keyword"}}},"size":0}

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


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "term": {
                        "enabled": {
                            "value": true,
                            "boost": 1
                        }
                    }
                },
                {
                    "terms": {
                        "channels.keyword": [
                            "WEB_EUR"
                        ]
                    }
                },
                {
                    "terms": {
                        "product_taxons.keyword": [
                            "cadhoc"
                        ]
                    }
                },
                {
                    "bool": {
                        "should": [
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "exists": {
                                                "field": "customer_groups"
                                            }
                                        },
                                        {
                                            "exists": {
                                                "field": "organizations"
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggs": {
        "t_shirt_brand": {
            "terms": {
                "field": "attribute_t_shirt_brand_fr_FR.keyword"
            }
        },
        "t_shirt_collection": {
            "terms": {
                "field": "attribute_t_shirt_collection_fr_FR.keyword"
            }
        },
        "t_shirt_material": {
            "terms": {
                "field": "attribute_t_shirt_material_fr_FR.keyword"
            }
        },
        "damage_reduction": {
            "terms": {
                "field": "attribute_damage_reduction_fr_FR"
            }
        },
        "cap_brand": {
            "terms": {
                "field": "attribute_cap_brand_fr_FR.keyword"
            }
        },
        "cap_collection": {
            "terms": {
                "field": "attribute_cap_collection_fr_FR.keyword"
            }
        },
        "cap_material": {
            "terms": {
                "field": "attribute_cap_material_fr_FR.keyword"
            }
        },
        "dress_brand": {
            "terms": {
                "field": "attribute_dress_brand_fr_FR.keyword"
            }
        },
        "dress_collection": {
            "terms": {
                "field": "attribute_dress_collection_fr_FR.keyword"
            }
        },
        "dress_material": {
            "terms": {
                "field": "attribute_dress_material_fr_FR.keyword"
            }
        },
        "length": {
            "terms": {
                "field": "attribute_length_fr_FR"
            }
        },
        "jeans_brand": {
            "terms": {
                "field": "attribute_jeans_brand_fr_FR.keyword"
            }
        },
        "jeans_collection": {
            "terms": {
                "field": "attribute_jeans_collection_fr_FR.keyword"
            }
        },
        "jeans_material": {
            "terms": {
                "field": "attribute_jeans_material_fr_FR.keyword"
            }
        },
        "Taille": {
            "terms": {
                "field": "attribute_taille_fr_FR.keyword"
            }
        },
        "Poids": {
            "terms": {
                "field": "attribute_poids_fr_FR.keyword"
            }
        },
        "Pays_fabrication": {
            "terms": {
                "field": "attribute_pays_fabrication_fr_FR.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"
            }
        },
        "Iphone-color": {
            "terms": {
                "field": "option_iphone-color.keyword"
            }
        },
        "grav": {
            "terms": {
                "field": "option_grav.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.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["cadhoc"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_fr_FR.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_fr_FR.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_fr_FR.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_fr_FR"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_fr_FR.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_fr_FR.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_fr_FR.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_fr_FR.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_fr_FR.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_fr_FR.keyword"}},"length":{"terms":{"field":"attribute_length_fr_FR"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_fr_FR.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_fr_FR.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_fr_FR.keyword"}},"Taille":{"terms":{"field":"attribute_taille_fr_FR.keyword"}},"Poids":{"terms":{"field":"attribute_poids_fr_FR.keyword"}},"Pays_fabrication":{"terms":{"field":"attribute_pays_fabrication_fr_FR.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"}},"Iphone-color":{"terms":{"field":"option_iphone-color.keyword"}},"grav":{"terms":{"field":"option_grav.keyword"}}},"size":0}'

#0 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_shop_pro...', 'POST', Array, 0.0016701221466064, Array, Array, 0, 1)
#1 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_shop_pro...', 'POST', Array, Array, 0.0016701221466064, 0, 1)
#2 /srv/sylius/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('bitbag_shop_pro...', 'POST', Array, Array)
#3 /srv/sylius/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search(Object(Elastica\Query))
#5 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations()
#6 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(57): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations()
#7 /srv/sylius/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 /srv/sylius/vendor/symfony/event-dispatcher/EventDispatcher.php(206): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher))
#9 /srv/sylius/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent))
#10 /srv/sylius/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(28): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#11 /srv/sylius/vendor/symfony/form/Form.php(480): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#12 /srv/sylius/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true)
#13 /srv/sylius/vendor/symfony/form/Form.php(418): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request))
#14 /srv/sylius/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/TaxonProductsSearchAction.php(25): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request))
#15 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(183): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\TaxonProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#16 /srv/sylius/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#17 /srv/sylius/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 /srv/sylius/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#19 /srv/sylius/vendor/autoload_runtime.php(32): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#20 /srv/sylius/public/index.php(5): require_once('/srv/sylius/ven...')
#21 {main}

1.72 ms

0.00 ms

{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["cadhoc"]}}]}},"size":20}

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


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "attribute_taxons.keyword": [
                            "cadhoc"
                        ]
                    }
                }
            ]
        }
    },
    "size": 20
}

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

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

Symfony Profiler

GET https://boutique.up-pulse.dev/wishlist/header-template

Configuration Settings

Theme

Page Width

Query Metrics

Queries