Symfony Profiler

Query Metrics

253 Database Queries

10 Different statements

168.80 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

134.86 ms
(79.89%)

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_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
10	Twig\Template->yield (line 55)
11	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->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 465)
20	App\Controller\Main\AnnonceController->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)

7.53 ms
(4.46%)

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 666)
8	App\Entity\Annonce->getMainImage (line 1913)
9	Twig\Extension\CoreExtension::getAttribute (line 172)
10	__TwigTemplate_d7f40aeeb357a5035a2de0dc8afda63a->{closure} (line 2110)
11	Twig\Extension\CoreExtension::captureOutput (line 163)
12	__TwigTemplate_d7f40aeeb357a5035a2de0dc8afda63a->macro_image (line 64)
13	__TwigTemplate_aeb3b1530209517f32ae4e6547db6f30->doDisplay (line 402)
14	Twig\Template->yield (line 293)
15	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->block_main (line 446)
16	Twig\Template->yieldBlock (line 603)
17	__TwigTemplate_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->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 465)
28	App\Controller\Main\AnnonceController->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)

7.29 ms
(4.32%)

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_aeb3b1530209517f32ae4e6547db6f30->doDisplay (line 402)
11	Twig\Template->yield (line 293)
12	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->block_main (line 446)
13	Twig\Template->yieldBlock (line 603)
14	__TwigTemplate_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->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 465)
25	App\Controller\Main\AnnonceController->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)

5.51 ms
(3.26%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = ?

Parameters:

[
  "Publié"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  annonce a0_
  LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id
  LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id
WHERE
  a0_.statut = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id 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 942)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container6CLKaCV\PaginatorProxy9cc2a8f->paginate (line 443)
16	App\Controller\Main\AnnonceController->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)

5.03 ms
(2.98%)

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_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
9	Twig\Template->yield (line 55)
10	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->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 465)
19	App\Controller\Main\AnnonceController->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)

2.50 ms
(1.48%)

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 451)
4	App\Controller\Main\AnnonceController->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)

2.38 ms
(1.41%)

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 98)
4	App\Twig\AppExtension->options (line 692)
5	__TwigTemplate_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
6	Twig\Template->yield (line 55)
7	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->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 465)
16	App\Controller\Main\AnnonceController->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)

1.57 ms
(0.93%)

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, c1_.id AS id_25, c1_.nom AS nom_26, c1_.description AS description_27, c1_.is_active AS is_active_28, c1_.slug AS slug_29, c2_.id AS id_30, c2_.nom AS nom_31, c2_.description AS description_32, c2_.is_active AS is_active_33, c2_.slug AS slug_34, a0_.user_id AS user_id_35, a0_.categorie_id AS categorie_id_36, a0_.supprime_paradmin_id AS supprime_paradmin_id_37, c1_.parent_id AS parent_id_38, c2_.parent_id AS parent_id_39 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.publication_at DESC

Parameters:

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,
  c1_.id AS id_25,
  c1_.nom AS nom_26,
  c1_.description AS description_27,
  c1_.is_active AS is_active_28,
  c1_.slug AS slug_29,
  c2_.id AS id_30,
  c2_.nom AS nom_31,
  c2_.description AS description_32,
  c2_.is_active AS is_active_33,
  c2_.slug AS slug_34,
  a0_.user_id AS user_id_35,
  a0_.categorie_id AS categorie_id_36,
  a0_.supprime_paradmin_id AS supprime_paradmin_id_37,
  c1_.parent_id AS parent_id_38,
  c2_.parent_id AS parent_id_39
FROM
  annonce a0_
  LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id
  LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id
WHERE
  a0_.statut = ?
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.publication_at DESC

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, c1_.id AS id_25, c1_.nom AS nom_26, c1_.description AS description_27, c1_.is_active AS is_active_28, c1_.slug AS slug_29, c2_.id AS id_30, c2_.nom AS nom_31, c2_.description AS description_32, c2_.is_active AS is_active_33, c2_.slug AS slug_34, a0_.user_id AS user_id_35, a0_.categorie_id AS categorie_id_36, a0_.supprime_paradmin_id AS supprime_paradmin_id_37, c1_.parent_id AS parent_id_38, c2_.parent_id AS parent_id_39 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = 'Publié' AND a0_.id IN (136, 126, 125, 127, 134, 131, 133, 132, 12) ORDER BY a0_.publication_at DESC;

#	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 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container6CLKaCV\PaginatorProxy9cc2a8f->paginate (line 443)
16	App\Controller\Main\AnnonceController->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)

1.28 ms
(0.76%)

SELECT DISTINCT a0_.id AS id_0, a0_.publication_at AS publication_at_1 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = ? ORDER BY a0_.publication_at DESC LIMIT 12

Parameters:

[
  "Publié"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.publication_at AS publication_at_1
FROM
  annonce a0_
  LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id
  LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id
WHERE
  a0_.statut = ?
ORDER BY
  a0_.publication_at DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a0_.publication_at AS publication_at_1 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = 'Publié' ORDER BY a0_.publication_at DESC LIMIT 12;

#	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 942)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container6CLKaCV\PaginatorProxy9cc2a8f->paginate (line 443)
16	App\Controller\Main\AnnonceController->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.86 ms
(0.51%)

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_de80b2c2ec49eff96c8102ef54ea4f18->doDisplay (line 402)
9	Twig\Template->yield (line 133)
10	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->block_main (line 446)
11	Twig\Template->yieldBlock (line 603)
12	__TwigTemplate_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_05a095aaa1f882e692094cc8e3e33073->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 465)
23	App\Controller\Main\AnnonceController->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)

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\Categorie	No errors.
App\Entity\User	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\Note	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/listes-des-annonces

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping