Symfony Profiler

Query Metrics

1 Database Queries

6.17 ms Execution Time

0.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

6.17 ms

0.00 ms

#▲	Execution Time	Query Time	Info
1	6.17 ms	0.00 ms	{"update":{"_id":"830","_index":"establishment_catalogue_"}} {"doc":{"id":830,"name":"SETA MOTORS","email":"info@seta-motors.com","manager":null,"phone":"629 00 62 73","phone2":"+224 629 00 62 73","note":4.2,"score":1324,"ranks":5,"created_at":"2022-11-28T23:14:01+00:00","address":[{"getFullAddress":"MATAM\/LIDO KM9 Route du Niger Guinea, Conakry, Guinée"}],"website":"http:\/\/www.seta-motors.com\/","description":"<div>Siège social: Km 9, Route du Niger - Matam Lido<br>Matam - BP 1012<br>Conakry - Guinée<\/div><div><br><\/div><div><a href=\"tel:+224 629 00 62 73\">(+224) <strong>629 00 62 73<\/strong> <\/a>Service Commercial<\/div><div><a href=\"tel:+224 628 86 83 28\">(+224) <strong>628 86 83 28<\/strong> <\/a>Secrétariat général<\/div><div><a href=\"tel:+224 629 00 83 88\">(+224) <strong>629 00 83 88<\/strong> <\/a>Service Après-vente<\/div><div>Concessionnaire automobile des marques MITSUBISHI, MERCEDES, RENAULT VL, KIA et des produits MICHELIN en Guinée. Vente de véhicules utilitaires, véhicules touristiques, véhicules personnel et de service, camions, magasin de pièces de rechange.<\/div>","complement_address":null,"slug":"seta-motors","enabled":true,"facebook":"https:\/\/www.facebook.com\/setamotors\/","latitude":9.5518794,"longitude":-13.6528918,"google_plus":null,"geoPoint":{"lat":9.5518794,"lon":-13.6528918},"category":[{"id":34,"name":"vente de voitures","slug":"vente-de-voitures"}],"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": "830", "_index": "establishment_catalogue_" } } { "doc": { "id": 830, "name": "SETA MOTORS", "email": "info@seta-motors.com", "manager": null, "phone": "629 00 62 73", "phone2": "+224 629 00 62 73", "note": 4.2, "score": 1324, "ranks": 5, "created_at": "2022-11-28T23:14:01+00:00", "address": [ { "getFullAddress": "MATAM\/LIDO KM9 Route du Niger Guinea, Conakry, Guinée" } ], "website": "http:\/\/www.seta-motors.com\/", "description": "<div>Siège social: Km 9, Route du Niger - Matam Lido<br>Matam - BP 1012<br>Conakry - Guinée<\/div><div><br><\/div><div><a href=\"tel:+224 629 00 62 73\">(+224) <strong>629 00 62 73<\/strong> <\/a>Service Commercial<\/div><div><a href=\"tel:+224 628 86 83 28\">(+224) <strong>628 86 83 28<\/strong> <\/a>Secrétariat général<\/div><div><a href=\"tel:+224 629 00 83 88\">(+224) <strong>629 00 83 88<\/strong> <\/a>Service Après-vente<\/div><div>Concessionnaire automobile des marques MITSUBISHI, MERCEDES, RENAULT VL, KIA et des produits MICHELIN en Guinée. Vente de véhicules utilitaires, véhicules touristiques, véhicules personnel et de service, camions, magasin de pièces de rechange.<\/div>", "complement_address": null, "slug": "seta-motors", "enabled": true, "facebook": "https:\/\/www.facebook.com\/setamotors\/", "latitude": 9.5518794, "longitude": -13.6528918, "google_plus": null, "geoPoint": { "lat": 9.5518794, "lon": -13.6528918 }, "category": [ { "id": 34, "name": "vente de voitures", "slug": "vente-de-voitures" } ], "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":"830","_index":"establishment_catalogue_"}} {"doc":{"id":830,"name":"SETA MOTORS","email":"info@seta-motors.com","manager":null,"phone":"629 00 62 73","phone2":"+224 629 00 62 73","note":4.2,"score":1324,"ranks":5,"created_at":"2022-11-28T23:14:01+00:00","address":[{"getFullAddress":"MATAM\/LIDO KM9 Route du Niger Guinea, Conakry, Guin\u00e9e"}],"website":"http:\/\/www.seta-motors.com\/","description":"<div>Si\u00e8ge social: Km 9, Route du Niger - Matam Lido<br>Matam - BP 1012<br>Conakry - Guin\u00e9e<\/div><div><br><\/div><div><a href=\"tel:+224 629 00 62 73\">(+224) <strong>629 00 62 73<\/strong> <\/a>Service Commercial<\/div><div><a href=\"tel:+224 628 86 83 28\">(+224) <strong>628 86 83 28<\/strong> <\/a>Secr\u00e9tariat g\u00e9n\u00e9ral<\/div><div><a href=\"tel:+224 629 00 83 88\">(+224) <strong>629 00 83 88<\/strong> <\/a>Service Apr\u00e8s-vente<\/div><div>Concessionnaire automobile des marques MITSUBISHI, MERCEDES, RENAULT VL, KIA et des produits MICHELIN en Guin\u00e9e. Vente de v\u00e9hicules utilitaires, v\u00e9hicules touristiques, v\u00e9hicules personnel et de service, camions, magasin de pi\u00e8ces de rechange.<\/div>","complement_address":null,"slug":"seta-motors","enabled":true,"facebook":"https:\/\/www.facebook.com\/setamotors\/","latitude":9.5518794,"longitude":-13.6528918,"google_plus":null,"geoPoint":{"lat":9.5518794,"lon":-13.6528918},"category":[{"id":34,"name":"vente de voitures","slug":"vente-de-voitures"}],"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":"830","_index":"establishment_catalogue_"}}

{"doc":{"id":830,"name":"SETA MOTORS","email":"info@seta-motors.com","manager":null,"phone":"629 00 62 73","phone2":"+224 629 00 62 73","note":4.2,"score":1324,"ranks":5,"created_at":"2022-11-28T23:14:01+00:00","address":[{"getFullAddress":"MATAM\/LIDO KM9 Route du Niger Guinea, Conakry, Guinée"}],"website":"http:\/\/www.seta-motors.com\/","description":"<div>Siège social: Km 9, Route du Niger - Matam Lido<br>Matam - BP 1012<br>Conakry - Guinée<\/div><div><br><\/div><div><a href=\"tel:+224 629 00 62 73\">(+224) <strong>629 00 62 73<\/strong>&nbsp;<\/a>Service Commercial<\/div><div><a href=\"tel:+224 628 86 83 28\">(+224) <strong>628 86 83 28<\/strong>&nbsp;<\/a>Secrétariat général<\/div><div><a href=\"tel:+224 629 00 83 88\">(+224) <strong>629 00 83 88<\/strong>&nbsp;<\/a>Service Après-vente<\/div><div>Concessionnaire automobile des marques MITSUBISHI, MERCEDES, RENAULT VL, KIA et des produits MICHELIN en Guinée. Vente de véhicules utilitaires, véhicules touristiques, véhicules personnel et de service, camions, magasin de pièces de rechange.<\/div>","complement_address":null,"slug":"seta-motors","enabled":true,"facebook":"https:\/\/www.facebook.com\/setamotors\/","latitude":9.5518794,"longitude":-13.6528918,"google_plus":null,"geoPoint":{"lat":9.5518794,"lon":-13.6528918},"category":[{"id":34,"name":"vente de voitures","slug":"vente-de-voitures"}],"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": "830",
        "_index": "establishment_catalogue_"
    }
}
                                                            {
    "doc": {
        "id": 830,
        "name": "SETA MOTORS",
        "email": "info@seta-motors.com",
        "manager": null,
        "phone": "629 00 62 73",
        "phone2": "+224 629 00 62 73",
        "note": 4.2,
        "score": 1324,
        "ranks": 5,
        "created_at": "2022-11-28T23:14:01+00:00",
        "address": [
            {
                "getFullAddress": "MATAM\/LIDO KM9 Route du Niger Guinea, Conakry, Guinée"
            }
        ],
        "website": "http:\/\/www.seta-motors.com\/",
        "description": "<div>Siège social: Km 9, Route du Niger - Matam Lido<br>Matam - BP 1012<br>Conakry - Guinée<\/div><div><br><\/div><div><a href=\"tel:+224 629 00 62 73\">(+224) <strong>629 00 62 73<\/strong>&nbsp;<\/a>Service Commercial<\/div><div><a href=\"tel:+224 628 86 83 28\">(+224) <strong>628 86 83 28<\/strong>&nbsp;<\/a>Secrétariat général<\/div><div><a href=\"tel:+224 629 00 83 88\">(+224) <strong>629 00 83 88<\/strong>&nbsp;<\/a>Service Après-vente<\/div><div>Concessionnaire automobile des marques MITSUBISHI, MERCEDES, RENAULT VL, KIA et des produits MICHELIN en Guinée. Vente de véhicules utilitaires, véhicules touristiques, véhicules personnel et de service, camions, magasin de pièces de rechange.<\/div>",
        "complement_address": null,
        "slug": "seta-motors",
        "enabled": true,
        "facebook": "https:\/\/www.facebook.com\/setamotors\/",
        "latitude": 9.5518794,
        "longitude": -13.6528918,
        "google_plus": null,
        "geoPoint": {
            "lat": 9.5518794,
            "lon": -13.6528918
        },
        "category": [
            {
                "id": 34,
                "name": "vente de voitures",
                "slug": "vente-de-voitures"
            }
        ],
        "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":"830","_index":"establishment_catalogue_"}}

{"doc":{"id":830,"name":"SETA MOTORS","email":"info@seta-motors.com","manager":null,"phone":"629 00 62 73","phone2":"+224 629 00 62 73","note":4.2,"score":1324,"ranks":5,"created_at":"2022-11-28T23:14:01+00:00","address":[{"getFullAddress":"MATAM\/LIDO KM9 Route du Niger Guinea, Conakry, Guin\u00e9e"}],"website":"http:\/\/www.seta-motors.com\/","description":"<div>Si\u00e8ge social: Km 9, Route du Niger - Matam Lido<br>Matam - BP 1012<br>Conakry - Guin\u00e9e<\/div><div><br><\/div><div><a href=\"tel:+224 629 00 62 73\">(+224) <strong>629 00 62 73<\/strong>&nbsp;<\/a>Service Commercial<\/div><div><a href=\"tel:+224 628 86 83 28\">(+224) <strong>628 86 83 28<\/strong>&nbsp;<\/a>Secr\u00e9tariat g\u00e9n\u00e9ral<\/div><div><a href=\"tel:+224 629 00 83 88\">(+224) <strong>629 00 83 88<\/strong>&nbsp;<\/a>Service Apr\u00e8s-vente<\/div><div>Concessionnaire automobile des marques MITSUBISHI, MERCEDES, RENAULT VL, KIA et des produits MICHELIN en Guin\u00e9e. Vente de v\u00e9hicules utilitaires, v\u00e9hicules touristiques, v\u00e9hicules personnel et de service, camions, magasin de pi\u00e8ces de rechange.<\/div>","complement_address":null,"slug":"seta-motors","enabled":true,"facebook":"https:\/\/www.facebook.com\/setamotors\/","latitude":9.5518794,"longitude":-13.6528918,"google_plus":null,"geoPoint":{"lat":9.5518794,"lon":-13.6528918},"category":[{"id":34,"name":"vente de voitures","slug":"vente-de-voitures"}],"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/seta-motors

Configuration Settings

Theme

Page Width

Query Metrics

Queries