Symfony Profiler

Query Metrics

44 Database Queries

7 Different statements

14.74 ms Query time

0 Invalid entities

850 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.73 ms
(93.19%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.link AS link_7, t0.image AS image_8, t0.old_slug AS old_slug_9, t0.dossier AS dossier_10, t0.fichier_image AS fichier_image_11, t0.publie AS publie_12, t0.date_modif_at AS date_modif_at_13, t0.en_avant AS en_avant_14, t0.editeur AS editeur_15, t0.credit AS credit_16, t0.meta_description AS meta_description_17, t0.note AS note_18, t0.source AS source_19, t0.guid AS guid_20, t0.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 FROM article t0 WHERE t0.categorie_id = ? ORDER BY t0.published_at DESC

Parameters:

[
  282
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.summary AS summary_4,
  t0.content AS content_5,
  t0.published_at AS published_at_6,
  t0.link AS link_7,
  t0.image AS image_8,
  t0.old_slug AS old_slug_9,
  t0.dossier AS dossier_10,
  t0.fichier_image AS fichier_image_11,
  t0.publie AS publie_12,
  t0.date_modif_at AS date_modif_at_13,
  t0.en_avant AS en_avant_14,
  t0.editeur AS editeur_15,
  t0.credit AS credit_16,
  t0.meta_description AS meta_description_17,
  t0.note AS note_18,
  t0.source AS source_19,
  t0.guid AS guid_20,
  t0.instagram_published_at AS instagram_published_at_21,
  t0.image_format AS image_format_22,
  t0.author_id AS author_id_23,
  t0.categorie_id AS categorie_id_24,
  t0.site_id AS site_id_25,
  t0.flux_rss_id AS flux_rss_id_26
FROM
  article t0
WHERE
  t0.categorie_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.link AS link_7, t0.image AS image_8, t0.old_slug AS old_slug_9, t0.dossier AS dossier_10, t0.fichier_image AS fichier_image_11, t0.publie AS publie_12, t0.date_modif_at AS date_modif_at_13, t0.en_avant AS en_avant_14, t0.editeur AS editeur_15, t0.credit AS credit_16, t0.meta_description AS meta_description_17, t0.note AS note_18, t0.source AS source_19, t0.guid AS guid_20, t0.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 FROM article t0 WHERE t0.categorie_id = 282 ORDER BY t0.published_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_f65e514ec1891b4e643119f822f5f1d6::doDisplay (line 57)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\CategorieController->categoriesRacine (line 48)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
26	__TwigTemplate_93daa9fec09b6c089513a7c98f2e28ed->doDisplay (line 71)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645->block_sidebar (line 1235)
29	Twig\Template->yieldBlock (line 456)
30	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645->doDisplay (line 329)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_025b76b2c392c97caf7be9763b40724e->doDisplay (line 60)
33	Twig\Template->yield (line 411)
34	Twig\Template->display (line 366)
35	Twig\Template->render (line 381)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
41	App\Controller\CategorieController->show (line 140)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 193)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
46	require_once (line 32)
47	require_once (line 9)

0.46 ms
(3.13%)

SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = ? LIMIT 1

Parameters:

[
  "la-buse.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_site AS nom_site_2,
  t0.url_site AS url_site_3,
  t0.meta_description AS meta_description_4,
  t0.meta_mots_cles AS meta_mots_cles_5,
  t0.description AS description_6,
  t0.meta_title AS meta_title_7,
  t0.a_propos AS a_propos_8,
  t0.titre_apropos AS titre_apropos_9,
  t0.slug_apropos AS slug_apropos_10,
  t0.resume_apropos AS resume_apropos_11,
  t0.instagram_user_id AS instagram_user_id_12,
  t0.instagram_access_token AS instagram_access_token_13,
  t0.image_format_default AS image_format_default_14,
  t0.auteur_principal_id AS auteur_principal_id_15
FROM
  site t0
WHERE
  t0.url_site = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = 'la-buse.fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Twig\AppExtension->getGlobals (line 79)
7	Twig\ExtensionSet->getGlobals (line 365)
8	Twig\Environment->getGlobals (line 908)
9	Twig\Template->yield (line 406)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
17	App\Controller\CategorieController->show (line 140)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 9)

0.13 ms
(0.86%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.bio AS bio_7, t0.photo AS photo_8, t0.linkedin AS linkedin_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.site_web AS site_web_12, t0.mastodon AS mastodon_13, t0.titre AS titre_14, t0.twitter AS twitter_15, t0.github AS github_16, t0.slug AS slug_17, t0.affiche_auteur AS affiche_auteur_18 FROM utilisateur t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.bio AS bio_7,
  t0.photo AS photo_8,
  t0.linkedin AS linkedin_9,
  t0.facebook AS facebook_10,
  t0.instagram AS instagram_11,
  t0.site_web AS site_web_12,
  t0.mastodon AS mastodon_13,
  t0.titre AS titre_14,
  t0.twitter AS twitter_15,
  t0.github AS github_16,
  t0.slug AS slug_17,
  t0.affiche_auteur AS affiche_auteur_18
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.bio AS bio_7, t0.photo AS photo_8, t0.linkedin AS linkedin_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.site_web AS site_web_12, t0.mastodon AS mastodon_13, t0.titre AS titre_14, t0.twitter AS twitter_15, t0.github AS github_16, t0.slug AS slug_17, t0.affiche_auteur AS affiche_auteur_18 FROM utilisateur t0 WHERE t0.id = 2;

#	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\User::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\User->__get (line 153)
7	App\Entity\User->isAfficheAuteur (line 424)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645::doDisplay (line 227)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_025b76b2c392c97caf7be9763b40724e->doDisplay (line 60)
12	Twig\Template->yield (line 411)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\CategorieController->show (line 140)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 9)

0.12 ms
(0.79%)

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN site s2_ ON a0_.site_id = s2_.id WHERE a0_.published_at <= ? AND s2_.url_site = ? AND a0_.categorie_id = ? ORDER BY a0_.published_at DESC LIMIT 30

Parameters:

[
  "2026-06-17 23:34:19"
  "la-buse.fr"
  294
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.published_at AS published_at_1
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN site s2_ ON a0_.site_id = s2_.id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND a0_.categorie_id = ?
ORDER BY
  a0_.published_at DESC
LIMIT
  30

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN site s2_ ON a0_.site_id = s2_.id WHERE a0_.published_at <= '2026-06-17 23:34:19' AND s2_.url_site = 'la-buse.fr' AND a0_.categorie_id = 294 ORDER BY a0_.published_at DESC LIMIT 30;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	App\Pagination\Paginator->paginate (line 71)
8	App\Repository\ArticleRepository->findLatestCategorie (line 127)
9	App\Controller\BlogController->articlesCategories (line 321)
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_025b76b2c392c97caf7be9763b40724e->block_main (line 293)
18	Twig\Template->yieldBlock (line 456)
19	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645->doDisplay (line 323)
20	Twig\Template->yield (line 411)
21	__TwigTemplate_025b76b2c392c97caf7be9763b40724e->doDisplay (line 60)
22	Twig\Template->yield (line 411)
23	Twig\Template->display (line 366)
24	Twig\Template->render (line 381)
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\CategorieController->show (line 140)
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 9)

0.11 ms
(0.76%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.texte_description AS texte_description_6, t0.site_id AS site_id_7, t0.categorie_parent_id AS categorie_parent_id_8 FROM categorie t0 WHERE t0.site_id = ? AND t0.categorie_parent_id IS NULL ORDER BY t0.nom DESC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.meta_description AS meta_description_4,
  t0.resume AS resume_5,
  t0.texte_description AS texte_description_6,
  t0.site_id AS site_id_7,
  t0.categorie_parent_id AS categorie_parent_id_8
FROM
  categorie t0
WHERE
  t0.site_id = ?
  AND t0.categorie_parent_id IS NULL
ORDER BY
  t0.nom DESC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.texte_description AS texte_description_6, t0.site_id AS site_id_7, t0.categorie_parent_id AS categorie_parent_id_8 FROM categorie t0 WHERE t0.site_id = 2 AND t0.categorie_parent_id IS NULL ORDER BY t0.nom DESC;

#	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\CategorieController->categoriesRacine (line 49)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_93daa9fec09b6c089513a7c98f2e28ed->doDisplay (line 71)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645->block_sidebar (line 1235)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645->doDisplay (line 329)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_025b76b2c392c97caf7be9763b40724e->doDisplay (line 60)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\CategorieController->show (line 140)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 9)

0.10 ms
(0.66%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.texte_description AS texte_description_6, t0.site_id AS site_id_7, t0.categorie_parent_id AS categorie_parent_id_8 FROM categorie t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "investisseurs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.meta_description AS meta_description_4,
  t0.resume AS resume_5,
  t0.texte_description AS texte_description_6,
  t0.site_id AS site_id_7,
  t0.categorie_parent_id AS categorie_parent_id_8
FROM
  categorie t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.texte_description AS texte_description_6, t0.site_id AS site_id_7, t0.categorie_parent_id AS categorie_parent_id_8 FROM categorie t0 WHERE t0.slug = 'investisseurs' 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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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 9)

0.09 ms
(0.62%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN site s2_ ON a0_.site_id = s2_.id WHERE a0_.published_at <= ? AND s2_.url_site = ? AND a0_.categorie_id = ?

Parameters:

[
  "2026-06-17 23:34:19"
  "la-buse.fr"
  294
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN site s2_ ON a0_.site_id = s2_.id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND a0_.categorie_id = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN site s2_ ON a0_.site_id = s2_.id WHERE a0_.published_at <= '2026-06-17 23:34:19' AND s2_.url_site = 'la-buse.fr' AND a0_.categorie_id = 294;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Pagination\Paginator->paginate (line 72)
8	App\Repository\ArticleRepository->findLatestCategorie (line 127)
9	App\Controller\BlogController->articlesCategories (line 321)
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_025b76b2c392c97caf7be9763b40724e->block_main (line 293)
18	Twig\Template->yieldBlock (line 456)
19	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645->doDisplay (line 323)
20	Twig\Template->yield (line 411)
21	__TwigTemplate_025b76b2c392c97caf7be9763b40724e->doDisplay (line 60)
22	Twig\Template->yield (line 411)
23	Twig\Template->display (line 366)
24	Twig\Template->render (line 381)
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\CategorieController->show (line 140)
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 9)

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\Article	812
App\Entity\Categorie	35
App\Entity\User	2
App\Entity\Site	1

Entities Mapping

Class	Mapping errors
App\Entity\Categorie	No errors.
App\Entity\Site	No errors.
App\Entity\Article	No errors.
App\Entity\FluxRss	No errors.
App\Entity\User	No errors.
App\Entity\Gallerie	No errors.
App\Entity\Tag	No errors.
App\Entity\ItemRss	No errors.
App\Entity\Comment	No errors.

Symfony Profiler

GET https://la-buse.fr/en/categories_categorie_racine

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping