Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.02 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.33 ms

SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5 FROM blog_categorie t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "actualites"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date_creation AS date_creation_1,
  t0.date_maj AS date_maj_2,
  t0.id AS id_3,
  t0.nom AS nom_4,
  t0.slug AS slug_5
FROM
  blog_categorie t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5 FROM blog_categorie t0 WHERE t0.slug = 'actualites' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 30)
4	App\Controller\BlogController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.37 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (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 FROM blog_article b0_ INNER JOIN blog_categorie b1_ ON b0_.categorie_id = b1_.id WHERE b0_.publie = ? AND b0_.date_publication <= ? AND b0_.categorie_id = ? ORDER BY b0_.date_publication DESC, b0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  1
  "2026-10-18 19:07:54"
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_2
    FROM
      (
        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
        FROM
          blog_article b0_
          INNER JOIN blog_categorie b1_ ON b0_.categorie_id = b1_.id
        WHERE
          b0_.publie = ?
          AND b0_.date_publication <= ?
          AND b0_.categorie_id = ?
        ORDER BY
          b0_.date_publication DESC,
          b0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (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 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:07:54' AND b0_.categorie_id = 3 ORDER BY b0_.date_publication DESC, b0_.id DESC) dctrn_result) dctrn_table;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 35)
9	App\Controller\BlogController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.06 ms

SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5 FROM blog_categorie t0 ORDER BY t0.nom ASC, t0.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date_creation AS date_creation_1,
  t0.date_maj AS date_maj_2,
  t0.id AS id_3,
  t0.nom AS nom_4,
  t0.slug AS slug_5
FROM
  blog_categorie t0
ORDER BY
  t0.nom ASC,
  t0.id ASC

SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5 FROM blog_categorie t0 ORDER BY t0.nom ASC, t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 40)
4	App\Controller\BlogController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.26 ms

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_.categorie_id = ? ORDER BY b0_.date_publication DESC, b0_.id DESC LIMIT 6

Parameters:

[
  1
  "2026-10-18 19:07:54"
  3
]

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_.categorie_id = ?
ORDER BY
  b0_.date_publication DESC,
  b0_.id DESC
LIMIT
  6

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:07:54' AND b0_.categorie_id = 3 ORDER BY b0_.date_publication DESC, b0_.id DESC LIMIT 6;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 198)
8	__TwigTemplate_0ae28cd6d9659855d4c58cf184c2465f->block_content (line 442)
9	Twig\Template->yieldBlock (line 150)
10	__TwigTemplate_77721b344846dd4d28393767e2aa6aad->doDisplay (line 398)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_0ae28cd6d9659855d4c58cf184c2465f->doDisplay (line 398)
13	Twig\Template->yield (line 354)
14	Twig\Template->display (line 369)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
21	App\Controller\BlogController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\BlogCategorie	No errors.
App\Entity\BlogArticle	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?categorie=actualites

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping