Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

4.85 ms Query time

21 Invalid entities

37 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.20 ms
(45.30%)

SELECT a0_.IDAscenseur AS IDAscenseur_0, a0_.NumAppareilASC AS NumAppareilASC_1, a0_.residenceASC AS residenceASC_2, a0_.AdresseInstallationASC AS AdresseInstallationASC_3, a0_.MarquageCE AS MarquageCE_4, a0_.LocalisationASC AS LocalisationASC_5, a0_.ConstructeurASC AS ConstructeurASC_6, a0_.ChargeEnCabine AS ChargeEnCabine_7, a0_.NbrPersonne AS NbrPersonne_8, a0_.DeplacementASC AS DeplacementASC_9, a0_.AnneeConstructionASC AS AnneeConstructionASC_10, a0_.PrixContrat AS PrixContrat_11, a0_.AbonnementGsm AS AbonnementGsm_12, a0_.SousTotalHT AS SousTotalHT_13, a0_.TVAContrat AS TVAContrat_14, a0_.TotalTTC AS TotalTTC_15, a0_.RevisionPrixContrat AS RevisionPrixContrat_16, a0_.NbNiveauASC AS NbNiveauASC_17, a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_18, a0_.loichatel AS loichatel_19, a0_.GardienASC AS GardienASC_20, a0_.PositionSerrure AS PositionSerrure_21, a0_.NumAffaire AS NumAffaire_22, a0_.QRCodeASC AS QRCodeASC_23, a0_.QRCodeFile AS QRCodeFile_24, a0_.ContactSurSite AS ContactSurSite_25, a0_.NumeroContactSurSite AS NumeroContactSurSite_26, a0_.EmailContactSurSite AS EmailContactSurSite_27, a0_.PortableContactSurSite AS PortableContactSurSite_28, a0_.NomGestionnaire AS NomGestionnaire_29, a0_.NumGestionnaire AS NumGestionnaire_30, a0_.MailGestionnaire AS MailGestionnaire_31, a0_.NomRespCopropriete AS NomRespCopropriete_32, a0_.ContactRespCopropriete AS ContactRespCopropriete_33, a0_.PortableRespCopropriete AS PortableRespCopropriete_34, a0_.EmailRespCopropriete AS EmailRespCopropriete_35, a0_.IDVille AS IDVille_36, a0_.CP AS CP_37, a0_.Latitude AS Latitude_38, a0_.Longitude AS Longitude_39, a0_.CoffreAcle AS CoffreAcle_40, a0_.photo AS photo_41, a0_.Autre AS Autre_42, a0_.IDTypeVitessenominale AS IDTypeVitessenominale_43, a0_.IDFournisseur AS IDFournisseur_44, a0_.IDConstructeur AS IDConstructeur_45, a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_46, a0_.IDTypeSecteur AS IDTypeSecteur_47, a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_48, a0_.IDTypePortePaliere AS IDTypePortePaliere_49, a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_50, a0_.IDClientAscoriste AS IDClientAscoriste_51, a0_.IDSite AS IDSite_52, a0_.IDTypeBatiment AS IDTypeBatiment_53, a0_.IDTypeOuverture AS IDTypeOuverture_54, a0_.IDTypeequipement AS IDTypeequipement_55, a0_.IDTypeDeplacement AS IDTypeDeplacement_56, a0_.IDTypeChargeencabine AS IDTypeChargeencabine_57, a0_.IDTypeService AS IDTypeService_58, a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_59, a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_60, a0_.IDAscensoriste AS IDAscensoriste_61, a0_.IDContrat AS IDContrat_62, a0_.IDFacturationAscenseur AS IDFacturationAscenseur_63 FROM Ascenseur a0_ INNER JOIN Contrat c1_ ON a0_.IDContrat = c1_.IDContrat WHERE a0_.IDAscensoriste = ? AND c1_.Valide = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.IDAscenseur AS IDAscenseur_0,
  a0_.NumAppareilASC AS NumAppareilASC_1,
  a0_.residenceASC AS residenceASC_2,
  a0_.AdresseInstallationASC AS AdresseInstallationASC_3,
  a0_.MarquageCE AS MarquageCE_4,
  a0_.LocalisationASC AS LocalisationASC_5,
  a0_.ConstructeurASC AS ConstructeurASC_6,
  a0_.ChargeEnCabine AS ChargeEnCabine_7,
  a0_.NbrPersonne AS NbrPersonne_8,
  a0_.DeplacementASC AS DeplacementASC_9,
  a0_.AnneeConstructionASC AS AnneeConstructionASC_10,
  a0_.PrixContrat AS PrixContrat_11,
  a0_.AbonnementGsm AS AbonnementGsm_12,
  a0_.SousTotalHT AS SousTotalHT_13,
  a0_.TVAContrat AS TVAContrat_14,
  a0_.TotalTTC AS TotalTTC_15,
  a0_.RevisionPrixContrat AS RevisionPrixContrat_16,
  a0_.NbNiveauASC AS NbNiveauASC_17,
  a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_18,
  a0_.loichatel AS loichatel_19,
  a0_.GardienASC AS GardienASC_20,
  a0_.PositionSerrure AS PositionSerrure_21,
  a0_.NumAffaire AS NumAffaire_22,
  a0_.QRCodeASC AS QRCodeASC_23,
  a0_.QRCodeFile AS QRCodeFile_24,
  a0_.ContactSurSite AS ContactSurSite_25,
  a0_.NumeroContactSurSite AS NumeroContactSurSite_26,
  a0_.EmailContactSurSite AS EmailContactSurSite_27,
  a0_.PortableContactSurSite AS PortableContactSurSite_28,
  a0_.NomGestionnaire AS NomGestionnaire_29,
  a0_.NumGestionnaire AS NumGestionnaire_30,
  a0_.MailGestionnaire AS MailGestionnaire_31,
  a0_.NomRespCopropriete AS NomRespCopropriete_32,
  a0_.ContactRespCopropriete AS ContactRespCopropriete_33,
  a0_.PortableRespCopropriete AS PortableRespCopropriete_34,
  a0_.EmailRespCopropriete AS EmailRespCopropriete_35,
  a0_.IDVille AS IDVille_36,
  a0_.CP AS CP_37,
  a0_.Latitude AS Latitude_38,
  a0_.Longitude AS Longitude_39,
  a0_.CoffreAcle AS CoffreAcle_40,
  a0_.photo AS photo_41,
  a0_.Autre AS Autre_42,
  a0_.IDTypeVitessenominale AS IDTypeVitessenominale_43,
  a0_.IDFournisseur AS IDFournisseur_44,
  a0_.IDConstructeur AS IDConstructeur_45,
  a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_46,
  a0_.IDTypeSecteur AS IDTypeSecteur_47,
  a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_48,
  a0_.IDTypePortePaliere AS IDTypePortePaliere_49,
  a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_50,
  a0_.IDClientAscoriste AS IDClientAscoriste_51,
  a0_.IDSite AS IDSite_52,
  a0_.IDTypeBatiment AS IDTypeBatiment_53,
  a0_.IDTypeOuverture AS IDTypeOuverture_54,
  a0_.IDTypeequipement AS IDTypeequipement_55,
  a0_.IDTypeDeplacement AS IDTypeDeplacement_56,
  a0_.IDTypeChargeencabine AS IDTypeChargeencabine_57,
  a0_.IDTypeService AS IDTypeService_58,
  a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_59,
  a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_60,
  a0_.IDAscensoriste AS IDAscensoriste_61,
  a0_.IDContrat AS IDContrat_62,
  a0_.IDFacturationAscenseur AS IDFacturationAscenseur_63
FROM
  Ascenseur a0_
  INNER JOIN Contrat c1_ ON a0_.IDContrat = c1_.IDContrat
WHERE
  a0_.IDAscensoriste = ?
  AND c1_.Valide = ?
LIMIT
  1

SELECT a0_.IDAscenseur AS IDAscenseur_0, a0_.NumAppareilASC AS NumAppareilASC_1, a0_.residenceASC AS residenceASC_2, a0_.AdresseInstallationASC AS AdresseInstallationASC_3, a0_.MarquageCE AS MarquageCE_4, a0_.LocalisationASC AS LocalisationASC_5, a0_.ConstructeurASC AS ConstructeurASC_6, a0_.ChargeEnCabine AS ChargeEnCabine_7, a0_.NbrPersonne AS NbrPersonne_8, a0_.DeplacementASC AS DeplacementASC_9, a0_.AnneeConstructionASC AS AnneeConstructionASC_10, a0_.PrixContrat AS PrixContrat_11, a0_.AbonnementGsm AS AbonnementGsm_12, a0_.SousTotalHT AS SousTotalHT_13, a0_.TVAContrat AS TVAContrat_14, a0_.TotalTTC AS TotalTTC_15, a0_.RevisionPrixContrat AS RevisionPrixContrat_16, a0_.NbNiveauASC AS NbNiveauASC_17, a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_18, a0_.loichatel AS loichatel_19, a0_.GardienASC AS GardienASC_20, a0_.PositionSerrure AS PositionSerrure_21, a0_.NumAffaire AS NumAffaire_22, a0_.QRCodeASC AS QRCodeASC_23, a0_.QRCodeFile AS QRCodeFile_24, a0_.ContactSurSite AS ContactSurSite_25, a0_.NumeroContactSurSite AS NumeroContactSurSite_26, a0_.EmailContactSurSite AS EmailContactSurSite_27, a0_.PortableContactSurSite AS PortableContactSurSite_28, a0_.NomGestionnaire AS NomGestionnaire_29, a0_.NumGestionnaire AS NumGestionnaire_30, a0_.MailGestionnaire AS MailGestionnaire_31, a0_.NomRespCopropriete AS NomRespCopropriete_32, a0_.ContactRespCopropriete AS ContactRespCopropriete_33, a0_.PortableRespCopropriete AS PortableRespCopropriete_34, a0_.EmailRespCopropriete AS EmailRespCopropriete_35, a0_.IDVille AS IDVille_36, a0_.CP AS CP_37, a0_.Latitude AS Latitude_38, a0_.Longitude AS Longitude_39, a0_.CoffreAcle AS CoffreAcle_40, a0_.photo AS photo_41, a0_.Autre AS Autre_42, a0_.IDTypeVitessenominale AS IDTypeVitessenominale_43, a0_.IDFournisseur AS IDFournisseur_44, a0_.IDConstructeur AS IDConstructeur_45, a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_46, a0_.IDTypeSecteur AS IDTypeSecteur_47, a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_48, a0_.IDTypePortePaliere AS IDTypePortePaliere_49, a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_50, a0_.IDClientAscoriste AS IDClientAscoriste_51, a0_.IDSite AS IDSite_52, a0_.IDTypeBatiment AS IDTypeBatiment_53, a0_.IDTypeOuverture AS IDTypeOuverture_54, a0_.IDTypeequipement AS IDTypeequipement_55, a0_.IDTypeDeplacement AS IDTypeDeplacement_56, a0_.IDTypeChargeencabine AS IDTypeChargeencabine_57, a0_.IDTypeService AS IDTypeService_58, a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_59, a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_60, a0_.IDAscensoriste AS IDAscensoriste_61, a0_.IDContrat AS IDContrat_62, a0_.IDFacturationAscenseur AS IDFacturationAscenseur_63 FROM Ascenseur a0_ INNER JOIN Contrat c1_ ON a0_.IDContrat = c1_.IDContrat WHERE a0_.IDAscensoriste = 17 AND c1_.Valide = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\SessionAscensoristeService->setAscensoristeActif (line 64)
7	App\EventListener\AppRequestListener->__invoke (line 42)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
16	require_once (line 32)
17	require_once (line 5)

0.48 ms
(9.99%)

SELECT t0.IDAscenseur AS IDAscenseur_1, t0.NumAppareilASC AS NumAppareilASC_2, t0.residenceASC AS residenceASC_3, t0.AdresseInstallationASC AS AdresseInstallationASC_4, t0.MarquageCE AS MarquageCE_5, t0.LocalisationASC AS LocalisationASC_6, t0.ConstructeurASC AS ConstructeurASC_7, t0.ChargeEnCabine AS ChargeEnCabine_8, t0.NbrPersonne AS NbrPersonne_9, t0.DeplacementASC AS DeplacementASC_10, t0.AnneeConstructionASC AS AnneeConstructionASC_11, t0.PrixContrat AS PrixContrat_12, t0.AbonnementGsm AS AbonnementGsm_13, t0.SousTotalHT AS SousTotalHT_14, t0.TVAContrat AS TVAContrat_15, t0.TotalTTC AS TotalTTC_16, t0.RevisionPrixContrat AS RevisionPrixContrat_17, t0.NbNiveauASC AS NbNiveauASC_18, t0.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_19, t0.loichatel AS loichatel_20, t0.GardienASC AS GardienASC_21, t0.PositionSerrure AS PositionSerrure_22, t0.NumAffaire AS NumAffaire_23, t0.QRCodeASC AS QRCodeASC_24, t0.QRCodeFile AS QRCodeFile_25, t0.ContactSurSite AS ContactSurSite_26, t0.NumeroContactSurSite AS NumeroContactSurSite_27, t0.EmailContactSurSite AS EmailContactSurSite_28, t0.PortableContactSurSite AS PortableContactSurSite_29, t0.NomGestionnaire AS NomGestionnaire_30, t0.NumGestionnaire AS NumGestionnaire_31, t0.MailGestionnaire AS MailGestionnaire_32, t0.NomRespCopropriete AS NomRespCopropriete_33, t0.ContactRespCopropriete AS ContactRespCopropriete_34, t0.PortableRespCopropriete AS PortableRespCopropriete_35, t0.EmailRespCopropriete AS EmailRespCopropriete_36, t0.IDVille AS IDVille_37, t0.CP AS CP_38, t0.Latitude AS Latitude_39, t0.Longitude AS Longitude_40, t0.CoffreAcle AS CoffreAcle_41, t0.photo AS photo_42, t0.Autre AS Autre_43, t0.IDTypeVitessenominale AS IDTypeVitessenominale_44, t0.IDFournisseur AS IDFournisseur_45, t0.IDConstructeur AS IDConstructeur_46, t0.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_47, t0.IDTypeSecteur AS IDTypeSecteur_48, t0.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_49, t0.IDTypePortePaliere AS IDTypePortePaliere_50, t0.IDTypeDeverrouillage AS IDTypeDeverrouillage_51, t0.IDClientAscoriste AS IDClientAscoriste_52, t0.IDSite AS IDSite_53, t0.IDTypeBatiment AS IDTypeBatiment_54, t0.IDTypeOuverture AS IDTypeOuverture_55, t0.IDTypeequipement AS IDTypeequipement_56, t0.IDTypeDeplacement AS IDTypeDeplacement_57, t0.IDTypeChargeencabine AS IDTypeChargeencabine_58, t0.IDTypeService AS IDTypeService_59, t0.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_60, t0.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_61, t0.IDAscensoriste AS IDAscensoriste_62, t0.IDContrat AS IDContrat_63, t64.IDScoreAscenseur AS IDScoreAscenseur_65, t64.CoefficherntCart AS CoefficherntCart_66, t64.CapaciteCibleTechnicien AS CapaciteCibleTechnicien_67, t64.ChargeSecteurAvant AS ChargeSecteurAvant_68, t64.ChargeSecteurApres AS ChargeSecteurApres_69, t64.DateDebutCalcule AS DateDebutCalcule_70, t64.ModeCalculScore AS ModeCalculScore_71, t64.IDAscenseur AS IDAscenseur_72, t64.IDScoringTypeFrequenceMaintenance AS IDScoringTypeFrequenceMaintenance_73, t64.IDTypeScoreModeCalculeTempsAnnuel AS IDTypeScoreModeCalculeTempsAnnuel_74, t64.IDTypescoretypebatiment AS IDTypescoretypebatiment_75, t64.IDTypescorenombreniveau AS IDTypescorenombreniveau_76, t64.IDTypescorefrequenceintervention AS IDTypescorefrequenceintervention_77, t64.IDTypescoreetatappareil AS IDTypescoreetatappareil_78, t64.IDTypeScoreSourceDonnee AS IDTypeScoreSourceDonnee_79, t64.IDTypeScoreModeCalcule AS IDTypeScoreModeCalcule_80, t64.IDTypeScoreUsageScore AS IDTypeScoreUsageScore_81, t64.IDTypeScoreAffectationSecteur AS IDTypeScoreAffectationSecteur_82, t64.IDTypeScoreFamilleEquipement AS IDTypeScoreFamilleEquipement_83, t64.IDTypeScoreRisqueglobal AS IDTypeScoreRisqueglobal_84, t64.IDTypescorechargecapacite AS IDTypescorechargecapacite_85, t86.IDScoreAscenseurSnapshot AS IDScoreAscenseurSnapshot_87, t86.ModeCalcul AS ModeCalcul_88, t86.RisqueNiveau AS RisqueNiveau_89, t86.RisqueLibelle AS RisqueLibelle_90, t86.RisqueCouleur AS RisqueCouleur_91, t86.ScoreGlobalTotal AS ScoreGlobalTotal_92, t86.ScoreGlobalMax AS ScoreGlobalMax_93, t86.ScoreGlobalPourcentage AS ScoreGlobalPourcentage_94, t86.ScoreTypeEquipement AS ScoreTypeEquipement_95, t86.ScoreTypeBatiment AS ScoreTypeBatiment_96, t86.ScoreEtatAnciennete AS ScoreEtatAnciennete_97, t86.ScoreNombreNiveaux AS ScoreNombreNiveaux_98, t86.ScoreChargeCapacite AS ScoreChargeCapacite_99, t86.ScoreFrequenceDepannages AS ScoreFrequenceDepannages_100, t86.ScoreFrequenceMaintenance AS ScoreFrequenceMaintenance_101, t86.ScoreTempsAnnuelEstime AS ScoreTempsAnnuelEstime_102, t86.DateCalcul AS DateCalcul_103, t86.IDAscenseur AS IDAscenseur_104, t0.IDFacturationAscenseur AS IDFacturationAscenseur_105, t106.IDGroupePropriete AS IDGroupePropriete_107, t106.Libelle AS Libelle_108, t106.NbMembre AS NbMembre_109, t106.IDTypeProprietaire AS IDTypeProprietaire_110, t106.IDAscenseur AS IDAscenseur_111 FROM Ascenseur t0 LEFT JOIN ScoreAscenseur t64 ON t64.IDAscenseur = t0.IDAscenseur LEFT JOIN ScoreAscenseurSnapshot t86 ON t86.IDAscenseur = t0.IDAscenseur LEFT JOIN GroupePropriete t106 ON t106.IDAscenseur = t0.IDAscenseur WHERE t0.IDAscenseur = ?

Parameters:

[
  "385"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDAscenseur AS IDAscenseur_1,
  t0.NumAppareilASC AS NumAppareilASC_2,
  t0.residenceASC AS residenceASC_3,
  t0.AdresseInstallationASC AS AdresseInstallationASC_4,
  t0.MarquageCE AS MarquageCE_5,
  t0.LocalisationASC AS LocalisationASC_6,
  t0.ConstructeurASC AS ConstructeurASC_7,
  t0.ChargeEnCabine AS ChargeEnCabine_8,
  t0.NbrPersonne AS NbrPersonne_9,
  t0.DeplacementASC AS DeplacementASC_10,
  t0.AnneeConstructionASC AS AnneeConstructionASC_11,
  t0.PrixContrat AS PrixContrat_12,
  t0.AbonnementGsm AS AbonnementGsm_13,
  t0.SousTotalHT AS SousTotalHT_14,
  t0.TVAContrat AS TVAContrat_15,
  t0.TotalTTC AS TotalTTC_16,
  t0.RevisionPrixContrat AS RevisionPrixContrat_17,
  t0.NbNiveauASC AS NbNiveauASC_18,
  t0.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_19,
  t0.loichatel AS loichatel_20,
  t0.GardienASC AS GardienASC_21,
  t0.PositionSerrure AS PositionSerrure_22,
  t0.NumAffaire AS NumAffaire_23,
  t0.QRCodeASC AS QRCodeASC_24,
  t0.QRCodeFile AS QRCodeFile_25,
  t0.ContactSurSite AS ContactSurSite_26,
  t0.NumeroContactSurSite AS NumeroContactSurSite_27,
  t0.EmailContactSurSite AS EmailContactSurSite_28,
  t0.PortableContactSurSite AS PortableContactSurSite_29,
  t0.NomGestionnaire AS NomGestionnaire_30,
  t0.NumGestionnaire AS NumGestionnaire_31,
  t0.MailGestionnaire AS MailGestionnaire_32,
  t0.NomRespCopropriete AS NomRespCopropriete_33,
  t0.ContactRespCopropriete AS ContactRespCopropriete_34,
  t0.PortableRespCopropriete AS PortableRespCopropriete_35,
  t0.EmailRespCopropriete AS EmailRespCopropriete_36,
  t0.IDVille AS IDVille_37,
  t0.CP AS CP_38,
  t0.Latitude AS Latitude_39,
  t0.Longitude AS Longitude_40,
  t0.CoffreAcle AS CoffreAcle_41,
  t0.photo AS photo_42,
  t0.Autre AS Autre_43,
  t0.IDTypeVitessenominale AS IDTypeVitessenominale_44,
  t0.IDFournisseur AS IDFournisseur_45,
  t0.IDConstructeur AS IDConstructeur_46,
  t0.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_47,
  t0.IDTypeSecteur AS IDTypeSecteur_48,
  t0.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_49,
  t0.IDTypePortePaliere AS IDTypePortePaliere_50,
  t0.IDTypeDeverrouillage AS IDTypeDeverrouillage_51,
  t0.IDClientAscoriste AS IDClientAscoriste_52,
  t0.IDSite AS IDSite_53,
  t0.IDTypeBatiment AS IDTypeBatiment_54,
  t0.IDTypeOuverture AS IDTypeOuverture_55,
  t0.IDTypeequipement AS IDTypeequipement_56,
  t0.IDTypeDeplacement AS IDTypeDeplacement_57,
  t0.IDTypeChargeencabine AS IDTypeChargeencabine_58,
  t0.IDTypeService AS IDTypeService_59,
  t0.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_60,
  t0.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_61,
  t0.IDAscensoriste AS IDAscensoriste_62,
  t0.IDContrat AS IDContrat_63,
  t64.IDScoreAscenseur AS IDScoreAscenseur_65,
  t64.CoefficherntCart AS CoefficherntCart_66,
  t64.CapaciteCibleTechnicien AS CapaciteCibleTechnicien_67,
  t64.ChargeSecteurAvant AS ChargeSecteurAvant_68,
  t64.ChargeSecteurApres AS ChargeSecteurApres_69,
  t64.DateDebutCalcule AS DateDebutCalcule_70,
  t64.ModeCalculScore AS ModeCalculScore_71,
  t64.IDAscenseur AS IDAscenseur_72,
  t64.IDScoringTypeFrequenceMaintenance AS IDScoringTypeFrequenceMaintenance_73,
  t64.IDTypeScoreModeCalculeTempsAnnuel AS IDTypeScoreModeCalculeTempsAnnuel_74,
  t64.IDTypescoretypebatiment AS IDTypescoretypebatiment_75,
  t64.IDTypescorenombreniveau AS IDTypescorenombreniveau_76,
  t64.IDTypescorefrequenceintervention AS IDTypescorefrequenceintervention_77,
  t64.IDTypescoreetatappareil AS IDTypescoreetatappareil_78,
  t64.IDTypeScoreSourceDonnee AS IDTypeScoreSourceDonnee_79,
  t64.IDTypeScoreModeCalcule AS IDTypeScoreModeCalcule_80,
  t64.IDTypeScoreUsageScore AS IDTypeScoreUsageScore_81,
  t64.IDTypeScoreAffectationSecteur AS IDTypeScoreAffectationSecteur_82,
  t64.IDTypeScoreFamilleEquipement AS IDTypeScoreFamilleEquipement_83,
  t64.IDTypeScoreRisqueglobal AS IDTypeScoreRisqueglobal_84,
  t64.IDTypescorechargecapacite AS IDTypescorechargecapacite_85,
  t86.IDScoreAscenseurSnapshot AS IDScoreAscenseurSnapshot_87,
  t86.ModeCalcul AS ModeCalcul_88,
  t86.RisqueNiveau AS RisqueNiveau_89,
  t86.RisqueLibelle AS RisqueLibelle_90,
  t86.RisqueCouleur AS RisqueCouleur_91,
  t86.ScoreGlobalTotal AS ScoreGlobalTotal_92,
  t86.ScoreGlobalMax AS ScoreGlobalMax_93,
  t86.ScoreGlobalPourcentage AS ScoreGlobalPourcentage_94,
  t86.ScoreTypeEquipement AS ScoreTypeEquipement_95,
  t86.ScoreTypeBatiment AS ScoreTypeBatiment_96,
  t86.ScoreEtatAnciennete AS ScoreEtatAnciennete_97,
  t86.ScoreNombreNiveaux AS ScoreNombreNiveaux_98,
  t86.ScoreChargeCapacite AS ScoreChargeCapacite_99,
  t86.ScoreFrequenceDepannages AS ScoreFrequenceDepannages_100,
  t86.ScoreFrequenceMaintenance AS ScoreFrequenceMaintenance_101,
  t86.ScoreTempsAnnuelEstime AS ScoreTempsAnnuelEstime_102,
  t86.DateCalcul AS DateCalcul_103,
  t86.IDAscenseur AS IDAscenseur_104,
  t0.IDFacturationAscenseur AS IDFacturationAscenseur_105,
  t106.IDGroupePropriete AS IDGroupePropriete_107,
  t106.Libelle AS Libelle_108,
  t106.NbMembre AS NbMembre_109,
  t106.IDTypeProprietaire AS IDTypeProprietaire_110,
  t106.IDAscenseur AS IDAscenseur_111
FROM
  Ascenseur t0
  LEFT JOIN ScoreAscenseur t64 ON t64.IDAscenseur = t0.IDAscenseur
  LEFT JOIN ScoreAscenseurSnapshot t86 ON t86.IDAscenseur = t0.IDAscenseur
  LEFT JOIN GroupePropriete t106 ON t106.IDAscenseur = t0.IDAscenseur
WHERE
  t0.IDAscenseur = ?

SELECT t0.IDAscenseur AS IDAscenseur_1, t0.NumAppareilASC AS NumAppareilASC_2, t0.residenceASC AS residenceASC_3, t0.AdresseInstallationASC AS AdresseInstallationASC_4, t0.MarquageCE AS MarquageCE_5, t0.LocalisationASC AS LocalisationASC_6, t0.ConstructeurASC AS ConstructeurASC_7, t0.ChargeEnCabine AS ChargeEnCabine_8, t0.NbrPersonne AS NbrPersonne_9, t0.DeplacementASC AS DeplacementASC_10, t0.AnneeConstructionASC AS AnneeConstructionASC_11, t0.PrixContrat AS PrixContrat_12, t0.AbonnementGsm AS AbonnementGsm_13, t0.SousTotalHT AS SousTotalHT_14, t0.TVAContrat AS TVAContrat_15, t0.TotalTTC AS TotalTTC_16, t0.RevisionPrixContrat AS RevisionPrixContrat_17, t0.NbNiveauASC AS NbNiveauASC_18, t0.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_19, t0.loichatel AS loichatel_20, t0.GardienASC AS GardienASC_21, t0.PositionSerrure AS PositionSerrure_22, t0.NumAffaire AS NumAffaire_23, t0.QRCodeASC AS QRCodeASC_24, t0.QRCodeFile AS QRCodeFile_25, t0.ContactSurSite AS ContactSurSite_26, t0.NumeroContactSurSite AS NumeroContactSurSite_27, t0.EmailContactSurSite AS EmailContactSurSite_28, t0.PortableContactSurSite AS PortableContactSurSite_29, t0.NomGestionnaire AS NomGestionnaire_30, t0.NumGestionnaire AS NumGestionnaire_31, t0.MailGestionnaire AS MailGestionnaire_32, t0.NomRespCopropriete AS NomRespCopropriete_33, t0.ContactRespCopropriete AS ContactRespCopropriete_34, t0.PortableRespCopropriete AS PortableRespCopropriete_35, t0.EmailRespCopropriete AS EmailRespCopropriete_36, t0.IDVille AS IDVille_37, t0.CP AS CP_38, t0.Latitude AS Latitude_39, t0.Longitude AS Longitude_40, t0.CoffreAcle AS CoffreAcle_41, t0.photo AS photo_42, t0.Autre AS Autre_43, t0.IDTypeVitessenominale AS IDTypeVitessenominale_44, t0.IDFournisseur AS IDFournisseur_45, t0.IDConstructeur AS IDConstructeur_46, t0.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_47, t0.IDTypeSecteur AS IDTypeSecteur_48, t0.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_49, t0.IDTypePortePaliere AS IDTypePortePaliere_50, t0.IDTypeDeverrouillage AS IDTypeDeverrouillage_51, t0.IDClientAscoriste AS IDClientAscoriste_52, t0.IDSite AS IDSite_53, t0.IDTypeBatiment AS IDTypeBatiment_54, t0.IDTypeOuverture AS IDTypeOuverture_55, t0.IDTypeequipement AS IDTypeequipement_56, t0.IDTypeDeplacement AS IDTypeDeplacement_57, t0.IDTypeChargeencabine AS IDTypeChargeencabine_58, t0.IDTypeService AS IDTypeService_59, t0.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_60, t0.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_61, t0.IDAscensoriste AS IDAscensoriste_62, t0.IDContrat AS IDContrat_63, t64.IDScoreAscenseur AS IDScoreAscenseur_65, t64.CoefficherntCart AS CoefficherntCart_66, t64.CapaciteCibleTechnicien AS CapaciteCibleTechnicien_67, t64.ChargeSecteurAvant AS ChargeSecteurAvant_68, t64.ChargeSecteurApres AS ChargeSecteurApres_69, t64.DateDebutCalcule AS DateDebutCalcule_70, t64.ModeCalculScore AS ModeCalculScore_71, t64.IDAscenseur AS IDAscenseur_72, t64.IDScoringTypeFrequenceMaintenance AS IDScoringTypeFrequenceMaintenance_73, t64.IDTypeScoreModeCalculeTempsAnnuel AS IDTypeScoreModeCalculeTempsAnnuel_74, t64.IDTypescoretypebatiment AS IDTypescoretypebatiment_75, t64.IDTypescorenombreniveau AS IDTypescorenombreniveau_76, t64.IDTypescorefrequenceintervention AS IDTypescorefrequenceintervention_77, t64.IDTypescoreetatappareil AS IDTypescoreetatappareil_78, t64.IDTypeScoreSourceDonnee AS IDTypeScoreSourceDonnee_79, t64.IDTypeScoreModeCalcule AS IDTypeScoreModeCalcule_80, t64.IDTypeScoreUsageScore AS IDTypeScoreUsageScore_81, t64.IDTypeScoreAffectationSecteur AS IDTypeScoreAffectationSecteur_82, t64.IDTypeScoreFamilleEquipement AS IDTypeScoreFamilleEquipement_83, t64.IDTypeScoreRisqueglobal AS IDTypeScoreRisqueglobal_84, t64.IDTypescorechargecapacite AS IDTypescorechargecapacite_85, t86.IDScoreAscenseurSnapshot AS IDScoreAscenseurSnapshot_87, t86.ModeCalcul AS ModeCalcul_88, t86.RisqueNiveau AS RisqueNiveau_89, t86.RisqueLibelle AS RisqueLibelle_90, t86.RisqueCouleur AS RisqueCouleur_91, t86.ScoreGlobalTotal AS ScoreGlobalTotal_92, t86.ScoreGlobalMax AS ScoreGlobalMax_93, t86.ScoreGlobalPourcentage AS ScoreGlobalPourcentage_94, t86.ScoreTypeEquipement AS ScoreTypeEquipement_95, t86.ScoreTypeBatiment AS ScoreTypeBatiment_96, t86.ScoreEtatAnciennete AS ScoreEtatAnciennete_97, t86.ScoreNombreNiveaux AS ScoreNombreNiveaux_98, t86.ScoreChargeCapacite AS ScoreChargeCapacite_99, t86.ScoreFrequenceDepannages AS ScoreFrequenceDepannages_100, t86.ScoreFrequenceMaintenance AS ScoreFrequenceMaintenance_101, t86.ScoreTempsAnnuelEstime AS ScoreTempsAnnuelEstime_102, t86.DateCalcul AS DateCalcul_103, t86.IDAscenseur AS IDAscenseur_104, t0.IDFacturationAscenseur AS IDFacturationAscenseur_105, t106.IDGroupePropriete AS IDGroupePropriete_107, t106.Libelle AS Libelle_108, t106.NbMembre AS NbMembre_109, t106.IDTypeProprietaire AS IDTypeProprietaire_110, t106.IDAscenseur AS IDAscenseur_111 FROM Ascenseur t0 LEFT JOIN ScoreAscenseur t64 ON t64.IDAscenseur = t0.IDAscenseur LEFT JOIN ScoreAscenseurSnapshot t86 ON t86.IDAscenseur = t0.IDAscenseur LEFT JOIN GroupePropriete t106 ON t106.IDAscenseur = t0.IDAscenseur WHERE t0.IDAscenseur = '385';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	App\Controller\Api\Activite\GetEssaisPhonieCarnetsController->__invoke (line 42)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.34 ms
(6.92%)

SELECT t0.IDClientAscoriste AS IDClientAscoriste_1, t0.RefClient AS RefClient_2, t0.NomClient AS NomClient_3, t0.EstActif AS EstActif_4, t0.AdresseClient AS AdresseClient_5, t0.TelClient AS TelClient_6, t0.Emailclient AS Emailclient_7, t0.NomContactClient AS NomContactClient_8, t0.LienSiteClient AS LienSiteClient_9, t0.NoteInterne AS NoteInterne_10, t0.EnvoiEmailActive AS EnvoiEmailActive_11, t0.RaisonSociale AS RaisonSociale_12, t0.TypeClient AS TypeClient_13, t0.GroupeEntite AS GroupeEntite_14, t0.ChargeDaffaires AS ChargeDaffaires_15, t0.OrigineClient AS OrigineClient_16, t0.DateCreation AS DateCreation_17, t0.IDUser AS IDUser_18, t0.IDAscensoriste AS IDAscensoriste_19, t20.IDComptaFacturation AS IDComptaFacturation_21, t20.Devise AS Devise_22, t20.RefObligatoireFacture AS RefObligatoireFacture_23, t20.NumeroEngagementJuridique AS NumeroEngagementJuridique_24, t20.NumeroMarche AS NumeroMarche_25, t20.PrelevementSepaAutorise AS PrelevementSepaAutorise_26, t20.BonCommandeObligatoire AS BonCommandeObligatoire_27, t20.ChorusProActive AS ChorusProActive_28, t20.CodeServiceChorusPro AS CodeServiceChorusPro_29, t20.EmailFacturation AS EmailFacturation_30, t20.EmailEnvoiFactures AS EmailEnvoiFactures_31, t20.EmailRelances AS EmailRelances_32, t20.DestinataireFactures AS DestinataireFactures_33, t20.AdresseFacturation AS AdresseFacturation_34, t20.DateProchaineFacturePrevisionnelle AS DateProchaineFacturePrevisionnelle_35, t20.MandatSepaDateDu AS MandatSepaDateDu_36, t20.MentionsSpeciales AS MentionsSpeciales_37, t20.CodeComptable AS CodeComptable_38, t20.CompteAuxilliaire AS CompteAuxilliaire_39, t20.Siret AS Siret_40, t20.CodeApeNaf AS CodeApeNaf_41, t20.NumTva AS NumTva_42, t20.ModePaiement AS ModePaiement_43, t20.DelaiPaiement AS DelaiPaiement_44, t20.IDClientAscoriste AS IDClientAscoriste_45, t20.IDTypeTva AS IDTypeTva_46, t20.IDTypeFacturePeriodicite AS IDTypeFacturePeriodicite_47, t20.IDTypeconditionpaiement AS IDTypeconditionpaiement_48 FROM ClientAscoriste t0 LEFT JOIN ComptaFacturation t20 ON t20.IDClientAscoriste = t0.IDClientAscoriste WHERE t0.IDUser = ? LIMIT 1

Parameters:

[
  659
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDClientAscoriste AS IDClientAscoriste_1,
  t0.RefClient AS RefClient_2,
  t0.NomClient AS NomClient_3,
  t0.EstActif AS EstActif_4,
  t0.AdresseClient AS AdresseClient_5,
  t0.TelClient AS TelClient_6,
  t0.Emailclient AS Emailclient_7,
  t0.NomContactClient AS NomContactClient_8,
  t0.LienSiteClient AS LienSiteClient_9,
  t0.NoteInterne AS NoteInterne_10,
  t0.EnvoiEmailActive AS EnvoiEmailActive_11,
  t0.RaisonSociale AS RaisonSociale_12,
  t0.TypeClient AS TypeClient_13,
  t0.GroupeEntite AS GroupeEntite_14,
  t0.ChargeDaffaires AS ChargeDaffaires_15,
  t0.OrigineClient AS OrigineClient_16,
  t0.DateCreation AS DateCreation_17,
  t0.IDUser AS IDUser_18,
  t0.IDAscensoriste AS IDAscensoriste_19,
  t20.IDComptaFacturation AS IDComptaFacturation_21,
  t20.Devise AS Devise_22,
  t20.RefObligatoireFacture AS RefObligatoireFacture_23,
  t20.NumeroEngagementJuridique AS NumeroEngagementJuridique_24,
  t20.NumeroMarche AS NumeroMarche_25,
  t20.PrelevementSepaAutorise AS PrelevementSepaAutorise_26,
  t20.BonCommandeObligatoire AS BonCommandeObligatoire_27,
  t20.ChorusProActive AS ChorusProActive_28,
  t20.CodeServiceChorusPro AS CodeServiceChorusPro_29,
  t20.EmailFacturation AS EmailFacturation_30,
  t20.EmailEnvoiFactures AS EmailEnvoiFactures_31,
  t20.EmailRelances AS EmailRelances_32,
  t20.DestinataireFactures AS DestinataireFactures_33,
  t20.AdresseFacturation AS AdresseFacturation_34,
  t20.DateProchaineFacturePrevisionnelle AS DateProchaineFacturePrevisionnelle_35,
  t20.MandatSepaDateDu AS MandatSepaDateDu_36,
  t20.MentionsSpeciales AS MentionsSpeciales_37,
  t20.CodeComptable AS CodeComptable_38,
  t20.CompteAuxilliaire AS CompteAuxilliaire_39,
  t20.Siret AS Siret_40,
  t20.CodeApeNaf AS CodeApeNaf_41,
  t20.NumTva AS NumTva_42,
  t20.ModePaiement AS ModePaiement_43,
  t20.DelaiPaiement AS DelaiPaiement_44,
  t20.IDClientAscoriste AS IDClientAscoriste_45,
  t20.IDTypeTva AS IDTypeTva_46,
  t20.IDTypeFacturePeriodicite AS IDTypeFacturePeriodicite_47,
  t20.IDTypeconditionpaiement AS IDTypeconditionpaiement_48
FROM
  ClientAscoriste t0
  LEFT JOIN ComptaFacturation t20 ON t20.IDClientAscoriste = t0.IDClientAscoriste
WHERE
  t0.IDUser = ?
LIMIT
  1

SELECT t0.IDClientAscoriste AS IDClientAscoriste_1, t0.RefClient AS RefClient_2, t0.NomClient AS NomClient_3, t0.EstActif AS EstActif_4, t0.AdresseClient AS AdresseClient_5, t0.TelClient AS TelClient_6, t0.Emailclient AS Emailclient_7, t0.NomContactClient AS NomContactClient_8, t0.LienSiteClient AS LienSiteClient_9, t0.NoteInterne AS NoteInterne_10, t0.EnvoiEmailActive AS EnvoiEmailActive_11, t0.RaisonSociale AS RaisonSociale_12, t0.TypeClient AS TypeClient_13, t0.GroupeEntite AS GroupeEntite_14, t0.ChargeDaffaires AS ChargeDaffaires_15, t0.OrigineClient AS OrigineClient_16, t0.DateCreation AS DateCreation_17, t0.IDUser AS IDUser_18, t0.IDAscensoriste AS IDAscensoriste_19, t20.IDComptaFacturation AS IDComptaFacturation_21, t20.Devise AS Devise_22, t20.RefObligatoireFacture AS RefObligatoireFacture_23, t20.NumeroEngagementJuridique AS NumeroEngagementJuridique_24, t20.NumeroMarche AS NumeroMarche_25, t20.PrelevementSepaAutorise AS PrelevementSepaAutorise_26, t20.BonCommandeObligatoire AS BonCommandeObligatoire_27, t20.ChorusProActive AS ChorusProActive_28, t20.CodeServiceChorusPro AS CodeServiceChorusPro_29, t20.EmailFacturation AS EmailFacturation_30, t20.EmailEnvoiFactures AS EmailEnvoiFactures_31, t20.EmailRelances AS EmailRelances_32, t20.DestinataireFactures AS DestinataireFactures_33, t20.AdresseFacturation AS AdresseFacturation_34, t20.DateProchaineFacturePrevisionnelle AS DateProchaineFacturePrevisionnelle_35, t20.MandatSepaDateDu AS MandatSepaDateDu_36, t20.MentionsSpeciales AS MentionsSpeciales_37, t20.CodeComptable AS CodeComptable_38, t20.CompteAuxilliaire AS CompteAuxilliaire_39, t20.Siret AS Siret_40, t20.CodeApeNaf AS CodeApeNaf_41, t20.NumTva AS NumTva_42, t20.ModePaiement AS ModePaiement_43, t20.DelaiPaiement AS DelaiPaiement_44, t20.IDClientAscoriste AS IDClientAscoriste_45, t20.IDTypeTva AS IDTypeTva_46, t20.IDTypeFacturePeriodicite AS IDTypeFacturePeriodicite_47, t20.IDTypeconditionpaiement AS IDTypeconditionpaiement_48 FROM ClientAscoriste t0 LEFT JOIN ComptaFacturation t20 ON t20.IDClientAscoriste = t0.IDClientAscoriste WHERE t0.IDUser = 659 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\EventListener\AppRequestListener->__invoke (line 54)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.33 ms
(6.75%)

SELECT c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0, c0_.DateVisite AS DateVisite_1, c0_.HeureArrivee AS HeureArrivee_2, c0_.HeureDepart AS HeureDepart_3, c0_.DateProchainVisite AS DateProchainVisite_4, c0_.DateDerniereVisite AS DateDerniereVisite_5, c0_.EtatAjour AS EtatAjour_6, c0_.MarcheDegrade AS MarcheDegrade_7, c0_.EtablirDevis AS EtablirDevis_8, c0_.AssistanceTechnique AS AssistanceTechnique_9, c0_.IDTypeVisite AS IDTypeVisite_10, c0_.IDTypeStatutASC AS IDTypeStatutASC_11, c0_.NotifEnvoye AS NotifEnvoye_12, c0_.viafichier AS viafichier_13, c0_.IDAscenseur AS IDAscenseur_14, c0_.IDTechnicien AS IDTechnicien_15, c0_.IDDetailEntretien AS IDDetailEntretien_16, c0_.IDEssaisPhonie AS IDEssaisPhonie_17, c0_.IDPVCableTraction AS IDPVCableTraction_18, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_19, c0_.IDDetailtravaux AS IDDetailtravaux_20, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_21, c0_.IDSignalerPanne AS IDSignalerPanne_22, c0_.IDEtudeSecurite AS IDEtudeSecurite_23, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_24, c0_.IDFicheRemiseService AS IDFicheRemiseService_25 FROM CarnetMaintenance c0_ WHERE c0_.IDAscenseur = ? AND c0_.IDTypeVisite = ? ORDER BY c0_.DateVisite DESC

Parameters:

[
  "385"
  "ESSAI_PHONIE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0,
  c0_.DateVisite AS DateVisite_1,
  c0_.HeureArrivee AS HeureArrivee_2,
  c0_.HeureDepart AS HeureDepart_3,
  c0_.DateProchainVisite AS DateProchainVisite_4,
  c0_.DateDerniereVisite AS DateDerniereVisite_5,
  c0_.EtatAjour AS EtatAjour_6,
  c0_.MarcheDegrade AS MarcheDegrade_7,
  c0_.EtablirDevis AS EtablirDevis_8,
  c0_.AssistanceTechnique AS AssistanceTechnique_9,
  c0_.IDTypeVisite AS IDTypeVisite_10,
  c0_.IDTypeStatutASC AS IDTypeStatutASC_11,
  c0_.NotifEnvoye AS NotifEnvoye_12,
  c0_.viafichier AS viafichier_13,
  c0_.IDAscenseur AS IDAscenseur_14,
  c0_.IDTechnicien AS IDTechnicien_15,
  c0_.IDDetailEntretien AS IDDetailEntretien_16,
  c0_.IDEssaisPhonie AS IDEssaisPhonie_17,
  c0_.IDPVCableTraction AS IDPVCableTraction_18,
  c0_.IDDetailsPVParachute AS IDDetailsPVParachute_19,
  c0_.IDDetailtravaux AS IDDetailtravaux_20,
  c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_21,
  c0_.IDSignalerPanne AS IDSignalerPanne_22,
  c0_.IDEtudeSecurite AS IDEtudeSecurite_23,
  c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_24,
  c0_.IDFicheRemiseService AS IDFicheRemiseService_25
FROM
  CarnetMaintenance c0_
WHERE
  c0_.IDAscenseur = ?
  AND c0_.IDTypeVisite = ?
ORDER BY
  c0_.DateVisite DESC

SELECT c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0, c0_.DateVisite AS DateVisite_1, c0_.HeureArrivee AS HeureArrivee_2, c0_.HeureDepart AS HeureDepart_3, c0_.DateProchainVisite AS DateProchainVisite_4, c0_.DateDerniereVisite AS DateDerniereVisite_5, c0_.EtatAjour AS EtatAjour_6, c0_.MarcheDegrade AS MarcheDegrade_7, c0_.EtablirDevis AS EtablirDevis_8, c0_.AssistanceTechnique AS AssistanceTechnique_9, c0_.IDTypeVisite AS IDTypeVisite_10, c0_.IDTypeStatutASC AS IDTypeStatutASC_11, c0_.NotifEnvoye AS NotifEnvoye_12, c0_.viafichier AS viafichier_13, c0_.IDAscenseur AS IDAscenseur_14, c0_.IDTechnicien AS IDTechnicien_15, c0_.IDDetailEntretien AS IDDetailEntretien_16, c0_.IDEssaisPhonie AS IDEssaisPhonie_17, c0_.IDPVCableTraction AS IDPVCableTraction_18, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_19, c0_.IDDetailtravaux AS IDDetailtravaux_20, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_21, c0_.IDSignalerPanne AS IDSignalerPanne_22, c0_.IDEtudeSecurite AS IDEtudeSecurite_23, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_24, c0_.IDFicheRemiseService AS IDFicheRemiseService_25 FROM CarnetMaintenance c0_ WHERE c0_.IDAscenseur = '385' AND c0_.IDTypeVisite = 'ESSAI_PHONIE' ORDER BY c0_.DateVisite DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Api\Activite\GetEssaisPhonieCarnetsController->__invoke (line 61)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.32 ms
(6.53%)

SELECT t0.IDScoreAscenseur AS IDScoreAscenseur_1, t0.CoefficherntCart AS CoefficherntCart_2, t0.CapaciteCibleTechnicien AS CapaciteCibleTechnicien_3, t0.ChargeSecteurAvant AS ChargeSecteurAvant_4, t0.ChargeSecteurApres AS ChargeSecteurApres_5, t0.DateDebutCalcule AS DateDebutCalcule_6, t0.ModeCalculScore AS ModeCalculScore_7, t0.IDAscenseur AS IDAscenseur_8, t0.IDScoringTypeFrequenceMaintenance AS IDScoringTypeFrequenceMaintenance_9, t0.IDTypeScoreModeCalculeTempsAnnuel AS IDTypeScoreModeCalculeTempsAnnuel_10, t0.IDTypescoretypebatiment AS IDTypescoretypebatiment_11, t0.IDTypescorenombreniveau AS IDTypescorenombreniveau_12, t0.IDTypescorefrequenceintervention AS IDTypescorefrequenceintervention_13, t0.IDTypescoreetatappareil AS IDTypescoreetatappareil_14, t0.IDTypeScoreSourceDonnee AS IDTypeScoreSourceDonnee_15, t0.IDTypeScoreModeCalcule AS IDTypeScoreModeCalcule_16, t0.IDTypeScoreUsageScore AS IDTypeScoreUsageScore_17, t0.IDTypeScoreAffectationSecteur AS IDTypeScoreAffectationSecteur_18, t0.IDTypeScoreFamilleEquipement AS IDTypeScoreFamilleEquipement_19, t0.IDTypeScoreRisqueglobal AS IDTypeScoreRisqueglobal_20, t0.IDTypescorechargecapacite AS IDTypescorechargecapacite_21 FROM ScoreAscenseur t0 WHERE t0.IDAscenseur = ?

Parameters:

[
  376
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDScoreAscenseur AS IDScoreAscenseur_1,
  t0.CoefficherntCart AS CoefficherntCart_2,
  t0.CapaciteCibleTechnicien AS CapaciteCibleTechnicien_3,
  t0.ChargeSecteurAvant AS ChargeSecteurAvant_4,
  t0.ChargeSecteurApres AS ChargeSecteurApres_5,
  t0.DateDebutCalcule AS DateDebutCalcule_6,
  t0.ModeCalculScore AS ModeCalculScore_7,
  t0.IDAscenseur AS IDAscenseur_8,
  t0.IDScoringTypeFrequenceMaintenance AS IDScoringTypeFrequenceMaintenance_9,
  t0.IDTypeScoreModeCalculeTempsAnnuel AS IDTypeScoreModeCalculeTempsAnnuel_10,
  t0.IDTypescoretypebatiment AS IDTypescoretypebatiment_11,
  t0.IDTypescorenombreniveau AS IDTypescorenombreniveau_12,
  t0.IDTypescorefrequenceintervention AS IDTypescorefrequenceintervention_13,
  t0.IDTypescoreetatappareil AS IDTypescoreetatappareil_14,
  t0.IDTypeScoreSourceDonnee AS IDTypeScoreSourceDonnee_15,
  t0.IDTypeScoreModeCalcule AS IDTypeScoreModeCalcule_16,
  t0.IDTypeScoreUsageScore AS IDTypeScoreUsageScore_17,
  t0.IDTypeScoreAffectationSecteur AS IDTypeScoreAffectationSecteur_18,
  t0.IDTypeScoreFamilleEquipement AS IDTypeScoreFamilleEquipement_19,
  t0.IDTypeScoreRisqueglobal AS IDTypeScoreRisqueglobal_20,
  t0.IDTypescorechargecapacite AS IDTypescorechargecapacite_21
FROM
  ScoreAscenseur t0
WHERE
  t0.IDAscenseur = ?

SELECT t0.IDScoreAscenseur AS IDScoreAscenseur_1, t0.CoefficherntCart AS CoefficherntCart_2, t0.CapaciteCibleTechnicien AS CapaciteCibleTechnicien_3, t0.ChargeSecteurAvant AS ChargeSecteurAvant_4, t0.ChargeSecteurApres AS ChargeSecteurApres_5, t0.DateDebutCalcule AS DateDebutCalcule_6, t0.ModeCalculScore AS ModeCalculScore_7, t0.IDAscenseur AS IDAscenseur_8, t0.IDScoringTypeFrequenceMaintenance AS IDScoringTypeFrequenceMaintenance_9, t0.IDTypeScoreModeCalculeTempsAnnuel AS IDTypeScoreModeCalculeTempsAnnuel_10, t0.IDTypescoretypebatiment AS IDTypescoretypebatiment_11, t0.IDTypescorenombreniveau AS IDTypescorenombreniveau_12, t0.IDTypescorefrequenceintervention AS IDTypescorefrequenceintervention_13, t0.IDTypescoreetatappareil AS IDTypescoreetatappareil_14, t0.IDTypeScoreSourceDonnee AS IDTypeScoreSourceDonnee_15, t0.IDTypeScoreModeCalcule AS IDTypeScoreModeCalcule_16, t0.IDTypeScoreUsageScore AS IDTypeScoreUsageScore_17, t0.IDTypeScoreAffectationSecteur AS IDTypeScoreAffectationSecteur_18, t0.IDTypeScoreFamilleEquipement AS IDTypeScoreFamilleEquipement_19, t0.IDTypeScoreRisqueglobal AS IDTypeScoreRisqueglobal_20, t0.IDTypescorechargecapacite AS IDTypescorechargecapacite_21 FROM ScoreAscenseur t0 WHERE t0.IDAscenseur = 376;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Service\SessionAscensoristeService->setAscensoristeActif (line 64)
12	App\EventListener\AppRequestListener->__invoke (line 42)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.30 ms
(6.12%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.PhotoProfil AS PhotoProfil_10, t0.IDVille AS IDVille_11, t0.isAdmin AS isAdmin_12, t0.Dateentrer AS Dateentrer_13, t0.Telurgence AS Telurgence_14, t0.IDProfil AS IDProfil_15, t0.IDAscensoriste AS IDAscensoriste_16, t0.TypeExperience AS TypeExperience_17 FROM user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "yassine.jantaoui@sietram.fr"
]

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.EstActive AS EstActive_5,
  t0.NomPrenom AS NomPrenom_6,
  t0.Tel AS Tel_7,
  t0.Adresse AS Adresse_8,
  t0.Pays AS Pays_9,
  t0.PhotoProfil AS PhotoProfil_10,
  t0.IDVille AS IDVille_11,
  t0.isAdmin AS isAdmin_12,
  t0.Dateentrer AS Dateentrer_13,
  t0.Telurgence AS Telurgence_14,
  t0.IDProfil AS IDProfil_15,
  t0.IDAscensoriste AS IDAscensoriste_16,
  t0.TypeExperience AS TypeExperience_17
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.PhotoProfil AS PhotoProfil_10, t0.IDVille AS IDVille_11, t0.isAdmin AS isAdmin_12, t0.Dateentrer AS Dateentrer_13, t0.Telurgence AS Telurgence_14, t0.IDProfil AS IDProfil_15, t0.IDAscensoriste AS IDAscensoriste_16, t0.TypeExperience AS TypeExperience_17 FROM user t0 WHERE t0.username = 'yassine.jantaoui@sietram.fr' LIMIT 1;

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

0.26 ms
(5.33%)

SELECT t0.IDGroupePropriete AS IDGroupePropriete_1, t0.Libelle AS Libelle_2, t0.NbMembre AS NbMembre_3, t0.IDTypeProprietaire AS IDTypeProprietaire_4, t0.IDAscenseur AS IDAscenseur_5 FROM GroupePropriete t0 WHERE t0.IDAscenseur = ?

Parameters:

[
  376
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDGroupePropriete AS IDGroupePropriete_1,
  t0.Libelle AS Libelle_2,
  t0.NbMembre AS NbMembre_3,
  t0.IDTypeProprietaire AS IDTypeProprietaire_4,
  t0.IDAscenseur AS IDAscenseur_5
FROM
  GroupePropriete t0
WHERE
  t0.IDAscenseur = ?

SELECT t0.IDGroupePropriete AS IDGroupePropriete_1, t0.Libelle AS Libelle_2, t0.NbMembre AS NbMembre_3, t0.IDTypeProprietaire AS IDTypeProprietaire_4, t0.IDAscenseur AS IDAscenseur_5 FROM GroupePropriete t0 WHERE t0.IDAscenseur = 376;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Service\SessionAscensoristeService->setAscensoristeActif (line 64)
12	App\EventListener\AppRequestListener->__invoke (line 42)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.22 ms
(4.55%)

SELECT t0.IDAscensoriste AS IDAscensoriste_1, t0.Logo AS Logo_2, t0.Nom AS Nom_3, t0.Slug AS Slug_4, t0.Email AS Email_5, t0.TelContact AS TelContact_6, t0.NomContact AS NomContact_7, t0.CP AS CP_8, t0.Type AS Type_9, t0.Adresse AS Adresse_10, t0.IDVille AS IDVille_11, t0.EstActif AS EstActif_12, t0.Pays AS Pays_13, t0.TauxHoraire AS TauxHoraire_14, t0.TempsDeplacement AS TempsDeplacement_15, t0.AugmentationPrixOpParAn AS AugmentationPrixOpParAn_16, t0.CodeCouleur AS CodeCouleur_17, t0.IDModeledevisDefaut AS IDModeledevisDefaut_18 FROM Ascensoriste t0 WHERE t0.IDAscensoriste = ?

Parameters:

[
  "17"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDAscensoriste AS IDAscensoriste_1,
  t0.Logo AS Logo_2,
  t0.Nom AS Nom_3,
  t0.Slug AS Slug_4,
  t0.Email AS Email_5,
  t0.TelContact AS TelContact_6,
  t0.NomContact AS NomContact_7,
  t0.CP AS CP_8,
  t0.Type AS Type_9,
  t0.Adresse AS Adresse_10,
  t0.IDVille AS IDVille_11,
  t0.EstActif AS EstActif_12,
  t0.Pays AS Pays_13,
  t0.TauxHoraire AS TauxHoraire_14,
  t0.TempsDeplacement AS TempsDeplacement_15,
  t0.AugmentationPrixOpParAn AS AugmentationPrixOpParAn_16,
  t0.CodeCouleur AS CodeCouleur_17,
  t0.IDModeledevisDefaut AS IDModeledevisDefaut_18
FROM
  Ascensoriste t0
WHERE
  t0.IDAscensoriste = ?

SELECT t0.IDAscensoriste AS IDAscensoriste_1, t0.Logo AS Logo_2, t0.Nom AS Nom_3, t0.Slug AS Slug_4, t0.Email AS Email_5, t0.TelContact AS TelContact_6, t0.NomContact AS NomContact_7, t0.CP AS CP_8, t0.Type AS Type_9, t0.Adresse AS Adresse_10, t0.IDVille AS IDVille_11, t0.EstActif AS EstActif_12, t0.Pays AS Pays_13, t0.TauxHoraire AS TauxHoraire_14, t0.TempsDeplacement AS TempsDeplacement_15, t0.AugmentationPrixOpParAn AS AugmentationPrixOpParAn_16, t0.CodeCouleur AS CodeCouleur_17, t0.IDModeledevisDefaut AS IDModeledevisDefaut_18 FROM Ascensoriste t0 WHERE t0.IDAscensoriste = '17';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Ascensoriste::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Ascensoriste->__get (line 153)
7	App\Entity\Ascensoriste->getType (line 356)
8	App\Service\SessionAscensoristeService->setAscensoristeActif (line 53)
9	App\EventListener\AppRequestListener->__invoke (line 42)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
18	require_once (line 32)
19	require_once (line 5)

0.21 ms
(4.39%)

SELECT t0.IDProfil AS IDProfil_1, t0.PL_Libelle AS PL_Libelle_2, t0.Commentaire AS Commentaire_3, t0.DroitAcces AS DroitAcces_4, t0.ProfilUserAscensoriste AS ProfilUserAscensoriste_5, t0.ProfilSalarier AS ProfilSalarier_6, t0.roles AS roles_7, t0.isDeletable AS isDeletable_8, t0.IDTypeUtilisateur AS IDTypeUtilisateur_9 FROM Profil t0 WHERE t0.IDProfil = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDProfil AS IDProfil_1,
  t0.PL_Libelle AS PL_Libelle_2,
  t0.Commentaire AS Commentaire_3,
  t0.DroitAcces AS DroitAcces_4,
  t0.ProfilUserAscensoriste AS ProfilUserAscensoriste_5,
  t0.ProfilSalarier AS ProfilSalarier_6,
  t0.roles AS roles_7,
  t0.isDeletable AS isDeletable_8,
  t0.IDTypeUtilisateur AS IDTypeUtilisateur_9
FROM
  Profil t0
WHERE
  t0.IDProfil = ?

SELECT t0.IDProfil AS IDProfil_1, t0.PL_Libelle AS PL_Libelle_2, t0.Commentaire AS Commentaire_3, t0.DroitAcces AS DroitAcces_4, t0.ProfilUserAscensoriste AS ProfilUserAscensoriste_5, t0.ProfilSalarier AS ProfilSalarier_6, t0.roles AS roles_7, t0.isDeletable AS isDeletable_8, t0.IDTypeUtilisateur AS IDTypeUtilisateur_9 FROM Profil t0 WHERE t0.IDProfil = '3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Profil::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Profil->__get (line 153)
7	App\Entity\Profil->getPlLibelle (line 64)
8	App\EventListener\AppRequestListener->__invoke (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

0.20 ms
(4.12%)

SELECT t0.IDScoreAscenseurSnapshot AS IDScoreAscenseurSnapshot_1, t0.ModeCalcul AS ModeCalcul_2, t0.RisqueNiveau AS RisqueNiveau_3, t0.RisqueLibelle AS RisqueLibelle_4, t0.RisqueCouleur AS RisqueCouleur_5, t0.ScoreGlobalTotal AS ScoreGlobalTotal_6, t0.ScoreGlobalMax AS ScoreGlobalMax_7, t0.ScoreGlobalPourcentage AS ScoreGlobalPourcentage_8, t0.ScoreTypeEquipement AS ScoreTypeEquipement_9, t0.ScoreTypeBatiment AS ScoreTypeBatiment_10, t0.ScoreEtatAnciennete AS ScoreEtatAnciennete_11, t0.ScoreNombreNiveaux AS ScoreNombreNiveaux_12, t0.ScoreChargeCapacite AS ScoreChargeCapacite_13, t0.ScoreFrequenceDepannages AS ScoreFrequenceDepannages_14, t0.ScoreFrequenceMaintenance AS ScoreFrequenceMaintenance_15, t0.ScoreTempsAnnuelEstime AS ScoreTempsAnnuelEstime_16, t0.DateCalcul AS DateCalcul_17, t0.IDAscenseur AS IDAscenseur_18 FROM ScoreAscenseurSnapshot t0 WHERE t0.IDAscenseur = ?

Parameters:

[
  376
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDScoreAscenseurSnapshot AS IDScoreAscenseurSnapshot_1,
  t0.ModeCalcul AS ModeCalcul_2,
  t0.RisqueNiveau AS RisqueNiveau_3,
  t0.RisqueLibelle AS RisqueLibelle_4,
  t0.RisqueCouleur AS RisqueCouleur_5,
  t0.ScoreGlobalTotal AS ScoreGlobalTotal_6,
  t0.ScoreGlobalMax AS ScoreGlobalMax_7,
  t0.ScoreGlobalPourcentage AS ScoreGlobalPourcentage_8,
  t0.ScoreTypeEquipement AS ScoreTypeEquipement_9,
  t0.ScoreTypeBatiment AS ScoreTypeBatiment_10,
  t0.ScoreEtatAnciennete AS ScoreEtatAnciennete_11,
  t0.ScoreNombreNiveaux AS ScoreNombreNiveaux_12,
  t0.ScoreChargeCapacite AS ScoreChargeCapacite_13,
  t0.ScoreFrequenceDepannages AS ScoreFrequenceDepannages_14,
  t0.ScoreFrequenceMaintenance AS ScoreFrequenceMaintenance_15,
  t0.ScoreTempsAnnuelEstime AS ScoreTempsAnnuelEstime_16,
  t0.DateCalcul AS DateCalcul_17,
  t0.IDAscenseur AS IDAscenseur_18
FROM
  ScoreAscenseurSnapshot t0
WHERE
  t0.IDAscenseur = ?

SELECT t0.IDScoreAscenseurSnapshot AS IDScoreAscenseurSnapshot_1, t0.ModeCalcul AS ModeCalcul_2, t0.RisqueNiveau AS RisqueNiveau_3, t0.RisqueLibelle AS RisqueLibelle_4, t0.RisqueCouleur AS RisqueCouleur_5, t0.ScoreGlobalTotal AS ScoreGlobalTotal_6, t0.ScoreGlobalMax AS ScoreGlobalMax_7, t0.ScoreGlobalPourcentage AS ScoreGlobalPourcentage_8, t0.ScoreTypeEquipement AS ScoreTypeEquipement_9, t0.ScoreTypeBatiment AS ScoreTypeBatiment_10, t0.ScoreEtatAnciennete AS ScoreEtatAnciennete_11, t0.ScoreNombreNiveaux AS ScoreNombreNiveaux_12, t0.ScoreChargeCapacite AS ScoreChargeCapacite_13, t0.ScoreFrequenceDepannages AS ScoreFrequenceDepannages_14, t0.ScoreFrequenceMaintenance AS ScoreFrequenceMaintenance_15, t0.ScoreTempsAnnuelEstime AS ScoreTempsAnnuelEstime_16, t0.DateCalcul AS DateCalcul_17, t0.IDAscenseur AS IDAscenseur_18 FROM ScoreAscenseurSnapshot t0 WHERE t0.IDAscenseur = 376;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Service\SessionAscensoristeService->setAscensoristeActif (line 64)
12	App\EventListener\AppRequestListener->__invoke (line 42)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	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\Ascenseur	2
App\Entity\Typevitessenominale	2
App\Entity\Typesecteur	2
App\Entity\Marquedemanoeuvre	2
App\Entity\Clientascoriste	2
App\Entity\Typeouverture	2
App\Entity\Typeequipement	2
App\Entity\Typechargeencabine	2
App\Entity\Typeservice	2
App\Entity\Typecategoriebatiment	2
App\Entity\Typelocalisationmachinerie	2
App\Entity\Contrat	2
App\Entity\Scoring\ScoreAscenseur	2
App\Entity\Scoring\ScoreAscenseurSnapshot	2
App\Entity\User	1
App\Entity\Profil	1
App\Entity\Ascensoriste	1
App\Entity\Typeconstructeur	1
App\Entity\Typeportepaliere	1
App\Entity\Typedeplacement	1
App\Entity\Groupepropriete	1
App\Entity\Typeproprietaire	1
App\Entity\Typeutilisateur	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Profil	No errors.
App\Entity\Ascensoriste	No errors.
App\Entity\Scoring\TypeExperienceTechnicien	No errors.
App\Entity\PushToken	No errors.
App\Entity\Notification	No errors.
App\Entity\Typesecteur	No errors.
App\Entity\Typecompetence	No errors.
App\Entity\Typehabilitation	No errors.
App\Entity\Typepermis	No errors.
App\Entity\Documentuser	No errors.
App\Entity\Avancementtravaux	The field App\Entity\Avancementtravaux#avancementOperations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AvancementOperation#avancementtravaux does not contain the required 'inversedBy: "avancementOperations"' attribute. The field App\Entity\Avancementtravaux#travauxRealises is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Travauxrealisedansavancement#avancementtravaux does not contain the required 'inversedBy: "travauxRealises"' attribute. The field App\Entity\Avancementtravaux#travauxPrevus is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Travauxprevudansavancement#avancementtravaux does not contain the required 'inversedBy: "travauxPrevus"' attribute. The field App\Entity\Avancementtravaux#pointsBloquants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pointbloquantdansavancement#avancementtravaux does not contain the required 'inversedBy: "pointsBloquants"' attribute.
App\Entity\Modeledevis	No errors.
App\Entity\Ascenseur	The field App\Entity\Ascenseur#carnetmaintenances is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#idascenseur does not contain the required 'inversedBy: "carnetmaintenances"' attribute.
App\Entity\Fournisseur	The field App\Entity\Fournisseur#piecesdetachees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Piecesdetachees#idfournisseur does not contain the required 'inversedBy: "piecesdetachees"' attribute.
App\Entity\Clientascoriste	The mappings App\Entity\Clientascoriste#contactclientascoriste and App\Entity\Contactclientascoriste#idclientascoriste are inconsistent with each other.
App\Entity\Typeoperationmaintenance	No errors.
App\Entity\Abonnement	No errors.
App\Entity\Salarier	No errors.
App\Entity\Contrat	No errors.
App\Entity\Lemarche	No errors.
App\Entity\Typevitessenominale	No errors.
App\Entity\Typeconstructeur	No errors.
App\Entity\Typemarqueserrure	No errors.
App\Entity\Marquedemanoeuvre	No errors.
App\Entity\Typeportepaliere	No errors.
App\Entity\Typedeverrouillage	No errors.
App\Entity\Site	No errors.
App\Entity\Typebatiment	No errors.
App\Entity\Typeouverture	No errors.
App\Entity\Typeequipement	No errors.
App\Entity\Typedeplacement	No errors.
App\Entity\Typechargeencabine	No errors.
App\Entity\Typeservice	No errors.
App\Entity\Typecategoriebatiment	No errors.
App\Entity\Typelocalisationmachinerie	No errors.
App\Entity\Facturation\FacturationAscenseur	No errors.
App\Entity\Scoring\ScoreAscenseur	No errors.
App\Entity\Scoring\TypescoretypefrequenceMaintenance	No errors.
App\Entity\Scoring\TypeScoreModeCalculeTempsAnnuel	No errors.
App\Entity\Scoring\Typescoretypebatiment	No errors.
App\Entity\Scoring\Typescorenombreniveau	No errors.
App\Entity\Scoring\Typescorefrequenceintervention	No errors.
App\Entity\Scoring\Typescoreetatappareil	No errors.
App\Entity\Scoring\TypeScoreSourceDonnee	No errors.
App\Entity\Scoring\TypeScoreModeCalcule	No errors.
App\Entity\Scoring\TypeScoreUsageScore	No errors.
App\Entity\Scoring\TypeScoreAffectationSecteur	No errors.
App\Entity\Scoring\TypeScoreFamilleEquipement	No errors.
App\Entity\Scoring\TypeScoreRisqueglobal	No errors.
App\Entity\Scoring\TypeScoreChargeCapacite	No errors.
App\Entity\Scoring\ScoreAscenseurSnapshot	No errors.
App\Entity\Accessursite	No errors.
App\Entity\Armoiremanoeuvre	No errors.
App\Entity\Attelage	The field App\Entity\Attelage#detailpouliemoufflage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Detailpouliemoufflage#idattelage does not contain the required 'inversedBy: "detailpouliemoufflage"' attribute. The field App\Entity\Attelage#machineriehautedansattelage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Machineriehautedansattelage#idattelage does not contain the required 'inversedBy: "machineriehautedansattelage"' attribute. The field App\Entity\Attelage#machineriebassedansattelage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Machineriebassedansattelage#idattelage does not contain the required 'inversedBy: "machineriebassedansattelage"' attribute.
App\Entity\Boiteboutonequipement	The field App\Entity\Boiteboutonequipement#idniveaudansboitebouton is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Niveaudansboitebouton#idboiteboutonequipement does not contain the required 'inversedBy: "idniveaudansboitebouton"' attribute.
App\Entity\Cabineequipement	The field App\Entity\Cabineequipement#maincourantesdanscabineequipement is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Maincourantdanscabine#idcabineequipement does not contain the required 'inversedBy: "maincourantesdanscabineequipement"' attribute. The field App\Entity\Cabineequipement#vitragesdanscabineequipement is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Vitragedanscabine#idcabineequipement does not contain the required 'inversedBy: "vitragesdanscabineequipement"' attribute.
App\Entity\Cuvette	No errors.
App\Entity\Gaine	The field App\Entity\Gaine#idniveaudansgaine is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Niveaudansgaine#idgaine does not contain the required 'inversedBy: "idniveaudansgaine"' attribute. The field App\Entity\Gaine#idceinturedansgaine is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ceinturedansgaine#idgaine does not contain the required 'inversedBy: "idceinturedansgaine"' attribute. The field App\Entity\Gaine#dimensionsdansgaine is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Dimensiondansgaine#idgaine does not contain the required 'inversedBy: "dimensionsdansgaine"' attribute.
App\Entity\Groupetraction	The field App\Entity\Groupetraction#infoimplantations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Infoimplantation#idgroupetraction does not contain the required 'inversedBy: "infoimplantations"' attribute.
App\Entity\Limiteurvitesse	The field App\Entity\Limiteurvitesse#guide is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Guide#idlimiteurvitesse does not contain the required 'inversedBy: "guide"' attribute.
App\Entity\Pendentifs	No errors.
App\Entity\Portecabineoperateur	No errors.
App\Entity\Portepaliere	The field App\Entity\Portepaliere#idniveaudansportepaliere is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Niveaudansportepaliere#idportepaliere does not contain the required 'inversedBy: "idniveaudansportepaliere"' attribute.
App\Entity\Telephoneurgence	No errors.
App\Entity\Accesmachineriepoulie	No errors.
App\Entity\Carnetmaintenance	No errors.
App\Entity\Devistravauxparasc	No errors.
App\Entity\Etatlieuxposttravauxasc	No errors.
App\Entity\Noteinformation	No errors.
App\Entity\Partitionparascenseur	The field App\Entity\Partitionparascenseur#images is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ImagePartitionAudit#partitionParAscenseur does not contain the required 'inversedBy: "images"' attribute.
App\Entity\Groupepropriete	No errors.
App\Entity\Typeproprietaire	No errors.
App\Entity\Controlleseasc	No errors.
App\Entity\Optiontarification	No errors.
App\Entity\RevisionPrixHistorique	No errors.
App\Entity\Typeutilisateur	No errors.
App\Entity\ComptaFacturation	No errors.
App\Entity\Typetva	No errors.
App\Entity\Facturation\TypeFacturePeriodicite	No errors.
App\Entity\Typeconditionpaiement	No errors.
App\Entity\Detailentretien	The field App\Entity\Detailentretien#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#detailentretien does not contain the required 'inversedBy: "carnetmaintenance"' attribute. The field App\Entity\Detailentretien#pieceparentretiens is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pieceparentretien#iddetailentretien does not contain the required 'inversedBy: "pieceparentretiens"' attribute.
App\Entity\Essaisphonie	The field App\Entity\Essaisphonie#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#essaisphonie does not contain the required 'inversedBy: "carnetmaintenance"' attribute.
App\Entity\Pvcabletraction	The field App\Entity\Pvcabletraction#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#pvcabletraction does not contain the required 'inversedBy: "carnetmaintenance"' attribute.
App\Entity\Detailspvparachute	The field App\Entity\Detailspvparachute#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#detailspvparachute does not contain the required 'inversedBy: "carnetmaintenance"' attribute.
App\Entity\Detailtravaux	The field App\Entity\Detailtravaux#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#detailtravaux does not contain the required 'inversedBy: "carnetmaintenance"' attribute.
App\Entity\Rapportbureaucontrole	The field App\Entity\Rapportbureaucontrole#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#rapportbureaucontrole does not contain the required 'inversedBy: "carnetmaintenance"' attribute. The field App\Entity\Rapportbureaucontrole#reserves is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Reservedansrapportbureaucontrole#idrapportbureaucontrole does not contain the required 'inversedBy: "reserves"' attribute.
App\Entity\Signalerpanne	The field App\Entity\Signalerpanne#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#signalerpanne does not contain the required 'inversedBy: "carnetmaintenance"' attribute. The field App\Entity\Signalerpanne#idpieceparpanne is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pieceparpanne#idsignalepanne does not contain the required 'inversedBy: "idpieceparpanne"' attribute.
App\Entity\Etudesecurite	No errors.
App\Entity\Historiquemarcheasc	The field App\Entity\Historiquemarcheasc#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#historiquemarcheasc does not contain the required 'inversedBy: "carnetmaintenance"' attribute.
App\Entity\Ficheremiseenservice	The field App\Entity\Ficheremiseenservice#carnetmaintenance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#ficheremiseenservice does not contain the required 'inversedBy: "carnetmaintenance"' attribute.

Symfony Profiler

GET https://arcadeapp.fr/api/ascenseurs/carnets/essais-phonie?idascenseur=385

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping