Symfony Profiler

Query Metrics

44 Database Queries

18 Different statements

17.62 ms Query time

0 Invalid entities

117 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.23 ms
(24.01%)

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= ?

Parameters:

[
  "2026-11-10 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_
WHERE
  v0_.first_seen_at >= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= '2026-11-10 00:00:00';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\VisitorCounter->count (line 44)
8	App\Service\VisitorCounter->stats (line 30)
9	App\Controller\StatsController->counter (line 14)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
17	__TwigTemplate_e0bc7d2ae86db31a728e54cf05a0afdd->doDisplay (line 211)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_9675eea3b54bce847418c7a1e805167c->doDisplay (line 362)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_430ab3482f7ef2e62033cb203642bf72->doDisplay (line 57)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
30	App\Controller\AccueilController->index (line 86)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	require_once (line 5)

2.39 ms
(13.59%)

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = ?
        ) ranked
        WHERE rn <= ?
        ORDER BY created_at DESC
        LIMIT ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  (
    SELECT
      a.id,
      a.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          a.sous_thematique_id
        ORDER BY
          a.created_at DESC
      ) AS rn
    FROM
      actualite a
      INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
    WHERE
      st.thematique_id = ?
  ) ranked
WHERE
  rn <= ?
ORDER BY
  created_at DESC
LIMIT
  ?

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = 1
        ) ranked
        WHERE rn <= 2
        ORDER BY created_at DESC
        LIMIT 4
    ;

#	File/Call
1	App\Repository\ActualiteRepository->findLatestByThematiqueGroupedBySousThematique (line 157)
2	App\Controller\AccueilController->index (line 33)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

1.65 ms
(9.34%)

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\VisitorCounter->count (line 44)
8	App\Service\VisitorCounter->stats (line 34)
9	App\Controller\StatsController->counter (line 14)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
17	__TwigTemplate_e0bc7d2ae86db31a728e54cf05a0afdd->doDisplay (line 211)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_9675eea3b54bce847418c7a1e805167c->doDisplay (line 362)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_430ab3482f7ef2e62033cb203642bf72->doDisplay (line 57)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
30	App\Controller\AccueilController->index (line 86)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	require_once (line 5)

