Symfony Profiler

Settings

Query Metrics

16 Database Queries

233.12 ms Execution Time

97.00 ms Query Time

Queries


{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}],"from":240}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"ville":{"terms":{"field":"ville","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"filtresArray":{"terms":{"field":"filtresArray","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"lva":{"terms":{"field":"lva","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"lvb":{"terms":{"field":"lvb","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"eds":{"terms":{"field":"eds","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"typesInternatKeyword":{"terms":{"field":"typesInternatKeyword","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":0}
{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]}
{"query":{"bool":{"must":[{"terms":{"type":["04-COLL"]}},{"terms":{"region":["AUVE"]}}]}},"size":0}
{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"region":["AUVE"]}}]}},"size":0}
{"query":{"bool":{"must":[{"terms":{"type":["08-LAGRI","09-LPROF","10-LEAP"]}},{"terms":{"region":["AUVE"]}}]}},"size":0}
{"query":{"bool":{"must":[{"terms":{"type":["12-SUP"]}},{"terms":{"region":["AUVE"]}}]}},"size":0}
{"query":{"bool":{"minimum_should_match":1,"must":[{"terms":{"region":["AUVE"]}}],"should":[{"match_phrase":{"typesInternat":{"query":"01-MATER"}}},{"match_phrase":{"typesInternat":{"query":"02-ELEM"}}},{"match_phrase":{"typesInternat":{"query":"03-PRIM"}}},{"match_phrase":{"typesInternat":{"query":"04-COLL"}}},{"match_phrase":{"typesInternat":{"query":"05-LGEN"}}},{"match_phrase":{"typesInternat":{"query":"06-LTECH"}}},{"match_phrase":{"typesInternat":{"query":"07-LEGT"}}},{"match_phrase":{"typesInternat":{"query":"08-LAGRI"}}},{"match_phrase":{"typesInternat":{"query":"09-LPROF"}}},{"match_phrase":{"typesInternat":{"query":"10-LEAP"}}},{"match_phrase":{"typesInternat":{"query":"12-SUP"}}}]}},"size":0}

#▲	Execution Time	Query Time	Info
1	34.61 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "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": "0d6cc84c", "types": [ "02-ELEM", "03-PRIM", "01-MATER" ], "villes": [] } } } } ] } 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":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]}' #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	22.42 ms	2.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}],"from":240} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "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": "0d6cc84c", "types": [ "02-ELEM", "03-PRIM", "01-MATER" ], "villes": [] } } } } ], "from": 240 } curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}],"from":240}' #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	17.33 ms	10.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "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": "0d6cc84c", "types": [ "02-ELEM", "03-PRIM", "01-MATER" ], "villes": [] } } } } ] } curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]}' #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	33.37 ms	14.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"ville":{"terms":{"field":"ville","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 1000, "aggs": { "ville": { "terms": { "field": "ville", "size": 1000 } } } }` `curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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	20.35 ms	13.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"filtresArray":{"terms":{"field":"filtresArray","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 1000, "aggs": { "filtresArray": { "terms": { "field": "filtresArray", "size": 1000 } } } }` `curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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	20.36 ms	13.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"lva":{"terms":{"field":"lva","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 1000, "aggs": { "lva": { "terms": { "field": "lva", "size": 1000 } } } }` `curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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	24.89 ms	13.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"lvb":{"terms":{"field":"lvb","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 1000, "aggs": { "lvb": { "terms": { "field": "lvb", "size": 1000 } } } }` `curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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	16.87 ms	8.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"eds":{"terms":{"field":"eds","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 1000, "aggs": { "eds": { "terms": { "field": "eds", "size": 1000 } } } }` `curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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	19.37 ms	13.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":1000,"aggs":{"typesInternatKeyword":{"terms":{"field":"typesInternatKeyword","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 1000, "aggs": { "typesInternatKeyword": { "terms": { "field": "typesInternatKeyword", "size": 1000 } } } }` `curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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	0.62 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"size":0} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 0 }` `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":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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	19.51 ms	11.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 736 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "terms": { "type": [ "02-ELEM", "03-PRIM", "01-MATER" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "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": "0d6cc84c", "types": [ "02-ELEM", "03-PRIM", "01-MATER" ], "villes": [] } } } } ] } curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["02-ELEM","03-PRIM","01-MATER"]}},{"terms":{"region":["AUVE"]}}]}},"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":"0d6cc84c","types":["02-ELEM","03-PRIM","01-MATER"],"villes":[]}}}}]}' #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}
12	1.09 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["04-COLL"]}},{"terms":{"region":["AUVE"]}}]}},"size":0} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 261 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "04-COLL" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 0 }` `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":["04-COLL"]}},{"terms":{"region":["AUVE"]}}]}},"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/Twig/LibelleNiveauExtension.php(74): App\Elasticsearch\Moteur->count() #6 /app/var/cache/dev/twig/10/103b90a6a7b86f478540ca932b74d8ea9bcf1c6188c5b1f8019e9ce21365bde6.php(55): App\Twig\LibelleNiveauExtension->autresNiveaux() #7 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_0e2ee561ec1113379078a62475cc01d36c9175a97e06d4d746ebba303d3cc6e0->doDisplay() #8 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #9 /app/var/cache/dev/twig/c9/c9bd339f773227974efcab913ce239c421eb011df4611632bccab965002e4011.php(127): Twig\Template->display() #10 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_9e30a3722ec5065307dcc73334aa370ddec3f009617232595307c708e613cd57->doDisplay() #11 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #12 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(507): Twig\Template->display() #13 /app/vendor/twig/twig/src/Template.php(171): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->block_body() #14 /app/var/cache/dev/twig/ce/ce484f4ef477a0f74f775d46919493c7b89f946d005cc4126fe2b34acafe91cb.php(343): Twig\Template->displayBlock() #15 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay() #16 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #17 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(81): Twig\Template->display() #18 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->doDisplay() #19 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #20 /app/vendor/twig/twig/src/Template.php(379): Twig\Template->display() #21 /app/vendor/twig/twig/src/TemplateWrapper.php(40): Twig\Template->render() #22 /app/vendor/twig/twig/src/Environment.php(280): Twig\TemplateWrapper->render() #23 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(258): Twig\Environment->render() #24 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(266): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView() #25 /app/src/Controller/AnnuaireController.php(981): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render() #26 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste() #27 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #28 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #29 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle() #30 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #31 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #32 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward() #33 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #34 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #35 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #36 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle() #37 {main}
13	0.54 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["05-LGEN","06-LTECH","07-LEGT"]}},{"terms":{"region":["AUVE"]}}]}},"size":0} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 134 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "05-LGEN", "06-LTECH", "07-LEGT" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 0 }` `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"]}},{"terms":{"region":["AUVE"]}}]}},"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/Twig/LibelleNiveauExtension.php(74): App\Elasticsearch\Moteur->count() #6 /app/var/cache/dev/twig/10/103b90a6a7b86f478540ca932b74d8ea9bcf1c6188c5b1f8019e9ce21365bde6.php(55): App\Twig\LibelleNiveauExtension->autresNiveaux() #7 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_0e2ee561ec1113379078a62475cc01d36c9175a97e06d4d746ebba303d3cc6e0->doDisplay() #8 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #9 /app/var/cache/dev/twig/c9/c9bd339f773227974efcab913ce239c421eb011df4611632bccab965002e4011.php(127): Twig\Template->display() #10 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_9e30a3722ec5065307dcc73334aa370ddec3f009617232595307c708e613cd57->doDisplay() #11 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #12 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(507): Twig\Template->display() #13 /app/vendor/twig/twig/src/Template.php(171): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->block_body() #14 /app/var/cache/dev/twig/ce/ce484f4ef477a0f74f775d46919493c7b89f946d005cc4126fe2b34acafe91cb.php(343): Twig\Template->displayBlock() #15 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay() #16 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #17 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(81): Twig\Template->display() #18 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->doDisplay() #19 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #20 /app/vendor/twig/twig/src/Template.php(379): Twig\Template->display() #21 /app/vendor/twig/twig/src/TemplateWrapper.php(40): Twig\Template->render() #22 /app/vendor/twig/twig/src/Environment.php(280): Twig\TemplateWrapper->render() #23 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(258): Twig\Environment->render() #24 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(266): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView() #25 /app/src/Controller/AnnuaireController.php(981): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render() #26 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste() #27 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #28 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #29 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle() #30 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #31 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #32 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward() #33 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #34 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #35 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #36 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle() #37 {main}
14	0.62 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["08-LAGRI","09-LPROF","10-LEAP"]}},{"terms":{"region":["AUVE"]}}]}},"size":0} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 251 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "08-LAGRI", "09-LPROF", "10-LEAP" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 0 }` `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":["08-LAGRI","09-LPROF","10-LEAP"]}},{"terms":{"region":["AUVE"]}}]}},"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/Twig/LibelleNiveauExtension.php(74): App\Elasticsearch\Moteur->count() #6 /app/var/cache/dev/twig/10/103b90a6a7b86f478540ca932b74d8ea9bcf1c6188c5b1f8019e9ce21365bde6.php(55): App\Twig\LibelleNiveauExtension->autresNiveaux() #7 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_0e2ee561ec1113379078a62475cc01d36c9175a97e06d4d746ebba303d3cc6e0->doDisplay() #8 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #9 /app/var/cache/dev/twig/c9/c9bd339f773227974efcab913ce239c421eb011df4611632bccab965002e4011.php(127): Twig\Template->display() #10 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_9e30a3722ec5065307dcc73334aa370ddec3f009617232595307c708e613cd57->doDisplay() #11 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #12 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(507): Twig\Template->display() #13 /app/vendor/twig/twig/src/Template.php(171): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->block_body() #14 /app/var/cache/dev/twig/ce/ce484f4ef477a0f74f775d46919493c7b89f946d005cc4126fe2b34acafe91cb.php(343): Twig\Template->displayBlock() #15 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay() #16 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #17 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(81): Twig\Template->display() #18 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->doDisplay() #19 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #20 /app/vendor/twig/twig/src/Template.php(379): Twig\Template->display() #21 /app/vendor/twig/twig/src/TemplateWrapper.php(40): Twig\Template->render() #22 /app/vendor/twig/twig/src/Environment.php(280): Twig\TemplateWrapper->render() #23 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(258): Twig\Environment->render() #24 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(266): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView() #25 /app/src/Controller/AnnuaireController.php(981): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render() #26 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste() #27 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #28 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #29 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle() #30 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #31 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #32 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward() #33 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #34 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #35 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #36 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle() #37 {main}
15	0.49 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["12-SUP"]}},{"terms":{"region":["AUVE"]}}]}},"size":0} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 295 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "12-SUP" ] } }, { "terms": { "region": [ "AUVE" ] } } ] } }, "size": 0 }` `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":["12-SUP"]}},{"terms":{"region":["AUVE"]}}]}},"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/Twig/LibelleNiveauExtension.php(74): App\Elasticsearch\Moteur->count() #6 /app/var/cache/dev/twig/10/103b90a6a7b86f478540ca932b74d8ea9bcf1c6188c5b1f8019e9ce21365bde6.php(55): App\Twig\LibelleNiveauExtension->autresNiveaux() #7 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_0e2ee561ec1113379078a62475cc01d36c9175a97e06d4d746ebba303d3cc6e0->doDisplay() #8 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #9 /app/var/cache/dev/twig/c9/c9bd339f773227974efcab913ce239c421eb011df4611632bccab965002e4011.php(127): Twig\Template->display() #10 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_9e30a3722ec5065307dcc73334aa370ddec3f009617232595307c708e613cd57->doDisplay() #11 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #12 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(507): Twig\Template->display() #13 /app/vendor/twig/twig/src/Template.php(171): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->block_body() #14 /app/var/cache/dev/twig/ce/ce484f4ef477a0f74f775d46919493c7b89f946d005cc4126fe2b34acafe91cb.php(343): Twig\Template->displayBlock() #15 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay() #16 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #17 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(81): Twig\Template->display() #18 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->doDisplay() #19 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #20 /app/vendor/twig/twig/src/Template.php(379): Twig\Template->display() #21 /app/vendor/twig/twig/src/TemplateWrapper.php(40): Twig\Template->render() #22 /app/vendor/twig/twig/src/Environment.php(280): Twig\TemplateWrapper->render() #23 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(258): Twig\Environment->render() #24 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(266): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView() #25 /app/src/Controller/AnnuaireController.php(981): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render() #26 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste() #27 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #28 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #29 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle() #30 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #31 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #32 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward() #33 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #34 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #35 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #36 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle() #37 {main}
16	0.69 ms	0.00 ms	{"query":{"bool":{"minimum_should_match":1,"must":[{"terms":{"region":["AUVE"]}}],"should":[{"match_phrase":{"typesInternat":{"query":"01-MATER"}}},{"match_phrase":{"typesInternat":{"query":"02-ELEM"}}},{"match_phrase":{"typesInternat":{"query":"03-PRIM"}}},{"match_phrase":{"typesInternat":{"query":"04-COLL"}}},{"match_phrase":{"typesInternat":{"query":"05-LGEN"}}},{"match_phrase":{"typesInternat":{"query":"06-LTECH"}}},{"match_phrase":{"typesInternat":{"query":"07-LEGT"}}},{"match_phrase":{"typesInternat":{"query":"08-LAGRI"}}},{"match_phrase":{"typesInternat":{"query":"09-LPROF"}}},{"match_phrase":{"typesInternat":{"query":"10-LEAP"}}},{"match_phrase":{"typesInternat":{"query":"12-SUP"}}}]}},"size":0} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 76 View formatted query View cURL query View query backtrace { "query": { "bool": { "minimum_should_match": 1, "must": [ { "terms": { "region": [ "AUVE" ] } } ], "should": [ { "match_phrase": { "typesInternat": { "query": "01-MATER" } } }, { "match_phrase": { "typesInternat": { "query": "02-ELEM" } } }, { "match_phrase": { "typesInternat": { "query": "03-PRIM" } } }, { "match_phrase": { "typesInternat": { "query": "04-COLL" } } }, { "match_phrase": { "typesInternat": { "query": "05-LGEN" } } }, { "match_phrase": { "typesInternat": { "query": "06-LTECH" } } }, { "match_phrase": { "typesInternat": { "query": "07-LEGT" } } }, { "match_phrase": { "typesInternat": { "query": "08-LAGRI" } } }, { "match_phrase": { "typesInternat": { "query": "09-LPROF" } } }, { "match_phrase": { "typesInternat": { "query": "10-LEAP" } } }, { "match_phrase": { "typesInternat": { "query": "12-SUP" } } } ] } }, "size": 0 } curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search?search_type=query_then_fetch' -H 'Content-Type: application/json' -d '{"query":{"bool":{"minimum_should_match":1,"must":[{"terms":{"region":["AUVE"]}}],"should":[{"match_phrase":{"typesInternat":{"query":"01-MATER"}}},{"match_phrase":{"typesInternat":{"query":"02-ELEM"}}},{"match_phrase":{"typesInternat":{"query":"03-PRIM"}}},{"match_phrase":{"typesInternat":{"query":"04-COLL"}}},{"match_phrase":{"typesInternat":{"query":"05-LGEN"}}},{"match_phrase":{"typesInternat":{"query":"06-LTECH"}}},{"match_phrase":{"typesInternat":{"query":"07-LEGT"}}},{"match_phrase":{"typesInternat":{"query":"08-LAGRI"}}},{"match_phrase":{"typesInternat":{"query":"09-LPROF"}}},{"match_phrase":{"typesInternat":{"query":"10-LEAP"}}},{"match_phrase":{"typesInternat":{"query":"12-SUP"}}}]}},"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/Twig/LibelleNiveauExtension.php(74): App\Elasticsearch\Moteur->count() #6 /app/var/cache/dev/twig/10/103b90a6a7b86f478540ca932b74d8ea9bcf1c6188c5b1f8019e9ce21365bde6.php(55): App\Twig\LibelleNiveauExtension->autresNiveaux() #7 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_0e2ee561ec1113379078a62475cc01d36c9175a97e06d4d746ebba303d3cc6e0->doDisplay() #8 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #9 /app/var/cache/dev/twig/c9/c9bd339f773227974efcab913ce239c421eb011df4611632bccab965002e4011.php(127): Twig\Template->display() #10 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_9e30a3722ec5065307dcc73334aa370ddec3f009617232595307c708e613cd57->doDisplay() #11 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #12 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(507): Twig\Template->display() #13 /app/vendor/twig/twig/src/Template.php(171): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->block_body() #14 /app/var/cache/dev/twig/ce/ce484f4ef477a0f74f775d46919493c7b89f946d005cc4126fe2b34acafe91cb.php(343): Twig\Template->displayBlock() #15 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay() #16 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #17 /app/var/cache/dev/twig/dc/dc2cfa3f9b9174daf1393c837b6d2ec26c64555444c3594668c8874483884691.php(81): Twig\Template->display() #18 /app/vendor/twig/twig/src/Template.php(394): __TwigTemplate_611c959658fa6200314047b75bc1ba02d9939ddf1b08fe26ad5e92f14df5f569->doDisplay() #19 /app/vendor/twig/twig/src/Template.php(367): Twig\Template->displayWithErrorHandling() #20 /app/vendor/twig/twig/src/Template.php(379): Twig\Template->display() #21 /app/vendor/twig/twig/src/TemplateWrapper.php(40): Twig\Template->render() #22 /app/vendor/twig/twig/src/Environment.php(280): Twig\TemplateWrapper->render() #23 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(258): Twig\Environment->render() #24 /app/vendor/symfony/framework-bundle/Controller/AbstractController.php(266): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView() #25 /app/src/Controller/AnnuaireController.php(981): Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render() #26 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\AnnuaireController->liste() #27 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #28 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #29 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle() #30 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #31 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #32 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward() #33 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #34 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #35 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #36 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle() #37 {main}

Symfony Profiler

http://aep-beta.onpc.fr/onglet/ecole/auvergne-rhone-alpes?page=5

Configuration Settings

Theme

Page Width

Query Metrics

Queries