Symfony Profiler

Query Metrics

12 Database Queries

6 Different statements

1.66 ms Query time

0 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.44 ms
(26.65%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.nom_en AS nom_en_4, t0.flag AS flag_5, t0.flag_url AS flag_url_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM pays t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.nom_en AS nom_en_4,
  t0.flag AS flag_5,
  t0.flag_url AS flag_url_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  pays t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.nom_en AS nom_en_4, t0.flag AS flag_5, t0.flag_url AS flag_url_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM pays t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Pays::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Pays->__get (line 153)
7	App\Entity\Pays->getNom (line 57)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_e357763aa842f7d571cf228c036d68e1::block_body (line 210)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_2185da0b13031d91b35d242dcfb4e887->doDisplay (line 165)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_e357763aa842f7d571cf228c036d68e1->doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\Public\PagesController->aPropos (line 128)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.42 ms
(25.46%)

SELECT t0.id AS id_1, t0.ville_destination AS ville_destination_2, t0.type_trafic AS type_trafic_3, t0.duree_estimee_jours AS duree_estimee_jours_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.entrepot_origine_id AS entrepot_origine_id_8, t0.pays_destination_id AS pays_destination_id_9 FROM route t0 WHERE t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ville_destination AS ville_destination_2,
  t0.type_trafic AS type_trafic_3,
  t0.duree_estimee_jours AS duree_estimee_jours_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.entrepot_origine_id AS entrepot_origine_id_8,
  t0.pays_destination_id AS pays_destination_id_9
FROM
  route t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.ville_destination AS ville_destination_2, t0.type_trafic AS type_trafic_3, t0.duree_estimee_jours AS duree_estimee_jours_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.entrepot_origine_id AS entrepot_origine_id_8, t0.pays_destination_id AS pays_destination_id_9 FROM route t0 WHERE t0.is_active = 1;

#	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	App\Controller\Public\PagesController->aPropos (line 129)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.28 ms
(17.19%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.pays_id AS pays_id_7 FROM entrepot t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ville AS ville_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.pays_id AS pays_id_7
FROM
  entrepot t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.pays_id AS pays_id_7 FROM entrepot t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Entrepot::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Entrepot->__get (line 153)
7	App\Entity\Entrepot->getVille (line 63)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_e357763aa842f7d571cf228c036d68e1::block_body (line 201)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_2185da0b13031d91b35d242dcfb4e887->doDisplay (line 165)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_e357763aa842f7d571cf228c036d68e1->doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\Public\PagesController->aPropos (line 128)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.28 ms
(16.83%)

SELECT p0_.id AS id_0, p0_.image_url AS image_url_1, p0_.message AS message_2, p0_.message_en AS message_en_3, p0_.lien AS lien_4, p0_.position AS position_5, p0_.date_debut AS date_debut_6, p0_.date_fin AS date_fin_7, p0_.is_active AS is_active_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM publicite p0_ WHERE p0_.is_active = ? AND (p0_.date_debut IS NULL OR p0_.date_debut <= ?) AND (p0_.date_fin IS NULL OR p0_.date_fin >= ?) ORDER BY p0_.position ASC

Parameters:

[
  1
  "2026-07-22 02:35:45"
  "2026-07-22 02:35:45"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.image_url AS image_url_1,
  p0_.message AS message_2,
  p0_.message_en AS message_en_3,
  p0_.lien AS lien_4,
  p0_.position AS position_5,
  p0_.date_debut AS date_debut_6,
  p0_.date_fin AS date_fin_7,
  p0_.is_active AS is_active_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10
FROM
  publicite p0_
WHERE
  p0_.is_active = ?
  AND (
    p0_.date_debut IS NULL
    OR p0_.date_debut <= ?
  )
  AND (
    p0_.date_fin IS NULL
    OR p0_.date_fin >= ?
  )
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.image_url AS image_url_1, p0_.message AS message_2, p0_.message_en AS message_en_3, p0_.lien AS lien_4, p0_.position AS position_5, p0_.date_debut AS date_debut_6, p0_.date_fin AS date_fin_7, p0_.is_active AS is_active_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM publicite p0_ WHERE p0_.is_active = 1 AND (p0_.date_debut IS NULL OR p0_.date_debut <= '2026-07-22 02:35:45') AND (p0_.date_fin IS NULL OR p0_.date_fin >= '2026-07-22 02:35:45') ORDER BY p0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PubliciteRepository->findActives (line 37)
7	App\Twig\SiteExtension->annoncesActives (line 61)
8	__TwigTemplate_86048d5cfa571d219fa9aec1accaa4de->doDisplay (line 49)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_2185da0b13031d91b35d242dcfb4e887->doDisplay (line 156)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_e357763aa842f7d571cf228c036d68e1->doDisplay (line 56)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\Public\PagesController->aPropos (line 128)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.18 ms
(10.86%)

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_utile t0 WHERE t0.cle = ? AND t0.is_active = ? LIMIT 1

Parameters:

[
  "lien_play_store"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cle AS cle_2,
  t0.valeur AS valeur_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  info_utile t0
WHERE
  t0.cle = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_utile t0 WHERE t0.cle = 'lien_play_store' AND t0.is_active = 1 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	App\Twig\SiteExtension->infoUtile (line 78)
5	__TwigTemplate_2da6cba32b2b58919687f3acecad5618->doDisplay (line 249)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_2185da0b13031d91b35d242dcfb4e887->doDisplay (line 159)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_e357763aa842f7d571cf228c036d68e1->doDisplay (line 56)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\Public\PagesController->aPropos (line 128)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.05 ms
(3.01%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.icone AS icone_4, t0.ordre_affichage AS ordre_affichage_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM reseau_social t0 ORDER BY t0.ordre_affichage ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.url AS url_3,
  t0.icone AS icone_4,
  t0.ordre_affichage AS ordre_affichage_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  reseau_social t0
ORDER BY
  t0.ordre_affichage ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.icone AS icone_4, t0.ordre_affichage AS ordre_affichage_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM reseau_social t0 ORDER BY t0.ordre_affichage ASC;

#	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	App\Twig\SiteExtension->reseauxSociaux (line 45)
5	__TwigTemplate_f17e207d0433248e6f727c1f5601fa5c->doDisplay (line 62)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_2185da0b13031d91b35d242dcfb4e887->doDisplay (line 171)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_e357763aa842f7d571cf228c036d68e1->doDisplay (line 56)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\Public\PagesController->aPropos (line 128)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	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\Route	6
App\Entity\InfoUtile	5
App\Entity\ReseauSocial	4
App\Entity\Pays	3
App\Entity\Entrepot	2

Entities Mapping

Class	Mapping errors
App\Entity\Route	No errors.
App\Entity\Entrepot	No errors.
App\Entity\Pays	No errors.
App\Entity\Publicite	No errors.
App\Entity\InfoUtile	No errors.
App\Entity\ReseauSocial	No errors.

Symfony Profiler

GET https://roicargoapi.secssarl.com/a-propos

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping