1 |
38.99 ms |
26.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"vendor.keyword":["hyfindr_corp"]}}]}},"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: 4
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":{"vendor.keyword":["hyfindr_corp"]}}]}},"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.038987159729004, Array, Array, 26, 4)
#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.038987159729004, 26, 4)
#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/src/Component/Elasticsearch/Form/Type/ListProductsType.php(80): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations()
#7 /srv/open_marketplace/src/Component/Elasticsearch/Form/Type/ListProductsType.php(52): BitBag\OpenMarketplace\Component\Elasticsearch\Form\Type\ListProductsType->modifyForm(Object(Symfony\Component\Form\Form), Object(FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter))
#8 /srv/open_marketplace/vendor/symfony/event-dispatcher/EventDispatcher.php(230): BitBag\OpenMarketplace\Component\Elasticsearch\Form\Type\ListProductsType->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/Core/Shop/Controller/Vendor/IndexAction.php(56): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request))
#15 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Core\Shop\Controller\Vendor\IndexAction->__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}
|
2 |
15.93 ms |
12.00 ms |
{"query":{"function_score":{"boost":8,"score_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"vendor.keyword":["hyfindr_corp"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}}]}},"sort":[{"featured":{"order":"desc","unmapped_type":"keyword"},"product_created_at":{"order":"desc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}
Path: bitbag_shop_products_dev/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 4
View formatted query
View cURL query
View query backtrace
curl -XPOST 'http://localhost:9200/bitbag_shop_products_dev/_search?search_type=query_then_fetch' -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":{"vendor.keyword":["hyfindr_corp"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}}]}},"sort":[{"featured":{"order":"desc","unmapped_type":"keyword"},"product_created_at":{"order":"desc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}'
#0 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('bitbag_shop_pro...', 'POST', Array, 0.015929937362671, Array, Array, 12, 4)
#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.015929937362671, 12, 4)
#2 /srv/open_marketplace/vendor/ruflin/elastica/src/Search.php(382): FOS\ElasticaBundle\Elastica\Client->request('bitbag_shop_pro...', 'POST', Array, Array)
#3 /srv/open_marketplace/vendor/ruflin/elastica/src/Index.php(556): Elastica\Search->count(Object(Elastica\Query), false, 'POST')
#4 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(91): Elastica\Index->count(Object(Elastica\Query))
#5 /srv/open_marketplace/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(45): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getTotalHits()
#6 /srv/open_marketplace/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(293): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getNbResults()
#7 /srv/open_marketplace/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(407): Pagerfanta\Pagerfanta->getNbResults()
#8 /srv/open_marketplace/vendor/twig/twig/src/Extension/CoreExtension.php(1072): Pagerfanta\Pagerfanta->count()
#9 /srv/open_marketplace/var/cache/dev/twig/f3/f30ccab25e333c1e406d630fd32b3d4f.php(256): twig_length_filter(Object(Twig\Environment), Object(Pagerfanta\Pagerfanta))
#10 /srv/open_marketplace/vendor/twig/twig/src/Template.php(182): __TwigTemplate_6da7741ac399bf9b3546521aac3ec6bf->block_content(Array, Array)
#11 /srv/open_marketplace/var/cache/dev/twig/06/0606d6acc34a583d5dd70635211c8340.php(148): Twig\Template->displayBlock('content', Array, Array)
#12 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_4a5301d823570ec3fdb568f80b88bbe6->doDisplay(Array, Array)
#13 /srv/open_marketplace/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling(Array, Array)
#14 /srv/open_marketplace/var/cache/dev/twig/f3/f30ccab25e333c1e406d630fd32b3d4f.php(57): Twig\Template->display(Array, Array)
#15 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_6da7741ac399bf9b3546521aac3ec6bf->doDisplay(Array, Array)
#16 /srv/open_marketplace/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling(Array, Array)
#17 /srv/open_marketplace/vendor/twig/twig/src/Template.php(390): Twig\Template->display(Array)
#18 /srv/open_marketplace/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render(Array, Array)
#19 /srv/open_marketplace/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render(Array)
#20 /srv/open_marketplace/src/Component/Core/Shop/Controller/Vendor/IndexAction.php(69): Twig\Environment->render('Context/Vendor/...', Array)
#21 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Core\Shop\Controller\Vendor\IndexAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#22 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#23 /srv/open_marketplace/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#24 /srv/open_marketplace/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#25 {main}
|
3 |
9.76 ms |
5.00 ms |
{"query":{"function_score":{"boost":8,"score_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"vendor.keyword":["hyfindr_corp"]}}]}},"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: 4
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":{"vendor.keyword":["hyfindr_corp"]}}]}},"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.0097589492797852, Array, Array, 5, 4)
#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.0097589492797852, 5, 4)
#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/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(415): Pagerfanta\Pagerfanta->getCurrentPageResults()
#10 /srv/open_marketplace/var/cache/dev/twig/f3/f30ccab25e333c1e406d630fd32b3d4f.php(276): Pagerfanta\Pagerfanta->getIterator()
#11 /srv/open_marketplace/vendor/twig/twig/src/Template.php(182): __TwigTemplate_6da7741ac399bf9b3546521aac3ec6bf->block_content(Array, Array)
#12 /srv/open_marketplace/var/cache/dev/twig/06/0606d6acc34a583d5dd70635211c8340.php(148): Twig\Template->displayBlock('content', Array, Array)
#13 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_4a5301d823570ec3fdb568f80b88bbe6->doDisplay(Array, Array)
#14 /srv/open_marketplace/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling(Array, Array)
#15 /srv/open_marketplace/var/cache/dev/twig/f3/f30ccab25e333c1e406d630fd32b3d4f.php(57): Twig\Template->display(Array, Array)
#16 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_6da7741ac399bf9b3546521aac3ec6bf->doDisplay(Array, Array)
#17 /srv/open_marketplace/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling(Array, Array)
#18 /srv/open_marketplace/vendor/twig/twig/src/Template.php(390): Twig\Template->display(Array)
#19 /srv/open_marketplace/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render(Array, Array)
#20 /srv/open_marketplace/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render(Array)
#21 /srv/open_marketplace/src/Component/Core/Shop/Controller/Vendor/IndexAction.php(69): Twig\Environment->render('Context/Vendor/...', Array)
#22 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Core\Shop\Controller\Vendor\IndexAction->__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}
|