Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

7.63 ms Execution Time

4.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

4.05 ms

2.00 ms

#▲	Execution Time	Query Time	Info
1	4.05 ms	2.00 ms	{"query":{"bool":{"must":[{"query_string":{"query":"?","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"size":999} Path: product_association/_search Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "query_string": { "query": "?", "fields": [ "title" ] } }, { "bool": { "should": [ { "term": { "template.isActive": { "value": true, "boost": 1 } } }, { "term": { "categoryMaster.template.isActive": { "value": true, "boost": 1 } } }, { "term": { "portalSettings.templates.isActive": { "value": true, "boost": 1 } } }, { "term": { "productMainType.template.isActive": { "value": true, "boost": 1 } } } ] } }, { "term": { "isHidden": { "value": false, "boost": 1 } } }, { "term": { "allCategoriesForElastica.id": { "value": 1, "boost": 1 } } }, { "term": { "productMainType.id": { "value": 12, "boost": 1 } } } ] } }, "size": 999 } curl -XPOST 'http://localhost:9200/product_association/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"query_string":{"query":"?*","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"size":999}' #0 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /app/test/global_order_system/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /app/test/global_order_system/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search() #5 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /app/test/global_order_system/src/Utils/Eforum/ElasticSearchUtils.php(124): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(125): App\Utils\Eforum\ElasticSearchUtils->search() #8 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(43): App\Utils\Eforum\SearchUtil->filter() #9 /app/test/global_order_system/src/Controller/FrontendShop/CatalogController.php(72): App\Utils\Eforum\SearchUtil->filterData() #10 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FrontendShop\CatalogController->categoriesAction() #11 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #12 /app/test/global_order_system/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #13 /app/test/global_order_system/public/index.php(35): Symfony\Component\HttpKernel\Kernel->handle() #14 {main}
2	3.59 ms	2.00 ms	{"query":{"bool":{"must":[{"query_string":{"query":"?","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"from":0,"size":12} Path: product_association/_search Query: Method: POST (Http on localhost:9200) Item count: 1 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "query_string": { "query": "?", "fields": [ "title" ] } }, { "bool": { "should": [ { "term": { "template.isActive": { "value": true, "boost": 1 } } }, { "term": { "categoryMaster.template.isActive": { "value": true, "boost": 1 } } }, { "term": { "portalSettings.templates.isActive": { "value": true, "boost": 1 } } }, { "term": { "productMainType.template.isActive": { "value": true, "boost": 1 } } } ] } }, { "term": { "isHidden": { "value": false, "boost": 1 } } }, { "term": { "allCategoriesForElastica.id": { "value": 1, "boost": 1 } } }, { "term": { "productMainType.id": { "value": 12, "boost": 1 } } } ] } }, "from": 0, "size": 12 } curl -XPOST 'http://localhost:9200/product_association/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"query_string":{"query":"?*","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"from":0,"size":12}' #0 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /app/test/global_order_system/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /app/test/global_order_system/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search() #5 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults() #6 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(40): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults() #7 /app/test/global_order_system/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(118): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items() #8 /app/test/global_order_system/vendor/symfony/event-dispatcher/EventDispatcher.php(230): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke() #9 /app/test/global_order_system/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #10 /app/test/global_order_system/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(154): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #11 /app/test/global_order_system/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(93): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch() #12 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(127): Knp\Component\Pager\Paginator->paginate() #13 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(43): App\Utils\Eforum\SearchUtil->filter() #14 /app/test/global_order_system/src/Controller/FrontendShop/CatalogController.php(72): App\Utils\Eforum\SearchUtil->filterData() #15 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FrontendShop\CatalogController->categoriesAction() #16 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #17 /app/test/global_order_system/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #18 /app/test/global_order_system/public/index.php(35): Symfony\Component\HttpKernel\Kernel->handle() #19 {main}

{"query":{"bool":{"must":[{"query_string":{"query":"?*","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"size":999}

Path: product_association/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "query_string": {
                        "query": "?*",
                        "fields": [
                            "title"
                        ]
                    }
                },
                {
                    "bool": {
                        "should": [
                            {
                                "term": {
                                    "template.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "term": {
                                    "categoryMaster.template.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "term": {
                                    "portalSettings.templates.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "term": {
                                    "productMainType.template.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            }
                        ]
                    }
                },
                {
                    "term": {
                        "isHidden": {
                            "value": false,
                            "boost": 1
                        }
                    }
                },
                {
                    "term": {
                        "allCategoriesForElastica.id": {
                            "value": 1,
                            "boost": 1
                        }
                    }
                },
                {
                    "term": {
                        "productMainType.id": {
                            "value": 12,
                            "boost": 1
                        }
                    }
                }
            ]
        }
    },
    "size": 999
}

curl -XPOST 'http://localhost:9200/product_association/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"query_string":{"query":"?*","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"size":999}'

#0 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/test/global_order_system/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/test/global_order_system/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(117): Elastica\Index->search()
#5 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(43): FOS\ElasticaBundle\Finder\TransformedFinder->search()
#6 /app/test/global_order_system/src/Utils/Eforum/ElasticSearchUtils.php(124): FOS\ElasticaBundle\Finder\TransformedFinder->find()
#7 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(125): App\Utils\Eforum\ElasticSearchUtils->search()
#8 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(43): App\Utils\Eforum\SearchUtil->filter()
#9 /app/test/global_order_system/src/Controller/FrontendShop/CatalogController.php(72): App\Utils\Eforum\SearchUtil->filterData()
#10 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FrontendShop\CatalogController->categoriesAction()
#11 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#12 /app/test/global_order_system/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#13 /app/test/global_order_system/public/index.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#14 {main}

3.59 ms

2.00 ms

{"query":{"bool":{"must":[{"query_string":{"query":"?*","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"from":0,"size":12}

Path: product_association/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "query_string": {
                        "query": "?*",
                        "fields": [
                            "title"
                        ]
                    }
                },
                {
                    "bool": {
                        "should": [
                            {
                                "term": {
                                    "template.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "term": {
                                    "categoryMaster.template.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "term": {
                                    "portalSettings.templates.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "term": {
                                    "productMainType.template.isActive": {
                                        "value": true,
                                        "boost": 1
                                    }
                                }
                            }
                        ]
                    }
                },
                {
                    "term": {
                        "isHidden": {
                            "value": false,
                            "boost": 1
                        }
                    }
                },
                {
                    "term": {
                        "allCategoriesForElastica.id": {
                            "value": 1,
                            "boost": 1
                        }
                    }
                },
                {
                    "term": {
                        "productMainType.id": {
                            "value": 12,
                            "boost": 1
                        }
                    }
                }
            ]
        }
    },
    "from": 0,
    "size": 12
}

curl -XPOST 'http://localhost:9200/product_association/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"query_string":{"query":"?*","fields":["title"]}},{"bool":{"should":[{"term":{"template.isActive":{"value":true,"boost":1}}},{"term":{"categoryMaster.template.isActive":{"value":true,"boost":1}}},{"term":{"portalSettings.templates.isActive":{"value":true,"boost":1}}},{"term":{"productMainType.template.isActive":{"value":true,"boost":1}}}]}},{"term":{"isHidden":{"value":false,"boost":1}}},{"term":{"allCategoriesForElastica.id":{"value":1,"boost":1}}},{"term":{"productMainType.id":{"value":12,"boost":1}}}]}},"from":0,"size":12}'

#0 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/test/global_order_system/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/test/global_order_system/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search()
#5 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /app/test/global_order_system/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(40): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults()
#7 /app/test/global_order_system/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(118): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items()
#8 /app/test/global_order_system/vendor/symfony/event-dispatcher/EventDispatcher.php(230): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
#9 /app/test/global_order_system/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#10 /app/test/global_order_system/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(154): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#11 /app/test/global_order_system/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(93): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
#12 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(127): Knp\Component\Pager\Paginator->paginate()
#13 /app/test/global_order_system/src/Utils/Eforum/SearchUtil.php(43): App\Utils\Eforum\SearchUtil->filter()
#14 /app/test/global_order_system/src/Controller/FrontendShop/CatalogController.php(72): App\Utils\Eforum\SearchUtil->filterData()
#15 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FrontendShop\CatalogController->categoriesAction()
#16 /app/test/global_order_system/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#17 /app/test/global_order_system/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#18 /app/test/global_order_system/public/index.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#19 {main}

Symfony Profiler

https://2.e-forum.pl/kategoria/edukacja/kursy-na-dvd

Configuration Settings

Theme

Page Width

Query Metrics

Queries