Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.92 ms Query time

16 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.33 ms
(36.20%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.type_user AS type_user_9, t0.date_creation AS date_creation_10, t0.adresse AS adresse_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.statut AS statut_14, t0.reference AS reference_15, t0.lieu_vente_id AS lieu_vente_id_16, t0.region_id AS region_id_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.telephone AS telephone_7,
  t0.email AS email_8,
  t0.type_user AS type_user_9,
  t0.date_creation AS date_creation_10,
  t0.adresse AS adresse_11,
  t0.ville AS ville_12,
  t0.pays AS pays_13,
  t0.statut AS statut_14,
  t0.reference AS reference_15,
  t0.lieu_vente_id AS lieu_vente_id_16,
  t0.region_id AS region_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.type_user AS type_user_9, t0.date_creation AS date_creation_10, t0.adresse AS adresse_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.statut AS statut_14, t0.reference AS reference_15, t0.lieu_vente_id AS lieu_vente_id_16, t0.region_id AS region_id_17 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 73)
10	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 44)
12	Symfony\Bridge\Twig\AppVariable->getUser (line 103)
13	Twig\Extension\CoreExtension->getAttribute (line 1919)
14	__TwigTemplate_38ae19ba68bbde1ae40dd18ad549883c::block_body (line 153)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_dfc625d7ba11e11748f6f86e9f49464f->doDisplay (line 96)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_38ae19ba68bbde1ae40dd18ad549883c->doDisplay (line 54)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
27	App\Controller\SecurityController->login (line 44)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 208)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

0.32 ms
(34.34%)

SELECT t0.id AS id_1, t0.numero_licence AS numero_licence_2, t0.date_debut AS date_debut_3, t0.datefin AS datefin_4, t0.statut AS statut_5, t0.statut_site_web AS statut_site_web_6, t0.tarif AS tarif_7, t0.type_licence AS type_licence_8, t0.lien_paiement AS lien_paiement_9, t0.entreprise_id AS entreprise_id_10 FROM licence t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero_licence AS numero_licence_2,
  t0.date_debut AS date_debut_3,
  t0.datefin AS datefin_4,
  t0.statut AS statut_5,
  t0.statut_site_web AS statut_site_web_6,
  t0.tarif AS tarif_7,
  t0.type_licence AS type_licence_8,
  t0.lien_paiement AS lien_paiement_9,
  t0.entreprise_id AS entreprise_id_10
FROM
  licence t0
LIMIT
  1

SELECT t0.id AS id_1, t0.numero_licence AS numero_licence_2, t0.date_debut AS date_debut_3, t0.datefin AS datefin_4, t0.statut AS statut_5, t0.statut_site_web AS statut_site_web_6, t0.tarif AS tarif_7, t0.type_licence AS type_licence_8, t0.lien_paiement AS lien_paiement_9, t0.entreprise_id AS entreprise_id_10 FROM licence t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\SecurityController->login (line 17)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.27 ms
(29.46%)

SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise 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_entreprise AS nom_entreprise_2,
  t0.identifiant AS identifiant_3,
  t0.numero_agrement AS numero_agrement_4,
  t0.adresse AS adresse_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Entreprise::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Entreprise->__get (line 184)
7	App\Entity\Entreprise->getLogo (line 121)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_dfc625d7ba11e11748f6f86e9f49464f::doDisplay (line 79)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_38ae19ba68bbde1ae40dd18ad549883c->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
20	App\Controller\SecurityController->login (line 44)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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\Licence	1
App\Entity\Entreprise	1
App\Entity\User	1
App\Entity\LieuxVentes	1
App\Entity\Region	1

Entities Mapping

Class	Mapping errors
App\Entity\Licence	No errors.
App\Entity\Entreprise	No errors.
App\Entity\LieuxVentes	No errors.
App\Entity\User	No errors.
App\Entity\Region	No errors.
App\Entity\ListeStock	No errors.
App\Entity\Personnel	No errors.
App\Entity\Client	No errors.
App\Entity\ListeInventaire	No errors.
App\Entity\Inventaire	No errors.
App\Entity\MouvementProduct	No errors.
App\Entity\AnomalieProduit	No errors.
App\Entity\ListeTransfertProduct	No errors.
App\Entity\TransfertProducts	The mappings App\Entity\TransfertProducts#traitePar and App\Entity\User#transfertProduct are inconsistent with each other.
App\Entity\AchatFournisseur	No errors.
App\Entity\ListeProductAchatFournisseur	No errors.
App\Entity\Decaissement	No errors.
App\Entity\MouvementCollaborateur	No errors.
App\Entity\BonCommandeFournisseur	No errors.
App\Entity\AbsencesPersonnels	No errors.
App\Entity\PrimesPersonnel	The mappings App\Entity\PrimesPersonnel#saisiePar and App\Entity\User#primesPersonnels are inconsistent with each other.
App\Entity\AvanceSalaire	The association App\Entity\AvanceSalaire#devise refers to the inverse side field App\Entity\Devise#avanceSalaires which does not exist.
App\Entity\PaiementSalairePersonnel	The mappings App\Entity\PaiementSalairePersonnel#saisiePar and App\Entity\User#paiementSalairePersonnels are inconsistent with each other. The association App\Entity\PaiementSalairePersonnel#compteRetrait refers to the inverse side field App\Entity\Caisse#paiementSalairePersonnels which does not exist. The association App\Entity\PaiementSalairePersonnel#typePaiement refers to the inverse side field App\Entity\ModePaiement#paiementSalairePersonnels which does not exist. The association App\Entity\PaiementSalairePersonnel#devise refers to the inverse side field App\Entity\Devise#paiementSalairePersonnels which does not exist.
App\Entity\ModifDecaissement	No errors.
App\Entity\Depenses	No errors.
App\Entity\Versement	No errors.
App\Entity\Modification	The mappings App\Entity\Modification#traitePar and App\Entity\User#modifications are inconsistent with each other.
App\Entity\TransfertFond	The mappings App\Entity\TransfertFond#caisseReception and App\Entity\Caisse#transfertFonds are inconsistent with each other. The mappings App\Entity\TransfertFond#envoyePar and App\Entity\User#transfertFonds are inconsistent with each other.
App\Entity\ChequeEspece	The mappings App\Entity\ChequeEspece#caisseRetrait and App\Entity\Caisse#chequeEspeces are inconsistent with each other. The mappings App\Entity\ChequeEspece#saisiePar and App\Entity\User#chequeEspeces are inconsistent with each other.
App\Entity\Recette	No errors.
App\Entity\AjustementSolde	No errors.
App\Entity\Livraison	No errors.
App\Entity\Facturation	The mappings App\Entity\Facturation#saisiePar and App\Entity\User#facturations are inconsistent with each other.
App\Entity\CommissionVente	No errors.
App\Entity\ModificationFacture	The mappings App\Entity\ModificationFacture#client and App\Entity\User#modificationFactures are inconsistent with each other.
App\Entity\Proformat	The mappings App\Entity\Proformat#saisiePar and App\Entity\User#proformats are inconsistent with each other.
App\Entity\SuppressionFacture	No errors.
App\Entity\RetourProduct	The association App\Entity\RetourProduct#lieuVente refers to the inverse side field App\Entity\LieuxVentes#retourProducts which does not exist.
App\Entity\EchangeDevise	The mappings App\Entity\EchangeDevise#caisseDestination and App\Entity\Caisse#echangeDevises are inconsistent with each other. The mappings App\Entity\EchangeDevise#deviseDestination and App\Entity\Devise#echangeDevises are inconsistent with each other.
App\Entity\MouvementCaisse	No errors.
App\Entity\GestionCheque	The mappings App\Entity\GestionCheque#caisseReception and App\Entity\Caisse#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#lieuVenteReception and App\Entity\LieuxVentes#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#envoyePar and App\Entity\User#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#collaborateur and App\Entity\User#gestionCheques are inconsistent with each other.
App\Entity\ClotureCaisse	No errors.
App\Entity\RetourProductFournisseur	No errors.
App\Entity\FactureFrais	The mappings App\Entity\FactureFrais#personnel and App\Entity\User#factureFrais are inconsistent with each other.
App\Entity\ListeProductAchatFournisseurFrais	No errors.
App\Entity\ListeProductAchatFournisseurMultiple	No errors.
App\Entity\AchatFournisseurGeneral	The mappings App\Entity\AchatFournisseurGeneral#personnel and App\Entity\User#achatFournisseurGenerals are inconsistent with each other.
App\Entity\Promotion	The mappings App\Entity\Promotion#produitBonus and App\Entity\Products#promotions are inconsistent with each other. If association App\Entity\Promotion#produitBonus is many-to-one, then the inversed side App\Entity\Products#promotions has to be one-to-many.
App\Entity\SortieStock	No errors.
App\Entity\ClotureAnnuel	No errors.
App\Entity\HistoriqueChangement	No errors.

Symfony Profiler

GET https://etselboubacarbalde.damkocompany.com/public/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping