Symfony Profiler

Query Metrics

1 Database Queries

6.43 ms Execution Time

0.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

6.43 ms

0.00 ms

#▲	Execution Time	Query Time	Info
1	6.43 ms	0.00 ms	{"update":{"_id":"4","_index":"establishment_catalogue_"}} {"doc":{"id":4,"name":"Aéroport Ahmed Sékou Touré","email":null,"manager":null,"phone":"629 00 52 59","phone2":"+224 629 00 52 59","note":3.7,"score":900,"ranks":2,"created_at":"2022-07-17T05:24:51+00:00","address":[{"getFullAddress":"Gbessia, Guinée"}],"website":"https:\/\/aeroportdeconakry.com\/","description":"Situé dans la localité de G’Bessia à 13 kilomètres du centre ville, l’Aéroport International de Conakry a été construit en 1945.Il est le principal aéroport de la République de Guinée.\r\nDes transformations successives lui ont permis de suivre l’évolution du traficet d’accueillir aujourd’hui tous les types d’avions jusqu’aux gros porteurs du type B 747-400.","complement_address":null,"slug":"aeroport-ahmed-sekou-toure","enabled":true,"facebook":null,"latitude":9.5754717,"longitude":-13.6198829,"google_plus":null,"geoPoint":{"lat":9.5754717,"lon":-13.6198829},"category":[{"id":109,"name":"aéroports","slug":"aeroports"},{"id":521,"name":"transport aérien","slug":"transport-aerien"}],"region":null,"sub_prefecture":null},"doc_as_upsert":true} Path: _bulk Query: Method: POST (Http on 127.0.0.1:9200) Item count: 0 View formatted query View cURL query View query backtrace { "update": { "_id": "4", "_index": "establishment_catalogue_" } } { "doc": { "id": 4, "name": "Aéroport Ahmed Sékou Touré", "email": null, "manager": null, "phone": "629 00 52 59", "phone2": "+224 629 00 52 59", "note": 3.7, "score": 900, "ranks": 2, "created_at": "2022-07-17T05:24:51+00:00", "address": [ { "getFullAddress": "Gbessia, Guinée" } ], "website": "https:\/\/aeroportdeconakry.com\/", "description": "Situé dans la localité de G’Bessia à 13 kilomètres du centre ville, l’Aéroport International de Conakry a été construit en 1945.Il est le principal aéroport de la République de Guinée.\r\nDes transformations successives lui ont permis de suivre l’évolution du traficet d’accueillir aujourd’hui tous les types d’avions jusqu’aux gros porteurs du type B 747-400.", "complement_address": null, "slug": "aeroport-ahmed-sekou-toure", "enabled": true, "facebook": null, "latitude": 9.5754717, "longitude": -13.6198829, "google_plus": null, "geoPoint": { "lat": 9.5754717, "lon": -13.6198829 }, "category": [ { "id": 109, "name": "aéroports", "slug": "aeroports" }, { "id": 521, "name": "transport aérien", "slug": "transport-aerien" } ], "region": null, "sub_prefecture": null }, "doc_as_upsert": true } curl -XPOST 'http://127.0.0.1:9200/_bulk' -H 'Content-Type: application/json' --data-binary '{"update":{"_id":"4","_index":"establishment_catalogue_"}} {"doc":{"id":4,"name":"A\u00e9roport Ahmed S\u00e9kou Tour\u00e9","email":null,"manager":null,"phone":"629 00 52 59","phone2":"+224 629 00 52 59","note":3.7,"score":900,"ranks":2,"created_at":"2022-07-17T05:24:51+00:00","address":[{"getFullAddress":"Gbessia, Guin\u00e9e"}],"website":"https:\/\/aeroportdeconakry.com\/","description":"Situ\u00e9 dans la localit\u00e9 de G\u2019Bessia \u00e0 13 kilom\u00e8tres du centre ville, l\u2019A\u00e9roport International de Conakry a \u00e9t\u00e9 construit en 1945.Il est le principal a\u00e9roport de la R\u00e9publique de Guin\u00e9e.\r\nDes transformations successives lui ont permis de suivre l\u2019\u00e9volution du traficet d\u2019accueillir aujourd\u2019hui tous les types d\u2019avions jusqu\u2019aux gros porteurs du type B 747-400.","complement_address":null,"slug":"aeroport-ahmed-sekou-toure","enabled":true,"facebook":null,"latitude":9.5754717,"longitude":-13.6198829,"google_plus":null,"geoPoint":{"lat":9.5754717,"lon":-13.6198829},"category":[{"id":109,"name":"a\u00e9roports","slug":"aeroports"},{"id":521,"name":"transport a\u00e9rien","slug":"transport-aerien"}],"region":null,"sub_prefecture":null},"doc_as_upsert":true} ' #0 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(135): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(79): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Bulk.php(306): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Client.php(230): Elastica\Bulk->send() #4 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Index.php(175): Elastica\Client->updateDocuments() #5 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Persister/ObjectPersister.php(151): Elastica\Index->updateDocuments() #6 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(180): FOS\ElasticaBundle\Persister\ObjectPersister->replaceMany() #7 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(155): FOS\ElasticaBundle\Doctrine\Listener->persistScheduled() #8 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php(63): FOS\ElasticaBundle\Doctrine\Listener->postFlush() #9 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/doctrine/orm/src/UnitOfWork.php(3133): Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent() #10 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/doctrine/orm/src/UnitOfWork.php(465): Doctrine\ORM\UnitOfWork->dispatchPostFlushEvent() #11 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/doctrine/orm/src/EntityManager.php(259): Doctrine\ORM\UnitOfWork->commit() #12 /var/www/catalogue/guinee_catalogue/app/symfony/src/Controller/EstablishmentController.php(108): Doctrine\ORM\EntityManager->flush() #13 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\EstablishmentController->single() #14 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #15 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #16 /var/www/catalogue/guinee_catalogue/app/symfony/public/index.php(23): Symfony\Component\HttpKernel\Kernel->handle() #17 {main}

{"update":{"_id":"4","_index":"establishment_catalogue_"}}

{"doc":{"id":4,"name":"Aéroport Ahmed Sékou Touré","email":null,"manager":null,"phone":"629 00 52 59","phone2":"+224 629 00 52 59","note":3.7,"score":900,"ranks":2,"created_at":"2022-07-17T05:24:51+00:00","address":[{"getFullAddress":"Gbessia, Guinée"}],"website":"https:\/\/aeroportdeconakry.com\/","description":"Situé dans la localité de G’Bessia à 13 kilomètres du centre ville, l’Aéroport International de Conakry a été construit en 1945.Il est le principal aéroport de la République de Guinée.\r\nDes transformations successives lui ont permis de suivre l’évolution du traficet d’accueillir aujourd’hui tous les types d’avions jusqu’aux gros porteurs du type B 747-400.","complement_address":null,"slug":"aeroport-ahmed-sekou-toure","enabled":true,"facebook":null,"latitude":9.5754717,"longitude":-13.6198829,"google_plus":null,"geoPoint":{"lat":9.5754717,"lon":-13.6198829},"category":[{"id":109,"name":"aéroports","slug":"aeroports"},{"id":521,"name":"transport aérien","slug":"transport-aerien"}],"region":null,"sub_prefecture":null},"doc_as_upsert":true}

Path: _bulk
Query:
Method: POST (Http on 127.0.0.1:9200)
Item count: 0
View formatted query View cURL query View query backtrace


                                                            {
    "update": {
        "_id": "4",
        "_index": "establishment_catalogue_"
    }
}
                                                            {
    "doc": {
        "id": 4,
        "name": "Aéroport Ahmed Sékou Touré",
        "email": null,
        "manager": null,
        "phone": "629 00 52 59",
        "phone2": "+224 629 00 52 59",
        "note": 3.7,
        "score": 900,
        "ranks": 2,
        "created_at": "2022-07-17T05:24:51+00:00",
        "address": [
            {
                "getFullAddress": "Gbessia, Guinée"
            }
        ],
        "website": "https:\/\/aeroportdeconakry.com\/",
        "description": "Situé dans la localité de G’Bessia à 13 kilomètres du centre ville, l’Aéroport International de Conakry a été construit en 1945.Il est le principal aéroport de la République de Guinée.\r\nDes transformations successives lui ont permis de suivre l’évolution du traficet d’accueillir aujourd’hui tous les types d’avions jusqu’aux gros porteurs du type B 747-400.",
        "complement_address": null,
        "slug": "aeroport-ahmed-sekou-toure",
        "enabled": true,
        "facebook": null,
        "latitude": 9.5754717,
        "longitude": -13.6198829,
        "google_plus": null,
        "geoPoint": {
            "lat": 9.5754717,
            "lon": -13.6198829
        },
        "category": [
            {
                "id": 109,
                "name": "aéroports",
                "slug": "aeroports"
            },
            {
                "id": 521,
                "name": "transport aérien",
                "slug": "transport-aerien"
            }
        ],
        "region": null,
        "sub_prefecture": null
    },
    "doc_as_upsert": true
}

curl -XPOST 'http://127.0.0.1:9200/_bulk' -H 'Content-Type: application/json' --data-binary '{"update":{"_id":"4","_index":"establishment_catalogue_"}}

{"doc":{"id":4,"name":"A\u00e9roport Ahmed S\u00e9kou Tour\u00e9","email":null,"manager":null,"phone":"629 00 52 59","phone2":"+224 629 00 52 59","note":3.7,"score":900,"ranks":2,"created_at":"2022-07-17T05:24:51+00:00","address":[{"getFullAddress":"Gbessia, Guin\u00e9e"}],"website":"https:\/\/aeroportdeconakry.com\/","description":"Situ\u00e9 dans la localit\u00e9 de G\u2019Bessia \u00e0 13 kilom\u00e8tres du centre ville, l\u2019A\u00e9roport International de Conakry a \u00e9t\u00e9 construit en 1945.Il est le principal a\u00e9roport de la R\u00e9publique de Guin\u00e9e.\r\nDes transformations successives lui ont permis de suivre l\u2019\u00e9volution du traficet d\u2019accueillir aujourd\u2019hui tous les types d\u2019avions jusqu\u2019aux gros porteurs du type B 747-400.","complement_address":null,"slug":"aeroport-ahmed-sekou-toure","enabled":true,"facebook":null,"latitude":9.5754717,"longitude":-13.6198829,"google_plus":null,"geoPoint":{"lat":9.5754717,"lon":-13.6198829},"category":[{"id":109,"name":"a\u00e9roports","slug":"aeroports"},{"id":521,"name":"transport a\u00e9rien","slug":"transport-aerien"}],"region":null,"sub_prefecture":null},"doc_as_upsert":true}

'

#0 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(135): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(79): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Bulk.php(306): FOS\ElasticaBundle\Elastica\Client->request()
#3 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Client.php(230): Elastica\Bulk->send()
#4 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Index.php(175): Elastica\Client->updateDocuments()
#5 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Persister/ObjectPersister.php(151): Elastica\Index->updateDocuments()
#6 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(180): FOS\ElasticaBundle\Persister\ObjectPersister->replaceMany()
#7 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(155): FOS\ElasticaBundle\Doctrine\Listener->persistScheduled()
#8 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php(63): FOS\ElasticaBundle\Doctrine\Listener->postFlush()
#9 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/doctrine/orm/src/UnitOfWork.php(3133): Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent()
#10 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/doctrine/orm/src/UnitOfWork.php(465): Doctrine\ORM\UnitOfWork->dispatchPostFlushEvent()
#11 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/doctrine/orm/src/EntityManager.php(259): Doctrine\ORM\UnitOfWork->commit()
#12 /var/www/catalogue/guinee_catalogue/app/symfony/src/Controller/EstablishmentController.php(108): Doctrine\ORM\EntityManager->flush()
#13 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\EstablishmentController->single()
#14 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#15 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#16 /var/www/catalogue/guinee_catalogue/app/symfony/public/index.php(23): Symfony\Component\HttpKernel\Kernel->handle()
#17 {main}

Symfony Profiler

GET http://193.70.3.237/index.php/establishment/aeroport-ahmed-sekou-toure

Configuration Settings

Theme

Page Width

Query Metrics

Queries