Symfony Profiler

Query Metrics

12 Database Queries

2 Different statements

6.15 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.44 ms
(88.45%)

SELECT t0.id AS id_1, t0.app_name AS app_name_2, t0.app_version AS app_version_3, t0.description AS description_4, t0.nom_entreprise AS nom_entreprise_5, t0.sigle_entreprise AS sigle_entreprise_6, t0.nom_institution AS nom_institution_7, t0.nom_pays AS nom_pays_8, t0.devise_pays AS devise_pays_9, t0.responsable AS responsable_10, t0.logo_entreprise_id AS logo_entreprise_id_11, t0.logo_pied_page_id AS logo_pied_page_id_12 FROM global_param t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.app_name AS app_name_2,
  t0.app_version AS app_version_3,
  t0.description AS description_4,
  t0.nom_entreprise AS nom_entreprise_5,
  t0.sigle_entreprise AS sigle_entreprise_6,
  t0.nom_institution AS nom_institution_7,
  t0.nom_pays AS nom_pays_8,
  t0.devise_pays AS devise_pays_9,
  t0.responsable AS responsable_10,
  t0.logo_entreprise_id AS logo_entreprise_id_11,
  t0.logo_pied_page_id AS logo_pied_page_id_12
FROM
  global_param t0
LIMIT
  1

SELECT t0.id AS id_1, t0.app_name AS app_name_2, t0.app_version AS app_version_3, t0.description AS description_4, t0.nom_entreprise AS nom_entreprise_5, t0.sigle_entreprise AS sigle_entreprise_6, t0.nom_institution AS nom_institution_7, t0.nom_pays AS nom_pays_8, t0.devise_pays AS devise_pays_9, t0.responsable AS responsable_10, t0.logo_entreprise_id AS logo_entreprise_id_11, t0.logo_pied_page_id AS logo_pied_page_id_12 FROM global_param t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 48)
4	App\Controller\GlobalParamController->getErhParams (line 1637)
5	twig_get_attribute (line 55)
6	__TwigTemplate_f69329e4727559c76cb0d7dc36a86c13->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 49)
9	__TwigTemplate_22852b8dfad4e973f170f40724ff49af->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 40)
13	Twig\TemplateWrapper->render (line 280)
14	Twig\Environment->render (line 243)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 24)
17	App\Controller\SecurityController->login (line 182)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.71 ms
(11.55%)

SELECT t0.id AS id_1, t0.nom_reel_objet AS nom_reel_objet_2, t0.reference_pj AS reference_pj_3, t0.updated_at AS updated_at_4, t0.origin_name AS origin_name_5, t0.date_pj AS date_pj_6, t0.id_objet AS id_objet_7, t0.auteur_id AS auteur_id_8, t0.proprietaire_id AS proprietaire_id_9, t0.type_pj_id AS type_pj_id_10, t0.demande_id AS demande_id_11, t0.personne_id AS personne_id_12 FROM piece_jointe t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_reel_objet AS nom_reel_objet_2,
  t0.reference_pj AS reference_pj_3,
  t0.updated_at AS updated_at_4,
  t0.origin_name AS origin_name_5,
  t0.date_pj AS date_pj_6,
  t0.id_objet AS id_objet_7,
  t0.auteur_id AS auteur_id_8,
  t0.proprietaire_id AS proprietaire_id_9,
  t0.type_pj_id AS type_pj_id_10,
  t0.demande_id AS demande_id_11,
  t0.personne_id AS personne_id_12
FROM
  piece_jointe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_reel_objet AS nom_reel_objet_2, t0.reference_pj AS reference_pj_3, t0.updated_at AS updated_at_4, t0.origin_name AS origin_name_5, t0.date_pj AS date_pj_6, t0.id_objet AS id_objet_7, t0.auteur_id AS auteur_id_8, t0.proprietaire_id AS proprietaire_id_9, t0.type_pj_id AS type_pj_id_10, t0.demande_id AS demande_id_11, t0.personne_id AS personne_id_12 FROM piece_jointe t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 111)
7	Proxies\__CG__\App\Entity\PieceJointe->__load (line 96)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromFirstField (line 121)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 60)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 35)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 28)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 67)
13	__TwigTemplate_f69329e4727559c76cb0d7dc36a86c13->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 49)
16	__TwigTemplate_22852b8dfad4e973f170f40724ff49af->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 40)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 243)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 24)
24	App\Controller\SecurityController->login (line 182)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\GlobalParam	No errors.
App\Entity\PieceJointe	No errors.
App\Entity\Agent	No errors.
App\Entity\TypePieceJointe	No errors.
App\Entity\Demande	No errors.
App\Entity\Personne	No errors.

Symfony Profiler

GET https://erhv2.dge.ci/login

Configuration Settings

Theme