Symfony Profiler

Query Metrics

262 Database Queries

15 Different statements

181.93 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

152.83 ms
(84.01%)

218

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = ? AND c1_.id = ?

Parameters:

[
  "Publié"
  243
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 243;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1025)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 49)
8	App\Twig\CategorieExtension->countPublishedAnnonces (line 417)
9	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
10	Twig\Template->yield (line 58)
11	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 452)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
20	App\Controller\Main\MainController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

6.60 ms
(3.63%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.nom = ? LIMIT 1

Parameters:

[
  "Emploi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.slug AS slug_5,
  t0.parent_id AS parent_id_6
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.nom = 'Emploi' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 97)
4	App\Twig\CategorieExtension->getCategoriesByName (line 209)
5	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->block_main (line 446)
6	Twig\Template->yieldBlock (line 603)
7	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
8	Twig\Template->yield (line 58)
9	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 452)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
18	App\Controller\Main\MainController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

5.13 ms
(2.82%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.date_ajout AS date_ajout_4, t0.taille AS taille_5, t0.position AS position_6, t0.annonce_id AS annonce_id_7 FROM media t0 WHERE t0.annonce_id = ?

Parameters:

[
  136
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.date_ajout AS date_ajout_4,
  t0.taille AS taille_5,
  t0.position AS position_6,
  t0.annonce_id AS annonce_id_7
FROM
  media t0
WHERE
  t0.annonce_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.date_ajout AS date_ajout_4, t0.taille AS taille_5, t0.position AS position_6, t0.annonce_id AS annonce_id_7 FROM media t0 WHERE t0.annonce_id = 136;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1897)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 315)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 651)
8	App\Entity\Annonce->getMainImage (line 1913)
9	Twig\Extension\CoreExtension::getAttribute (line 172)
10	__TwigTemplate_e3116b224c2bc7a2614c6e523ab92eb4->{closure} (line 2110)
11	Twig\Extension\CoreExtension::captureOutput (line 194)
12	__TwigTemplate_e3116b224c2bc7a2614c6e523ab92eb4->macro_image (line 64)
13	__TwigTemplate_bb0b368915c6a6a300ac3bcd44963f29->doDisplay (line 402)
14	Twig\Template->yield (line 315)
15	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->block_main (line 446)
16	Twig\Template->yieldBlock (line 603)
17	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
18	Twig\Template->yield (line 58)
19	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 452)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
28	App\Controller\Main\MainController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

5.06 ms
(2.78%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.parent_id = ?

Parameters:

[
  235
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.slug AS slug_5,
  t0.parent_id AS parent_id_6
FROM
  categorie t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.parent_id = 235;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1897)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 315)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 404)
8	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
9	Twig\Template->yield (line 58)
10	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
19	App\Controller\Main\MainController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

4.34 ms
(2.39%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM favori t0 WHERE t0.annonce_id = ?

Parameters:

[
  136
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.user_id AS user_id_3,
  t0.annonce_id AS annonce_id_4
FROM
  favori t0
WHERE
  t0.annonce_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM favori t0 WHERE t0.annonce_id = 136;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1897)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 41)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1272)
