Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.54 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.54 ms
(100.00%)

SELECT b0_.date_creation AS date_creation_0, b0_.date_maj AS date_maj_1, b0_.id AS id_2, b0_.titre AS titre_3, b0_.slug AS slug_4, b0_.contenu AS contenu_5, b0_.contenu_editeur AS contenu_editeur_6, b0_.meta_description AS meta_description_7, b0_.image AS image_8, b0_.image_alt AS image_alt_9, b0_.date_publication AS date_publication_10, b0_.publie AS publie_11, b1_.date_creation AS date_creation_12, b1_.date_maj AS date_maj_13, b1_.id AS id_14, b1_.nom AS nom_15, b1_.slug AS slug_16, b0_.categorie_id AS categorie_id_17 FROM blog_article b0_ INNER JOIN blog_categorie b1_ ON b0_.categorie_id = b1_.id WHERE b0_.publie = ? AND b0_.date_publication <= ? AND b0_.slug = ?

Parameters:

[
  1
  "2026-10-18 19:10:08"
  "reprendre-une-pharmacie-quelle-structure-juridique-choisir"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.date_creation AS date_creation_0,
  b0_.date_maj AS date_maj_1,
  b0_.id AS id_2,
  b0_.titre AS titre_3,
  b0_.slug AS slug_4,
  b0_.contenu AS contenu_5,
  b0_.contenu_editeur AS contenu_editeur_6,
  b0_.meta_description AS meta_description_7,
  b0_.image AS image_8,
  b0_.image_alt AS image_alt_9,
  b0_.date_publication AS date_publication_10,
  b0_.publie AS publie_11,
  b1_.date_creation AS date_creation_12,
  b1_.date_maj AS date_maj_13,
  b1_.id AS id_14,
  b1_.nom AS nom_15,
  b1_.slug AS slug_16,
  b0_.categorie_id AS categorie_id_17
FROM
  blog_article b0_
  INNER JOIN blog_categorie b1_ ON b0_.categorie_id = b1_.id
WHERE
  b0_.publie = ?
  AND b0_.date_publication <= ?
  AND b0_.slug = ?

SELECT b0_.date_creation AS date_creation_0, b0_.date_maj AS date_maj_1, b0_.id AS id_2, b0_.titre AS titre_3, b0_.slug AS slug_4, b0_.contenu AS contenu_5, b0_.contenu_editeur AS contenu_editeur_6, b0_.meta_description AS meta_description_7, b0_.image AS image_8, b0_.image_alt AS image_alt_9, b0_.date_publication AS date_publication_10, b0_.publie AS publie_11, b1_.date_creation AS date_creation_12, b1_.date_maj AS date_maj_13, b1_.id AS id_14, b1_.nom AS nom_15, b1_.slug AS slug_16, b0_.categorie_id AS categorie_id_17 FROM blog_article b0_ INNER JOIN blog_categorie b1_ ON b0_.categorie_id = b1_.id WHERE b0_.publie = 1 AND b0_.date_publication <= '2026-10-18 19:10:08' AND b0_.slug = 'reprendre-une-pharmacie-quelle-structure-juridique-choisir';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 21)
7	App\Repository\BlogArticleRepository->findPublishedBySlug (line 51)
8	App\Controller\BlogController->article (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\Historisation	No errors.
App\Entity\BlogArticle	No errors.
App\Entity\BlogCategorie	No errors.
App\Entity\Newsletter	No errors.
App\Entity\Offre	No errors.
App\Entity\Region	No errors.
App\Entity\Personne	No errors.
App\Entity\Vendeur	No errors.
App\Entity\PasswordToken	No errors.
App\Entity\Acheteur	No errors.
App\Entity\Courrier	No errors.
App\Entity\Actualite	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Civilite	No errors.
App\Entity\ChiffreAffaire	No errors.
App\Entity\Departement	No errors.
App\Entity\Partenaire	No errors.
App\Entity\Visite	No errors.
App\Entity\UtilisateurSite	No errors.
App\Entity\Negociateur	No errors.
App\Entity\PublipostagePersonnalise	No errors.
App\Entity\Publipostage	No errors.
App\Entity\Slider	No errors.
App\Entity\AchatEnAssociation	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Algolia\SearchBundle\Entity\Aggregator	No errors.
FOS\UserBundle\Model\User	No errors.

Symfony Profiler

GET https://cabinet-guerry.test.agence-11h10.fr/blog/reprendre-une-pharmacie-quelle-structure-juridique-choisir

Configuration Settings

Theme