Symfony Profiler

Settings

Query Metrics

5 Database Queries

12.01 ms Execution Time

1.00 ms Query Time

Queries


{"query":{"bool":{"must":[{"terms":{"option_taxons":["cat00154"]}}]}},"size":20}
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["livmedx"]}},{"terms":{"product_taxons":["cat00154"]}}]}},"size":0}
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}

#▲	Execution Time	Query Time	Info
1	3.06 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"option_taxons":["cat00154"]}}]}},"size":20} Path: bitbag_option_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "option_taxons": [ "cat00154" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_option_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"option_taxons":["cat00154"]}}]}},"size":20}'` #0 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/livmedx.com/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/livmedx.com/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search() #5 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductOptionsFinder.php(44): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Context/ProductOptionsContext.php(35): BitBag\SyliusElasticsearchPlugin\Finder\ProductOptionsFinder->findByTaxon() #8 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ProductOptionsFilterType.php(41): BitBag\SyliusElasticsearchPlugin\Context\ProductOptionsContext->getOptions() #9 /var/www/livmedx.com/vendor/symfony/form/ResolvedFormType.php(131): BitBag\SyliusElasticsearchPlugin\Form\Type\ProductOptionsFilterType->buildForm() #10 /var/www/livmedx.com/vendor/symfony/form/Extension/DataCollector/Proxy/ResolvedTypeDataCollectorProxy.php(95): Symfony\Component\Form\ResolvedFormType->buildForm() #11 /var/www/livmedx.com/vendor/symfony/form/FormFactory.php(73): Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm() #12 /var/www/livmedx.com/vendor/symfony/form/FormBuilder.php(97): Symfony\Component\Form\FormFactory->createNamedBuilder() #13 /var/www/livmedx.com/vendor/symfony/form/FormBuilder.php(249): Symfony\Component\Form\FormBuilder->create() #14 /var/www/livmedx.com/vendor/symfony/form/FormBuilder.php(199): Symfony\Component\Form\FormBuilder->resolveChildren() #15 /var/www/livmedx.com/vendor/symfony/form/FormFactory.php(31): Symfony\Component\Form\FormBuilder->getForm() #16 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/ListProductsAction.php(59): Symfony\Component\Form\FormFactory->create() #17 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\ListProductsAction->__invoke() #18 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #19 /var/www/livmedx.com/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #20 /var/www/livmedx.com/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle() #21 {main}
2	3.29 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20} Path: bitbag_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons": [ "cat00154" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}'` #0 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/livmedx.com/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/livmedx.com/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search() #5 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(44): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Context/ProductAttributesContext.php(35): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon() #8 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ProductAttributesFilterType.php(45): BitBag\SyliusElasticsearchPlugin\Context\ProductAttributesContext->getAttributes() #9 /var/www/livmedx.com/vendor/symfony/form/ResolvedFormType.php(131): BitBag\SyliusElasticsearchPlugin\Form\Type\ProductAttributesFilterType->buildForm() #10 /var/www/livmedx.com/vendor/symfony/form/Extension/DataCollector/Proxy/ResolvedTypeDataCollectorProxy.php(95): Symfony\Component\Form\ResolvedFormType->buildForm() #11 /var/www/livmedx.com/vendor/symfony/form/FormFactory.php(73): Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm() #12 /var/www/livmedx.com/vendor/symfony/form/FormBuilder.php(97): Symfony\Component\Form\FormFactory->createNamedBuilder() #13 /var/www/livmedx.com/vendor/symfony/form/FormBuilder.php(249): Symfony\Component\Form\FormBuilder->create() #14 /var/www/livmedx.com/vendor/symfony/form/FormBuilder.php(199): Symfony\Component\Form\FormBuilder->resolveChildren() #15 /var/www/livmedx.com/vendor/symfony/form/FormFactory.php(31): Symfony\Component\Form\FormBuilder->getForm() #16 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/ListProductsAction.php(59): Symfony\Component\Form\FormFactory->create() #17 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\ListProductsAction->__invoke() #18 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #19 /var/www/livmedx.com/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #20 /var/www/livmedx.com/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle() #21 {main}
3	1.46 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20} Path: bitbag_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons": [ "cat00154" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}'` #0 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/livmedx.com/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/livmedx.com/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search() #5 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(44): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(64): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon() #8 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/QueryBuilder/FormQueryBuilder/TaxonFacetsQueryBuilder.php(39): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData() #9 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Form/Resolver/ProductsFilterFacetResolver.php(39): BitBag\SyliusElasticsearchPlugin\QueryBuilder\FormQueryBuilder\TaxonFacetsQueryBuilder->getQuery() #10 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ShopProductsFilterType.php(51): BitBag\SyliusElasticsearchPlugin\Form\Resolver\ProductsFilterFacetResolver->resolveFacets() #11 /var/www/livmedx.com/vendor/symfony/event-dispatcher/EventDispatcher.php(230): BitBag\SyliusElasticsearchPlugin\Form\Type\ShopProductsFilterType->addFacets() #12 /var/www/livmedx.com/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #13 /var/www/livmedx.com/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(33): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #14 /var/www/livmedx.com/vendor/symfony/form/Form.php(568): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch() #15 /var/www/livmedx.com/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(115): Symfony\Component\Form\Form->submit() #16 /var/www/livmedx.com/vendor/symfony/form/Form.php(503): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest() #17 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/ListProductsAction.php(60): Symfony\Component\Form\Form->handleRequest() #18 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\ListProductsAction->__invoke() #19 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #20 /var/www/livmedx.com/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #21 /var/www/livmedx.com/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle() #22 {main}
4	2.55 ms	1.00 ms	{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["livmedx"]}},{"terms":{"product_taxons":["cat00154"]}}]}},"size":0} Path: bitbag_shop_products_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "term": { "enabled": { "value": true, "boost": 1 } } }, { "terms": { "channels": [ "livmedx" ] } }, { "terms": { "product_taxons": [ "cat00154" ] } } ] } }, "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":["livmedx"]}},{"terms":{"product_taxons":["cat00154"]}}]}},"size":0}'` #0 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/livmedx.com/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/livmedx.com/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(102): Elastica\Index->search() #5 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(57): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations() #6 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ShopProductsFilterType.php(68): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations() #7 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Form/Type/ShopProductsFilterType.php(54): BitBag\SyliusElasticsearchPlugin\Form\Type\ShopProductsFilterType->modifyForm() #8 /var/www/livmedx.com/vendor/symfony/event-dispatcher/EventDispatcher.php(230): BitBag\SyliusElasticsearchPlugin\Form\Type\ShopProductsFilterType->addFacets() #9 /var/www/livmedx.com/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #10 /var/www/livmedx.com/vendor/symfony/event-dispatcher/ImmutableEventDispatcher.php(33): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #11 /var/www/livmedx.com/vendor/symfony/form/Form.php(568): Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch() #12 /var/www/livmedx.com/vendor/sylius/resource-bundle/src/Bundle/Form/Extension/HttpFoundation/HttpFoundationRequestHandler.php(115): Symfony\Component\Form\Form->submit() #13 /var/www/livmedx.com/vendor/symfony/form/Form.php(503): Sylius\Bundle\ResourceBundle\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest() #14 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/ListProductsAction.php(60): Symfony\Component\Form\Form->handleRequest() #15 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\ListProductsAction->__invoke() #16 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #17 /var/www/livmedx.com/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #18 /var/www/livmedx.com/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle() #19 {main}
5	1.66 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20} Path: bitbag_attribute_taxons_dev/_search Query: Method: POST (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "attribute_taxons": [ "cat00154" ] } } ] } }, "size": 20 }` `curl -XPOST 'http://localhost:9200/bitbag_attribute_taxons_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}'` #0 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/livmedx.com/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/livmedx.com/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search() #5 /var/www/livmedx.com/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Finder/ProductAttributesFinder.php(44): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Controller/RequestDataHandler/ShopProductListDataHandler.php(64): BitBag\SyliusElasticsearchPlugin\Finder\ProductAttributesFinder->findByTaxon() #8 /var/www/livmedx.com/vendor/bitbag/elasticsearch-plugin/src/Controller/Action/Shop/ListProductsAction.php(72): BitBag\SyliusElasticsearchPlugin\Controller\RequestDataHandler\ShopProductListDataHandler->retrieveData() #9 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(163): BitBag\SyliusElasticsearchPlugin\Controller\Action\Shop\ListProductsAction->__invoke() #10 /var/www/livmedx.com/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #11 /var/www/livmedx.com/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #12 /var/www/livmedx.com/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle() #13 {main}

Symfony Profiler

https://livmedx.com/wishlist/header-template

Configuration Settings

Theme

Page Width

Query Metrics

Queries