1.40 ms
(7.92%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = ? LIMIT 1

Parameters:

[
  "Urbanisme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3
FROM
  thematique t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = 'Urbanisme' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\AccueilController->index (line 31)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.27 ms
(7.23%)

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY s0_.libelle ASC

Parameters:

[
  "Urbanisme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Urbanisme' ORDER BY s0_.libelle ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\SousThematiqueRepository->findByThematiqueLibelle (line 27)
7	App\Controller\AccueilController->index (line 77)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.99 ms
(5.60%)

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.last_seen_at >= ?

Parameters:

[
  "2026-11-10 23:42:23"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_
WHERE
  v0_.last_seen_at >= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.last_seen_at >= '2026-11-10 23:42:23';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Service\VisitorCounter->count (line 44)
8	App\Service\VisitorCounter->stats (line 29)
9	App\Controller\StatsController->counter (line 14)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
17	__TwigTemplate_e0bc7d2ae86db31a728e54cf05a0afdd->doDisplay (line 211)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_9675eea3b54bce847418c7a1e805167c->doDisplay (line 362)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_430ab3482f7ef2e62033cb203642bf72->doDisplay (line 57)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
30	App\Controller\AccueilController->index (line 86)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	require_once (line 5)

0.86 ms
(4.88%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.id IN (?, ?, ?, ?) ORDER BY a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.id IN (87, 86, 85, 84) ORDER BY a0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActualiteRepository->findLatestByThematiqueGroupedBySousThematique (line 182)
7	App\Controller\AccueilController->index (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.84 ms
(4.79%)

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.titre_en AS titre_en_2, p0_.contenu AS contenu_3, p0_.contenu_en AS contenu_en_4, p0_.image AS image_5, p0_.legende AS legende_6, p0_.legende_en AS legende_en_7, p0_.created_at AS created_at_8, p0_.thematique_id AS thematique_id_9 FROM problemes p0_ INNER JOIN thematique t1_ ON p0_.thematique_id = t1_.id WHERE t1_.libelle = ? ORDER BY p0_.created_at DESC LIMIT 5

Parameters:

[
  "Urbanisme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.titre_en AS titre_en_2,
  p0_.contenu AS contenu_3,
  p0_.contenu_en AS contenu_en_4,
  p0_.image AS image_5,
  p0_.legende AS legende_6,
  p0_.legende_en AS legende_en_7,
  p0_.created_at AS created_at_8,
  p0_.thematique_id AS thematique_id_9
FROM
  problemes p0_
  INNER JOIN thematique t1_ ON p0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.titre_en AS titre_en_2, p0_.contenu AS contenu_3, p0_.contenu_en AS contenu_en_4, p0_.image AS image_5, p0_.legende AS legende_6, p0_.legende_en AS legende_en_7, p0_.created_at AS created_at_8, p0_.thematique_id AS thematique_id_9 FROM problemes p0_ INNER JOIN thematique t1_ ON p0_.thematique_id = t1_.id WHERE t1_.libelle = 'Urbanisme' ORDER BY p0_.created_at DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ProblemesRepository->findLastByThematique (line 56)
7	App\Controller\AccueilController->index (line 82)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.59 ms
(3.33%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?

Parameters:

[
  69
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 69;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\SousThematique::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\SousThematique->__get (line 153)
7	App\Entity\SousThematique->getThematique (line 78)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_430ab3482f7ef2e62033cb203642bf72::block_body (line 229)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9675eea3b54bce847418c7a1e805167c->doDisplay (line 357)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_430ab3482f7ef2e62033cb203642bf72->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\AccueilController->index (line 86)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.58 ms
(3.30%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = ? ORDER BY a0_.id DESC LIMIT 2 OFFSET 1

Parameters:

[
  "Economie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
ORDER BY
  a0_.id DESC
LIMIT
  2
OFFSET
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Economie' ORDER BY a0_.id DESC LIMIT 2 OFFSET 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActualiteRepository->findPreviousTwoBySousThematiqueLibelle (line 78)
7	App\Controller\AccueilController->index (line 74)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.58 ms
(3.28%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = ? ORDER BY a0_.id DESC LIMIT 1

Parameters:

[
  "Economie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Economie' ORDER BY a0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\ActualiteRepository->findLatestBySousThematiqueLibelle (line 65)
7	App\Controller\AccueilController->index (line 71)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.48 ms
(2.75%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.id IN (?, ?) ORDER BY a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.id IN (92, 91) ORDER BY a0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActualiteRepository->findLatestByThematiqueGroupedBySousThematique (line 182)
7	App\Controller\AccueilController->index (line 57)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.40 ms
(2.27%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.ala_une = 1 AND a0_.id <> ? ORDER BY a0_.created_at DESC LIMIT 10

Parameters:

[
  92
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
WHERE
  a0_.ala_une = 1
  AND a0_.id <> ?
ORDER BY
  a0_.created_at DESC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.ala_une = 1 AND a0_.id <> 92 ORDER BY a0_.created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActualiteRepository->findLatestAlaUneList (line 33)
7	App\Controller\AccueilController->index (line 27)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.40 ms
(2.25%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.ala_une = 1 ORDER BY a0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
WHERE
  a0_.ala_une = 1
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.ala_une = 1 ORDER BY a0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\ActualiteRepository->findLatestAlaUne (line 43)
7	App\Controller\AccueilController->index (line 25)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.31 ms
(1.76%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = ? AND a0_.id <> ? ORDER BY a0_.created_at DESC LIMIT 4

Parameters:

[
  "Sport"
  92
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
  AND a0_.id <> ?
ORDER BY
  a0_.created_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Sport' AND a0_.id <> 92 ORDER BY a0_.created_at DESC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActualiteRepository->findLatestSportList (line 95)
7	App\Controller\AccueilController->index (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.25 ms
(1.43%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.id IN (?, ?, ?) ORDER BY a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.id IN (90, 89, 62) ORDER BY a0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActualiteRepository->findLatestByThematiqueGroupedBySousThematique (line 182)
7	App\Controller\AccueilController->index (line 48)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.23 ms
(1.29%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.titre = ? LIMIT 1

Parameters:

[
  "CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
WHERE
  a0_.titre = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_.titre = 'CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\ActualiteRepository->findByTitle (line 53)
7	App\Controller\AccueilController->index (line 29)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.17 ms
(0.98%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.description AS description_4, t0.created_at AS created_at_5 FROM dossier_redaction t0 ORDER BY t0.id DESC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5
FROM
  dossier_redaction t0
ORDER BY
  t0.id DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.description AS description_4, t0.created_at AS created_at_5 FROM dossier_redaction t0 ORDER BY t0.id DESC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\AccueilController->index (line 52)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\SousThematique	63
App\Entity\Actualite	32
App\Entity\Problemes	12
App\Entity\Thematique	7
App\Entity\Utilisateur	3

Entities Mapping

Class	Mapping errors
App\Entity\Actualite	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\SousThematique	No errors.
App\Entity\DossierRedaction	No errors.
App\Entity\Article	No errors.
App\Entity\Thematique	No errors.
App\Entity\Problemes	No errors.
App\Entity\Visiteur	No errors.

Symfony Profiler

GET https://www.yusiip.cm/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping