Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

1045.20 ms Execution Time

833.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

893.53 ms

717.00 ms

#▲	Execution Time	Query Time	Info
1	893.53 ms	717.00 ms	{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"countries.keyword":["FR"]}}]}},"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 { "query": { "bool": { "must": [ { "term": { "enabled": { "value": true, "boost": 1 } } }, { "terms": { "channels": [ "open_marketplace" ] } }, { "terms": { "countries.keyword": [ "FR" ] } } ] } }, "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 } 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":["FR"]}}]}},"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.89353108406067, Array, Array, 717, 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.89353108406067, 717, 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	65.76 ms	50.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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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 { "query": { "function_score": { "boost": 8, "score_mode": "sum", "query": { "bool": { "must": [ { "term": { "enabled": { "value": true, "boost": 1 } } }, { "terms": { "channels": [ "open_marketplace" ] } }, { "terms": { "countries.keyword": [ "FR" ] } } ] } }, "functions": [ { "weight": 3000, "filter": { "match": { "featured": 1 } } }, { "random_score": { "seed": 1726716036 } } ] } }, "sort": [ { "featured": { "order": "desc", "unmapped_type": "keyword" }, "product_created_at": { "order": "desc", "unmapped_type": "keyword" } } ], "size": 0, "track_total_hits": true } 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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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.065757989883423, Array, Array, 50, 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.065757989883423, 50, 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	85.91 ms	66.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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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 { "query": { "function_score": { "boost": 8, "score_mode": "sum", "query": { "bool": { "must": [ { "term": { "enabled": { "value": true, "boost": 1 } } }, { "terms": { "channels": [ "open_marketplace" ] } }, { "terms": { "countries.keyword": [ "FR" ] } } ] } }, "functions": [ { "weight": 3000, "filter": { "match": { "featured": 1 } } }, { "random_score": { "seed": 1726716036 } } ] } }, "sort": [ { "featured": { "order": "desc", "unmapped_type": "keyword" }, "product_created_at": { "order": "desc", "unmapped_type": "keyword" } } ], "from": 0, "size": 24 } 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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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.085912942886353, Array, Array, 66, 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.085912942886353, 66, 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}

{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"countries.keyword":["FR"]}}]}},"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


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "term": {
                        "enabled": {
                            "value": true,
                            "boost": 1
                        }
                    }
                },
                {
                    "terms": {
                        "channels": [
                            "open_marketplace"
                        ]
                    }
                },
                {
                    "terms": {
                        "countries.keyword": [
                            "FR"
                        ]
                    }
                }
            ]
        }
    },
    "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
}

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":["FR"]}}]}},"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.89353108406067, Array, Array, 717, 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.89353108406067, 717, 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}

65.76 ms

50.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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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


                                                            {
    "query": {
        "function_score": {
            "boost": 8,
            "score_mode": "sum",
            "query": {
                "bool": {
                    "must": [
                        {
                            "term": {
                                "enabled": {
                                    "value": true,
                                    "boost": 1
                                }
                            }
                        },
                        {
                            "terms": {
                                "channels": [
                                    "open_marketplace"
                                ]
                            }
                        },
                        {
                            "terms": {
                                "countries.keyword": [
                                    "FR"
                                ]
                            }
                        }
                    ]
                }
            },
            "functions": [
                {
                    "weight": 3000,
                    "filter": {
                        "match": {
                            "featured": 1
                        }
                    }
                },
                {
                    "random_score": {
                        "seed": 1726716036
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "featured": {
                "order": "desc",
                "unmapped_type": "keyword"
            },
            "product_created_at": {
                "order": "desc",
                "unmapped_type": "keyword"
            }
        }
    ],
    "size": 0,
    "track_total_hits": true
}

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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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.065757989883423, Array, Array, 50, 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.065757989883423, 50, 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}

85.91 ms

66.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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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


                                                            {
    "query": {
        "function_score": {
            "boost": 8,
            "score_mode": "sum",
            "query": {
                "bool": {
                    "must": [
                        {
                            "term": {
                                "enabled": {
                                    "value": true,
                                    "boost": 1
                                }
                            }
                        },
                        {
                            "terms": {
                                "channels": [
                                    "open_marketplace"
                                ]
                            }
                        },
                        {
                            "terms": {
                                "countries.keyword": [
                                    "FR"
                                ]
                            }
                        }
                    ]
                }
            },
            "functions": [
                {
                    "weight": 3000,
                    "filter": {
                        "match": {
                            "featured": 1
                        }
                    }
                },
                {
                    "random_score": {
                        "seed": 1726716036
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "featured": {
                "order": "desc",
                "unmapped_type": "keyword"
            },
            "product_created_at": {
                "order": "desc",
                "unmapped_type": "keyword"
            }
        }
    ],
    "from": 0,
    "size": 24
}

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":["FR"]}}]}},"functions":[{"weight":3000,"filter":{"match":{"featured":1}}},{"random_score":{"seed":1726716036}}]}},"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.085912942886353, Array, Array, 66, 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.085912942886353, 66, 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}

Symfony Profiler

http://185.237.252.235:8080/en/countries/FR

Configuration Settings

Theme

Page Width

Query Metrics

Queries