Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.86 ms Query time

5 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.62 ms

SELECT t0.id AS id_1, t0.idClient AS idClient_2, t0.idghost AS idghost_3, t0.prixpdv AS prixpdv_4, t0.DatePDV AS DatePDV_5, t0.locat AS locat_6, t0.idCom AS idCom_7, t0.enabled AS enabled_8, t0.validate AS validate_9, t0.mut AS mut_10, t0.statPDV AS statPDV_11, t0.recstatus AS recstatus_12, t0.recrestetot AS recrestetot_13, t0.postponed AS postponed_14, t0.ravenant AS ravenant_15, t0.rannulation AS rannulation_16, t0.postponed_date AS postponed_date_17, t0.nextcloud_path AS nextcloud_path_18, t0.nextcloud_share_url AS nextcloud_share_url_19, t0.terrain_id AS terrain_id_20 FROM promesse t0 WHERE t0.id = ?

Parameters:

[
  1381
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idClient AS idClient_2,
  t0.idghost AS idghost_3,
  t0.prixpdv AS prixpdv_4,
  t0.DatePDV AS DatePDV_5,
  t0.locat AS locat_6,
  t0.idCom AS idCom_7,
  t0.enabled AS enabled_8,
  t0.validate AS validate_9,
  t0.mut AS mut_10,
  t0.statPDV AS statPDV_11,
  t0.recstatus AS recstatus_12,
  t0.recrestetot AS recrestetot_13,
  t0.postponed AS postponed_14,
  t0.ravenant AS ravenant_15,
  t0.rannulation AS rannulation_16,
  t0.postponed_date AS postponed_date_17,
  t0.nextcloud_path AS nextcloud_path_18,
  t0.nextcloud_share_url AS nextcloud_share_url_19,
  t0.terrain_id AS terrain_id_20
FROM
  promesse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.idClient AS idClient_2, t0.idghost AS idghost_3, t0.prixpdv AS prixpdv_4, t0.DatePDV AS DatePDV_5, t0.locat AS locat_6, t0.idCom AS idCom_7, t0.enabled AS enabled_8, t0.validate AS validate_9, t0.mut AS mut_10, t0.statPDV AS statPDV_11, t0.recstatus AS recstatus_12, t0.recrestetot AS recrestetot_13, t0.postponed AS postponed_14, t0.ravenant AS ravenant_15, t0.rannulation AS rannulation_16, t0.postponed_date AS postponed_date_17, t0.nextcloud_path AS nextcloud_path_18, t0.nextcloud_share_url AS nextcloud_share_url_19, t0.terrain_id AS terrain_id_20 FROM promesse t0 WHERE t0.id = 1381;

#	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 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 503)
6	App\Controller\Api\ClientSpaceController->resolveClientPromesse (line 176)
7	App\Controller\Api\ClientSpaceController->myCompromisDocumentsBrowse (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.69 ms

SELECT t0.id AS id_1, t0.Denprojet AS Denprojet_2, t0.restap AS restap_3, t0.idanal AS idanal_4, t0.codeprojet AS codeprojet_5, t0.sitjuridique AS sitjuridique_6, t0.Numtitrs AS Numtitrs_7, t0.Numregistre AS Numregistre_8, t0.Numfolio AS Numfolio_9, t0.sisea AS sisea_10, t0.fokotany AS fokotany_11, t0.Commune AS Commune_12, t0.District AS District_13, t0.Region AS Region_14, t0.Nompropriete AS Nompropriete_15, t0.contenance AS contenance_16, t0.proprietaire AS proprietaire_17, t0.Signataire AS Signataire_18, t0.PersonaPPV AS PersonaPPV_19, t0.PAterrain AS PAterrain_20, t0.contrat AS contrat_21, t0.categorie AS categorie_22, t0.refarch AS refarch_23, t0.coordong AS coordong_24, t0.aventage AS aventage_25, t0.inconv AS inconv_26, t0.contenance_av AS contenance_av_27, t0.piecejoint AS piecejoint_28, t0.suivie AS suivie_29, t0.description AS description_30, t0.coordinates AS coordinates_31, t0.date AS date_32, t0.axe AS axe_33, t0.type AS type_34, t0.min AS min_35, t0.max AS max_36, t0.supmin AS supmin_37, t0.supmax AS supmax_38, t0.noted AS noted_39, t0.budget AS budget_40, t0.budgets AS budgets_41, t0.public_visibility AS public_visibility_42, t0.nextcloud_path AS nextcloud_path_43, t0.nextcloud_share_url AS nextcloud_share_url_44, t0.fournisseur_id AS fournisseur_id_45, t0.logo_id AS logo_id_46, t0.image_principal_id AS image_principal_id_47 FROM terrain t0 WHERE t0.id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.Denprojet AS Denprojet_2,
  t0.restap AS restap_3,
  t0.idanal AS idanal_4,
  t0.codeprojet AS codeprojet_5,
  t0.sitjuridique AS sitjuridique_6,
  t0.Numtitrs AS Numtitrs_7,
  t0.Numregistre AS Numregistre_8,
  t0.Numfolio AS Numfolio_9,
  t0.sisea AS sisea_10,
  t0.fokotany AS fokotany_11,
  t0.Commune AS Commune_12,
  t0.District AS District_13,
  t0.Region AS Region_14,
  t0.Nompropriete AS Nompropriete_15,
  t0.contenance AS contenance_16,
  t0.proprietaire AS proprietaire_17,
  t0.Signataire AS Signataire_18,
  t0.PersonaPPV AS PersonaPPV_19,
  t0.PAterrain AS PAterrain_20,
  t0.contrat AS contrat_21,
  t0.categorie AS categorie_22,
  t0.refarch AS refarch_23,
  t0.coordong AS coordong_24,
  t0.aventage AS aventage_25,
  t0.inconv AS inconv_26,
  t0.contenance_av AS contenance_av_27,
  t0.piecejoint AS piecejoint_28,
  t0.suivie AS suivie_29,
  t0.description AS description_30,
  t0.coordinates AS coordinates_31,
  t0.date AS date_32,
  t0.axe AS axe_33,
  t0.type AS type_34,
  t0.min AS min_35,
  t0.max AS max_36,
  t0.supmin AS supmin_37,
  t0.supmax AS supmax_38,
  t0.noted AS noted_39,
  t0.budget AS budget_40,
  t0.budgets AS budgets_41,
  t0.public_visibility AS public_visibility_42,
  t0.nextcloud_path AS nextcloud_path_43,
  t0.nextcloud_share_url AS nextcloud_share_url_44,
  t0.fournisseur_id AS fournisseur_id_45,
  t0.logo_id AS logo_id_46,
  t0.image_principal_id AS image_principal_id_47
FROM
  terrain t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.Denprojet AS Denprojet_2, t0.restap AS restap_3, t0.idanal AS idanal_4, t0.codeprojet AS codeprojet_5, t0.sitjuridique AS sitjuridique_6, t0.Numtitrs AS Numtitrs_7, t0.Numregistre AS Numregistre_8, t0.Numfolio AS Numfolio_9, t0.sisea AS sisea_10, t0.fokotany AS fokotany_11, t0.Commune AS Commune_12, t0.District AS District_13, t0.Region AS Region_14, t0.Nompropriete AS Nompropriete_15, t0.contenance AS contenance_16, t0.proprietaire AS proprietaire_17, t0.Signataire AS Signataire_18, t0.PersonaPPV AS PersonaPPV_19, t0.PAterrain AS PAterrain_20, t0.contrat AS contrat_21, t0.categorie AS categorie_22, t0.refarch AS refarch_23, t0.coordong AS coordong_24, t0.aventage AS aventage_25, t0.inconv AS inconv_26, t0.contenance_av AS contenance_av_27, t0.piecejoint AS piecejoint_28, t0.suivie AS suivie_29, t0.description AS description_30, t0.coordinates AS coordinates_31, t0.date AS date_32, t0.axe AS axe_33, t0.type AS type_34, t0.min AS min_35, t0.max AS max_36, t0.supmin AS supmin_37, t0.supmax AS supmax_38, t0.noted AS noted_39, t0.budget AS budget_40, t0.budgets AS budgets_41, t0.public_visibility AS public_visibility_42, t0.nextcloud_path AS nextcloud_path_43, t0.nextcloud_share_url AS nextcloud_share_url_44, t0.fournisseur_id AS fournisseur_id_45, t0.logo_id AS logo_id_46, t0.image_principal_id AS image_principal_id_47 FROM terrain t0 WHERE t0.id = 299;

#	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\Terrain::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Terrain->__get (line 308)
8	App\Entity\Terrain->getDenprojet (line 136)
9	App\Service\CompromisDocumentService->getProjectName (line 147)
10	App\Service\CompromisDocumentService->getProjectFolderPath (line 260)
11	App\Service\CompromisDocumentService->assertPathUnderProject (line 231)
12	App\Service\CompromisDocumentService->normalizeBrowseRoot (line 217)
13	App\Service\CompromisDocumentService->resolveBrowseRootPath (line 188)
14	App\Controller\Api\ClientSpaceController->myCompromisDocumentsBrowse (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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\Promesse	The field App\Entity\Promesse#negociations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Negociation#compromis does not contain the required 'inversedBy="negociations"' attribute.
App\Entity\Terrain	The association App\Entity\Terrain#fournisseur refers to the inverse side field App\Entity\Fournisseur#terrains which does not exist.
App\Entity\NoteDeCredit	The association App\Entity\NoteDeCredit#promesses refers to the owning side field App\Entity\Promesse#NoteDeCredits which does not exist.
App\Entity\NDCU	No errors.
App\Entity\PlandeP	No errors.
App\Entity\Listlot	No errors.
App\Entity\OffrePromesse	No errors.
App\Entity\Mutation	No errors.
App\Entity\Negociation	No errors.
App\Entity\DossierClient	No errors.
App\Entity\Fournisseur	No errors.
App\Entity\Image	No errors.
App\Entity\ImageTerrain	No errors.
App\Entity\TerrainTag	No errors.
App\Entity\PropositionOffre	No errors.
App\Entity\SourceTerrain	No errors.
App\Entity\Contract	The field 'App\Entity\Contract#amount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Reservation	No errors.
App\Entity\Decaissement	No errors.
App\Entity\Terrassement	No errors.
App\Entity\CaisseCompte	No errors.

Symfony Profiler

GET https://app.master-immo.net/api/client/space/mycompromis/1381/documents/browse?root=%2FDOSSIER%20CLIENT%2FPROJET%2FHAVRE%20VERT%2FHVT58

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping