Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.67 ms Query time

1 Invalid entities

40 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.84 ms

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "guermassimoheddine@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.token_password AS token_password_8,
  t0.token_activate AS token_activate_9,
  t0.nom AS nom_10,
  t0.prenom AS prenom_11,
  t0.created_at AS created_at_12,
  t0.the_statut_id AS the_statut_id_13,
  t0.mobile AS mobile_14,
  t0.reference AS reference_15,
  t0.the_type_id AS the_type_id_16,
  t0.the_role_principal_id AS the_role_principal_id_17,
  t0.photo AS photo_18,
  t0.updated_at AS updated_at_19,
  t0.discr,
  t2.tarif_horaire AS tarif_horaire_20,
  t2.client_id AS client_id_21,
  t3.client_id AS client_id_22,
  t3.bailleur_id AS bailleur_id_23
FROM
  user t0
  LEFT JOIN user_admin t1 ON t0.id = t1.id
  LEFT JOIN user_client t2 ON t0.id = t2.id
  LEFT JOIN user_bailleur t3 ON t0.id = t3.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.email = 'guermassimoheddine@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 91)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.49 ms

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.email AS email_10, t0.the_statut_id AS the_statut_id_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.sous_domaine AS sous_domaine_13, t0.capital AS capital_14, t0.num_tva_intra AS num_tva_intra_15, t0.footer_devis AS footer_devis_16, t0.secteurs_id AS secteurs_id_17 FROM clients t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.raison_sociale AS raison_sociale_3,
  t0.siret AS siret_4,
  t0.reference_index AS reference_index_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.email AS email_10,
  t0.the_statut_id AS the_statut_id_11,
  t0.stripe_customer_id AS stripe_customer_id_12,
  t0.sous_domaine AS sous_domaine_13,
  t0.capital AS capital_14,
  t0.num_tva_intra AS num_tva_intra_15,
  t0.footer_devis AS footer_devis_16,
  t0.secteurs_id AS secteurs_id_17
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.email AS email_10, t0.the_statut_id AS the_statut_id_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.sous_domaine AS sous_domaine_13, t0.capital AS capital_14, t0.num_tva_intra AS num_tva_intra_15, t0.footer_devis AS footer_devis_16, t0.secteurs_id AS secteurs_id_17 FROM clients t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Clients::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Clients->__get (line 161)
8	App\Entity\Clients->getReference (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 784)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 134)
14	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 71)
15	App\ApiResource\Serializer\CommonSerializer->normalize (line 50)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->normalize (line 131)
18	Symfony\Component\Serializer\Serializer->serialize (line 44)
19	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
20	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
21	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.34 ms

SELECT t0.id AS id_1, t0.the_action_id AS the_action_id_2, t0.the_user_role_id AS the_user_role_id_3, t0.the_module_id AS the_module_id_4 FROM permission t0 WHERE t0.the_user_role_id = ?

Parameters:

[
  "ROLE_CLIENT_TECHNICIEN"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.the_action_id AS the_action_id_2,
  t0.the_user_role_id AS the_user_role_id_3,
  t0.the_module_id AS the_module_id_4
FROM
  permission t0
WHERE
  t0.the_user_role_id = ?

SELECT t0.id AS id_1, t0.the_action_id AS the_action_id_2, t0.the_user_role_id AS the_user_role_id_3, t0.the_module_id AS the_module_id_4 FROM permission t0 WHERE t0.the_user_role_id = 'ROLE_CLIENT_TECHNICIEN';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 66)
5	App\Service\EspaceClientService->getPermissions (line 106)
6	App\Service\EspaceClientService->hasPermission (line 84)
7	App\Service\EspaceClientService->getApiPermissions (line 74)
8	App\ApiResource\Serializer\CommonSerializer->normalize (line 50)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
10	Symfony\Component\Serializer\Serializer->normalize (line 131)
11	Symfony\Component\Serializer\Serializer->serialize (line 44)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
13	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
14	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Permission	37
App\Entity\User	1
App\Entity\Clients	1
App\Entity\Secteurs	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserAdmin	No errors.
App\Entity\UserClient	The association App\Entity\UserClient#inspectionTechnicien refers to the owning side field App\Entity\Inspection#technicien which does not exist.
App\Entity\UserBailleur	No errors.
App\Entity\Clients	No errors.
App\Entity\Bailleurs	No errors.
App\Entity\Inspection	No errors.
App\Entity\Intervention	No errors.
App\Entity\Commande	No errors.
App\Entity\Secteurs	No errors.
App\Entity\Adresses	No errors.
App\Entity\Permission	No errors.

Symfony Profiler

GET https://fluxxo.fr/api/profil

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping