| 1 |
8.30 ms |
2.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"match_phrase":{"name_en_us":{"query":"ASME BPVC.VIII.1-2025","boost":10}}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["name_en_us^5"],"fuzziness":"AUTO"}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["code_en_us","short_description_en_us"],"fuzziness":"AUTO"}}]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword"}},"available_in_subscription":{"terms":{"field":"attribute_available_in_subscription_en_US"}},"state":{"terms":{"field":"attribute_state_en_US.keyword"}},"most_recent":{"terms":{"field":"attribute_most_recent_en_US.keyword"}},"confirmed":{"terms":{"field":"attribute_confirmed_en_US"}},"has_draft":{"terms":{"field":"attribute_has_draft_en_US"}},"modified":{"terms":{"field":"attribute_modified_en_US"}},"new":{"terms":{"field":"attribute_new_en_US"}},"type":{"terms":{"field":"attribute_type_en_US.keyword"}},"edition":{"terms":{"field":"attribute_edition_en_US.keyword"}},"published_at":{"terms":{"field":"attribute_published_at_en_US"}},"keywords":{"terms":{"field":"attribute_keywords_en_US.keyword"}},"themes":{"terms":{"field":"attribute_themes_en_US.keyword"}},"supplier":{"terms":{"field":"attribute_supplier_en_US.keyword"}},"format":{"terms":{"field":"option_format.keyword"}},"languages":{"terms":{"field":"option_languages.keyword"}},"multi_user":{"terms":{"field":"option_multi_user.keyword"}},"red_line":{"terms":{"field":"option_red_line.keyword"}}},"size":0}
Path: normadoc_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 5037
View formatted query
View cURL query
View query backtrace
curl -XPOST 'http://localhost:9200/normadoc_shop_products_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"match_phrase":{"name_en_us":{"query":"ASME BPVC.VIII.1-2025","boost":10}}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["name_en_us^5"],"fuzziness":"AUTO"}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["code_en_us","short_description_en_us"],"fuzziness":"AUTO"}}]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword"}},"available_in_subscription":{"terms":{"field":"attribute_available_in_subscription_en_US"}},"state":{"terms":{"field":"attribute_state_en_US.keyword"}},"most_recent":{"terms":{"field":"attribute_most_recent_en_US.keyword"}},"confirmed":{"terms":{"field":"attribute_confirmed_en_US"}},"has_draft":{"terms":{"field":"attribute_has_draft_en_US"}},"modified":{"terms":{"field":"attribute_modified_en_US"}},"new":{"terms":{"field":"attribute_new_en_US"}},"type":{"terms":{"field":"attribute_type_en_US.keyword"}},"edition":{"terms":{"field":"attribute_edition_en_US.keyword"}},"published_at":{"terms":{"field":"attribute_published_at_en_US"}},"keywords":{"terms":{"field":"attribute_keywords_en_US.keyword"}},"themes":{"terms":{"field":"attribute_themes_en_US.keyword"}},"supplier":{"terms":{"field":"attribute_supplier_en_US.keyword"}},"format":{"terms":{"field":"option_format.keyword"}},"languages":{"terms":{"field":"option_languages.keyword"}},"multi_user":{"terms":{"field":"option_multi_user.keyword"}},"red_line":{"terms":{"field":"option_red_line.keyword"}}},"size":0}'
#0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_shop_p...', 'POST', Array, 0.0083048343658447, Array, Array, 2, 5037)
#1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_shop_p...', 'POST', Array, Array, 0.0083048343658447, 2, 5037)
#2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('normadoc_shop_p...', 'POST', Array, Array)
#3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search(Object(Elastica\Query))
#5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations()
#6 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(59): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations()
#7 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Form/EventSubscriber/AddFacetsEventSubscriber.php(46): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->modifyForm(Object(Symfony\Component\Form\Form), Object(FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter))
#8 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(220): BitBag\SyliusElasticsearchPlugin\Form\EventSubscriber\AddFacetsEventSubscriber->addFacets(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit', Object(Symfony\Component\EventDispatcher\EventDispatcher))
#9 /home/normadev/dev/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'form.pre_submit', Object(Symfony\Component\Form\Event\PreSubmitEvent))
#10 /home/normadev/dev/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(30): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#11 /home/normadev/dev/vendor/symfony/form/Form.php(482): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch(Object(Symfony\Component\Form\Event\PreSubmitEvent), 'form.pre_submit')
#12 /home/normadev/dev/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(110): Symfony\Component\Form\Form->submit(Array, true)
#13 /home/normadev/dev/vendor/symfony/form/Form.php(420): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest(Object(Symfony\Component\Form\Form), Object(Symfony\Component\HttpFoundation\Request))
#14 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/SiteWideProductsSearchAction.php(27): Symfony\Component\Form\Form->handleRequest(Object(Symfony\Component\HttpFoundation\Request))
#15 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\SiteWideProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#16 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#17 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#19 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#20 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...')
#21 {main}
|
| 2 |
4.36 ms |
1.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"match_phrase":{"name_en_us":{"query":"ASME BPVC.VIII.1-2025","boost":10}}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["name_en_us^5"],"fuzziness":"AUTO"}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["code_en_us","short_description_en_us"],"fuzziness":"AUTO"}}]}}]}},"sort":[{"price_default":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}
Path: normadoc_shop_products_dev/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 5037
View formatted query
View cURL query
View query backtrace
curl -XPOST 'http://localhost:9200/normadoc_shop_products_dev/_search?search_type=query_then_fetch' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"match_phrase":{"name_en_us":{"query":"ASME BPVC.VIII.1-2025","boost":10}}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["name_en_us^5"],"fuzziness":"AUTO"}},{"multi_match":{"query":"ASME BPVC.VIII.1-2025","fields":["code_en_us","short_description_en_us"],"fuzziness":"AUTO"}}]}}]}},"sort":[{"price_default":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}'
#0 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('normadoc_shop_p...', 'POST', Array, 0.0043601989746094, Array, Array, 1, 5037)
#1 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('normadoc_shop_p...', 'POST', Array, Array, 0.0043601989746094, 1, 5037)
#2 /home/normadev/dev/vendor/ruflin/elastica/src/Search.php(378): FOS\ElasticaBundle\Elastica\Client->request('normadoc_shop_p...', 'POST', Array, Array)
#3 /home/normadev/dev/vendor/ruflin/elastica/src/Index.php(556): Elastica\Search->count(Object(Elastica\Query), false, 'POST')
#4 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(91): Elastica\Index->count(Object(Elastica\Query))
#5 /home/normadev/dev/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(45): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getTotalHits()
#6 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(290): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getNbResults()
#7 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(319): Pagerfanta\Pagerfanta->getNbResults()
#8 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(301): Pagerfanta\Pagerfanta->calculateNbPages()
#9 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(207): Pagerfanta\Pagerfanta->getNbPages()
#10 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(202): Pagerfanta\Pagerfanta->currentPageOutOfRange(289)
#11 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(193): Pagerfanta\Pagerfanta->notAllowedCurrentPageOutOfRange(289)
#12 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(175): Pagerfanta\Pagerfanta->filterOutOfRangeCurrentPage(289)
#13 /home/normadev/dev/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(162): Pagerfanta\Pagerfanta->filterCurrentPage(289)
#14 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Finder/ShopProductsFinder.php(59): Pagerfanta\Pagerfanta->setCurrentPage(289)
#15 /home/normadev/dev/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/SiteWideProductsSearchAction.php(46): BitBag\SyliusElasticsearchPlugin\Finder\ShopProductsFinder->find(Array)
#16 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(181): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\SiteWideProductsSearchAction->__invoke(Object(Symfony\Component\HttpFoundation\Request))
#17 /home/normadev/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#18 /home/normadev/dev/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#19 /home/normadev/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#20 /home/normadev/dev/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#21 /home/normadev/dev/public/index.php(5): require_once('/home/normadev/...')
#22 {main}
|