Symfony Profiler

Query Metrics

75 Database Queries

9 Different statements

9.85 ms Query time

0 Invalid entities

850 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.40 ms
(54.86%)

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)

2.59 ms
(26.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = ? ORDER BY t0.name ASC

Parameters:

[
  3296
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
  INNER JOIN article_tag ON t0.id = article_tag.tag_id
WHERE
  article_tag.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = 3296 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1707)
10	__TwigTemplate_fd70f75b3a20d9a970cd888abab783f3::doDisplay (line 48)
11	Twig\Template->yield (line 411)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Extension\CoreExtension->include (line 1522)
16	__TwigTemplate_c188fc28072d86d76cb025f3f3f8140f::doDisplay (line 105)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Extension\CoreExtension->include (line 1522)
22	__TwigTemplate_089a7db5983f621e9a1bb66cc5bb5e87::doDisplay (line 76)
23	Twig\Template->yield (line 411)
24	Twig\Template->display (line 366)
25	Twig\Template->render (line 381)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	App\Controller\BlogController->articlesCategories (line 326)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
35	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
36	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
37	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
38	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
39	__TwigTemplate_025b76b2c392c97caf7be9763b40724e->block_main (line 293)
40	Twig\Template->yieldBlock (line 456)
41	__TwigTemplate_d4339729bdc38eeebfbada9f179c4645->doDisplay (line 323)
42	Twig\Template->yield (line 411)
43	__TwigTemplate_025b76b2c392c97caf7be9763b40724e->doDisplay (line 60)
44	Twig\Template->yield (line 411)
45	Twig\Template->display (line 366)
46	Twig\Template->render (line 381)
47	Twig\TemplateWrapper->render (line 51)
48	Twig\Environment->render (line 333)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
50	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
52	App\Controller\CategorieController->show (line 140)
53	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
54	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
55	Symfony\Component\HttpKernel\Kernel->handle (line 193)
56	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
57	require_once (line 32)
58	require_once (line 9)

0.46 ms
(4.64%)

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.45 ms
(4.60%)

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 OFFSET 90

Parameters:

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

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
OFFSET
  90

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 = 293 ORDER BY a0_.published_at DESC LIMIT 30 OFFSET 90;

#	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.36 ms
(3.70%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.summary AS summary_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.link AS link_6, a0_.image AS image_7, a0_.old_slug AS old_slug_8, a0_.dossier AS dossier_9, a0_.fichier_image AS fichier_image_10, a0_.publie AS publie_11, a0_.date_modif_at AS date_modif_at_12, a0_.en_avant AS en_avant_13, a0_.editeur AS editeur_14, a0_.credit AS credit_15, a0_.meta_description AS meta_description_16, a0_.note AS note_17, a0_.source AS source_18, a0_.guid AS guid_19, a0_.instagram_published_at AS instagram_published_at_20, a0_.image_format AS image_format_21, u1_.id AS id_22, u1_.full_name AS full_name_23, u1_.username AS username_24, u1_.email AS email_25, u1_.password AS password_26, u1_.roles AS roles_27, u1_.bio AS bio_28, u1_.photo AS photo_29, u1_.linkedin AS linkedin_30, u1_.facebook AS facebook_31, u1_.instagram AS instagram_32, u1_.site_web AS site_web_33, u1_.mastodon AS mastodon_34, u1_.titre AS titre_35, u1_.twitter AS twitter_36, u1_.github AS github_37, u1_.slug AS slug_38, u1_.affiche_auteur AS affiche_auteur_39, a0_.author_id AS author_id_40, a0_.categorie_id AS categorie_id_41, a0_.site_id AS site_id_42, a0_.flux_rss_id AS flux_rss_id_43 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 = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.published_at DESC

Parameters:

[
  "2026-06-17 23:34:19"
  "la-buse.fr"
  293
  3296
  3292
  3291
  3290
  3285
  3284
  3278
  3277
  3265
  3263
  3236
  3230
  3226
  3203
  3194
  3191
  3183
  3166
  3161
  3144
  3143
  3148
  3137
  3136
  2942
  3125
  3111
  3110
  3086
  3077
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.summary AS summary_3,
  a0_.content AS content_4,
  a0_.published_at AS published_at_5,
  a0_.link AS link_6,
  a0_.image AS image_7,
  a0_.old_slug AS old_slug_8,
  a0_.dossier AS dossier_9,
  a0_.fichier_image AS fichier_image_10,
  a0_.publie AS publie_11,
  a0_.date_modif_at AS date_modif_at_12,
  a0_.en_avant AS en_avant_13,
  a0_.editeur AS editeur_14,
  a0_.credit AS credit_15,
  a0_.meta_description AS meta_description_16,
  a0_.note AS note_17,
  a0_.source AS source_18,
  a0_.guid AS guid_19,
  a0_.instagram_published_at AS instagram_published_at_20,
  a0_.image_format AS image_format_21,
  u1_.id AS id_22,
  u1_.full_name AS full_name_23,
  u1_.username AS username_24,
  u1_.email AS email_25,
  u1_.password AS password_26,
  u1_.roles AS roles_27,
  u1_.bio AS bio_28,
  u1_.photo AS photo_29,
  u1_.linkedin AS linkedin_30,
  u1_.facebook AS facebook_31,
  u1_.instagram AS instagram_32,
  u1_.site_web AS site_web_33,
  u1_.mastodon AS mastodon_34,
  u1_.titre AS titre_35,
  u1_.twitter AS twitter_36,
  u1_.github AS github_37,
  u1_.slug AS slug_38,
  u1_.affiche_auteur AS affiche_auteur_39,
  a0_.author_id AS author_id_40,
  a0_.categorie_id AS categorie_id_41,
  a0_.site_id AS site_id_42,
  a0_.flux_rss_id AS flux_rss_id_43
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 = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.published_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.summary AS summary_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.link AS link_6, a0_.image AS image_7, a0_.old_slug AS old_slug_8, a0_.dossier AS dossier_9, a0_.fichier_image AS fichier_image_10, a0_.publie AS publie_11, a0_.date_modif_at AS date_modif_at_12, a0_.en_avant AS en_avant_13, a0_.editeur AS editeur_14, a0_.credit AS credit_15, a0_.meta_description AS meta_description_16, a0_.note AS note_17, a0_.source AS source_18, a0_.guid AS guid_19, a0_.instagram_published_at AS instagram_published_at_20, a0_.image_format AS image_format_21, u1_.id AS id_22, u1_.full_name AS full_name_23, u1_.username AS username_24, u1_.email AS email_25, u1_.password AS password_26, u1_.roles AS roles_27, u1_.bio AS bio_28, u1_.photo AS photo_29, u1_.linkedin AS linkedin_30, u1_.facebook AS facebook_31, u1_.instagram AS instagram_32, u1_.site_web AS site_web_33, u1_.mastodon AS mastodon_34, u1_.titre AS titre_35, u1_.twitter AS twitter_36, u1_.github AS github_37, u1_.slug AS slug_38, u1_.affiche_auteur AS affiche_auteur_39, a0_.author_id AS author_id_40, a0_.categorie_id AS categorie_id_41, a0_.site_id AS site_id_42, a0_.flux_rss_id AS flux_rss_id_43 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 = 293 AND a0_.id IN (3296, 3292, 3291, 3290, 3285, 3284, 3278, 3277, 3265, 3263, 3236, 3230, 3226, 3203, 3194, 3191, 3183, 3166, 3161, 3144, 3143, 3148, 3137, 3136, 2942, 3125, 3111, 3110, 3086, 3077) ORDER BY a0_.published_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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
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.24 ms
(2.49%)

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"
  293
]

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 = 293;

#	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)

0.12 ms
(1.19%)

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
(1.18%)

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.11 ms
(1.09%)

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:

[
  "ces-grands-hommes"
]

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 = 'ces-grands-hommes' 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)

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