Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

15.92 ms Execution Time

5.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

9.70 ms

3.00 ms

#▲	Execution Time	Query Time	Info
1	9.70 ms	3.00 ms	{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"717af725","types":[],"villes":["59178"]}}}}]} Path: aep_etablissement/etablissement/_search Query: search_type=query_then_fetch Method: GET (Http on localhost:9200) Item count: 18 View formatted query View cURL query View query backtrace { "query": { "bool": { "must_not": [ { "terms": { "_id": [ "ET059-226" ] } } ], "must": [ { "match": { "texte": { "query": "primaire", "minimum_should_match": "75%", "fuzziness": "0.75" } } }, { "bool": { "should": [ { "terms": { "ville": [ "59178" ] } }, { "bool": { "should": [ { "geo_distance": { "distance": "20km", "coordonnees": { "lat": 50.366667, "lon": 3.066667 } } } ], "minimum_should_match": 1 } } ], "minimum_should_match": 1 } } ] } }, "size": 0, "sort": [ { "_script": { "type": "string", "order": "desc", "script": { "lang": "painless", "source": "\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ", "params": { "graine": "717af725", "types": [], "villes": [ "59178" ] } } } } ] } curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search?search_type=query_then_fetch' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n String participant =\n 'true' == doc['participant'].value ?\n '1' : '0';\n String type =\n false == Collections.disjoint(doc['type'], params.types) ?\n '1' : '0';\n String ville =\n false == Collections.disjoint(doc['ville'], params.villes) ?\n '1' : '0';\n\n return\n participant + '_' +\n type + '_' +\n ville + '_' +\n (params.graine + doc['graine'].value).hashCode();\n ","params":{"graine":"717af725","types":[],"villes":["59178"]}}}}]}' #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/FicheController.php(162): App\Elasticsearch\Moteur->cherche() #7 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FicheController->index() #8 /app/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #9 /app/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #10 /app/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle() #11 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #12 /app/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(73): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #13 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward() #14 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #15 /app/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #16 /app/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #17 /app/public/index.php(22): Symfony\Component\HttpKernel\Kernel->handle() #18 {main}
2	6.23 ms	2.00 ms	{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":8,"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":"717af725","types":[],"villes":["59178"]}}}}],"from":0} Path: aep_etablissement/etablissement/_search Query: Method: GET (Http on localhost:9200) Item count: 18 View formatted query View cURL query View query backtrace { "query": { "bool": { "must_not": [ { "terms": { "_id": [ "ET059-226" ] } } ], "must": [ { "match": { "texte": { "query": "primaire", "minimum_should_match": "75%", "fuzziness": "0.75" } } }, { "bool": { "should": [ { "terms": { "ville": [ "59178" ] } }, { "bool": { "should": [ { "geo_distance": { "distance": "20km", "coordonnees": { "lat": 50.366667, "lon": 3.066667 } } } ], "minimum_should_match": 1 } } ], "minimum_should_match": 1 } } ] } }, "size": 8, "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": "717af725", "types": [], "villes": [ "59178" ] } } } } ], "from": 0 } curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":8,"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":"717af725","types":[],"villes":["59178"]}}}}],"from":0}' #0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request() #3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search() #4 /app/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(177): Elastica\Type->search() #5 /app/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(43): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults() #6 /app/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(46): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults() #7 /app/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(117): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items() #8 /app/vendor/symfony/event-dispatcher/EventDispatcher.php(230): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke() #9 /app/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #10 /app/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(154): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #11 /app/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(93): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch() #12 /app/var/cache/dev/Container2u3tDSD/PaginatorInterface_82dac15.php(31): Knp\Component\Pager\Paginator->paginate() #13 /app/src/Elasticsearch/Moteur.php(107): Container2u3tDSD\PaginatorInterface_82dac15->paginate() #14 /app/src/Controller/FicheController.php(162): App\Elasticsearch\Moteur->cherche() #15 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FicheController->index() #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}

{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n                        String participant =\n                            'true' == doc['participant'].value ?\n                            '1' : '0';\n                        String type =\n                            false == Collections.disjoint(doc['type'], params.types) ?\n                            '1' : '0';\n                        String ville =\n                            false == Collections.disjoint(doc['ville'], params.villes) ?\n                            '1' : '0';\n\n                        return\n                            participant + '_' +\n                            type + '_' +\n                            ville + '_' +\n                            (params.graine + doc['graine'].value).hashCode();\n                    ","params":{"graine":"717af725","types":[],"villes":["59178"]}}}}]}

Path: aep_etablissement/etablissement/_search
Query: search_type=query_then_fetch
Method: GET (Http on localhost:9200)
Item count: 18
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must_not": [
                {
                    "terms": {
                        "_id": [
                            "ET059-226"
                        ]
                    }
                }
            ],
            "must": [
                {
                    "match": {
                        "texte": {
                            "query": "primaire",
                            "minimum_should_match": "75%",
                            "fuzziness": "0.75"
                        }
                    }
                },
                {
                    "bool": {
                        "should": [
                            {
                                "terms": {
                                    "ville": [
                                        "59178"
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "geo_distance": {
                                                "distance": "20km",
                                                "coordonnees": {
                                                    "lat": 50.366667,
                                                    "lon": 3.066667
                                                }
                                            }
                                        }
                                    ],
                                    "minimum_should_match": 1
                                }
                            }
                        ],
                        "minimum_should_match": 1
                    }
                }
            ]
        }
    },
    "size": 0,
    "sort": [
        {
            "_script": {
                "type": "string",
                "order": "desc",
                "script": {
                    "lang": "painless",
                    "source": "\n                        String participant =\n                            'true' == doc['participant'].value ?\n                            '1' : '0';\n                        String type =\n                            false == Collections.disjoint(doc['type'], params.types) ?\n                            '1' : '0';\n                        String ville =\n                            false == Collections.disjoint(doc['ville'], params.villes) ?\n                            '1' : '0';\n\n                        return\n                            participant + '_' +\n                            type + '_' +\n                            ville + '_' +\n                            (params.graine + doc['graine'].value).hashCode();\n                    ",
                    "params": {
                        "graine": "717af725",
                        "types": [],
                        "villes": [
                            "59178"
                        ]
                    }
                }
            }
        }
    ]
}

curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search?search_type=query_then_fetch' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":0,"sort":[{"_script":{"type":"string","order":"desc","script":{"lang":"painless","source":"\n                        String participant =\n                            'true' == doc['participant'].value ?\n                            '1' : '0';\n                        String type =\n                            false == Collections.disjoint(doc['type'], params.types) ?\n                            '1' : '0';\n                        String ville =\n                            false == Collections.disjoint(doc['ville'], params.villes) ?\n                            '1' : '0';\n\n                        return\n                            participant + '_' +\n                            type + '_' +\n                            ville + '_' +\n                            (params.graine + doc['graine'].value).hashCode();\n                    ","params":{"graine":"717af725","types":[],"villes":["59178"]}}}}]}'

#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/FicheController.php(162): App\Elasticsearch\Moteur->cherche()
#7 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FicheController->index()
#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}

6.23 ms

2.00 ms

{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":8,"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":"717af725","types":[],"villes":["59178"]}}}}],"from":0}

Path: aep_etablissement/etablissement/_search
Query:
Method: GET (Http on localhost:9200)
Item count: 18
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must_not": [
                {
                    "terms": {
                        "_id": [
                            "ET059-226"
                        ]
                    }
                }
            ],
            "must": [
                {
                    "match": {
                        "texte": {
                            "query": "primaire",
                            "minimum_should_match": "75%",
                            "fuzziness": "0.75"
                        }
                    }
                },
                {
                    "bool": {
                        "should": [
                            {
                                "terms": {
                                    "ville": [
                                        "59178"
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "geo_distance": {
                                                "distance": "20km",
                                                "coordonnees": {
                                                    "lat": 50.366667,
                                                    "lon": 3.066667
                                                }
                                            }
                                        }
                                    ],
                                    "minimum_should_match": 1
                                }
                            }
                        ],
                        "minimum_should_match": 1
                    }
                }
            ]
        }
    },
    "size": 8,
    "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": "717af725",
                        "types": [],
                        "villes": [
                            "59178"
                        ]
                    }
                }
            }
        }
    ],
    "from": 0
}

curl -XGET 'http://localhost:9200/aep_etablissement/etablissement/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must_not":[{"terms":{"_id":["ET059-226"]}}],"must":[{"match":{"texte":{"query":"primaire","minimum_should_match":"75%","fuzziness":"0.75"}}},{"bool":{"should":[{"terms":{"ville":["59178"]}},{"bool":{"should":[{"geo_distance":{"distance":"20km","coordonnees":{"lat":50.366667,"lon":3.066667}}}],"minimum_should_match":1}}],"minimum_should_match":1}}]}},"size":8,"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":"717af725","types":[],"villes":["59178"]}}}}],"from":0}'

#0 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /app/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /app/vendor/ruflin/elastica/lib/Elastica/Search.php(460): FOS\ElasticaBundle\Elastica\Client->request()
#3 /app/vendor/ruflin/elastica/lib/Elastica/Type.php(361): Elastica\Search->search()
#4 /app/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(177): Elastica\Type->search()
#5 /app/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(43): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /app/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(46): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults()
#7 /app/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(117): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items()
#8 /app/vendor/symfony/event-dispatcher/EventDispatcher.php(230): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
#9 /app/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#10 /app/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(154): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#11 /app/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(93): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
#12 /app/var/cache/dev/Container2u3tDSD/PaginatorInterface_82dac15.php(31): Knp\Component\Pager\Paginator->paginate()
#13 /app/src/Elasticsearch/Moteur.php(107): Container2u3tDSD\PaginatorInterface_82dac15->paginate()
#14 /app/src/Controller/FicheController.php(162): App\Elasticsearch\Moteur->cherche()
#15 /app/vendor/symfony/http-kernel/HttpKernel.php(163): App\Controller\FicheController->index()
#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}

Symfony Profiler

http://aep-beta.onpc.fr/fiche/ecole-elementaire-et-maternelle-privee-saint-jean-douai/ET059-226?video-id=434

Configuration Settings

Theme

Page Width

Query Metrics

Queries