Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.02 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.87 ms
(28.90%)

SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = ? AND t0.deleted_at IS NULL

Parameters:

[
  "en attente de validation"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  objet_trouve t0
WHERE
  t0.statut = ?
  AND t0.deleted_at IS NULL

SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = 'en attente de validation' AND t0.deleted_at IS NULL;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Twig\ModerationExtension->getGlobals (line 31)
5	Twig\ExtensionSet->getGlobals (line 365)
6	Twig\Environment->getGlobals (line 908)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
15	App\Controller\Public\ContactController->index (line 22)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.77 ms
(25.39%)

SELECT COUNT(*) FROM reclamation t0 WHERE t0.statut = ?

Parameters:

[
  "soumis"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  reclamation t0
WHERE
  t0.statut = ?

SELECT COUNT(*) FROM reclamation t0 WHERE t0.statut = 'soumis';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Twig\ModerationExtension->getGlobals (line 32)
5	Twig\ExtensionSet->getGlobals (line 365)
6	Twig\Environment->getGlobals (line 908)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
15	App\Controller\Public\ContactController->index (line 22)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.73 ms
(24.07%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.email_principal AS email_principal_3, t0.email_contact AS email_contact_4, t0.telephone AS telephone_5, t0.whatsapp AS whatsapp_6, t0.adresse AS adresse_7, t0.facebook AS facebook_8, t0.instagram AS instagram_9, t0.twitter AS twitter_10, t0.is_maintenance_mode AS is_maintenance_mode_11, t0.maintenance_message AS maintenance_message_12, t0.logo AS logo_13, t0.description AS description_14 FROM global_setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.email_principal AS email_principal_3,
  t0.email_contact AS email_contact_4,
  t0.telephone AS telephone_5,
  t0.whatsapp AS whatsapp_6,
  t0.adresse AS adresse_7,
  t0.facebook AS facebook_8,
  t0.instagram AS instagram_9,
  t0.twitter AS twitter_10,
  t0.is_maintenance_mode AS is_maintenance_mode_11,
  t0.maintenance_message AS maintenance_message_12,
  t0.logo AS logo_13,
  t0.description AS description_14
FROM
  global_setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.email_principal AS email_principal_3, t0.email_contact AS email_contact_4, t0.telephone AS telephone_5, t0.whatsapp AS whatsapp_6, t0.adresse AS adresse_7, t0.facebook AS facebook_8, t0.instagram AS instagram_9, t0.twitter AS twitter_10, t0.is_maintenance_mode AS is_maintenance_mode_11, t0.maintenance_message AS maintenance_message_12, t0.logo AS logo_13, t0.description AS description_14 FROM global_setting t0 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	App\Repository\GlobalSettingRepository->getSettings (line 26)
5	App\Service\SettingService->getSettings (line 28)
6	App\Service\SettingService->isMaintenanceMode (line 41)
7	App\EventSubscriber\MaintenanceSubscriber->onKernelRequest (line 51)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.65 ms
(21.65%)

SELECT COUNT(*) FROM message_contact t0 WHERE t0.is_read = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  message_contact t0
WHERE
  t0.is_read = ?

SELECT COUNT(*) FROM message_contact t0 WHERE t0.is_read = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Twig\ModerationExtension->getGlobals (line 33)
5	Twig\ExtensionSet->getGlobals (line 365)
6	Twig\Environment->getGlobals (line 908)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
15	App\Controller\Public\ContactController->index (line 22)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\GlobalSetting	1

Entities Mapping

Class	Mapping errors
App\Entity\GlobalSetting	No errors.
App\Entity\ObjetTrouve	No errors.
App\Entity\Reclamation	No errors.
App\Entity\MessageContact	No errors.
App\Entity\User	No errors.
App\Entity\ObjetTrouveImage	No errors.
App\Entity\PreuveRestitution	No errors.
App\Entity\Litige	No errors.
App\Entity\AuditLog	No errors.
App\Entity\Categorie	No errors.
App\Entity\Deposeur	No errors.
App\Entity\FieldValue	No errors.
App\Entity\ObjetTrouveModeration	No errors.
App\Entity\ReclamationImage	No errors.

Symfony Profiler

GET https://test.objetstrouves221.com/contact

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping