Symfony Profiler

Settings

Query Metrics

8 Database Queries

37.96 ms Execution Time

8.00 ms Query Time

Queries


{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"bool":{"should":[{"terms":{"ville":["44026"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":47.3,"lon":-1.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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":"b6a065fb","types":["01-MATER","03-PRIM"],"villes":["44026"]}}}}]}
{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"bool":{"should":[{"terms":{"ville":["44026"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":47.3,"lon":-1.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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":"b6a065fb","types":["01-MATER","03-PRIM"],"villes":["44026"]}}}}]}
{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"ville":{"terms":{"field":"ville","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"filtresArray":{"terms":{"field":"filtresArray","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"lva":{"terms":{"field":"lva","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"lvb":{"terms":{"field":"lvb","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"eds":{"terms":{"field":"eds","size":1000}}}}
{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"typesInternatKeyword":{"terms":{"field":"typesInternatKeyword","size":1000}}}}

#▲	Execution Time	Query Time	Info
1	20.65 ms	2.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"bool":{"should":[{"terms":{"ville":["44026"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":47.3,"lon":-1.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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":"b6a065fb","types":["01-MATER","03-PRIM"],"villes":["44026"]}}}}]} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "bool": { "should": [ { "terms": { "ville": [ "44026" ] } }, { "bool": { "should": [ { "geo_distance": { "distance": "20km", "coordonnees": { "lat": 47.3, "lon": -1.5 } } } ], "minimum_should_match": 1 } } ], "minimum_should_match": 1 } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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": "b6a065fb", "types": [ "01-MATER", "03-PRIM" ], "villes": [ "44026" ] } } } } ] } 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":["01-MATER","03-PRIM"]}},{"bool":{"should":[{"terms":{"ville":["44026"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":47.3,"lon":-1.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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":"b6a065fb","types":["01-MATER","03-PRIM"],"villes":["44026"]}}}}]}' #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	3.63 ms	2.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"bool":{"should":[{"terms":{"ville":["44026"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":47.3,"lon":-1.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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":"b6a065fb","types":["01-MATER","03-PRIM"],"villes":["44026"]}}}}]} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace { "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "bool": { "should": [ { "terms": { "ville": [ "44026" ] } }, { "bool": { "should": [ { "geo_distance": { "distance": "20km", "coordonnees": { "lat": 47.3, "lon": -1.5 } } } ], "minimum_should_match": 1 } } ], "minimum_should_match": 1 } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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": "b6a065fb", "types": [ "01-MATER", "03-PRIM" ], "villes": [ "44026" ] } } } } ] } curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"bool":{"should":[{"terms":{"ville":["44026"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":47.3,"lon":-1.5}}}],"minimum_should_match":1}}],"minimum_should_match":1}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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":"b6a065fb","types":["01-MATER","03-PRIM"],"villes":["44026"]}}}}]}' #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}
3	4.18 ms	1.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"ville":{"terms":{"field":"ville","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "terms": { "departement": [ "44" ] } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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}
4	1.64 ms	1.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"filtresArray":{"terms":{"field":"filtresArray","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "terms": { "departement": [ "44" ] } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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}
5	0.99 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"lva":{"terms":{"field":"lva","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "terms": { "departement": [ "44" ] } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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}
6	2.16 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"lvb":{"terms":{"field":"lvb","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "terms": { "departement": [ "44" ] } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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}
7	1.16 ms	0.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"eds":{"terms":{"field":"eds","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "terms": { "departement": [ "44" ] } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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}
8	3.54 ms	2.00 ms	{"query":{"bool":{"must":[{"terms":{"type":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"size":1000,"aggs":{"typesInternatKeyword":{"terms":{"field":"typesInternatKeyword","size":1000}}}} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 0 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "terms": { "type": [ "01-MATER", "03-PRIM" ] } }, { "terms": { "departement": [ "44" ] } }, { "range": { "ageAdmission": { "lte": 2.9 } } } ] } }, "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":["01-MATER","03-PRIM"]}},{"terms":{"departement":["44"]}},{"range":{"ageAdmission":{"lte":2.9}}}]}},"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}

Symfony Profiler

http://aep-beta.onpc.fr/onglet/ecole/maternelle/carquefou-44470?age%5B0%5D=-3

Configuration Settings

Theme

Page Width

Query Metrics

Queries