Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.63 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.73 ms
(44.54%)

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 32)
8	App\Controller\Front\ImplantationsController->__construct (line 24)
9	ContainerIueNYr2\getImplantationsControllerService::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.48 ms
(29.35%)

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.secteur AS secteur_6, t0.picto AS picto_7, t0.date_maj AS date_maj_8, t0.email AS email_9, t0.tel AS tel_10, t0.ordre AS ordre_11, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "grenoble"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.societe AS societe_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.ville AS ville_5,
  t0.secteur AS secteur_6,
  t0.picto AS picto_7,
  t0.date_maj AS date_maj_8,
  t0.email AS email_9,
  t0.tel AS tel_10,
  t0.ordre AS ordre_11,
  t0.presentation AS presentation_12,
  t0.logiciel_type AS logiciel_type_13,
  t0.logiciel_id AS logiciel_id_14,
  t0.email_demande AS email_demande_15,
  t0.slug AS slug_16,
  t0.titre AS titre_17,
  t0.image AS image_18,
  t0.title AS title_19,
  t0.meta_desc AS meta_desc_20,
  t0.titre_og AS titre_og_21,
  t0.desc_og AS desc_og_22,
  t0.image_og AS image_og_23,
  t0.calendy AS calendy_24
FROM
  agence t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.secteur AS secteur_6, t0.picto AS picto_7, t0.date_maj AS date_maj_8, t0.email AS email_9, t0.tel AS tel_10, t0.ordre AS ordre_11, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 WHERE t0.slug = 'grenoble' 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 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 77)
5	App\Controller\Front\ImplantationsController->agenceDetails (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.43 ms
(26.11%)

SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.afficher_actus_similaires AS afficher_actus_similaires_5, t0.url_liste AS url_liste_6, t0.url_detail AS url_detail_7, t0.h1_liste AS h1_liste_8, t0.afficher_bloc_contact AS afficher_bloc_contact_9, t0.titre_actu_similaire AS titre_actu_similaire_10, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11, t0.seo_title AS seo_title_12, t0.seo_desc AS seo_desc_13, t0.image_bg AS image_bg_14, t0.date_maj AS date_maj_15 FROM actus_config t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nb_lignes AS nb_lignes_2,
  t0.libelle AS libelle_3,
  t0.afficher_pagination AS afficher_pagination_4,
  t0.afficher_actus_similaires AS afficher_actus_similaires_5,
  t0.url_liste AS url_liste_6,
  t0.url_detail AS url_detail_7,
  t0.h1_liste AS h1_liste_8,
  t0.afficher_bloc_contact AS afficher_bloc_contact_9,
  t0.titre_actu_similaire AS titre_actu_similaire_10,
  t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11,
  t0.seo_title AS seo_title_12,
  t0.seo_desc AS seo_desc_13,
  t0.image_bg AS image_bg_14,
  t0.date_maj AS date_maj_15
FROM
  actus_config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.afficher_actus_similaires AS afficher_actus_similaires_5, t0.url_liste AS url_liste_6, t0.url_detail AS url_detail_7, t0.h1_liste AS h1_liste_8, t0.afficher_bloc_contact AS afficher_bloc_contact_9, t0.titre_actu_similaire AS titre_actu_similaire_10, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11, t0.seo_title AS seo_title_12, t0.seo_desc AS seo_desc_13, t0.image_bg AS image_bg_14, t0.date_maj AS date_maj_15 FROM actus_config t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 33)
7	App\Controller\Front\ImplantationsController->__construct (line 24)
8	ContainerIueNYr2\getImplantationsControllerService::do (line 697)
9	ContainerIueNYr2\App_KernelDevDebugContainer->load (line 221)
10	Symfony\Component\DependencyInjection\Container::make (line 203)
11	Symfony\Component\DependencyInjection\Container->get (line 38)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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\Actus	The association App\Entity\Actus#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\ActusCategorie	No errors.
App\Entity\Offres	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\Secteur	No errors.
App\Entity\Carriere	No errors.

Symfony Profiler

GET https://preprod.evolis-ie.com/agences/grenoble/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping