| 1 |
26.21 ms |
18.00 ms |
{"query":{"bool":{"must":[{"bool":{"minimum_should_match":1}},{"bool":{"minimum_should_match":1,"should":[{"terms":{"ConnectionType":["DSL"]}},{"terms":{"ConnectionType":["Kabel"]}},{"terms":{"ConnectionType":["Glasfaser"]}},{"terms":{"ConnectionType":["LTE"]}}]}},{"terms":{"tariffId":[6,17,18,23,24,25,26,39,40,45,46,59,63,74,75,82,87,88,98,101,102,105,106,108,109,110,114,114,115,115,116,116,117,117,118,118,119,119,186,194,198,199,201,202,212,213,216,217,220,221,223,228,228,229,229,230,231,233,252,255,256,264,272,279,285,291,298,324,327,330,337]}},{"bool":{"must":[{"terms":{"partner__top":[true]}}]}}],"filter":[{"range":{"maxAge":{"gte":0}}},{"terms":{"MinContractTime":[24]}},{"terms":{"tripleplayInternet":[true]}},{"terms":{"__isCurrentContract":[true]}},{"terms":{"__remainingContractTime":[1]}},{"terms":{"partnerId":[1]}},{"terms":{"active":[true]}}]}},"aggs":{"providers":{"terms":{"field":"provider","size":500,"order":{"provider_nested>min_price":"asc"}},"aggs":{"provider_nested":{"nested":{"path":"tariffPrices"},"aggs":{"min_price":{"min":{"field":"tariffPrices.price"}}}}}}},"sort":[{"finalMonthly":{"order":"asc"}}],"from":0,"size":10}
Path: dsl_tariff_variants_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query
View cURL query
View query backtrace
{
"query": {
"bool": {
"must": [
{
"bool": {
"minimum_should_match": 1
}
},
{
"bool": {
"minimum_should_match": 1,
"should": [
{
"terms": {
"ConnectionType": [
"DSL"
]
}
},
{
"terms": {
"ConnectionType": [
"Kabel"
]
}
},
{
"terms": {
"ConnectionType": [
"Glasfaser"
]
}
},
{
"terms": {
"ConnectionType": [
"LTE"
]
}
}
]
}
},
{
"terms": {
"tariffId": [
6,
17,
18,
23,
24,
25,
26,
39,
40,
45,
46,
59,
63,
74,
75,
82,
87,
88,
98,
101,
102,
105,
106,
108,
109,
110,
114,
114,
115,
115,
116,
116,
117,
117,
118,
118,
119,
119,
186,
194,
198,
199,
201,
202,
212,
213,
216,
217,
220,
221,
223,
228,
228,
229,
229,
230,
231,
233,
252,
255,
256,
264,
272,
279,
285,
291,
298,
324,
327,
330,
337
]
}
},
{
"bool": {
"must": [
{
"terms": {
"partner__top": [
true
]
}
}
]
}
}
],
"filter": [
{
"range": {
"maxAge": {
"gte": 0
}
}
},
{
"terms": {
"MinContractTime": [
24
]
}
},
{
"terms": {
"tripleplayInternet": [
true
]
}
},
{
"terms": {
"__isCurrentContract": [
true
]
}
},
{
"terms": {
"__remainingContractTime": [
1
]
}
},
{
"terms": {
"partnerId": [
1
]
}
},
{
"terms": {
"active": [
true
]
}
}
]
}
},
"aggs": {
"providers": {
"terms": {
"field": "provider",
"size": 500,
"order": {
"provider_nested>min_price": "asc"
}
},
"aggs": {
"provider_nested": {
"nested": {
"path": "tariffPrices"
},
"aggs": {
"min_price": {
"min": {
"field": "tariffPrices.price"
}
}
}
}
}
}
},
"sort": [
{
"finalMonthly": {
"order": "asc"
}
}
],
"from": 0,
"size": 10
}
curl -XPOST 'http://localhost:9200/dsl_tariff_variants_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"bool":{"minimum_should_match":1}},{"bool":{"minimum_should_match":1,"should":[{"terms":{"ConnectionType":["DSL"]}},{"terms":{"ConnectionType":["Kabel"]}},{"terms":{"ConnectionType":["Glasfaser"]}},{"terms":{"ConnectionType":["LTE"]}}]}},{"terms":{"tariffId":[6,17,18,23,24,25,26,39,40,45,46,59,63,74,75,82,87,88,98,101,102,105,106,108,109,110,114,114,115,115,116,116,117,117,118,118,119,119,186,194,198,199,201,202,212,213,216,217,220,221,223,228,228,229,229,230,231,233,252,255,256,264,272,279,285,291,298,324,327,330,337]}},{"bool":{"must":[{"terms":{"partner__top":[true]}}]}}],"filter":[{"range":{"maxAge":{"gte":0}}},{"terms":{"MinContractTime":[24]}},{"terms":{"tripleplayInternet":[true]}},{"terms":{"__isCurrentContract":[true]}},{"terms":{"__remainingContractTime":[1]}},{"terms":{"partnerId":[1]}},{"terms":{"active":[true]}}]}},"aggs":{"providers":{"terms":{"field":"provider","size":500,"order":{"provider_nested>min_price":"asc"}},"aggs":{"provider_nested":{"nested":{"path":"tariffPrices"},"aggs":{"min_price":{"min":{"field":"tariffPrices.price"}}}}}}},"sort":[{"finalMonthly":{"order":"asc"}}],"from":0,"size":10}'
#0 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /home/application/tarif-experten/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /home/application/tarif-experten/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search()
#5 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Paginator/HybridPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /home/application/tarif-experten/src/API/Provider/ElasticaFilteredProvider.php(142): FOS\ElasticaBundle\Paginator\HybridPaginatorAdapter->getResults()
#7 /home/application/tarif-experten/src/API/Provider/ElasticaFilteredProvider.php(68): App\API\Provider\ElasticaFilteredProvider->queryTop0()
#8 /home/application/tarif-experten/src/API/Command/FilterTariffsCommand.php(68): App\API\Provider\ElasticaFilteredProvider->provide()
#9 /home/application/tarif-experten/src/API/Command/AbstractCommand.php(51): App\API\Command\FilterTariffsCommand->process()
#10 /home/application/tarif-experten/src/API/Controller/Tariff/FilteredAction.php(21): App\API\Command\AbstractCommand->handle()
#11 /home/application/tarif-experten/vendor/symfony/http-kernel/HttpKernel.php(183): App\API\Controller\Tariff\FilteredAction->__invoke()
#12 /home/application/tarif-experten/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#13 /home/application/tarif-experten/vendor/symfony/http-kernel/Kernel.php(182): Symfony\Component\HttpKernel\HttpKernel->handle()
#14 /home/application/tarif-experten/public/index.php(30): Symfony\Component\HttpKernel\Kernel->handle()
#15 {main}
|
| 2 |
51.29 ms |
21.00 ms |
{"query":{"bool":{"must":[{"bool":{"minimum_should_match":1}},{"bool":{"minimum_should_match":1,"should":[{"terms":{"ConnectionType":["DSL"]}},{"terms":{"ConnectionType":["Kabel"]}},{"terms":{"ConnectionType":["Glasfaser"]}},{"terms":{"ConnectionType":["LTE"]}}]}},{"terms":{"tariffId":[6,17,18,23,24,25,26,39,40,45,46,59,63,74,75,82,87,88,98,101,102,105,106,108,109,110,114,114,115,115,116,116,117,117,118,118,119,119,186,194,198,199,201,202,212,213,216,217,220,221,223,228,228,229,229,230,231,233,252,255,256,264,272,279,285,291,298,324,327,330,337]}}],"filter":[{"range":{"maxAge":{"gte":0}}},{"terms":{"MinContractTime":[24]}},{"terms":{"tripleplayInternet":[true]}},{"terms":{"__isCurrentContract":[true]}},{"terms":{"__remainingContractTime":[1]}},{"terms":{"partnerId":[1]}},{"terms":{"active":[true]}}]}},"aggs":{"providers":{"terms":{"field":"provider","size":500,"order":{"provider_nested>min_price":"asc"}},"aggs":{"provider_nested":{"nested":{"path":"tariffPrices"},"aggs":{"min_price":{"min":{"field":"tariffPrices.price"}}}}}}},"sort":[{"finalMonthly":{"order":"asc"}}],"from":0,"size":10}
Path: dsl_tariff_variants_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 24
View formatted query
View cURL query
View query backtrace
{
"query": {
"bool": {
"must": [
{
"bool": {
"minimum_should_match": 1
}
},
{
"bool": {
"minimum_should_match": 1,
"should": [
{
"terms": {
"ConnectionType": [
"DSL"
]
}
},
{
"terms": {
"ConnectionType": [
"Kabel"
]
}
},
{
"terms": {
"ConnectionType": [
"Glasfaser"
]
}
},
{
"terms": {
"ConnectionType": [
"LTE"
]
}
}
]
}
},
{
"terms": {
"tariffId": [
6,
17,
18,
23,
24,
25,
26,
39,
40,
45,
46,
59,
63,
74,
75,
82,
87,
88,
98,
101,
102,
105,
106,
108,
109,
110,
114,
114,
115,
115,
116,
116,
117,
117,
118,
118,
119,
119,
186,
194,
198,
199,
201,
202,
212,
213,
216,
217,
220,
221,
223,
228,
228,
229,
229,
230,
231,
233,
252,
255,
256,
264,
272,
279,
285,
291,
298,
324,
327,
330,
337
]
}
}
],
"filter": [
{
"range": {
"maxAge": {
"gte": 0
}
}
},
{
"terms": {
"MinContractTime": [
24
]
}
},
{
"terms": {
"tripleplayInternet": [
true
]
}
},
{
"terms": {
"__isCurrentContract": [
true
]
}
},
{
"terms": {
"__remainingContractTime": [
1
]
}
},
{
"terms": {
"partnerId": [
1
]
}
},
{
"terms": {
"active": [
true
]
}
}
]
}
},
"aggs": {
"providers": {
"terms": {
"field": "provider",
"size": 500,
"order": {
"provider_nested>min_price": "asc"
}
},
"aggs": {
"provider_nested": {
"nested": {
"path": "tariffPrices"
},
"aggs": {
"min_price": {
"min": {
"field": "tariffPrices.price"
}
}
}
}
}
}
},
"sort": [
{
"finalMonthly": {
"order": "asc"
}
}
],
"from": 0,
"size": 10
}
curl -XPOST 'http://localhost:9200/dsl_tariff_variants_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"bool":{"minimum_should_match":1}},{"bool":{"minimum_should_match":1,"should":[{"terms":{"ConnectionType":["DSL"]}},{"terms":{"ConnectionType":["Kabel"]}},{"terms":{"ConnectionType":["Glasfaser"]}},{"terms":{"ConnectionType":["LTE"]}}]}},{"terms":{"tariffId":[6,17,18,23,24,25,26,39,40,45,46,59,63,74,75,82,87,88,98,101,102,105,106,108,109,110,114,114,115,115,116,116,117,117,118,118,119,119,186,194,198,199,201,202,212,213,216,217,220,221,223,228,228,229,229,230,231,233,252,255,256,264,272,279,285,291,298,324,327,330,337]}}],"filter":[{"range":{"maxAge":{"gte":0}}},{"terms":{"MinContractTime":[24]}},{"terms":{"tripleplayInternet":[true]}},{"terms":{"__isCurrentContract":[true]}},{"terms":{"__remainingContractTime":[1]}},{"terms":{"partnerId":[1]}},{"terms":{"active":[true]}}]}},"aggs":{"providers":{"terms":{"field":"provider","size":500,"order":{"provider_nested>min_price":"asc"}},"aggs":{"provider_nested":{"nested":{"path":"tariffPrices"},"aggs":{"min_price":{"min":{"field":"tariffPrices.price"}}}}}}},"sort":[{"finalMonthly":{"order":"asc"}}],"from":0,"size":10}'
#0 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /home/application/tarif-experten/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /home/application/tarif-experten/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search()
#5 /home/application/tarif-experten/vendor/friendsofsymfony/elastica-bundle/src/Paginator/HybridPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /home/application/tarif-experten/src/API/Provider/ElasticaFilteredProvider.php(73): FOS\ElasticaBundle\Paginator\HybridPaginatorAdapter->getResults()
#7 /home/application/tarif-experten/src/API/Command/FilterTariffsCommand.php(68): App\API\Provider\ElasticaFilteredProvider->provide()
#8 /home/application/tarif-experten/src/API/Command/AbstractCommand.php(51): App\API\Command\FilterTariffsCommand->process()
#9 /home/application/tarif-experten/src/API/Controller/Tariff/FilteredAction.php(21): App\API\Command\AbstractCommand->handle()
#10 /home/application/tarif-experten/vendor/symfony/http-kernel/HttpKernel.php(183): App\API\Controller\Tariff\FilteredAction->__invoke()
#11 /home/application/tarif-experten/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#12 /home/application/tarif-experten/vendor/symfony/http-kernel/Kernel.php(182): Symfony\Component\HttpKernel\HttpKernel->handle()
#13 /home/application/tarif-experten/public/index.php(30): Symfony\Component\HttpKernel\Kernel->handle()
#14 {main}
|