Symfony Profiler

Query Metrics

1 Database Queries

5.68 ms Execution Time

0.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

5.68 ms

0.00 ms

#▲	Execution Time	Query Time	Info
1	5.68 ms	0.00 ms	{"update":{"_id":"515","_index":"establishment_catalogue_"}} {"doc":{"id":515,"name":"Prima Center Conakry","email":"info@primaconakry.com","manager":null,"phone":"625 00 01 11","phone2":"+224 625 00 01 11","note":4,"score":2026,"ranks":3,"created_at":"2022-09-04T01:33:06+00:00","address":[{"getFullAddress":"Rails Kipe, Conakry, Guinée"}],"website":"http:\/\/www.primaconakry.com\/","description":"<div><br>12.000 m² de loisirs, de commerces et de services : hypermarché, restaurants, shoppings, banques, salle événementielle... et bien plus encore !!!<\/div><div><br>Hypermarché, restaurants, snacks, glacier, pâtisserie, café terrasse, banques, agence de voyage, pressing, laboratoire photo, prêt à porter, électroménager, papeterie, librairie, téléphonie, informatique, mobilier, magasin de décoration, luminaires, mobilier extérieur, salon d'esthétique, coiffeur, garderie, espaces dédié aux enfants... font partie des activités que le public trouvera au Prima Center Conakry !<br>Un calendrier d'évènements est aménagé afin de proposer toujours plus au public : plus de choix, plus de qualité de service, plus de loisirs !<\/div>","complement_address":null,"slug":"prima-center-conakry","enabled":true,"facebook":"https:\/\/www.facebook.com\/primaconakry","latitude":9.602587,"longitude":-13.6395122,"google_plus":null,"geoPoint":{"lat":9.602587,"lon":-13.6395122},"category":[{"id":251,"name":"centre commercial","slug":"centre-commercial"},{"id":252,"name":"boutique","slug":"boutique"}],"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": "515", "_index": "establishment_catalogue_" } } { "doc": { "id": 515, "name": "Prima Center Conakry", "email": "info@primaconakry.com", "manager": null, "phone": "625 00 01 11", "phone2": "+224 625 00 01 11", "note": 4, "score": 2026, "ranks": 3, "created_at": "2022-09-04T01:33:06+00:00", "address": [ { "getFullAddress": "Rails Kipe, Conakry, Guinée" } ], "website": "http:\/\/www.primaconakry.com\/", "description": "<div><br>12.000 m² de loisirs, de commerces et de services : hypermarché, restaurants, shoppings, banques, salle événementielle... et bien plus encore !!!<\/div><div><br>Hypermarché, restaurants, snacks, glacier, pâtisserie, café terrasse, banques, agence de voyage, pressing, laboratoire photo, prêt à porter, électroménager, papeterie, librairie, téléphonie, informatique, mobilier, magasin de décoration, luminaires, mobilier extérieur, salon d'esthétique, coiffeur, garderie, espaces dédié aux enfants... font partie des activités que le public trouvera au Prima Center Conakry !<br>Un calendrier d'évènements est aménagé afin de proposer toujours plus au public : plus de choix, plus de qualité de service, plus de loisirs !<\/div>", "complement_address": null, "slug": "prima-center-conakry", "enabled": true, "facebook": "https:\/\/www.facebook.com\/primaconakry", "latitude": 9.602587, "longitude": -13.6395122, "google_plus": null, "geoPoint": { "lat": 9.602587, "lon": -13.6395122 }, "category": [ { "id": 251, "name": "centre commercial", "slug": "centre-commercial" }, { "id": 252, "name": "boutique", "slug": "boutique" } ], "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":"515","_index":"establishment_catalogue_"}} {"doc":{"id":515,"name":"Prima Center Conakry","email":"info@primaconakry.com","manager":null,"phone":"625 00 01 11","phone2":"+224 625 00 01 11","note":4,"score":2026,"ranks":3,"created_at":"2022-09-04T01:33:06+00:00","address":[{"getFullAddress":"Rails Kipe, Conakry, Guin\u00e9e"}],"website":"http:\/\/www.primaconakry.com\/","description":"<div><br>12.000 m\u00b2 de loisirs, de commerces et de services : hypermarch\u00e9, restaurants, shoppings, banques, salle \u00e9v\u00e9nementielle... et bien plus encore !!!<\/div><div><br>Hypermarch\u00e9, restaurants, snacks, glacier, p\u00e2tisserie, caf\u00e9 terrasse, banques, agence de voyage, pressing, laboratoire photo, pr\u00eat \u00e0 porter, \u00e9lectrom\u00e9nager, papeterie, librairie, t\u00e9l\u00e9phonie, informatique, mobilier, magasin de d\u00e9coration, luminaires, mobilier ext\u00e9rieur, salon d'esth\u00e9tique, coiffeur, garderie, espaces d\u00e9di\u00e9 aux enfants... font partie des activit\u00e9s que le public trouvera au Prima Center Conakry !<br>Un calendrier d'\u00e9v\u00e8nements est am\u00e9nag\u00e9 afin de proposer toujours plus au public : plus de choix, plus de qualit\u00e9 de service, plus de loisirs !<\/div>","complement_address":null,"slug":"prima-center-conakry","enabled":true,"facebook":"https:\/\/www.facebook.com\/primaconakry","latitude":9.602587,"longitude":-13.6395122,"google_plus":null,"geoPoint":{"lat":9.602587,"lon":-13.6395122},"category":[{"id":251,"name":"centre commercial","slug":"centre-commercial"},{"id":252,"name":"boutique","slug":"boutique"}],"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":"515","_index":"establishment_catalogue_"}}

{"doc":{"id":515,"name":"Prima Center Conakry","email":"info@primaconakry.com","manager":null,"phone":"625 00 01 11","phone2":"+224 625 00 01 11","note":4,"score":2026,"ranks":3,"created_at":"2022-09-04T01:33:06+00:00","address":[{"getFullAddress":"Rails Kipe, Conakry, Guinée"}],"website":"http:\/\/www.primaconakry.com\/","description":"<div><br>12.000 m² de loisirs, de commerces et de services : hypermarché, restaurants, shoppings, banques, salle événementielle... et bien plus encore !!!<\/div><div><br>Hypermarché, restaurants, snacks, glacier, pâtisserie, café terrasse, banques, agence de voyage, pressing, laboratoire photo, prêt à porter, électroménager, papeterie, librairie, téléphonie, informatique, mobilier, magasin de décoration, luminaires, mobilier extérieur, salon d'esthétique, coiffeur, garderie, espaces dédié aux enfants... font partie des activités que le public trouvera au Prima Center Conakry !<br>Un calendrier d'évènements est aménagé afin de proposer toujours plus au public : plus de choix, plus de qualité de service, plus de loisirs !<\/div>","complement_address":null,"slug":"prima-center-conakry","enabled":true,"facebook":"https:\/\/www.facebook.com\/primaconakry","latitude":9.602587,"longitude":-13.6395122,"google_plus":null,"geoPoint":{"lat":9.602587,"lon":-13.6395122},"category":[{"id":251,"name":"centre commercial","slug":"centre-commercial"},{"id":252,"name":"boutique","slug":"boutique"}],"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": "515",
        "_index": "establishment_catalogue_"
    }
}
                                                            {
    "doc": {
        "id": 515,
        "name": "Prima Center Conakry",
        "email": "info@primaconakry.com",
        "manager": null,
        "phone": "625 00 01 11",
        "phone2": "+224 625 00 01 11",
        "note": 4,
        "score": 2026,
        "ranks": 3,
        "created_at": "2022-09-04T01:33:06+00:00",
        "address": [
            {
                "getFullAddress": "Rails Kipe, Conakry, Guinée"
            }
        ],
        "website": "http:\/\/www.primaconakry.com\/",
        "description": "<div><br>12.000 m² de loisirs, de commerces et de services : hypermarché, restaurants, shoppings, banques, salle événementielle... et bien plus encore !!!<\/div><div><br>Hypermarché, restaurants, snacks, glacier, pâtisserie, café terrasse, banques, agence de voyage, pressing, laboratoire photo, prêt à porter, électroménager, papeterie, librairie, téléphonie, informatique, mobilier, magasin de décoration, luminaires, mobilier extérieur, salon d'esthétique, coiffeur, garderie, espaces dédié aux enfants... font partie des activités que le public trouvera au Prima Center Conakry !<br>Un calendrier d'évènements est aménagé afin de proposer toujours plus au public : plus de choix, plus de qualité de service, plus de loisirs !<\/div>",
        "complement_address": null,
        "slug": "prima-center-conakry",
        "enabled": true,
        "facebook": "https:\/\/www.facebook.com\/primaconakry",
        "latitude": 9.602587,
        "longitude": -13.6395122,
        "google_plus": null,
        "geoPoint": {
            "lat": 9.602587,
            "lon": -13.6395122
        },
        "category": [
            {
                "id": 251,
                "name": "centre commercial",
                "slug": "centre-commercial"
            },
            {
                "id": 252,
                "name": "boutique",
                "slug": "boutique"
            }
        ],
        "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":"515","_index":"establishment_catalogue_"}}

{"doc":{"id":515,"name":"Prima Center Conakry","email":"info@primaconakry.com","manager":null,"phone":"625 00 01 11","phone2":"+224 625 00 01 11","note":4,"score":2026,"ranks":3,"created_at":"2022-09-04T01:33:06+00:00","address":[{"getFullAddress":"Rails Kipe, Conakry, Guin\u00e9e"}],"website":"http:\/\/www.primaconakry.com\/","description":"<div><br>12.000 m\u00b2 de loisirs, de commerces et de services : hypermarch\u00e9, restaurants, shoppings, banques, salle \u00e9v\u00e9nementielle... et bien plus encore !!!<\/div><div><br>Hypermarch\u00e9, restaurants, snacks, glacier, p\u00e2tisserie, caf\u00e9 terrasse, banques, agence de voyage, pressing, laboratoire photo, pr\u00eat \u00e0 porter, \u00e9lectrom\u00e9nager, papeterie, librairie, t\u00e9l\u00e9phonie, informatique, mobilier, magasin de d\u00e9coration, luminaires, mobilier ext\u00e9rieur, salon d'esth\u00e9tique, coiffeur, garderie, espaces d\u00e9di\u00e9 aux enfants... font partie des activit\u00e9s que le public trouvera au Prima Center Conakry !<br>Un calendrier d'\u00e9v\u00e8nements est am\u00e9nag\u00e9 afin de proposer toujours plus au public : plus de choix, plus de qualit\u00e9 de service, plus de loisirs !<\/div>","complement_address":null,"slug":"prima-center-conakry","enabled":true,"facebook":"https:\/\/www.facebook.com\/primaconakry","latitude":9.602587,"longitude":-13.6395122,"google_plus":null,"geoPoint":{"lat":9.602587,"lon":-13.6395122},"category":[{"id":251,"name":"centre commercial","slug":"centre-commercial"},{"id":252,"name":"boutique","slug":"boutique"}],"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/prima-center-conakry

Configuration Settings

Theme

Page Width

Query Metrics

Queries