Symfony Profiler

Query Metrics

20 Database Queries

4 Different statements

7.02 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.08 ms
(43.88%)

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:

[
  575
]

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 = 575;

#	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 345)
13	__TwigTemplate_d88df635cc833aa564d362714ff2c511->block_body (line 171)
14	Twig\Template->displayBlock (line 184)
15	__TwigTemplate_8d4243839db0bcfccf9bd94bc411a02a->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 52)
18	__TwigTemplate_d88df635cc833aa564d362714ff2c511->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 40)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\PageController->indexAll (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.46 ms
(35.00%)

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:

[
  286
]

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 = 286;

#	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 377)
10	__TwigTemplate_d88df635cc833aa564d362714ff2c511->block_body (line 171)
11	Twig\Template->displayBlock (line 184)
12	__TwigTemplate_8d4243839db0bcfccf9bd94bc411a02a->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 52)
15	__TwigTemplate_d88df635cc833aa564d362714ff2c511->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
24	App\Controller\PageController->indexAll (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.84 ms
(11.96%)

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

Parameters:

[
  1
]

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 = 1;

#	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 193)
9	twig_escape_filter (line 377)
10	__TwigTemplate_d88df635cc833aa564d362714ff2c511->block_body (line 171)
11	Twig\Template->displayBlock (line 184)
12	__TwigTemplate_8d4243839db0bcfccf9bd94bc411a02a->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 52)
15	__TwigTemplate_d88df635cc833aa564d362714ff2c511->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
24	App\Controller\PageController->indexAll (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.64 ms
(9.16%)

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.facebook AS facebook_4, p0_.youtube AS youtube_5, p0_.email AS email_6, p0_.whatsapp AS whatsapp_7, p0_.tiktok AS tiktok_8, p0_.tel1 AS tel1_9, p0_.tel2 AS tel2_10, p0_.map_location AS map_location_11, p0_.location_text AS location_text_12, p0_.video1 AS video1_13, p0_.video2 AS video2_14, p0_.logo_id AS logo_id_15, p0_.banniere_id AS banniere_id_16, p0_.boutique_id AS boutique_id_17 FROM page p0_ INNER JOIN boutique b1_ ON p0_.boutique_id = b1_.id INNER JOIN type_boutique t2_ ON b1_.type_boutique_id = t2_.id WHERE t2_.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.facebook AS facebook_4,
  p0_.youtube AS youtube_5,
  p0_.email AS email_6,
  p0_.whatsapp AS whatsapp_7,
  p0_.tiktok AS tiktok_8,
  p0_.tel1 AS tel1_9,
  p0_.tel2 AS tel2_10,
  p0_.map_location AS map_location_11,
  p0_.location_text AS location_text_12,
  p0_.video1 AS video1_13,
  p0_.video2 AS video2_14,
  p0_.logo_id AS logo_id_15,
  p0_.banniere_id AS banniere_id_16,
  p0_.boutique_id AS boutique_id_17
FROM
  page p0_
  INNER JOIN boutique b1_ ON p0_.boutique_id = b1_.id
  INNER JOIN type_boutique t2_ ON b1_.type_boutique_id = t2_.id
WHERE
  t2_.id = ?

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.facebook AS facebook_4, p0_.youtube AS youtube_5, p0_.email AS email_6, p0_.whatsapp AS whatsapp_7, p0_.tiktok AS tiktok_8, p0_.tel1 AS tel1_9, p0_.tel2 AS tel2_10, p0_.map_location AS map_location_11, p0_.location_text AS location_text_12, p0_.video1 AS video1_13, p0_.video2 AS video2_14, p0_.logo_id AS logo_id_15, p0_.banniere_id AS banniere_id_16, p0_.boutique_id AS boutique_id_17 FROM page p0_ INNER JOIN boutique b1_ ON p0_.boutique_id = b1_.id INNER JOIN type_boutique t2_ ON b1_.type_boutique_id = t2_.id WHERE t2_.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 57)
7	App\Repository\PageRepository->getPagesByTypeCategorie (line 40)
8	App\Controller\PageController->indexAll (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\Boutique	No errors.
App\Entity\TypeBoutique	No errors.
App\Entity\PieceJointe	No errors.
App\Entity\Galerie	No errors.
App\Entity\Activite	No errors.
App\Entity\Souscription	No errors.

Symfony Profiler

GET https://mycard.gwabo.ci/~home/services/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping