1 |
13.49 ms |
5.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["pressure_relief_devices"]}}]}},"size":20}
Path: bitbag_b2b_plugin_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query
View cURL query
View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_b2b_plugin_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["pressure_relief_devices"]}}]}},"size":20}'
#0 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_b2b_plug...', 'POST', Array, 0.013486862182617, Array, Array, 5, 0)
#1 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_b2b_plug...', 'POST', Array, Array, 0.013486862182617, 5, 0)
#2 /srv/open_marketplace/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('bitbag_b2b_plug...', 'POST', Array, Array)
#3 /srv/open_marketplace/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search(Object(Elastica\Query), Array)
#5 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search(Object(Elastica\Query\BoolQuery), 20, Array)
#6 /srv/open_marketplace/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(44): FOS\ElasticaBundle\Finder\TransformedFinder->find(Object(Elastica\Query\BoolQuery), 20)
#7 /srv/open_marketplace/vendor/bitbag/elasticsearch-plugin/src/Context/ProductAttributesContext.php(35): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon(Object(BitBag\OpenMarketplace\Component\Taxonomy\Entity\Taxon))
#8 /srv/open_marketplace/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ProductAttributesFilterType.php(45): BitBag\SyliusElasticsearchPlugin\Context\ProductAttributesContext->getAttributes()
#9 /srv/open_marketplace/vendor/symfony/form/ResolvedFormType.php(131): BitBag\SyliusElasticsearchPlugin\Form\Type\ProductAttributesFilterType->buildForm(Object(Symfony\Component\Form\FormBuilder), Array)
#10 /srv/open_marketplace/vendor/symfony/form/Extension/DataCollector/Proxy/ResolvedTypeDataCollectorProxy.php(95): Symfony\Component\Form\ResolvedFormType->buildForm(Object(Symfony\Component\Form\FormBuilder), Array)
#11 /srv/open_marketplace/vendor/symfony/form/FormFactory.php(73): Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm(Object(Symfony\Component\Form\FormBuilder), Array)
#12 /srv/open_marketplace/vendor/symfony/form/FormBuilder.php(97): Symfony\Component\Form\FormFactory->createNamedBuilder('attributes', Object(Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy), NULL, Array)
#13 /srv/open_marketplace/vendor/symfony/form/FormBuilder.php(240): Symfony\Component\Form\FormBuilder->create('attributes', 'BitBag\\SyliusEl...', Array)
#14 /srv/open_marketplace/vendor/symfony/form/FormBuilder.php(113): Symfony\Component\Form\FormBuilder->resolveChild('attributes')
#15 /srv/open_marketplace/src/Component/Elasticsearch/Form/Extension/ShopProductsFilterTypeExtension.php(24): Symfony\Component\Form\FormBuilder->get('attributes')
#16 /srv/open_marketplace/vendor/symfony/form/ResolvedFormType.php(134): BitBag\OpenMarketplace\Component\Elasticsearch\Form\Extension\ShopProductsFilterTypeExtension->buildForm(Object(Symfony\Component\Form\FormBuilder), Array)
#17 /srv/open_marketplace/vendor/symfony/form/Extension/DataCollector/Proxy/ResolvedTypeDataCollectorProxy.php(95): Symfony\Component\Form\ResolvedFormType->buildForm(Object(Symfony\Component\Form\FormBuilder), Array)
#18 /srv/open_marketplace/vendor/symfony/form/FormFactory.php(73): Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm(Object(Symfony\Component\Form\FormBuilder), Array)
#19 /srv/open_marketplace/vendor/symfony/form/FormFactory.php(55): Symfony\Component\Form\FormFactory->createNamedBuilder('', Object(Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy), NULL, Array)
#20 /srv/open_marketplace/vendor/symfony/form/FormFactory.php(31): Symfony\Component\Form\FormFactory->createBuilder('BitBag\\SyliusEl...', NULL, Array)
#21 /srv/open_marketplace/src/Component/Elasticsearch/Controller/ListProductsAction.php(48): Symfony\Component\Form\FormFactory->create('BitBag\\SyliusEl...')
#22 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Elasticsearch\Controller\ListProductsAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#23 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#24 /srv/open_marketplace/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#25 /srv/open_marketplace/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#26 {main}
|
4 |
15.86 ms |
12.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"product_taxons":["pressure_relief_devices"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword","size":1000}},"vendor":{"terms":{"field":"vendor.keyword","size":1000}},"tag":{"terms":{"field":"tags_en.keyword","size":1000}},"weight":{"terms":{"field":"attribute_weight_en.keyword","size":1000}},"delivery":{"terms":{"field":"attribute_delivery_en.keyword","size":1000}},"length":{"terms":{"field":"attribute_length_en","size":1000}},"width":{"terms":{"field":"attribute_width_en","size":1000}},"height":{"terms":{"field":"attribute_height_en","size":1000}},"countryoforigin":{"terms":{"field":"attribute_countryoforigin_en.keyword","size":1000}},"maxpressure":{"terms":{"field":"attribute_maxpressure_en","size":1000}},"pressuredrop":{"terms":{"field":"attribute_pressuredrop_en","size":1000}},"maxambtemp":{"terms":{"field":"attribute_maxambtemp_en","size":1000}},"minambtemp":{"terms":{"field":"attribute_minambtemp_en","size":1000}},"MRL":{"terms":{"field":"attribute_mrl_en.keyword","size":1000}},"TRL":{"terms":{"field":"attribute_trl_en.keyword","size":1000}},"maxinputv":{"terms":{"field":"attribute_maxinputv_en","size":1000}},"mininputv":{"terms":{"field":"attribute_mininputv_en","size":1000}},"maxpower":{"terms":{"field":"attribute_maxpower_en","size":1000}},"inputcurrent":{"terms":{"field":"attribute_inputcurrent_en.keyword","size":1000}},"ECI":{"terms":{"field":"attribute_eci_en.keyword","size":1000}},"MRS":{"terms":{"field":"attribute_mrs_en","size":1000}},"cooling":{"terms":{"field":"attribute_cooling_en.keyword","size":1000}},"IPR":{"terms":{"field":"attribute_ipr_en.keyword","size":1000}},"flowconfig":{"terms":{"field":"attribute_flowconfig_en.keyword","size":1000}},"maxvolumeflow":{"terms":{"field":"attribute_maxvolumeflow_en.keyword","size":1000}},"compliancewith":{"terms":{"field":"attribute_compliancewith_en.keyword","size":1000}},"maxplates":{"terms":{"field":"attribute_maxplates_en","size":1000}},"minplates":{"terms":{"field":"attribute_minplates_en","size":1000}}},"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
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":["open_marketplace"]}},{"terms":{"product_taxons":["pressure_relief_devices"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword","size":1000}},"vendor":{"terms":{"field":"vendor.keyword","size":1000}},"tag":{"terms":{"field":"tags_en.keyword","size":1000}},"weight":{"terms":{"field":"attribute_weight_en.keyword","size":1000}},"delivery":{"terms":{"field":"attribute_delivery_en.keyword","size":1000}},"length":{"terms":{"field":"attribute_length_en","size":1000}},"width":{"terms":{"field":"attribute_width_en","size":1000}},"height":{"terms":{"field":"attribute_height_en","size":1000}},"countryoforigin":{"terms":{"field":"attribute_countryoforigin_en.keyword","size":1000}},"maxpressure":{"terms":{"field":"attribute_maxpressure_en","size":1000}},"pressuredrop":{"terms":{"field":"attribute_pressuredrop_en","size":1000}},"maxambtemp":{"terms":{"field":"attribute_maxambtemp_en","size":1000}},"minambtemp":{"terms":{"field":"attribute_minambtemp_en","size":1000}},"MRL":{"terms":{"field":"attribute_mrl_en.keyword","size":1000}},"TRL":{"terms":{"field":"attribute_trl_en.keyword","size":1000}},"maxinputv":{"terms":{"field":"attribute_maxinputv_en","size":1000}},"mininputv":{"terms":{"field":"attribute_mininputv_en","size":1000}},"maxpower":{"terms":{"field":"attribute_maxpower_en","size":1000}},"inputcurrent":{"terms":{"field":"attribute_inputcurrent_en.keyword","size":1000}},"ECI":{"terms":{"field":"attribute_eci_en.keyword","size":1000}},"MRS":{"terms":{"field":"attribute_mrs_en","size":1000}},"cooling":{"terms":{"field":"attribute_cooling_en.keyword","size":1000}},"IPR":{"terms":{"field":"attribute_ipr_en.keyword","size":1000}},"flowconfig":{"terms":{"field":"attribute_flowconfig_en.keyword","size":1000}},"maxvolumeflow":{"terms":{"field":"attribute_maxvolumeflow_en.keyword","size":1000}},"compliancewith":{"terms":{"field":"attribute_compliancewith_en.keyword","size":1000}},"maxplates":{"terms":{"field":"attribute_maxplates_en","size":1000}},"minplates":{"terms":{"field":"attribute_minplates_en","size":1000}}},"size":0}'
#0 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_shop_pro...', 'POST', Array, 0.015857934951782, Array, Array, 12, 1)
#1 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_shop_pro...', 'POST', Array, Array, 0.015857934951782, 12, 1)
#2 /srv/open_marketplace/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('bitbag_shop_pro...', 'POST', Array, Array)
#3 /srv/open_marketplace/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search(Object(Elastica\Query))
#5 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations()
#6 /srv/open_marketplace/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ShopProductsFilterType.php(68): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations()
#7 /srv/open_marketplace/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ShopProductsFilterType.php(54): BitBag\SyliusElasticsearchPlugin\Form\Type\ShopProductsFilterType->modifyForm(Object(Symfony\Component\Form\Form), Object(FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter))
#8 /srv/open_marketplace/vendor/symfony/event-dispatcher/EventDispatcher.php(230): BitBag\SyliusElasticsearchPlugin\Form\Type\ShopProductsFilterType->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher))
#9 /srv/open_marketplace/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent))
#10 /srv/open_marketplace/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(33): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#11 /srv/open_marketplace/vendor/symfony/form/Form.php(568): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#12 /srv/open_marketplace/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(115): Symfony\Component\Form\Form->submit(Array, true)
#13 /srv/open_marketplace/vendor/symfony/form/Form.php(503): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request))
#14 /srv/open_marketplace/src/Component/Elasticsearch/Controller/ListProductsAction.php(49): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request))
#15 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Elasticsearch\Controller\ListProductsAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#16 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#17 /srv/open_marketplace/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 /srv/open_marketplace/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#19 {main}
|
6 |
6.93 ms |
3.00 ms |
{"query":{"function_score":{"boost":8,"score_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"product_taxons":["pressure_relief_devices"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}}]}},"sort":[{"featured":{"order":"desc","unmapped_type":"keyword"},"product_created_at":{"order":"desc","unmapped_type":"keyword"}}],"from":0,"size":24}
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
curl -XPOST 'http://localhost:9200/bitbag_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"function_score":{"boost":8,"score_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"product_taxons":["pressure_relief_devices"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}}]}},"sort":[{"featured":{"order":"desc","unmapped_type":"keyword"},"product_created_at":{"order":"desc","unmapped_type":"keyword"}}],"from":0,"size":24}'
#0 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_shop_pro...', 'POST', Array, 0.0069260597229004, Array, Array, 3, 1)
#1 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery('bitbag_shop_pro...', 'POST', Array, Array, 0.0069260597229004, 3, 1)
#2 /srv/open_marketplace/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('bitbag_shop_pro...', 'POST', Array, Array)
#3 /srv/open_marketplace/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search(Object(Elastica\Query), Array)
#5 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults(0, 24)
#6 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(80): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults(0, 24)
#7 /srv/open_marketplace/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(260): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getSlice(0, 24)
#8 /srv/open_marketplace/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(246): Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter()
#9 /srv/open_marketplace/src/Component/Elasticsearch/Controller/ListProductsAction.php(69): Pagerfanta\Pagerfanta->getCurrentPageResults()
#10 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Elasticsearch\Controller\ListProductsAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#11 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#12 /srv/open_marketplace/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 /srv/open_marketplace/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#14 {main}
|