GET https://arcadeapp.fr/admin/activites/informationsgenerales?sch_adresse=&sch_naprl=610356&sch_typesecteur=66&year=

Response
200 OK
Browse referrer URL
IP
185.146.223.189
Profiled on
Token
429fbc

Query Metrics

50 Database Queries
33 Different statements
15.37 ms Query time
25 Invalid entities
315 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.66 ms
(10.81%) 		8 
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 FROM Ascensoriste t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
1.35 ms
(8.77%) 		4 
SELECT t0.IDContrat AS IDContrat_1, t0.Valide AS Valide_2, t0.TVA AS TVA_3, t0.PrixHT AS PrixHT_4, t0.PrixTTC AS PrixTTC_5, t0.PrixHTgsm AS PrixHTgsm_6, t0.PrixTTCgsm AS PrixTTCgsm_7, t0.RevisionPrix AS RevisionPrix_8, t0.NumContrat AS NumContrat_9, t0.DateProposition AS DateProposition_10, t0.aDeterminer AS aDeterminer_11, t0.DateContrat AS DateContrat_12, t0.resilier AS resilier_13, t0.DateResiliation AS DateResiliation_14, t0.Duree AS Duree_15, t0.TaciteRec AS TaciteRec_16, t0.Preavis AS Preavis_17, t0.NBVisiteAn AS NBVisiteAn_18, t0.DelaiInterventionPanne AS DelaiInterventionPanne_19, t0.DelaiInterventionDesincar AS DelaiInterventionDesincar_20, t0.DelaiRemiseEnService AS DelaiRemiseEnService_21, t0.DelaiRemplacementPiece AS DelaiRemplacementPiece_22, t0.AdresseContrat AS AdresseContrat_23, t0.photo AS photo_24, t0.PlageHoraireVisite AS PlageHoraireVisite_25, t0.HoraireDepannageCourant AS HoraireDepannageCourant_26, t0.HoraireDepannageDesincar AS HoraireDepannageDesincar_27, t0.PlanfondPenalite AS PlanfondPenalite_28, t0.PrixTotalHT AS PrixTotalHT_29, t0.IDTypeTva AS IDTypeTva_30, t0.IDTypeconditionpaiement AS IDTypeconditionpaiement_31, t0.IDTypeTvaGSM AS IDTypeTvaGSM_32, t0.IDClientAscoriste AS IDClientAscoriste_33, t0.IDAscensoriste AS IDAscensoriste_34 FROM Contrat t0 WHERE t0.IDClientAscoriste = ? AND t0.Valide = ?
Parameters: 
[
  "24"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.28 ms
(8.32%) 		1 
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.NbNiveauASC AS NbNiveauASC_14, t0.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_15, t0.loichatel AS loichatel_16, t0.GardienASC AS GardienASC_17, t0.PositionSerrure AS PositionSerrure_18, t0.NumAffaire AS NumAffaire_19, t0.QRCodeASC AS QRCodeASC_20, t0.QRCodeFile AS QRCodeFile_21, t0.ContactSurSite AS ContactSurSite_22, t0.NumeroContactSurSite AS NumeroContactSurSite_23, t0.EmailContactSurSite AS EmailContactSurSite_24, t0.IDVille AS IDVille_25, t0.CP AS CP_26, t0.CoffreAcle AS CoffreAcle_27, t0.Autre AS Autre_28, t0.IDTypeVitessenominale AS IDTypeVitessenominale_29, t0.IDFournisseur AS IDFournisseur_30, t0.IDConstructeur AS IDConstructeur_31, t0.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_32, t0.IDTypeSecteur AS IDTypeSecteur_33, t0.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_34, t0.IDTypePortePaliere AS IDTypePortePaliere_35, t0.IDTypeDeverrouillage AS IDTypeDeverrouillage_36, t0.IDClientAscoriste AS IDClientAscoriste_37, t0.IDTypeBatiment AS IDTypeBatiment_38, t0.IDTypeOuverture AS IDTypeOuverture_39, t0.IDTypeequipement AS IDTypeequipement_40, t0.IDTypeDeplacement AS IDTypeDeplacement_41, t0.IDTypeChargeencabine AS IDTypeChargeencabine_42, t0.IDTypeService AS IDTypeService_43, t0.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_44, t0.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_45, t0.IDAscensoriste AS IDAscensoriste_46, t0.IDContrat AS IDContrat_47, t48.IDGroupePropriete AS IDGroupePropriete_49, t48.Libelle AS Libelle_50, t48.NbMembre AS NbMembre_51, t48.IDTypeProprietaire AS IDTypeProprietaire_52, t48.IDAscenseur AS IDAscenseur_53 FROM Ascenseur t0 LEFT JOIN GroupePropriete t48 ON t48.IDAscenseur = t0.IDAscenseur WHERE t0.IDContrat = ?
Parameters: 
[
  45
]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(6.51%) 		2 
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.IDVille AS IDVille_10, t0.isAdmin AS isAdmin_11, t0.IDProfil AS IDProfil_12, t0.IDAscensoriste AS IDAscensoriste_13 FROM user t0 WHERE t0.isAdmin = ? AND t0.EstActive = ?
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(5.56%) 		3 
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_.IDAscenseur AS IDAscenseur_13, c0_.IDTechnicien AS IDTechnicien_14, c0_.IDDetailEntretien AS IDDetailEntretien_15, c0_.IDEssaisPhonie AS IDEssaisPhonie_16, c0_.IDPVCableTraction AS IDPVCableTraction_17, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18, c0_.IDDetailtravaux AS IDDetailtravaux_19, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20, c0_.IDSignalerPanne AS IDSignalerPanne_21, c0_.IDEtudeSecurite AS IDEtudeSecurite_22, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23, c0_.IDFicheRemiseService AS IDFicheRemiseService_24 FROM CarnetMaintenance c0_ WHERE c0_.IDAscenseur = ? AND c0_.IDTypeVisite = ? ORDER BY c0_.DateVisite DESC LIMIT 1
Parameters: 
[
  212
  "ENTRETIEN"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(4.62%) 		2 
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_.IDAscenseur AS IDAscenseur_13, c0_.IDTechnicien AS IDTechnicien_14, c0_.IDDetailEntretien AS IDDetailEntretien_15, c0_.IDEssaisPhonie AS IDEssaisPhonie_16, c0_.IDPVCableTraction AS IDPVCableTraction_17, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18, c0_.IDDetailtravaux AS IDDetailtravaux_19, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20, c0_.IDSignalerPanne AS IDSignalerPanne_21, c0_.IDEtudeSecurite AS IDEtudeSecurite_22, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23, c0_.IDFicheRemiseService AS IDFicheRemiseService_24 FROM CarnetMaintenance c0_ WHERE ((c0_.DateVisite >= ? AND c0_.DateVisite <= ?) OR (c0_.DateProchainVisite >= ? AND c0_.DateProchainVisite <= ?)) AND c0_.IDAscenseur = ? AND c0_.IDTypeVisite = ? ORDER BY c0_.DateVisite DESC
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  212
  "ENTRETIEN"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(4.60%) 		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_.NbNiveauASC AS NbNiveauASC_13, a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_14, a0_.loichatel AS loichatel_15, a0_.GardienASC AS GardienASC_16, a0_.PositionSerrure AS PositionSerrure_17, a0_.NumAffaire AS NumAffaire_18, a0_.QRCodeASC AS QRCodeASC_19, a0_.QRCodeFile AS QRCodeFile_20, a0_.ContactSurSite AS ContactSurSite_21, a0_.NumeroContactSurSite AS NumeroContactSurSite_22, a0_.EmailContactSurSite AS EmailContactSurSite_23, a0_.IDVille AS IDVille_24, a0_.CP AS CP_25, a0_.CoffreAcle AS CoffreAcle_26, a0_.Autre AS Autre_27, a0_.IDTypeVitessenominale AS IDTypeVitessenominale_28, a0_.IDFournisseur AS IDFournisseur_29, a0_.IDConstructeur AS IDConstructeur_30, a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_31, a0_.IDTypeSecteur AS IDTypeSecteur_32, a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_33, a0_.IDTypePortePaliere AS IDTypePortePaliere_34, a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_35, a0_.IDClientAscoriste AS IDClientAscoriste_36, a0_.IDTypeBatiment AS IDTypeBatiment_37, a0_.IDTypeOuverture AS IDTypeOuverture_38, a0_.IDTypeequipement AS IDTypeequipement_39, a0_.IDTypeDeplacement AS IDTypeDeplacement_40, a0_.IDTypeChargeencabine AS IDTypeChargeencabine_41, a0_.IDTypeService AS IDTypeService_42, a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_43, a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_44, a0_.IDAscensoriste AS IDAscensoriste_45, a0_.IDContrat AS IDContrat_46 FROM Ascenseur a0_ INNER JOIN Contrat c1_ ON a0_.IDContrat = c1_.IDContrat WHERE a0_.IDAscensoriste = ? AND c1_.Valide = ? AND c1_.DateContrat <= ? AND ((c1_.resilier = 0 OR (c1_.resilier = 1 AND c1_.DateResiliation > ?))) AND a0_.NumAppareilASC LIKE ? AND a0_.IDTypeSecteur = ?
Parameters: 
[
  "9"
  1
  "2026-04-07 16:22:16"
  "2026-04-07 16:22:16"
  "%610356%"
  "66"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(3.15%) 		2 
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.CodeComptable AS CodeComptable_10, t0.IDUser AS IDUser_11, t0.IDAscensoriste AS IDAscensoriste_12 FROM ClientAscoriste t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(2.88%) 		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.IDVille AS IDVille_10, t0.isAdmin AS isAdmin_11, t0.IDProfil AS IDProfil_12, t0.IDAscensoriste AS IDAscensoriste_13 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(2.72%) 		1 
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.EstActive AS EstActive_4, u0_.NomPrenom AS NomPrenom_5, u0_.Tel AS Tel_6, u0_.Adresse AS Adresse_7, u0_.Pays AS Pays_8, u0_.IDVille AS IDVille_9, u0_.isAdmin AS isAdmin_10, u0_.IDProfil AS IDProfil_11, u0_.IDAscensoriste AS IDAscensoriste_12 FROM user u0_ WHERE u0_.IDAscensoriste = ? AND u0_.EstActive = ? AND u0_.roles LIKE ?
Parameters: 
[
  9
  1
  "%ROLE_TECHNICIEN%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(2.53%) 		1 
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, e1_.IDEssaisPhonie AS IDEssaisPhonie_13, e1_.IDCarnetMaintenance AS IDCarnetMaintenance_14, e1_.RapportEssaiPhonie AS RapportEssaiPhonie_15, e1_.EssaiConcluant AS EssaiConcluant_16, e1_.TestTelephoneCabine AS TestTelephoneCabine_17, e1_.MotifTestTelephoneCabine AS MotifTestTelephoneCabine_18, e1_.TestTelephoneSurToitCabine AS TestTelephoneSurToitCabine_19, e1_.MotifTestTelephoneSurToitCabine AS MotifTestTelephoneSurToitCabine_20, e1_.TestTelephoneCuvetteSousCabine AS TestTelephoneCuvetteSousCabine_21, e1_.MotifTestTelephoneCuvetteSousCabine AS MotifTestTelephoneCuvetteSousCabine_22, e1_.IdentLieuAppareilConcluant AS IdentLieuAppareilConcluant_23, e1_.TestBatterieSecourConcluant AS TestBatterieSecourConcluant_24, e1_.AcquietmentAppelConcluant AS AcquietmentAppelConcluant_25, c0_.IDAscenseur AS IDAscenseur_26, c0_.IDTechnicien AS IDTechnicien_27, c0_.IDDetailEntretien AS IDDetailEntretien_28, c0_.IDEssaisPhonie AS IDEssaisPhonie_29, c0_.IDPVCableTraction AS IDPVCableTraction_30, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_31, c0_.IDDetailtravaux AS IDDetailtravaux_32, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_33, c0_.IDSignalerPanne AS IDSignalerPanne_34, c0_.IDEtudeSecurite AS IDEtudeSecurite_35, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_36, c0_.IDFicheRemiseService AS IDFicheRemiseService_37, e1_.IDPeriode AS IDPeriode_38 FROM CarnetMaintenance c0_ INNER JOIN essaisphonie e1_ ON c0_.IDEssaisPhonie = e1_.IDEssaisPhonie WHERE c0_.IDAscenseur = ? AND c0_.IDTypeVisite = ? AND e1_.EssaiConcluant = ? ORDER BY c0_.DateVisite DESC LIMIT 1
Parameters: 
[
  212
  "ESSAI_PHONIE"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(2.53%) 		1 
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, d1_.IDDetailtravaux AS IDDetailtravaux_13, d1_.RapportTravaux AS RapportTravaux_14, t2_.IDTypeTravaux AS IDTypeTravaux_15, t2_.Libelle AS Libelle_16, t2_.ERentabilite AS ERentabilite_17, c0_.IDAscenseur AS IDAscenseur_18, c0_.IDTechnicien AS IDTechnicien_19, c0_.IDDetailEntretien AS IDDetailEntretien_20, c0_.IDEssaisPhonie AS IDEssaisPhonie_21, c0_.IDPVCableTraction AS IDPVCableTraction_22, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_23, c0_.IDDetailtravaux AS IDDetailtravaux_24, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_25, c0_.IDSignalerPanne AS IDSignalerPanne_26, c0_.IDEtudeSecurite AS IDEtudeSecurite_27, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_28, c0_.IDFicheRemiseService AS IDFicheRemiseService_29, d1_.IDTypeTravaux AS IDTypeTravaux_30, d1_.IDDevisMaintenance AS IDDevisMaintenance_31 FROM CarnetMaintenance c0_ INNER JOIN detailtravaux d1_ ON c0_.IDDetailtravaux = d1_.IDDetailtravaux INNER JOIN typetravaux t2_ ON d1_.IDTypeTravaux = t2_.IDTypeTravaux WHERE ((c0_.DateVisite >= ? AND c0_.DateVisite <= ?) OR (c0_.DateProchainVisite >= ? AND c0_.DateProchainVisite <= ?)) AND c0_.IDAscenseur = ? AND c0_.IDTypeVisite = ? AND t2_.ERentabilite = ?
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  212
  "TRAVAUX_CONTROLE"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(2.51%) 		1 
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.NbNiveauASC AS NbNiveauASC_14, t0.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_15, t0.loichatel AS loichatel_16, t0.GardienASC AS GardienASC_17, t0.PositionSerrure AS PositionSerrure_18, t0.NumAffaire AS NumAffaire_19, t0.QRCodeASC AS QRCodeASC_20, t0.QRCodeFile AS QRCodeFile_21, t0.ContactSurSite AS ContactSurSite_22, t0.NumeroContactSurSite AS NumeroContactSurSite_23, t0.EmailContactSurSite AS EmailContactSurSite_24, t0.IDVille AS IDVille_25, t0.CP AS CP_26, t0.CoffreAcle AS CoffreAcle_27, t0.Autre AS Autre_28, t0.IDTypeVitessenominale AS IDTypeVitessenominale_29, t0.IDFournisseur AS IDFournisseur_30, t0.IDConstructeur AS IDConstructeur_31, t0.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_32, t0.IDTypeSecteur AS IDTypeSecteur_33, t0.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_34, t0.IDTypePortePaliere AS IDTypePortePaliere_35, t0.IDTypeDeverrouillage AS IDTypeDeverrouillage_36, t0.IDClientAscoriste AS IDClientAscoriste_37, t0.IDTypeBatiment AS IDTypeBatiment_38, t0.IDTypeOuverture AS IDTypeOuverture_39, t0.IDTypeequipement AS IDTypeequipement_40, t0.IDTypeDeplacement AS IDTypeDeplacement_41, t0.IDTypeChargeencabine AS IDTypeChargeencabine_42, t0.IDTypeService AS IDTypeService_43, t0.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_44, t0.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_45, t0.IDAscensoriste AS IDAscensoriste_46, t0.IDContrat AS IDContrat_47, t48.IDGroupePropriete AS IDGroupePropriete_49, t48.Libelle AS Libelle_50, t48.NbMembre AS NbMembre_51, t48.IDTypeProprietaire AS IDTypeProprietaire_52, t48.IDAscenseur AS IDAscenseur_53 FROM Ascenseur t0 LEFT JOIN GroupePropriete t48 ON t48.IDAscenseur = t0.IDAscenseur WHERE t0.IDAscenseur = ?
Parameters: 
[
  "220"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(2.41%) 		1 
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.NbNiveauASC AS NbNiveauASC_14, t0.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_15, t0.loichatel AS loichatel_16, t0.GardienASC AS GardienASC_17, t0.PositionSerrure AS PositionSerrure_18, t0.NumAffaire AS NumAffaire_19, t0.QRCodeASC AS QRCodeASC_20, t0.QRCodeFile AS QRCodeFile_21, t0.ContactSurSite AS ContactSurSite_22, t0.NumeroContactSurSite AS NumeroContactSurSite_23, t0.EmailContactSurSite AS EmailContactSurSite_24, t0.IDVille AS IDVille_25, t0.CP AS CP_26, t0.CoffreAcle AS CoffreAcle_27, t0.Autre AS Autre_28, t0.IDTypeVitessenominale AS IDTypeVitessenominale_29, t0.IDFournisseur AS IDFournisseur_30, t0.IDConstructeur AS IDConstructeur_31, t0.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_32, t0.IDTypeSecteur AS IDTypeSecteur_33, t0.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_34, t0.IDTypePortePaliere AS IDTypePortePaliere_35, t0.IDTypeDeverrouillage AS IDTypeDeverrouillage_36, t0.IDClientAscoriste AS IDClientAscoriste_37, t0.IDTypeBatiment AS IDTypeBatiment_38, t0.IDTypeOuverture AS IDTypeOuverture_39, t0.IDTypeequipement AS IDTypeequipement_40, t0.IDTypeDeplacement AS IDTypeDeplacement_41, t0.IDTypeChargeencabine AS IDTypeChargeencabine_42, t0.IDTypeService AS IDTypeService_43, t0.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_44, t0.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_45, t0.IDAscensoriste AS IDAscensoriste_46, t0.IDContrat AS IDContrat_47, t48.IDGroupePropriete AS IDGroupePropriete_49, t48.Libelle AS Libelle_50, t48.NbMembre AS NbMembre_51, t48.IDTypeProprietaire AS IDTypeProprietaire_52, t48.IDAscenseur AS IDAscenseur_53 FROM Ascenseur t0 LEFT JOIN GroupePropriete t48 ON t48.IDAscenseur = t0.IDAscenseur WHERE t0.IDAscenseur = ? LIMIT 1
Parameters: 
[
  "212"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(2.31%) 		2 
SELECT COUNT(*) FROM Profil t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(2.13%) 		1 
SELECT COALESCE(SUM(r0_.NBreservealever), 0) AS sclr_0 FROM Ascenseur a1_ LEFT JOIN CarnetMaintenance c2_ ON a1_.IDAscenseur = c2_.IDAscenseur LEFT JOIN rapportbureaucontrole r0_ ON c2_.IDRapportBureaucontrole = r0_.IDRapportBureaucontrole WHERE a1_.IDAscenseur = ? AND c2_.IDTypeVisite = ? AND r0_.NBreservealever IS NOT NULL AND (c2_.DateVisite BETWEEN ? AND ?)
Parameters: 
[
  212
  "BUREAU_CONTROLE"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(2.10%) 		1 
SELECT COUNT(p0_.IDPieceParEntretien) AS sclr_0 FROM pieceparentretien p0_ INNER JOIN detailentretien d1_ ON p0_.IDDetailEntretien = d1_.IDDetailEntretien INNER JOIN CarnetMaintenance c2_ ON d1_.IDDetailEntretien = c2_.IDDetailEntretien WHERE c2_.IDAscenseur = ? AND c2_.IDTypeVisite = ? AND (c2_.DateVisite BETWEEN ? AND ?) AND p0_.PieceRemplace = ?
Parameters: 
[
  212
  "ENTRETIEN"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(1.99%) 		1 
SELECT COUNT(p0_.IDPieceParPanne) AS sclr_0 FROM pieceparpanne p0_ INNER JOIN SignalerPanne s1_ ON p0_.IDSignalerPanne = s1_.IDSignalerPanne INNER JOIN CarnetMaintenance c2_ ON s1_.IDSignalerPanne = c2_.IDSignalerPanne WHERE c2_.IDAscenseur = ? AND c2_.IDTypeVisite = ? AND (c2_.DateVisite BETWEEN ? AND ?) AND p0_.PieceRemplace = ?
Parameters: 
[
  212
  "DEPANNAGE"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(1.95%) 		2 
SELECT COUNT(*) FROM Ascensoriste t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(1.95%) 		1 
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: 
[
  212
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(1.92%) 		1 
SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.MarcheDegrade AS MarcheDegrade_8, t0.EtablirDevis AS EtablirDevis_9, t0.AssistanceTechnique AS AssistanceTechnique_10, t0.IDTypeVisite AS IDTypeVisite_11, t0.IDTypeStatutASC AS IDTypeStatutASC_12, t0.NotifEnvoye AS NotifEnvoye_13, t0.IDAscenseur AS IDAscenseur_14, t0.IDTechnicien AS IDTechnicien_15, t0.IDDetailEntretien AS IDDetailEntretien_16, t0.IDEssaisPhonie AS IDEssaisPhonie_17, t0.IDPVCableTraction AS IDPVCableTraction_18, t0.IDDetailsPVParachute AS IDDetailsPVParachute_19, t0.IDDetailtravaux AS IDDetailtravaux_20, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_21, t0.IDSignalerPanne AS IDSignalerPanne_22, t0.IDEtudeSecurite AS IDEtudeSecurite_23, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_24, t0.IDFicheRemiseService AS IDFicheRemiseService_25 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC
Parameters: 
[
  212
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(1.91%) 		1 
SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.MarcheDegrade AS MarcheDegrade_8, t0.EtablirDevis AS EtablirDevis_9, t0.AssistanceTechnique AS AssistanceTechnique_10, t0.IDTypeVisite AS IDTypeVisite_11, t0.IDTypeStatutASC AS IDTypeStatutASC_12, t0.NotifEnvoye AS NotifEnvoye_13, t0.IDAscenseur AS IDAscenseur_14, t0.IDTechnicien AS IDTechnicien_15, t0.IDDetailEntretien AS IDDetailEntretien_16, t0.IDEssaisPhonie AS IDEssaisPhonie_17, t0.IDPVCableTraction AS IDPVCableTraction_18, t0.IDDetailsPVParachute AS IDDetailsPVParachute_19, t0.IDDetailtravaux AS IDDetailtravaux_20, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_21, t0.IDSignalerPanne AS IDSignalerPanne_22, t0.IDEtudeSecurite AS IDEtudeSecurite_23, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_24, t0.IDFicheRemiseService AS IDFicheRemiseService_25 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? AND t0.IDTypeVisite = ? ORDER BY t0.DateVisite DESC
Parameters: 
[
  "212"
  "DEPANNAGE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(1.61%) 		1 
SELECT t0.IDFournisseur AS IDFournisseur_1, t0.NomFournisseur AS NomFournisseur_2, t0.TelFournisseur AS TelFournisseur_3, t0.EmailFournisseur AS EmailFournisseur_4, t0.AdresseFournisseur AS AdresseFournisseur_5, t0.SiteWebFournisseur AS SiteWebFournisseur_6, t0.RefFournisseur AS RefFournisseur_7, t0.NomContactFournisseur AS NomContactFournisseur_8, t0.IDAscensoriste AS IDAscensoriste_9 FROM Fournisseur t0 WHERE t0.IDAscensoriste IN (?)
Parameters: 
[
  "9"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(1.59%) 		1 
SELECT COUNT(*) FROM ClientAscoriste t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(1.58%) 		1 
SELECT t0.IDEmailrelanceducarnet AS IDEmailrelanceducarnet_1, t0.Date AS Date_2, t0.Envoyer AS Envoyer_3, t0.DescriptionLongue AS DescriptionLongue_4, t0.IDCarnetMaintenance AS IDCarnetMaintenance_5, t0.IDAscensoriste AS IDAscensoriste_6 FROM emailrelanceducarnet t0 WHERE t0.IDCarnetMaintenance = ? ORDER BY t0.Date DESC
Parameters: 
[
  "3026"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(1.57%) 		1 
SELECT t0.IDTypeSecteur AS IDTypeSecteur_1, t0.Libelle AS Libelle_2, t0.IDAscensoriste AS IDAscensoriste_3 FROM TypeSecteur t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(1.57%) 		1 
SELECT t0.IDNotification AS IDNotification_1, t0.NOT_Titre AS NOT_Titre_2, t0.NOT_Rubrique AS NOT_Rubrique_3, t0.NOT_Text AS NOT_Text_4, t0.NOT_Lu AS NOT_Lu_5, t0.NOT_DateCreation AS NOT_DateCreation_6, t0.user_id AS user_id_7 FROM Notification t0 WHERE t0.user_id = ? AND t0.NOT_Lu = ? ORDER BY t0.NOT_DateCreation DESC
Parameters: 
[
  4
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(1.49%) 		1 
SELECT COUNT(c0_.IDCommande) AS sclr_0 FROM Commande c0_ WHERE c0_.IDAscensoriste = ? AND c0_.Status NOT IN (?, ?)
Parameters: 
[
  9
  "LIVREE"
  "ANNULEE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(1.45%) 		1 
SELECT t0.IDEmailrelanceducarnet AS IDEmailrelanceducarnet_1, t0.Date AS Date_2, t0.Envoyer AS Envoyer_3, t0.DescriptionLongue AS DescriptionLongue_4, t0.IDCarnetMaintenance AS IDCarnetMaintenance_5, t0.IDAscensoriste AS IDAscensoriste_6 FROM emailrelanceducarnet t0 WHERE t0.IDCarnetMaintenance = ?
Parameters: 
[
  3026
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(1.31%) 		1 
SELECT COUNT(p0_.IDPanier) AS sclr_0 FROM Panier p0_ WHERE p0_.IDAscensoriste = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(1.23%) 		1 
SELECT COUNT(*) FROM Ascenseur t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(1.23%) 		1 
SELECT COUNT(c0_.IDCommande) AS sclr_0 FROM Commande c0_ WHERE c0_.IDAscensoriste = ? AND c0_.Status NOT IN (?, ?, ?)
Parameters: 
[
  9
  "VALIDEE"
  "LIVREE"
  "ANNULEE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(1.19%) 		1 
SELECT COUNT(*) FROM ClientAscoriste t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace

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 122
App\Entity\Groupepropriete 122
App\Entity\User 14
App\Entity\Typechargeencabine 13
App\Entity\Typesecteur 9
App\Entity\Ascensoriste 8
App\Entity\Clientascoriste 4
App\Entity\Profil 3
App\Entity\Typevitessenominale 3
App\Entity\Typecategoriebatiment 2
App\Entity\Typeouverture 2
App\Entity\Typeportepaliere 1
App\Entity\Typelocalisationmachinerie 1
App\Entity\Contrat 1
App\Entity\Typeproprietaire 1
App\Entity\Typeconstructeur 1
App\Entity\Marquedemanoeuvre 1
App\Entity\Typedeplacement 1
App\Entity\Typeservice 1
App\Entity\Carnetmaintenance 1
App\Entity\Pvcabletraction 1
App\Entity\Typetva 1
App\Entity\Typebatiment 1
App\Entity\Typeequipement 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Profil No errors.
App\Entity\Ascensoriste
  • The field App\Entity\Ascensoriste#ascenseurs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ascenseur#idascensoriste does not contain the required 'inversedBy: "ascenseurs"' attribute.
  • The field App\Entity\Ascensoriste#users is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#idascensoriste does not contain the required 'inversedBy: "users"' attribute.
  • The field App\Entity\Ascensoriste#fournisseurs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Fournisseur#idascensoriste does not contain the required 'inversedBy: "fournisseurs"' attribute.
  • The field App\Entity\Ascensoriste#clientascoriste is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Clientascoriste#idascensoriste does not contain the required 'inversedBy: "clientascoriste"' attribute.
  • The field App\Entity\Ascensoriste#typeoperationmaintenances is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Typeoperationmaintenance#ascensoriste does not contain the required 'inversedBy: "typeoperationmaintenances"' attribute.
App\Entity\PushToken No errors.
App\Entity\Typesecteur 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\Ascenseur
  • The field 'App\Entity\Ascenseur#nbrpersonne' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field App\Entity\Ascenseur#armoiremanoeuvre is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Armoiremanoeuvre#idascenseur does not contain the required 'inversedBy: "armoiremanoeuvre"' attribute.
  • The field App\Entity\Ascenseur#attelage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Attelage#idascenseur does not contain the required 'inversedBy: "attelage"' attribute.
  • The field App\Entity\Ascenseur#boiteboutonequipement is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Boiteboutonequipement#idascenseur does not contain the required 'inversedBy: "boiteboutonequipement"' attribute.
  • The field App\Entity\Ascenseur#cabineequipement is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cabineequipement#idascenseur does not contain the required 'inversedBy: "cabineequipement"' attribute.
  • The field App\Entity\Ascenseur#cuvette is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cuvette#idascenseur does not contain the required 'inversedBy: "cuvette"' attribute.
  • The field App\Entity\Ascenseur#gaine is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Gaine#idascenseur does not contain the required 'inversedBy: "gaine"' attribute.
  • The field App\Entity\Ascenseur#groupetraction is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Groupetraction#idascenseur does not contain the required 'inversedBy: "groupetraction"' attribute.
  • The field App\Entity\Ascenseur#limiteurvitesse is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Limiteurvitesse#idascenseur does not contain the required 'inversedBy: "limiteurvitesse"' attribute.
  • The field App\Entity\Ascenseur#pendentifs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pendentifs#idascenseur does not contain the required 'inversedBy: "pendentifs"' attribute.
  • The field App\Entity\Ascenseur#portecabineoperateur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Portecabineoperateur#idascenseur does not contain the required 'inversedBy: "portecabineoperateur"' attribute.
  • The field App\Entity\Ascenseur#portepaliere is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Portepaliere#idascenseur does not contain the required 'inversedBy: "portepaliere"' attribute.
  • The field App\Entity\Ascenseur#telephoneurgence is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Telephoneurgence#idascenseur does not contain the required 'inversedBy: "telephoneurgence"' attribute.
  • The field App\Entity\Ascenseur#accesmachineriepoulie is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Accesmachineriepoulie#idascenseur does not contain the required 'inversedBy: "accesmachineriepoulie"' attribute.
  • The field App\Entity\Ascenseur#carnetmaintenancesentretien 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: "carnetmaintenancesentretien"' attribute.
  • The field App\Entity\Ascenseur#carnetmaintenanceessaisphonie 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: "carnetmaintenanceessaisphonie"' attribute.
  • The field App\Entity\Ascenseur#carnetmaintenancecontrolecable 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: "carnetmaintenancecontrolecable"' attribute.
  • The field App\Entity\Ascenseur#carnetmaintenancecontroleparachute 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: "carnetmaintenancecontroleparachute"' attribute.
  • The field App\Entity\Ascenseur#carnetmaintenancetravauxcontrole 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: "carnetmaintenancetravauxcontrole"' attribute.
  • The field App\Entity\Ascenseur#carnetmaintenancedepannage 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: "carnetmaintenancedepannage"' attribute.
  • The field App\Entity\Ascenseur#carnetmaintenancebureaucontrole 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: "carnetmaintenancebureaucontrole"' attribute.
  • The field App\Entity\Ascenseur#devistravauxparasc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Devistravauxparasc#idascenseur does not contain the required 'inversedBy: "devistravauxparasc"' attribute.
  • The field App\Entity\Ascenseur#idEtatlieuxposttravauxasc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Etatlieuxposttravauxasc#idascenseur does not contain the required 'inversedBy: "idEtatlieuxposttravauxasc"' attribute.
  • The field App\Entity\Ascenseur#idpartitionparascenseur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Partitionparascenseur#idascenseur does not contain the required 'inversedBy: "idpartitionparascenseur"' attribute.
  • The field App\Entity\Ascenseur#controlleseascs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Controlleseasc#idascenseur does not contain the required 'inversedBy: "controlleseascs"' attribute.
App\Entity\Contrat
  • The association App\Entity\Contrat#idascensoriste refers to the inverse side field App\Entity\Ascensoriste#contrats which does not exist.
  • The field App\Entity\Contrat#idascenseur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ascenseur#idcontrat does not contain the required 'inversedBy: "idascenseur"' attribute.
App\Entity\Typevitessenominale No errors.
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\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\Clientascoriste 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\Accessursite No errors.
App\Entity\Armoiremanoeuvre
  • The field 'App\Entity\Armoiremanoeuvre#opportecabineprevu' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Armoiremanoeuvre#nbvalve' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Armoiremanoeuvre#courantElectrovalveA' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Armoiremanoeuvre#courantElectrovalvedescenteA' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
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
  • The field App\Entity\Devistravauxparasc#plannings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Planningtravauxparasc#devistravauxparasc does not contain the required 'inversedBy: "plannings"' attribute.
App\Entity\Etatlieuxposttravauxasc 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\Typeoperationmaintenance 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.
App\Entity\Emailrelanceducarnet No errors.
App\Entity\PhotoCarnetMaintenance No errors.
App\Entity\Periode No errors.
App\Entity\Typetravaux No errors.
App\Entity\Devismaintenance No errors.
App\Entity\Pieceparentretien No errors.
App\Entity\Pieceparpanne No errors.
App\Entity\Typetva No errors.
App\Entity\Typeconditionpaiement No errors.
App\Entity\Facturecontratmaintenance No errors.
App\Entity\Panier No errors.
App\Entity\Commande No errors.
App\Entity\Notification
  • The association App\Entity\Notification#user refers to the inverse side field App\Entity\User#notifications which does not exist.