Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.70 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.04 ms

SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.libelle AS libelle_1,
  t0_.description AS description_2,
  t0_.image AS image_3,
  t0_.courant AS courant_4,
  t0_.dirname AS dirname_5,
  t0_.color_prime AS color_prime_6,
  t0_.color_second AS color_second_7,
  t0_.color_third AS color_third_8,
  t0_.date_maj AS date_maj_9,
  t0_.text_color_prime AS text_color_prime_10,
  t0_.text_color_second AS text_color_second_11,
  t0_.color_seperateur AS color_seperateur_12
FROM
  template t0_
WHERE
  t0_.courant = ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\TemplateRepository->findActif (line 27)
8	App\Controller\Front\PageController->__construct (line 24)
9	ContainerIueNYr2\getPageControllerService::do (line 697)
10	ContainerIueNYr2\App_KernelDevDebugContainer->load (line 221)
11	Symfony\Component\DependencyInjection\Container::make (line 203)
12	Symfony\Component\DependencyInjection\Container->get (line 38)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.94 ms

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.seo_url = ? LIMIT 1

Parameters:

[
  "68b2e6f0a1210_shutterstock_2603936229.webp"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.seo_url AS seo_url_3,
  t0.seo_titre AS seo_titre_4,
  t0.seo_desc AS seo_desc_5,
  t0.titre AS titre_6,
  t0.contenu_un AS contenu_un_7,
  t0.contenu_deux AS contenu_deux_8,
  t0.date_maj AS date_maj_9,
  t0.image AS image_10,
  t0.citation AS citation_11,
  t0.image_citation AS image_citation_12,
  t0.afficher_bloc_contact AS afficher_bloc_contact_13,
  t0.nature_offre AS nature_offre_14,
  t0.type_offre AS type_offre_15,
  t0.smin_offre AS smin_offre_16,
  t0.smax_offre AS smax_offre_17,
  t0.afficher_carrousel_offre AS afficher_carrousel_offre_18,
  t0.afficher_carrousel_crit AS afficher_carrousel_crit_19,
  t0.titre_offre AS titre_offre_20,
  t0.afficher_bouton_offre AS afficher_bouton_offre_21,
  t0.libelle_bouton_offre AS libelle_bouton_offre_22,
  t0.title_bouton_offre AS title_bouton_offre_23,
  t0.url_offre AS url_offre_24,
  t0.afficher_bloc_actus AS afficher_bloc_actus_25,
  t0.og_title AS og_title_26,
  t0.og_desc AS og_desc_27,
  t0.og_image AS og_image_28,
  t0.page_mere_id AS page_mere_id_29
FROM
  pages t0
WHERE
  t0.seo_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.seo_url = '68b2e6f0a1210_shutterstock_2603936229.webp' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 45)
7	App\Controller\Front\PageController->pageContentFille (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.72 ms

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.contenu AS contenu_2, a0_.date_creation AS date_creation_3, a0_.date_maj AS date_maj_4, a0_.image AS image_5, a0_.titre_seo AS titre_seo_6, a0_.date_publication AS date_publication_7, a0_.nature_offre AS nature_offre_8, a0_.type_offre AS type_offre_9, a0_.smin_offre AS smin_offre_10, a0_.smax_offre AS smax_offre_11, a0_.afficher_carrousel_offre AS afficher_carrousel_offre_12, a0_.afficher_carrousel_crit AS afficher_carrousel_crit_13, a0_.titre_offre AS titre_offre_14, a0_.afficher_bouton_offre AS afficher_bouton_offre_15, a0_.libelle_bouton_offre AS libelle_bouton_offre_16, a0_.title_bouton_offre AS title_bouton_offre_17, a0_.url_offre AS url_offre_18, a0_.og_title AS og_title_19, a0_.og_desc AS og_desc_20, a0_.og_image AS og_image_21, a0_.seo_titre AS seo_titre_22, a0_.seo_desc AS seo_desc_23, a0_.user_id AS user_id_24, a0_.statut_id AS statut_id_25, a0_.categorie_id AS categorie_id_26, a0_.agence_id AS agence_id_27 FROM actus a0_ WHERE a0_.statut_id = ? AND a0_.date_publication < ? ORDER BY a0_.date_publication DESC LIMIT 3

Parameters:

[
  2
  "2025-11-08 12:43:14"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.contenu AS contenu_2,
  a0_.date_creation AS date_creation_3,
  a0_.date_maj AS date_maj_4,
  a0_.image AS image_5,
  a0_.titre_seo AS titre_seo_6,
  a0_.date_publication AS date_publication_7,
  a0_.nature_offre AS nature_offre_8,
  a0_.type_offre AS type_offre_9,
  a0_.smin_offre AS smin_offre_10,
  a0_.smax_offre AS smax_offre_11,
  a0_.afficher_carrousel_offre AS afficher_carrousel_offre_12,
  a0_.afficher_carrousel_crit AS afficher_carrousel_crit_13,
  a0_.titre_offre AS titre_offre_14,
  a0_.afficher_bouton_offre AS afficher_bouton_offre_15,
  a0_.libelle_bouton_offre AS libelle_bouton_offre_16,
  a0_.title_bouton_offre AS title_bouton_offre_17,
  a0_.url_offre AS url_offre_18,
  a0_.og_title AS og_title_19,
  a0_.og_desc AS og_desc_20,
  a0_.og_image AS og_image_21,
  a0_.seo_titre AS seo_titre_22,
  a0_.seo_desc AS seo_desc_23,
  a0_.user_id AS user_id_24,
  a0_.statut_id AS statut_id_25,
  a0_.categorie_id AS categorie_id_26,
  a0_.agence_id AS agence_id_27
FROM
  actus a0_
WHERE
  a0_.statut_id = ?
  AND a0_.date_publication < ?
ORDER BY
  a0_.date_publication DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.contenu AS contenu_2, a0_.date_creation AS date_creation_3, a0_.date_maj AS date_maj_4, a0_.image AS image_5, a0_.titre_seo AS titre_seo_6, a0_.date_publication AS date_publication_7, a0_.nature_offre AS nature_offre_8, a0_.type_offre AS type_offre_9, a0_.smin_offre AS smin_offre_10, a0_.smax_offre AS smax_offre_11, a0_.afficher_carrousel_offre AS afficher_carrousel_offre_12, a0_.afficher_carrousel_crit AS afficher_carrousel_crit_13, a0_.titre_offre AS titre_offre_14, a0_.afficher_bouton_offre AS afficher_bouton_offre_15, a0_.libelle_bouton_offre AS libelle_bouton_offre_16, a0_.title_bouton_offre AS title_bouton_offre_17, a0_.url_offre AS url_offre_18, a0_.og_title AS og_title_19, a0_.og_desc AS og_desc_20, a0_.og_image AS og_image_21, a0_.seo_titre AS seo_titre_22, a0_.seo_desc AS seo_desc_23, a0_.user_id AS user_id_24, a0_.statut_id AS statut_id_25, a0_.categorie_id AS categorie_id_26, a0_.agence_id AS agence_id_27 FROM actus a0_ WHERE a0_.statut_id = 2 AND a0_.date_publication < '2025-11-08 12:43:14' ORDER BY a0_.date_publication DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 86)
7	App\Repository\ActusRepository->findHome (line 46)
8	App\Controller\Front\PageController->pageContentFille (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Infos	No errors.
App\Entity\Agence	No errors.
App\Entity\ActusConfig	No errors.
App\Entity\OffresConfig	No errors.
App\Entity\OffresPhotos	No errors.
App\Entity\OffresNature	No errors.
App\Entity\OffresType	No errors.
App\Entity\Localisations	No errors.
App\Entity\Pages	The association App\Entity\Pages#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Template	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuMega	No errors.
App\Entity\Footer	No errors.
App\Entity\SecteurConfig	No errors.
App\Entity\FavorisConfig	No errors.
App\Entity\PartageConfig	No errors.
App\Entity\Maps	No errors.
App\Entity\TypeAffichage	No errors.
App\Entity\PageEquipe	The association App\Entity\PageEquipe#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Equipe	No errors.
App\Entity\Actus	The association App\Entity\Actus#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Offres	No errors.
App\Entity\User	No errors.
App\Entity\ActusStatut	No errors.
App\Entity\ActusCategorie	No errors.
App\Entity\Carriere	No errors.
App\Entity\Secteur	No errors.
App\Entity\AlerteMail	No errors.
App\Entity\MenuLink	No errors.
App\Entity\FooterLink	No errors.
App\Entity\Collaborateurs	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Surfaces	No errors.
App\Entity\Renseignements	No errors.
App\Entity\PageIndex	No errors.
App\Entity\MenuMegaDeux	No errors.
App\Entity\FooterBig	No errors.
App\Entity\Slider	No errors.
App\Entity\Config	No errors.
App\Entity\ImportType	No errors.
App\Entity\ImportConfig	No errors.
App\Entity\BlocNoResult	No errors.
App\Entity\PageImplantation	The association App\Entity\PageImplantation#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\TriConfig	No errors.
App\Entity\Content	No errors.
App\Entity\Test	No errors.
App\Entity\PageCarriere	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://preprod.evolis-ie.com/uploads/images/pages/68b2e6f0a1210_shutterstock_2603936229.webp

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping