Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.40 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.55 ms
(39.58%)

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:10:07"
  2
]

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:10:07' AND b0_.categorie_id = 2 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.50 ms
(35.63%)

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:

[
  "juridique-reglementaire"
]

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 = 'juridique-reglementaire' 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.27 ms
(19.63%)

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:10:07"
  2
]

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:10:07' AND b0_.categorie_id = 2 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)

0.07 ms
(5.16%)

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)

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.

Symfony Profiler

GET https://cabinet-guerry.test.agence-11h10.fr/login-popup

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping