1 |
532.49 ms |
353.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"countries.keyword":["PL"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword","size":1000}},"vendor":{"terms":{"field":"vendor.keyword","size":1000}},"tag":{"terms":{"field":"tags_de.keyword","size":1000}},"weight":{"terms":{"field":"attribute_weight_de.keyword","size":1000}},"delivery":{"terms":{"field":"attribute_delivery_de.keyword","size":1000}},"length":{"terms":{"field":"attribute_length_de","size":1000}},"width":{"terms":{"field":"attribute_width_de","size":1000}},"height":{"terms":{"field":"attribute_height_de","size":1000}},"countryoforigin":{"terms":{"field":"attribute_countryoforigin_de.keyword","size":1000}},"maxpressure":{"terms":{"field":"attribute_maxpressure_de","size":1000}},"pressuredrop":{"terms":{"field":"attribute_pressuredrop_de","size":1000}},"maxambtemp":{"terms":{"field":"attribute_maxambtemp_de","size":1000}},"minambtemp":{"terms":{"field":"attribute_minambtemp_de","size":1000}},"MRL":{"terms":{"field":"attribute_mrl_de.keyword","size":1000}},"TRL":{"terms":{"field":"attribute_trl_de.keyword","size":1000}},"maxinputv":{"terms":{"field":"attribute_maxinputv_de","size":1000}},"mininputv":{"terms":{"field":"attribute_mininputv_de","size":1000}},"maxpower":{"terms":{"field":"attribute_maxpower_de","size":1000}},"inputcurrent":{"terms":{"field":"attribute_inputcurrent_de.keyword","size":1000}},"ECI":{"terms":{"field":"attribute_eci_de.keyword","size":1000}},"MRS":{"terms":{"field":"attribute_mrs_de","size":1000}},"cooling":{"terms":{"field":"attribute_cooling_de.keyword","size":1000}},"IPR":{"terms":{"field":"attribute_ipr_de.keyword","size":1000}},"flowconfig":{"terms":{"field":"attribute_flowconfig_de.keyword","size":1000}},"maxvolumeflow":{"terms":{"field":"attribute_maxvolumeflow_de.keyword","size":1000}},"compliancewith":{"terms":{"field":"attribute_compliancewith_de.keyword","size":1000}},"maxplates":{"terms":{"field":"attribute_maxplates_de","size":1000}},"minplates":{"terms":{"field":"attribute_minplates_de","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":{"countries.keyword":["PL"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword","size":1000}},"vendor":{"terms":{"field":"vendor.keyword","size":1000}},"tag":{"terms":{"field":"tags_de.keyword","size":1000}},"weight":{"terms":{"field":"attribute_weight_de.keyword","size":1000}},"delivery":{"terms":{"field":"attribute_delivery_de.keyword","size":1000}},"length":{"terms":{"field":"attribute_length_de","size":1000}},"width":{"terms":{"field":"attribute_width_de","size":1000}},"height":{"terms":{"field":"attribute_height_de","size":1000}},"countryoforigin":{"terms":{"field":"attribute_countryoforigin_de.keyword","size":1000}},"maxpressure":{"terms":{"field":"attribute_maxpressure_de","size":1000}},"pressuredrop":{"terms":{"field":"attribute_pressuredrop_de","size":1000}},"maxambtemp":{"terms":{"field":"attribute_maxambtemp_de","size":1000}},"minambtemp":{"terms":{"field":"attribute_minambtemp_de","size":1000}},"MRL":{"terms":{"field":"attribute_mrl_de.keyword","size":1000}},"TRL":{"terms":{"field":"attribute_trl_de.keyword","size":1000}},"maxinputv":{"terms":{"field":"attribute_maxinputv_de","size":1000}},"mininputv":{"terms":{"field":"attribute_mininputv_de","size":1000}},"maxpower":{"terms":{"field":"attribute_maxpower_de","size":1000}},"inputcurrent":{"terms":{"field":"attribute_inputcurrent_de.keyword","size":1000}},"ECI":{"terms":{"field":"attribute_eci_de.keyword","size":1000}},"MRS":{"terms":{"field":"attribute_mrs_de","size":1000}},"cooling":{"terms":{"field":"attribute_cooling_de.keyword","size":1000}},"IPR":{"terms":{"field":"attribute_ipr_de.keyword","size":1000}},"flowconfig":{"terms":{"field":"attribute_flowconfig_de.keyword","size":1000}},"maxvolumeflow":{"terms":{"field":"attribute_maxvolumeflow_de.keyword","size":1000}},"compliancewith":{"terms":{"field":"attribute_compliancewith_de.keyword","size":1000}},"maxplates":{"terms":{"field":"attribute_maxplates_de","size":1000}},"minplates":{"terms":{"field":"attribute_minplates_de","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.53248691558838, Array, Array, 353, 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.53248691558838, 353, 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/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/Country/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\Country\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 |
71.86 ms |
59.00 ms |
{"query":{"function_score":{"boost":8,"score_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"countries.keyword":["PL"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1728124017}}]}},"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: 1
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":{"countries.keyword":["PL"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1728124017}}]}},"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.071861982345581, Array, Array, 59, 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.071861982345581, 59, 1)
#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/ac/acc0359d6bb0cbdf87ed274523f6adfe.php(222): twig_length_filter(Object(Twig\Environment), Object(Pagerfanta\Pagerfanta))
#10 /srv/open_marketplace/vendor/twig/twig/src/Template.php(182): __TwigTemplate_68ff9cc3696186635dca9509dd2d1fbf->block_content(Array, Array)
#11 /srv/open_marketplace/var/cache/dev/twig/b1/b165c9dc0ff07990345a7cf29afdc281.php(155): Twig\Template->displayBlock('content', Array, Array)
#12 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_99c5e7384005670623a55d3c5fb033e4->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/ac/acc0359d6bb0cbdf87ed274523f6adfe.php(57): Twig\Template->display(Array, Array)
#15 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_68ff9cc3696186635dca9509dd2d1fbf->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/Country/IndexAction.php(69): Twig\Environment->render('Context/Shop/Co...', Array)
#21 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Core\Shop\Controller\Country\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 |
52.44 ms |
44.00 ms |
{"query":{"function_score":{"boost":8,"score_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"countries.keyword":["PL"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1728124017}}]}},"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":{"countries.keyword":["PL"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1728124017}}]}},"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.052436113357544, Array, Array, 44, 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.052436113357544, 44, 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/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(415): Pagerfanta\Pagerfanta->getCurrentPageResults()
#10 /srv/open_marketplace/var/cache/dev/twig/ac/acc0359d6bb0cbdf87ed274523f6adfe.php(242): Pagerfanta\Pagerfanta->getIterator()
#11 /srv/open_marketplace/vendor/twig/twig/src/Template.php(182): __TwigTemplate_68ff9cc3696186635dca9509dd2d1fbf->block_content(Array, Array)
#12 /srv/open_marketplace/var/cache/dev/twig/b1/b165c9dc0ff07990345a7cf29afdc281.php(155): Twig\Template->displayBlock('content', Array, Array)
#13 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_99c5e7384005670623a55d3c5fb033e4->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/ac/acc0359d6bb0cbdf87ed274523f6adfe.php(57): Twig\Template->display(Array, Array)
#16 /srv/open_marketplace/vendor/twig/twig/src/Template.php(405): __TwigTemplate_68ff9cc3696186635dca9509dd2d1fbf->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/Country/IndexAction.php(69): Twig\Environment->render('Context/Shop/Co...', Array)
#22 /srv/open_marketplace/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\OpenMarketplace\Component\Core\Shop\Controller\Country\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}
|