9	Twig\Extension\CoreExtension::length (line 84)
10	__TwigTemplate_bb0b368915c6a6a300ac3bcd44963f29->doDisplay (line 402)
11	Twig\Template->yield (line 315)
12	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->block_main (line 446)
13	Twig\Template->yieldBlock (line 603)
14	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
15	Twig\Template->yield (line 58)
16	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 452)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
25	App\Controller\Main\MainController->index (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.17 ms
(0.64%)

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.created_at AS created_at_2, a0_.titre AS titre_3, a0_.limite_at AS limite_at_4, a0_.nombre_de_vues AS nombre_de_vues_5, a0_.publication_at AS publication_at_6, a0_.prix AS prix_7, a0_.start_at AS start_at_8, a0_.slug AS slug_9, a0_.statut AS statut_10, a0_.numero_annonce AS numero_annonce_11, a0_.region AS region_12, a0_.ville AS ville_13, a0_.quartier AS quartier_14, a0_.latitude AS latitude_15, a0_.longitude AS longitude_16, a0_.es_negociable AS es_negociable_17, a0_.vedette AS vedette_18, a0_.is_annonce_deleted AS is_annonce_deleted_19, a0_.annonce_deleted_at AS annonce_deleted_at_20, a0_.disponibilite AS disponibilite_21, a0_.temps_de_reponse AS temps_de_reponse_22, a0_.telephone AS telephone_23, a0_.whatsapp AS whatsapp_24, a0_.user_id AS user_id_25, a0_.categorie_id AS categorie_id_26, a0_.supprime_paradmin_id AS supprime_paradmin_id_27 FROM annonce a0_ WHERE a0_.publication_at IS NOT NULL AND a0_.statut = ? AND (a0_.limite_at IS NULL OR a0_.limite_at > ?) ORDER BY a0_.publication_at DESC LIMIT 8

Parameters:

[
  "Publié"
  "2026-03-05 16:41:34"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.created_at AS created_at_2,
  a0_.titre AS titre_3,
  a0_.limite_at AS limite_at_4,
  a0_.nombre_de_vues AS nombre_de_vues_5,
  a0_.publication_at AS publication_at_6,
  a0_.prix AS prix_7,
  a0_.start_at AS start_at_8,
  a0_.slug AS slug_9,
  a0_.statut AS statut_10,
  a0_.numero_annonce AS numero_annonce_11,
  a0_.region AS region_12,
  a0_.ville AS ville_13,
  a0_.quartier AS quartier_14,
  a0_.latitude AS latitude_15,
  a0_.longitude AS longitude_16,
  a0_.es_negociable AS es_negociable_17,
  a0_.vedette AS vedette_18,
  a0_.is_annonce_deleted AS is_annonce_deleted_19,
  a0_.annonce_deleted_at AS annonce_deleted_at_20,
  a0_.disponibilite AS disponibilite_21,
  a0_.temps_de_reponse AS temps_de_reponse_22,
  a0_.telephone AS telephone_23,
  a0_.whatsapp AS whatsapp_24,
  a0_.user_id AS user_id_25,
  a0_.categorie_id AS categorie_id_26,
  a0_.supprime_paradmin_id AS supprime_paradmin_id_27
FROM
  annonce a0_
WHERE
  a0_.publication_at IS NOT NULL
  AND a0_.statut = ?
  AND (
    a0_.limite_at IS NULL
    OR a0_.limite_at > ?
  )
ORDER BY
  a0_.publication_at DESC
LIMIT
  8

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.created_at AS created_at_2, a0_.titre AS titre_3, a0_.limite_at AS limite_at_4, a0_.nombre_de_vues AS nombre_de_vues_5, a0_.publication_at AS publication_at_6, a0_.prix AS prix_7, a0_.start_at AS start_at_8, a0_.slug AS slug_9, a0_.statut AS statut_10, a0_.numero_annonce AS numero_annonce_11, a0_.region AS region_12, a0_.ville AS ville_13, a0_.quartier AS quartier_14, a0_.latitude AS latitude_15, a0_.longitude AS longitude_16, a0_.es_negociable AS es_negociable_17, a0_.vedette AS vedette_18, a0_.is_annonce_deleted AS is_annonce_deleted_19, a0_.annonce_deleted_at AS annonce_deleted_at_20, a0_.disponibilite AS disponibilite_21, a0_.temps_de_reponse AS temps_de_reponse_22, a0_.telephone AS telephone_23, a0_.whatsapp AS whatsapp_24, a0_.user_id AS user_id_25, a0_.categorie_id AS categorie_id_26, a0_.supprime_paradmin_id AS supprime_paradmin_id_27 FROM annonce a0_ WHERE a0_.publication_at IS NOT NULL AND a0_.statut = 'Publié' AND (a0_.limite_at IS NULL OR a0_.limite_at > '2026-03-05 16:41:34') ORDER BY a0_.publication_at DESC LIMIT 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 103)
7	App\Repository\AnnonceRepository->findAnnoncesRecentes (line 99)
8	App\Controller\Main\MainController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.07 ms
(0.59%)

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.is_active AS is_active_3, c0_.slug AS slug_4, c0_.parent_id AS parent_id_5 FROM categorie c0_ WHERE c0_.is_active = ? AND c0_.parent_id IS NOT NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.description AS description_2,
  c0_.is_active AS is_active_3,
  c0_.slug AS slug_4,
  c0_.parent_id AS parent_id_5
FROM
  categorie c0_
WHERE
  c0_.is_active = ?
  AND c0_.parent_id IS NOT NULL

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.is_active AS is_active_3, c0_.slug AS slug_4, c0_.parent_id AS parent_id_5 FROM categorie c0_ WHERE c0_.is_active = 1 AND c0_.parent_id IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 68)
7	App\Twig\CategorieExtension->getCategories (line 68)
8	__TwigTemplate_fd353947f1f165807f32b128dfae9de5->doDisplay (line 402)
9	Twig\Template->yield (line 178)
10	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->block_main (line 446)
11	Twig\Template->yieldBlock (line 603)
12	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
13	Twig\Template->yield (line 58)
14	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
23	App\Controller\Main\MainController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.06 ms
(0.58%)

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.created_at AS created_at_2, a0_.titre AS titre_3, a0_.limite_at AS limite_at_4, a0_.nombre_de_vues AS nombre_de_vues_5, a0_.publication_at AS publication_at_6, a0_.prix AS prix_7, a0_.start_at AS start_at_8, a0_.slug AS slug_9, a0_.statut AS statut_10, a0_.numero_annonce AS numero_annonce_11, a0_.region AS region_12, a0_.ville AS ville_13, a0_.quartier AS quartier_14, a0_.latitude AS latitude_15, a0_.longitude AS longitude_16, a0_.es_negociable AS es_negociable_17, a0_.vedette AS vedette_18, a0_.is_annonce_deleted AS is_annonce_deleted_19, a0_.annonce_deleted_at AS annonce_deleted_at_20, a0_.disponibilite AS disponibilite_21, a0_.temps_de_reponse AS temps_de_reponse_22, a0_.telephone AS telephone_23, a0_.whatsapp AS whatsapp_24, a0_.user_id AS user_id_25, a0_.categorie_id AS categorie_id_26, a0_.supprime_paradmin_id AS supprime_paradmin_id_27 FROM annonce a0_ WHERE a0_.vedette = ? AND a0_.statut = ? AND (a0_.limite_at IS NULL OR a0_.limite_at > ?) ORDER BY a0_.publication_at DESC LIMIT 4

Parameters:

[
  1
  "Publié"
  "2026-03-05 16:41:34"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.created_at AS created_at_2,
  a0_.titre AS titre_3,
  a0_.limite_at AS limite_at_4,
  a0_.nombre_de_vues AS nombre_de_vues_5,
  a0_.publication_at AS publication_at_6,
  a0_.prix AS prix_7,
  a0_.start_at AS start_at_8,
  a0_.slug AS slug_9,
  a0_.statut AS statut_10,
  a0_.numero_annonce AS numero_annonce_11,
  a0_.region AS region_12,
  a0_.ville AS ville_13,
  a0_.quartier AS quartier_14,
  a0_.latitude AS latitude_15,
  a0_.longitude AS longitude_16,
  a0_.es_negociable AS es_negociable_17,
  a0_.vedette AS vedette_18,
  a0_.is_annonce_deleted AS is_annonce_deleted_19,
  a0_.annonce_deleted_at AS annonce_deleted_at_20,
  a0_.disponibilite AS disponibilite_21,
  a0_.temps_de_reponse AS temps_de_reponse_22,
  a0_.telephone AS telephone_23,
  a0_.whatsapp AS whatsapp_24,
  a0_.user_id AS user_id_25,
  a0_.categorie_id AS categorie_id_26,
  a0_.supprime_paradmin_id AS supprime_paradmin_id_27
FROM
  annonce a0_
WHERE
  a0_.vedette = ?
  AND a0_.statut = ?
  AND (
    a0_.limite_at IS NULL
    OR a0_.limite_at > ?
  )
ORDER BY
  a0_.publication_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.created_at AS created_at_2, a0_.titre AS titre_3, a0_.limite_at AS limite_at_4, a0_.nombre_de_vues AS nombre_de_vues_5, a0_.publication_at AS publication_at_6, a0_.prix AS prix_7, a0_.start_at AS start_at_8, a0_.slug AS slug_9, a0_.statut AS statut_10, a0_.numero_annonce AS numero_annonce_11, a0_.region AS region_12, a0_.ville AS ville_13, a0_.quartier AS quartier_14, a0_.latitude AS latitude_15, a0_.longitude AS longitude_16, a0_.es_negociable AS es_negociable_17, a0_.vedette AS vedette_18, a0_.is_annonce_deleted AS is_annonce_deleted_19, a0_.annonce_deleted_at AS annonce_deleted_at_20, a0_.disponibilite AS disponibilite_21, a0_.temps_de_reponse AS temps_de_reponse_22, a0_.telephone AS telephone_23, a0_.whatsapp AS whatsapp_24, a0_.user_id AS user_id_25, a0_.categorie_id AS categorie_id_26, a0_.supprime_paradmin_id AS supprime_paradmin_id_27 FROM annonce a0_ WHERE a0_.vedette = 1 AND a0_.statut = 'Publié' AND (a0_.limite_at IS NULL OR a0_.limite_at > '2026-03-05 16:41:34') ORDER BY a0_.publication_at DESC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 62)
7	App\Repository\AnnonceRepository->findAnnoncesVedettes (line 100)
8	App\Controller\Main\MainController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.06 ms
(0.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM options t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "app_adresse"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.label AS label_4
FROM
  options t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM options t0 WHERE t0.name = 'app_adresse' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 100)
4	App\Twig\AppExtension->options (line 692)
5	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
6	Twig\Template->yield (line 58)
7	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 452)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
16	App\Controller\Main\MainController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.77 ms
(0.42%)

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ WHERE a0_.statut = ?

Parameters:

[
  "Publié"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
WHERE
  a0_.statut = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ WHERE a0_.statut = 'Publié';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1025)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 194)
8	App\Repository\AnnonceRepository->countByStatut (line 82)
9	App\Controller\Main\MainController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.71 ms
(0.39%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.is_active = ? AND t0.parent_id IS NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.slug AS slug_5,
  t0.parent_id AS parent_id_6
FROM
  categorie t0
WHERE
  t0.is_active = ?
  AND t0.parent_id IS NULL

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.is_active = 1 AND t0.parent_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 995)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 78)
4	App\Twig\CategorieExtension->getCategoriesParent (line 55)
5	__TwigTemplate_62c37c86b780b79a74e2ecee718776f9->doDisplay (line 402)
6	Twig\Template->yield (line 58)
7	__TwigTemplate_f9f2619d90bb7aa3408fac887146cd4e->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 452)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 457)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 257)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 106)
16	App\Controller\Main\MainController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.58 ms
(0.32%)

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ WHERE a0_.statut = ? AND a0_.publication_at IS NOT NULL AND a0_.publication_at >= ?

Parameters:

[
  "Publié"
  "2026-03-04 16:41:34"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
WHERE
  a0_.statut = ?
  AND a0_.publication_at IS NOT NULL
  AND a0_.publication_at >= ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ WHERE a0_.statut = 'Publié' AND a0_.publication_at IS NOT NULL AND a0_.publication_at >= '2026-03-04 16:41:34';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1025)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 210)
8	App\Repository\AnnonceRepository->countPublishedSince (line 85)
9	App\Controller\Main\MainController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.54 ms
(0.30%)

SELECT COUNT(n0_.id) AS sclr_0 FROM note n0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  note n0_

SELECT COUNT(n0_.id) AS sclr_0 FROM note n0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1025)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 77)
8	App\Repository\NoteRepository->getSatisfactionRate (line 86)
9	App\Controller\Main\MainController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.53 ms
(0.29%)

SELECT COUNT(*) FROM user t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  user t0

SELECT COUNT(*) FROM user t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 909)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 254)
3	Doctrine\ORM\EntityRepository->count (line 83)
4	App\Controller\Main\MainController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.49 ms
(0.27%)

SELECT COUNT(n0_.id) AS sclr_0 FROM note n0_ WHERE n0_.note >= ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  note n0_
WHERE
  n0_.note >= ?

SELECT COUNT(n0_.id) AS sclr_0 FROM note n0_ WHERE n0_.note >= 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1025)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 87)
8	App\Repository\NoteRepository->getSatisfactionRate (line 86)
9	App\Controller\Main\MainController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Annonce	The field App\Entity\Annonce#contactAnnonces is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContactAnnonce#annonce does not contain the required 'inversedBy="contactAnnonces"' attribute.
App\Entity\User	No errors.
App\Entity\Note	No errors.
App\Entity\Categorie	No errors.
App\Entity\AnnonceChamp	No errors.
App\Entity\Media	No errors.
App\Entity\CreditTransaction	No errors.
App\Entity\Litige	No errors.
App\Entity\Favori	No errors.
App\Entity\ContactAnnonce	No errors.
App\Entity\Signalement	No errors.
App\Entity\ModerationActions	No errors.
App\Entity\AnnonceModeration	No errors.
App\Entity\AnnonceFeatured	No errors.
App\Entity\ChatConversation	No errors.
App\Entity\CategorieChamp	No errors.
App\Entity\Options	No errors.

Symfony Profiler

GET https://www.test.annonce221.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping