| 1 |
19.46 ms |
3.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}]}
Path: aep_etablissement/etablissement/_search
Query: search_type=query_then_fetch
Method: GET (Http on localhost:9200)
Item count: 43
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search?search_type=query_then_fetch' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}]}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(488): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(377): Elastica\Search->count()
#4 /app/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(93): Elastica\Type->count()
#5 /app/src/Elasticsearch/Moteur.php(94): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getTotalHits()
#6 /app/src/Controller/AnnuaireController.php(484): App\Elasticsearch\Moteur->cherche()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#8 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#9 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#11 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#12 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#15 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#16 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#17 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#18 {main}
|
| 2 |
6.32 ms |
3.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":60,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}],"from":0}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 43
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":60,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}],"from":0}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(177): Elastica\Type->search()
#5 /app/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(43): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /app/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(46): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults()
#7 /app/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(117): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items()
#8 /app/vendor/symfony/event-dispatcher/EventDispatcher.php(230): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
#9 /app/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#10 /app/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(154): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#11 /app/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(93): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
#12 /app/var/cache/dev/Container2u3tDSD/PaginatorInterface_82dac15.php(31): Knp\Component\Pager\Paginator->paginate()
#13 /app/src/Elasticsearch/Moteur.php(107): Container2u3tDSD\PaginatorInterface_82dac15->paginate()
#14 /app/src/Controller/AnnuaireController.php(484): App\Elasticsearch\Moteur->cherche()
#15 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#16 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#17 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#18 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#19 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#20 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#21 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#22 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#23 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#24 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#25 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#26 {main}
|
| 3 |
27.21 ms |
4.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":1000,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}]}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 43
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":1000,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}]}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(121): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(546): App\Elasticsearch\Moteur->createContext()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 4 |
7.61 ms |
2.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"ville":{"terms":{"field":"ville","size":1000}}}}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 15
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"ville":{"terms":{"field":"ville","size":1000}}}}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(139): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(562): App\Elasticsearch\Moteur->getIdsVille()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 5 |
29.37 ms |
27.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"filtresArray":{"terms":{"field":"filtresArray","size":1000}}}}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 15
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"filtresArray":{"terms":{"field":"filtresArray","size":1000}}}}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(157): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(577): App\Elasticsearch\Moteur->getIdsFiltres()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 6 |
3.72 ms |
2.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"lva":{"terms":{"field":"lva","size":1000}}}}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 15
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"lva":{"terms":{"field":"lva","size":1000}}}}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(175): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(586): App\Elasticsearch\Moteur->getIdsLVx()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 7 |
2.72 ms |
1.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"lvb":{"terms":{"field":"lvb","size":1000}}}}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 15
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"lvb":{"terms":{"field":"lvb","size":1000}}}}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(175): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(588): App\Elasticsearch\Moteur->getIdsLVx()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 8 |
2.36 ms |
1.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"eds":{"terms":{"field":"eds","size":1000}}}}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 15
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"eds":{"terms":{"field":"eds","size":1000}}}}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(193): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(594): App\Elasticsearch\Moteur->getIdsEenseignementsDeSpecialite()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 9 |
3.22 ms |
1.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"typesInternatKeyword":{"terms":{"field":"typesInternatKeyword","size":1000}}}}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 15
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"departement":["95"]}}]}},"size":1000,"aggs":{"typesInternatKeyword":{"terms":{"field":"typesInternatKeyword","size":1000}}}}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(211): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(599): App\Elasticsearch\Moteur->getIdsTypesInternat()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 10 |
10.04 ms |
3.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0}
Path: aep_etablissement/etablissement/_search
Query: search_type=query_then_fetch
Method: GET (Http on localhost:9200)
Item count: 43
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search?search_type=query_then_fetch' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(488): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(377): Elastica\Search->count()
#4 /app/src/Elasticsearch/Moteur.php(223): Elastica\Type->count()
#5 /app/src/Controller/AnnuaireController.php(838): App\Elasticsearch\Moteur->count()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|
| 11 |
7.14 ms |
4.00 ms |
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":1000,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}]}
Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 43
View formatted query
View cURL query
View query backtrace
curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"bool":{"should":[{"terms":{"ville":["95351"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":49.033333,"lon":2.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":1000,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"957d685f","types":["05-LGEN","06-LTECH","07-LEGT"],"villes":["95351"]}}}}]}'
#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/src/Elasticsearch/Moteur.php(121): Elastica\Type->search()
#5 /app/src/Controller/AnnuaireController.php(868): App\Elasticsearch\Moteur->createContext()
#6 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#10 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#11 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#12 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#15 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#16 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}
|