| 1 |
31.27 ms |
1.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["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
curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["jeans"]}}]}},"size":20}'
#0 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_attribut...', 'POST', Array, 0.031268119812012, Array, Array, 1, 3)
#1 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_attribut...', 'POST', Array, Array, 0.031268119812012, 1, 3)
#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 |
2.98 ms |
1.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["HOME_WEB"]}},{"terms":{"product_taxons.keyword":["jeans"]}},{"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"}},"chair_brand":{"terms":{"field":"attribute_chair_brand_fr_FR.keyword"}},"chair_material":{"terms":{"field":"attribute_chair_material_fr_FR.keyword"}},"lamp_brand":{"terms":{"field":"attribute_lamp_brand_fr_FR.keyword"}},"lamp_collection":{"terms":{"field":"attribute_lamp_collection_fr_FR.keyword"}},"lamp_material":{"terms":{"field":"attribute_lamp_material_fr_FR.keyword"}},"mug_brand":{"terms":{"field":"attribute_mug_brand_fr_FR.keyword"}},"mug_material":{"terms":{"field":"attribute_mug_material_fr_FR.keyword"}},"plant_type":{"terms":{"field":"attribute_plant_type_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"}},"lamp_color":{"terms":{"field":"option_lamp_color.keyword"}},"mug_color":{"terms":{"field":"option_mug_color.keyword"}},"plant_size":{"terms":{"field":"option_plant_size.keyword"}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 8
View formatted query
View cURL query
View query backtrace
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":["HOME_WEB"]}},{"terms":{"product_taxons.keyword":["jeans"]}},{"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"}},"chair_brand":{"terms":{"field":"attribute_chair_brand_fr_FR.keyword"}},"chair_material":{"terms":{"field":"attribute_chair_material_fr_FR.keyword"}},"lamp_brand":{"terms":{"field":"attribute_lamp_brand_fr_FR.keyword"}},"lamp_collection":{"terms":{"field":"attribute_lamp_collection_fr_FR.keyword"}},"lamp_material":{"terms":{"field":"attribute_lamp_material_fr_FR.keyword"}},"mug_brand":{"terms":{"field":"attribute_mug_brand_fr_FR.keyword"}},"mug_material":{"terms":{"field":"attribute_mug_material_fr_FR.keyword"}},"plant_type":{"terms":{"field":"attribute_plant_type_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"}},"lamp_color":{"terms":{"field":"option_lamp_color.keyword"}},"mug_color":{"terms":{"field":"option_mug_color.keyword"}},"plant_size":{"terms":{"field":"option_plant_size.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.002979040145874, Array, Array, 1, 8)
#1 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_shop_pro...', 'POST', Array, Array, 0.002979040145874, 1, 8)
#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 |
2.16 ms |
0.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["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
curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["jeans"]}}]}},"size":20}'
#0 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_attribut...', 'POST', Array, 0.0021569728851318, Array, Array, 0, 3)
#1 /srv/sylius/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_attribut...', 'POST', Array, Array, 0.0021569728851318, 0, 3)
#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}
|