Symfony Profiler

Query Metrics

122 Database Queries

5 Different statements

93.59 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

79.22 ms
(84.65%)

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 53)
11	__TwigTemplate_81b2348cbc0f163bc5e5187c1c480ba7->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 24)
20	App\Controller\SecurityController->login (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)

5.69 ms
(6.08%)

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 53)
10	__TwigTemplate_81b2348cbc0f163bc5e5187c1c480ba7->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 24)
19	App\Controller\SecurityController->login (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)

3.29 ms
(3.52%)

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

Parameters:

[]

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 995)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 24)
5	App\Controller\SecurityController->login (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

3.19 ms
(3.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 53)
7	__TwigTemplate_81b2348cbc0f163bc5e5187c1c480ba7->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 24)
16	App\Controller\SecurityController->login (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)

2.20 ms
(2.35%)

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 53)
7	__TwigTemplate_81b2348cbc0f163bc5e5187c1c480ba7->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 24)
16	App\Controller\SecurityController->login (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)

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\User	No errors.
App\Entity\Adresse	No errors.
App\Entity\Phone	No 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\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\Litige	No errors.
App\Entity\LitigeEtape	No errors.
App\Entity\LitigeMessage	No errors.
App\Entity\LitigeAnalyse	No errors.
App\Entity\Note	No errors.
App\Entity\Signalement	No errors.
App\Entity\ModerationActions	No errors.
App\Entity\DemandeRetraitSanction	No errors.
App\Entity\Notification	No errors.
App\Entity\AnnonceModeration	No errors.
App\Entity\Categorie	No errors.
App\Entity\CategorieChamp	No errors.
App\Entity\Options	No errors.

Symfony Profiler

GET https://www.test.annonce221.com/se-connecter

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping