Symfony Profiler

Query Metrics

8 Database Queries

4 Different statements

1552.66 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1549.51 ms
(99.80%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ifu AS ifu_3, t0.rccm AS rccm_4, t0.created_at AS created_at_5, t0.presentation AS presentation_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.banniere AS banniere_9, t0.localisation AS localisation_10, t0.contact AS contact_11, t0.page_face_book AS page_face_book_12, t0.actif AS actif_13, t0.nom_contact AS nom_contact_14, t0.telephone_contact AS telephone_contact_15, t0.status AS status_16, t0.ifu_document AS ifu_document_17, t0.rccmdocument AS rccmdocument_18, t19.id AS id_20, t19.email AS email_21, t19.roles AS roles_22, t19.password AS password_23, t19.is_verified AS is_verified_24, t19.secteur_activite AS secteur_activite_25, t19.phone AS phone_26, t19.personne_acontacter AS personne_acontacter_27, t19.entreprise_id AS entreprise_id_28 FROM entreprise t0 LEFT JOIN `user` t19 ON t19.entreprise_id = t0.id WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "les-delices-du-borgou"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ifu AS ifu_3,
  t0.rccm AS rccm_4,
  t0.created_at AS created_at_5,
  t0.presentation AS presentation_6,
  t0.logo AS logo_7,
  t0.slug AS slug_8,
  t0.banniere AS banniere_9,
  t0.localisation AS localisation_10,
  t0.contact AS contact_11,
  t0.page_face_book AS page_face_book_12,
  t0.actif AS actif_13,
  t0.nom_contact AS nom_contact_14,
  t0.telephone_contact AS telephone_contact_15,
  t0.status AS status_16,
  t0.ifu_document AS ifu_document_17,
  t0.rccmdocument AS rccmdocument_18,
  t19.id AS id_20,
  t19.email AS email_21,
  t19.roles AS roles_22,
  t19.password AS password_23,
  t19.is_verified AS is_verified_24,
  t19.secteur_activite AS secteur_activite_25,
  t19.phone AS phone_26,
  t19.personne_acontacter AS personne_acontacter_27,
  t19.entreprise_id AS entreprise_id_28
FROM
  entreprise t0
  LEFT JOIN `user` t19 ON t19.entreprise_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ifu AS ifu_3, t0.rccm AS rccm_4, t0.created_at AS created_at_5, t0.presentation AS presentation_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.banniere AS banniere_9, t0.localisation AS localisation_10, t0.contact AS contact_11, t0.page_face_book AS page_face_book_12, t0.actif AS actif_13, t0.nom_contact AS nom_contact_14, t0.telephone_contact AS telephone_contact_15, t0.status AS status_16, t0.ifu_document AS ifu_document_17, t0.rccmdocument AS rccmdocument_18, t19.id AS id_20, t19.email AS email_21, t19.roles AS roles_22, t19.password AS password_23, t19.is_verified AS is_verified_24, t19.secteur_activite AS secteur_activite_25, t19.phone AS phone_26, t19.personne_acontacter AS personne_acontacter_27, t19.entreprise_id AS entreprise_id_28 FROM entreprise t0 LEFT JOIN `user` t19 ON t19.entreprise_id = t0.id WHERE t0.slug = 'les-delices-du-borgou' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.53 ms
(0.10%)

SELECT t0.id AS id_1, t0.libele AS libele_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libele AS libele_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0

SELECT t0.id AS id_1, t0.libele AS libele_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\ExposantController->index (line 58)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.94 ms
(0.06%)

SELECT t0.id AS id_1, t0.libele AS libele_2, t0.prix AS prix_3, t0.description AS description_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.vue AS vue_7, t0.categories_id AS categories_id_8, t0.entreprise_id AS entreprise_id_9 FROM produits t0 WHERE t0.entreprise_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libele AS libele_2,
  t0.prix AS prix_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.vue AS vue_7,
  t0.categories_id AS categories_id_8,
  t0.entreprise_id AS entreprise_id_9
FROM
  produits t0
WHERE
  t0.entreprise_id = ?

SELECT t0.id AS id_1, t0.libele AS libele_2, t0.prix AS prix_3, t0.description AS description_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.vue AS vue_7, t0.categories_id AS categories_id_8, t0.entreprise_id AS entreprise_id_9 FROM produits t0 WHERE t0.entreprise_id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_8df02fe647b461cbde73a39d3eaf35ad::block_body (line 417)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b6e98a4358a3e7cf096dea381e1d2ec0->doDisplay (line 434)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_8df02fe647b461cbde73a39d3eaf35ad->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\ExposantController->index (line 56)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.69 ms
(0.04%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.produits_id AS produits_id_3 FROM image t0 WHERE t0.produits_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.produits_id AS produits_id_3
FROM
  image t0
WHERE
  t0.produits_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.produits_id AS produits_id_3 FROM image t0 WHERE t0.produits_id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 108)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1698)
10	__TwigTemplate_8df02fe647b461cbde73a39d3eaf35ad::block_body (line 441)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_b6e98a4358a3e7cf096dea381e1d2ec0->doDisplay (line 434)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8df02fe647b461cbde73a39d3eaf35ad->doDisplay (line 57)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\ExposantController->index (line 56)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Category	2
App\Entity\Entreprise	1
App\Entity\User	1
App\Entity\Produits	1
App\Entity\Image	1

Entities Mapping

Class	Mapping errors
App\Entity\Entreprise	No errors.
App\Entity\User	No errors.
App\Entity\Produits	No errors.
App\Entity\Inscription	No errors.
App\Entity\Category	No errors.
App\Entity\Image	No errors.

Symfony Profiler

GET https://foire.jinukun.bj/exposant/les-delices-du-borgou

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping