Symfony Profiler

Query Metrics

123 Database Queries

6 Different statements

115.29 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

102.54 ms
(88.94%)

109

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 58)
11	__TwigTemplate_504f9acbd2515a81b635ee748a6121eb->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 175)
20	App\Controller\Main\LitigeController->annonce_litige (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)

8.44 ms
(7.32%)

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 58)
10	__TwigTemplate_504f9acbd2515a81b635ee748a6121eb->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 175)
19	App\Controller\Main\LitigeController->annonce_litige (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.13 ms
(1.85%)

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 58)
7	__TwigTemplate_504f9acbd2515a81b635ee748a6121eb->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 175)
16	App\Controller\Main\LitigeController->annonce_litige (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.85 ms
(0.73%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.titre AS titre_4, t0.limite_at AS limite_at_5, t0.nombre_de_vues AS nombre_de_vues_6, t0.publication_at AS publication_at_7, t0.prix AS prix_8, t0.start_at AS start_at_9, t0.slug AS slug_10, t0.statut AS statut_11, t0.numero_annonce AS numero_annonce_12, t0.region AS region_13, t0.ville AS ville_14, t0.quartier AS quartier_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.es_negociable AS es_negociable_18, t0.vedette AS vedette_19, t0.is_annonce_deleted AS is_annonce_deleted_20, t0.annonce_deleted_at AS annonce_deleted_at_21, t0.disponibilite AS disponibilite_22, t0.temps_de_reponse AS temps_de_reponse_23, t0.telephone AS telephone_24, t0.whatsapp AS whatsapp_25, t0.user_id AS user_id_26, t0.categorie_id AS categorie_id_27, t0.supprime_paradmin_id AS supprime_paradmin_id_28 FROM annonce t0 WHERE t0.id = ?

Parameters:

[
  "126"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.created_at AS created_at_3,
  t0.titre AS titre_4,
  t0.limite_at AS limite_at_5,
  t0.nombre_de_vues AS nombre_de_vues_6,
  t0.publication_at AS publication_at_7,
  t0.prix AS prix_8,
  t0.start_at AS start_at_9,
  t0.slug AS slug_10,
  t0.statut AS statut_11,
  t0.numero_annonce AS numero_annonce_12,
  t0.region AS region_13,
  t0.ville AS ville_14,
  t0.quartier AS quartier_15,
  t0.latitude AS latitude_16,
  t0.longitude AS longitude_17,
  t0.es_negociable AS es_negociable_18,
  t0.vedette AS vedette_19,
  t0.is_annonce_deleted AS is_annonce_deleted_20,
  t0.annonce_deleted_at AS annonce_deleted_at_21,
  t0.disponibilite AS disponibilite_22,
  t0.temps_de_reponse AS temps_de_reponse_23,
  t0.telephone AS telephone_24,
  t0.whatsapp AS whatsapp_25,
  t0.user_id AS user_id_26,
  t0.categorie_id AS categorie_id_27,
  t0.supprime_paradmin_id AS supprime_paradmin_id_28
FROM
  annonce t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.titre AS titre_4, t0.limite_at AS limite_at_5, t0.nombre_de_vues AS nombre_de_vues_6, t0.publication_at AS publication_at_7, t0.prix AS prix_8, t0.start_at AS start_at_9, t0.slug AS slug_10, t0.statut AS statut_11, t0.numero_annonce AS numero_annonce_12, t0.region AS region_13, t0.ville AS ville_14, t0.quartier AS quartier_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.es_negociable AS es_negociable_18, t0.vedette AS vedette_19, t0.is_annonce_deleted AS is_annonce_deleted_20, t0.annonce_deleted_at AS annonce_deleted_at_21, t0.disponibilite AS disponibilite_22, t0.temps_de_reponse AS temps_de_reponse_23, t0.telephone AS telephone_24, t0.whatsapp AS whatsapp_25, t0.user_id AS user_id_26, t0.categorie_id AS categorie_id_27, t0.supprime_paradmin_id AS supprime_paradmin_id_28 FROM annonce t0 WHERE t0.id = '126';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.76 ms
(0.66%)

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_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
6	Twig\Template->yield (line 58)
7	__TwigTemplate_504f9acbd2515a81b635ee748a6121eb->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 175)
16	App\Controller\Main\LitigeController->annonce_litige (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.59 ms
(0.51%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.avatar AS avatar_7, t0.is_verified AS is_verified_8, t0.status AS status_9, t0.token AS token_10, t0.username AS username_11, t0.created_at AS created_at_12, t0.type_compte AS type_compte_13, t0.a_propos_de_moi AS a_propos_de_moi_14, t0.credit AS credit_15, t0.note AS note_16, t0.is_bloqued AS is_bloqued_17, t0.bloqued_until AS bloqued_until_18, t0.is_compte_deleted AS is_compte_deleted_19, t0.compte_deleted_at AS compte_deleted_at_20, t0.new_email AS new_email_21, t0.email_change_token AS email_change_token_22, t0.email_change_requested_at AS email_change_requested_at_23, t0.last_activity_at AS last_activity_at_24, t0.api_key AS api_key_25, t0.adresse_id AS adresse_id_26, t0.compte_supprime_id AS compte_supprime_id_27 FROM user t0 WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.avatar AS avatar_7,
  t0.is_verified AS is_verified_8,
  t0.status AS status_9,
  t0.token AS token_10,
  t0.username AS username_11,
  t0.created_at AS created_at_12,
  t0.type_compte AS type_compte_13,
  t0.a_propos_de_moi AS a_propos_de_moi_14,
  t0.credit AS credit_15,
  t0.note AS note_16,
  t0.is_bloqued AS is_bloqued_17,
  t0.bloqued_until AS bloqued_until_18,
  t0.is_compte_deleted AS is_compte_deleted_19,
  t0.compte_deleted_at AS compte_deleted_at_20,
  t0.new_email AS new_email_21,
  t0.email_change_token AS email_change_token_22,
  t0.email_change_requested_at AS email_change_requested_at_23,
  t0.last_activity_at AS last_activity_at_24,
  t0.api_key AS api_key_25,
  t0.adresse_id AS adresse_id_26,
  t0.compte_supprime_id AS compte_supprime_id_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.avatar AS avatar_7, t0.is_verified AS is_verified_8, t0.status AS status_9, t0.token AS token_10, t0.username AS username_11, t0.created_at AS created_at_12, t0.type_compte AS type_compte_13, t0.a_propos_de_moi AS a_propos_de_moi_14, t0.credit AS credit_15, t0.note AS note_16, t0.is_bloqued AS is_bloqued_17, t0.bloqued_until AS bloqued_until_18, t0.is_compte_deleted AS is_compte_deleted_19, t0.compte_deleted_at AS compte_deleted_at_20, t0.new_email AS new_email_21, t0.email_change_token AS email_change_token_22, t0.email_change_requested_at AS email_change_requested_at_23, t0.last_activity_at AS last_activity_at_24, t0.api_key AS api_key_25, t0.adresse_id AS adresse_id_26, t0.compte_supprime_id AS compte_supprime_id_27 FROM user t0 WHERE t0.id = 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 369)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 479)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\User->__get (line 487)
8	App\Entity\User->getFullName (line 1913)
9	Twig\Extension\CoreExtension::getAttribute (line 400)
10	__TwigTemplate_504f9acbd2515a81b635ee748a6121eb->block_main (line 446)
11	Twig\Template->yieldBlock (line 603)
12	__TwigTemplate_bdefc0b4fad78721f37e7a338558ba40->doDisplay (line 402)
13	Twig\Template->yield (line 58)
14	__TwigTemplate_504f9acbd2515a81b635ee748a6121eb->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 175)
23	App\Controller\Main\LitigeController->annonce_litige (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\User	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\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\Adresse	No errors.
App\Entity\Phone	No errors.
App\Entity\UserSetting	No errors.
App\Entity\Credit	No errors.
App\Entity\Certification	No errors.
App\Entity\RelanceCertification	No errors.
App\Entity\ActionRelanceNormalise	No errors.
App\Entity\ModificationRelanceApporte	No errors.
App\Entity\CentreInteret	No errors.
App\Entity\LitigeEtape	No errors.
App\Entity\LitigeMessage	No errors.
App\Entity\LitigeAnalyse	No errors.
App\Entity\DemandeRetraitSanction	No errors.
App\Entity\Notification	No errors.
App\Entity\Options	No errors.

Symfony Profiler

GET https://www.test.annonce221.com/litige/annonce/126/Annonce-13

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping