Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

1.34 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.34 ms
(25.16%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.updated_at AS updated_at_6, t0.id_gwabo AS id_gwabo_7, t0.slug AS slug_8, t0.is_supended AS is_supended_9, t0.logo_boutique_id AS logo_boutique_id_10, t0.banner_boutique_id AS banner_boutique_id_11, t0.type_boutique_id AS type_boutique_id_12, t13.id AS id_14, t13.titre AS titre_15, t13.slug AS slug_16, t13.description AS description_17, t13.facebook AS facebook_18, t13.youtube AS youtube_19, t13.email AS email_20, t13.whatsapp AS whatsapp_21, t13.tiktok AS tiktok_22, t13.tel1 AS tel1_23, t13.tel2 AS tel2_24, t13.map_location AS map_location_25, t13.location_text AS location_text_26, t13.video1 AS video1_27, t13.video2 AS video2_28, t13.logo_id AS logo_id_29, t13.banniere_id AS banniere_id_30, t13.boutique_id AS boutique_id_31 FROM boutique t0 LEFT JOIN page t13 ON t13.boutique_id = t0.id WHERE t0.id = ?

Parameters:

[
  316
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.telephone AS telephone_4,
  t0.email AS email_5,
  t0.updated_at AS updated_at_6,
  t0.id_gwabo AS id_gwabo_7,
  t0.slug AS slug_8,
  t0.is_supended AS is_supended_9,
  t0.logo_boutique_id AS logo_boutique_id_10,
  t0.banner_boutique_id AS banner_boutique_id_11,
  t0.type_boutique_id AS type_boutique_id_12,
  t13.id AS id_14,
  t13.titre AS titre_15,
  t13.slug AS slug_16,
  t13.description AS description_17,
  t13.facebook AS facebook_18,
  t13.youtube AS youtube_19,
  t13.email AS email_20,
  t13.whatsapp AS whatsapp_21,
  t13.tiktok AS tiktok_22,
  t13.tel1 AS tel1_23,
  t13.tel2 AS tel2_24,
  t13.map_location AS map_location_25,
  t13.location_text AS location_text_26,
  t13.video1 AS video1_27,
  t13.video2 AS video2_28,
  t13.logo_id AS logo_id_29,
  t13.banniere_id AS banniere_id_30,
  t13.boutique_id AS boutique_id_31
FROM
  boutique t0
  LEFT JOIN page t13 ON t13.boutique_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.updated_at AS updated_at_6, t0.id_gwabo AS id_gwabo_7, t0.slug AS slug_8, t0.is_supended AS is_supended_9, t0.logo_boutique_id AS logo_boutique_id_10, t0.banner_boutique_id AS banner_boutique_id_11, t0.type_boutique_id AS type_boutique_id_12, t13.id AS id_14, t13.titre AS titre_15, t13.slug AS slug_16, t13.description AS description_17, t13.facebook AS facebook_18, t13.youtube AS youtube_19, t13.email AS email_20, t13.whatsapp AS whatsapp_21, t13.tiktok AS tiktok_22, t13.tel1 AS tel1_23, t13.tel2 AS tel2_24, t13.map_location AS map_location_25, t13.location_text AS location_text_26, t13.video1 AS video1_27, t13.video2 AS video2_28, t13.logo_id AS logo_id_29, t13.banniere_id AS banniere_id_30, t13.boutique_id AS boutique_id_31 FROM boutique t0 LEFT JOIN page t13 ON t13.boutique_id = t0.id WHERE t0.id = 316;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Boutique->__get (line 214)
8	App\Entity\Boutique->getTypeBoutique (line 1637)
9	twig_get_attribute (line 52)
10	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
19	App\Controller\PageController->myCard (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.31 ms
(22.92%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.description AS description_4, t0.facebook AS facebook_5, t0.youtube AS youtube_6, t0.email AS email_7, t0.whatsapp AS whatsapp_8, t0.tiktok AS tiktok_9, t0.tel1 AS tel1_10, t0.tel2 AS tel2_11, t0.map_location AS map_location_12, t0.location_text AS location_text_13, t0.video1 AS video1_14, t0.video2 AS video2_15, t0.logo_id AS logo_id_16, t0.banniere_id AS banniere_id_17, t0.boutique_id AS boutique_id_18 FROM page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "asec-mimosas"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.facebook AS facebook_5,
  t0.youtube AS youtube_6,
  t0.email AS email_7,
  t0.whatsapp AS whatsapp_8,
  t0.tiktok AS tiktok_9,
  t0.tel1 AS tel1_10,
  t0.tel2 AS tel2_11,
  t0.map_location AS map_location_12,
  t0.location_text AS location_text_13,
  t0.video1 AS video1_14,
  t0.video2 AS video2_15,
  t0.logo_id AS logo_id_16,
  t0.banniere_id AS banniere_id_17,
  t0.boutique_id AS boutique_id_18
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.description AS description_4, t0.facebook AS facebook_5, t0.youtube AS youtube_6, t0.email AS email_7, t0.whatsapp AS whatsapp_8, t0.tiktok AS tiktok_9, t0.tel1 AS tel1_10, t0.tel2 AS tel2_11, t0.map_location AS map_location_12, t0.location_text AS location_text_13, t0.video1 AS video1_14, t0.video2 AS video2_15, t0.logo_id AS logo_id_16, t0.banniere_id AS banniere_id_17, t0.boutique_id AS boutique_id_18 FROM page t0 WHERE t0.slug = 'asec-mimosas' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.21 ms
(15.47%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_boutique t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  type_boutique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_boutique t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\TypeBoutique->__get (line 21)
8	App\Entity\TypeBoutique->__toString (line 225)
9	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->block_header (line 171)
10	Twig\Template->displayBlock (line 176)
11	__TwigTemplate_8d4243839db0bcfccf9bd94bc411a02a->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 55)
14	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
23	App\Controller\PageController->myCard (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.18 ms
(13.18%)

SELECT t0.id AS id_1, t0.nom_reel_objet AS nom_reel_objet_2, t0.updated_at AS updated_at_3, t0.origin_name AS origin_name_4, t0.id_objet AS id_objet_5, t0.galerie_id AS galerie_id_6 FROM piece_jointe t0 WHERE t0.id = ?

Parameters:

[
  641
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_reel_objet AS nom_reel_objet_2,
  t0.updated_at AS updated_at_3,
  t0.origin_name AS origin_name_4,
  t0.id_objet AS id_objet_5,
  t0.galerie_id AS galerie_id_6
FROM
  piece_jointe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_reel_objet AS nom_reel_objet_2, t0.updated_at AS updated_at_3, t0.origin_name AS origin_name_4, t0.id_objet AS id_objet_5, t0.galerie_id AS galerie_id_6 FROM piece_jointe t0 WHERE t0.id = 641;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 111)
7	Proxies\__CG__\App\Entity\PieceJointe->__load (line 96)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromFirstField (line 121)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 60)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 35)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 28)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 77)
13	__TwigTemplate_f7c74f4aab8529ee3aa50ef71c1091e0->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 316)
16	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->block_body (line 171)
17	Twig\Template->displayBlock (line 184)
18	__TwigTemplate_8d4243839db0bcfccf9bd94bc411a02a->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 55)
21	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 40)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
30	App\Controller\PageController->myCard (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.16 ms
(12.28%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.page_id AS page_id_3 FROM galerie t0 WHERE t0.page_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.page_id AS page_id_3
FROM
  galerie t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.page_id AS page_id_3 FROM galerie t0 WHERE t0.page_id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 231)
8	__TwigTemplate_f7c74f4aab8529ee3aa50ef71c1091e0->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 316)
11	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->block_body (line 171)
12	Twig\Template->displayBlock (line 184)
13	__TwigTemplate_8d4243839db0bcfccf9bd94bc411a02a->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 55)
16	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 40)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
25	App\Controller\PageController->myCard (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.15 ms
(11.00%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.page_id AS page_id_4, t0.pj_id AS pj_id_5 FROM activite t0 WHERE t0.page_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.page_id AS page_id_4,
  t0.pj_id AS pj_id_5
FROM
  activite t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.page_id AS page_id_4, t0.pj_id AS pj_id_5 FROM activite t0 WHERE t0.page_id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 305)
8	__TwigTemplate_f7c74f4aab8529ee3aa50ef71c1091e0->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 316)
11	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->block_body (line 171)
12	Twig\Template->displayBlock (line 184)
13	__TwigTemplate_8d4243839db0bcfccf9bd94bc411a02a->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 55)
16	__TwigTemplate_a3fbab3210a66610e4919c27a45c7ab2->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 40)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 57)
25	App\Controller\PageController->myCard (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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.

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\PieceJointe	No errors.
App\Entity\Boutique	No errors.
App\Entity\Galerie	No errors.
App\Entity\Activite	No errors.
App\Entity\TypeBoutique	No errors.
App\Entity\Souscription	No errors.

Symfony Profiler

GET https://mycard.gwabo.ci/~home/asec-mimosas/card

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping