Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.15 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.55 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.created_at AS created_at_5, t0.actif AS actif_6, t0.impersonator AS impersonator_7, t0.label AS label_8, t0.client_id AS client_id_9, t10.id AS id_11, t10.idUtilisateur AS idUtilisateur_12, t10.idtiers AS idtiers_13, t10.statut AS statut_14, t10.idCommercial AS idCommercial_15, t10.NomAlt AS NomAlt_16, t10.Sweb AS Sweb_17, t10.Fax AS Fax_18, t10.STAT AS STAT_19, t10.RCS AS RCS_20, t10.NIF AS NIF_21, t10.AssTva AS AssTva_22, t10.NumTva AS NumTva_23, t10.FormeJur AS FormeJur_24, t10.Effectif AS Effectif_25, t10.typetiers AS typetiers_26, t10.source AS source_27, t10.gender AS gender_28, t10.nompr AS nompr_29, t10.prenompr AS prenompr_30, t10.phonepr AS phonepr_31, t10.interes AS interes_32, t10.degr AS degr_33, t10.datec AS datec_34, t10.datetra AS datetra_35, t10.tra AS tra_36, t10.majnote AS majnote_37, t10.datemaj AS datemaj_38, t10.superficie AS superficie_39, t10.action AS action_40, t10.phonepr2 AS phonepr2_41, t10.budget AS budget_42, t10.status AS status_43, t10.urgence AS urgence_44, t10.provinces AS provinces_45, t10.axe AS axe_46, t10.projet AS projet_47, t10.created_at AS created_at_48, t10.emailpr AS emailpr_49, t10.client_user_id AS client_user_id_50 FROM client_user t0 LEFT JOIN tiers t10 ON t10.client_user_id = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "hasinandriamah@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.created_at AS created_at_5,
  t0.actif AS actif_6,
  t0.impersonator AS impersonator_7,
  t0.label AS label_8,
  t0.client_id AS client_id_9,
  t10.id AS id_11,
  t10.idUtilisateur AS idUtilisateur_12,
  t10.idtiers AS idtiers_13,
  t10.statut AS statut_14,
  t10.idCommercial AS idCommercial_15,
  t10.NomAlt AS NomAlt_16,
  t10.Sweb AS Sweb_17,
  t10.Fax AS Fax_18,
  t10.STAT AS STAT_19,
  t10.RCS AS RCS_20,
  t10.NIF AS NIF_21,
  t10.AssTva AS AssTva_22,
  t10.NumTva AS NumTva_23,
  t10.FormeJur AS FormeJur_24,
  t10.Effectif AS Effectif_25,
  t10.typetiers AS typetiers_26,
  t10.source AS source_27,
  t10.gender AS gender_28,
  t10.nompr AS nompr_29,
  t10.prenompr AS prenompr_30,
  t10.phonepr AS phonepr_31,
  t10.interes AS interes_32,
  t10.degr AS degr_33,
  t10.datec AS datec_34,
  t10.datetra AS datetra_35,
  t10.tra AS tra_36,
  t10.majnote AS majnote_37,
  t10.datemaj AS datemaj_38,
  t10.superficie AS superficie_39,
  t10.action AS action_40,
  t10.phonepr2 AS phonepr2_41,
  t10.budget AS budget_42,
  t10.status AS status_43,
  t10.urgence AS urgence_44,
  t10.provinces AS provinces_45,
  t10.axe AS axe_46,
  t10.projet AS projet_47,
  t10.created_at AS created_at_48,
  t10.emailpr AS emailpr_49,
  t10.client_user_id AS client_user_id_50
FROM
  client_user t0
  LEFT JOIN tiers t10 ON t10.client_user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.created_at AS created_at_5, t0.actif AS actif_6, t0.impersonator AS impersonator_7, t0.label AS label_8, t0.client_id AS client_id_9, t10.id AS id_11, t10.idUtilisateur AS idUtilisateur_12, t10.idtiers AS idtiers_13, t10.statut AS statut_14, t10.idCommercial AS idCommercial_15, t10.NomAlt AS NomAlt_16, t10.Sweb AS Sweb_17, t10.Fax AS Fax_18, t10.STAT AS STAT_19, t10.RCS AS RCS_20, t10.NIF AS NIF_21, t10.AssTva AS AssTva_22, t10.NumTva AS NumTva_23, t10.FormeJur AS FormeJur_24, t10.Effectif AS Effectif_25, t10.typetiers AS typetiers_26, t10.source AS source_27, t10.gender AS gender_28, t10.nompr AS nompr_29, t10.prenompr AS prenompr_30, t10.phonepr AS phonepr_31, t10.interes AS interes_32, t10.degr AS degr_33, t10.datec AS datec_34, t10.datetra AS datetra_35, t10.tra AS tra_36, t10.majnote AS majnote_37, t10.datemaj AS datemaj_38, t10.superficie AS superficie_39, t10.action AS action_40, t10.phonepr2 AS phonepr2_41, t10.budget AS budget_42, t10.status AS status_43, t10.urgence AS urgence_44, t10.provinces AS provinces_45, t10.axe AS axe_46, t10.projet AS projet_47, t10.created_at AS created_at_48, t10.emailpr AS emailpr_49, t10.client_user_id AS client_user_id_50 FROM client_user t0 LEFT JOIN tiers t10 ON t10.client_user_id = t0.id WHERE t0.email = 'hasinandriamah@gmail.com' 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 54)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.60 ms

SELECT t0.id AS id_1, t0.reftier AS reftier_2, t0.gender AS gender_3, t0.dep AS dep_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.phone AS phone_11, t0.cin AS cin_12, t0.datenaiss AS datenaiss_13, t0.lieunaiss AS lieunaiss_14, t0.phone2 AS phone2_15, t0.facebook AS facebook_16, t0.etatcivil AS etatcivil_17, t0.besoin AS besoin_18, t0.profession AS profession_19, t0.hierarchie AS hierarchie_20, t0.decideurs AS decideurs_21, t0.etat_mat AS etat_mat_22, t0.email AS email_23, t0.nationalite AS nationalite_24, t0.email_pro AS email_pro_25, t26.id AS id_27, t26.email AS email_28, t26.password AS password_29, t26.roles AS roles_30, t26.created_at AS created_at_31, t26.actif AS actif_32, t26.impersonator AS impersonator_33, t26.label AS label_34, t26.client_id AS client_id_35 FROM fos_user t0 LEFT JOIN client_user t26 ON t26.client_id = t0.id WHERE t0.id = ?

Parameters:

[
  1768
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reftier AS reftier_2,
  t0.gender AS gender_3,
  t0.dep AS dep_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.address AS address_7,
  t0.zip_code AS zip_code_8,
  t0.city AS city_9,
  t0.country AS country_10,
  t0.phone AS phone_11,
  t0.cin AS cin_12,
  t0.datenaiss AS datenaiss_13,
  t0.lieunaiss AS lieunaiss_14,
  t0.phone2 AS phone2_15,
  t0.facebook AS facebook_16,
  t0.etatcivil AS etatcivil_17,
  t0.besoin AS besoin_18,
  t0.profession AS profession_19,
  t0.hierarchie AS hierarchie_20,
  t0.decideurs AS decideurs_21,
  t0.etat_mat AS etat_mat_22,
  t0.email AS email_23,
  t0.nationalite AS nationalite_24,
  t0.email_pro AS email_pro_25,
  t26.id AS id_27,
  t26.email AS email_28,
  t26.password AS password_29,
  t26.roles AS roles_30,
  t26.created_at AS created_at_31,
  t26.actif AS actif_32,
  t26.impersonator AS impersonator_33,
  t26.label AS label_34,
  t26.client_id AS client_id_35
FROM
  fos_user t0
  LEFT JOIN client_user t26 ON t26.client_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reftier AS reftier_2, t0.gender AS gender_3, t0.dep AS dep_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.phone AS phone_11, t0.cin AS cin_12, t0.datenaiss AS datenaiss_13, t0.lieunaiss AS lieunaiss_14, t0.phone2 AS phone2_15, t0.facebook AS facebook_16, t0.etatcivil AS etatcivil_17, t0.besoin AS besoin_18, t0.profession AS profession_19, t0.hierarchie AS hierarchie_20, t0.decideurs AS decideurs_21, t0.etat_mat AS etat_mat_22, t0.email AS email_23, t0.nationalite AS nationalite_24, t0.email_pro AS email_pro_25, t26.id AS id_27, t26.email AS email_28, t26.password AS password_29, t26.roles AS roles_30, t26.created_at AS created_at_31, t26.actif AS actif_32, t26.impersonator AS impersonator_33, t26.label AS label_34, t26.client_id AS client_id_35 FROM fos_user t0 LEFT JOIN client_user t26 ON t26.client_id = t0.id WHERE t0.id = 1768;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\FosUser::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\FosUser->__get (line 231)
8	App\Entity\FosUser->getFirstname (line 200)
9	App\Controller\Api\ClientAuthController->me (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\ClientUser	No errors.
App\Entity\FosUser	The field App\Entity\FosUser#clientUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ClientUser#client does not contain the required 'inversedBy="clientUser"' attribute. The association App\Entity\FosUser#tiers refers to the owning side field App\Entity\Tiers#commercial which does not exist.
App\Entity\Tiers	No errors.
App\Entity\ActionAf	No errors.
App\Entity\RedispacheTo	No errors.
App\Entity\ObservationClient	No errors.
App\Entity\Parrainage	No errors.

Symfony Profiler

GET https://app.master-immo.net/api/client/me

Configuration Settings

Theme