GET https://arcadeapp.fr/admin/devis/preparerdevis/

Response
200 OK
Browse referrer URL
IP
2a05:6e02:1036:6910:6ca8:1335:e26c:ae7
Profiled on
Token
65a1ec

Query Metrics

114 Database Queries
21 Different statements
65.65 ms Query time
26 Invalid entities
3212 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
40.12 ms
(61.11%) 		41 
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: 
[
  49
]
View formatted query    View runnable query    Explain query    View query backtrace
9.78 ms
(14.90%) 		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: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
6.16 ms
(9.38%) 		41 
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: 
[
  49
]
View formatted query    View runnable query    Explain query    View query backtrace
2.14 ms
(3.25%) 		1 
SELECT DISTINCT d0_.IDDevistravauxparasc AS IDDevistravauxparasc_0, d0_.datedevis AS datedevis_1, d0_.numero AS numero_2, d0_.numOS AS numOS_3, d0_.affairesuivipar AS affairesuivipar_4, d0_.Telpro AS Telpro_5, d0_.Mailpro AS Mailpro_6, d0_.tva AS tva_7, d0_.Validite AS Validite_8, d0_.ConditionPayment AS ConditionPayment_9, d0_.total AS total_10, d0_.totalTTC AS totalTTC_11, d0_.Estvalide AS Estvalide_12, d0_.parIA AS parIA_13, d0_.AppareilHorsContrat AS AppareilHorsContrat_14, d0_.devisFile AS devisFile_15, d0_.Texteaccopagnement AS Texteaccopagnement_16, d0_.FichierOs AS FichierOs_17, d0_.NoteInformation AS NoteInformation_18, d0_.datevalidation AS datevalidation_19, d0_.Status AS Status_20, d0_.DecisionToken AS DecisionToken_21, d0_.typeFacturation AS typeFacturation_22, a1_.IDAscenseur AS IDAscenseur_23, a1_.NumAppareilASC AS NumAppareilASC_24, a1_.residenceASC AS residenceASC_25, a1_.AdresseInstallationASC AS AdresseInstallationASC_26, a1_.MarquageCE AS MarquageCE_27, a1_.LocalisationASC AS LocalisationASC_28, a1_.ConstructeurASC AS ConstructeurASC_29, a1_.ChargeEnCabine AS ChargeEnCabine_30, a1_.NbrPersonne AS NbrPersonne_31, a1_.DeplacementASC AS DeplacementASC_32, a1_.AnneeConstructionASC AS AnneeConstructionASC_33, a1_.PrixContrat AS PrixContrat_34, a1_.AbonnementGsm AS AbonnementGsm_35, a1_.NbNiveauASC AS NbNiveauASC_36, a1_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_37, a1_.loichatel AS loichatel_38, a1_.GardienASC AS GardienASC_39, a1_.PositionSerrure AS PositionSerrure_40, a1_.NumAffaire AS NumAffaire_41, a1_.QRCodeASC AS QRCodeASC_42, a1_.QRCodeFile AS QRCodeFile_43, a1_.ContactSurSite AS ContactSurSite_44, a1_.NumeroContactSurSite AS NumeroContactSurSite_45, a1_.EmailContactSurSite AS EmailContactSurSite_46, a1_.IDVille AS IDVille_47, a1_.CP AS CP_48, a1_.CoffreAcle AS CoffreAcle_49, a1_.Autre AS Autre_50, c2_.IDClientAscoriste AS IDClientAscoriste_51, c2_.RefClient AS RefClient_52, c2_.NomClient AS NomClient_53, c2_.EstActif AS EstActif_54, c2_.AdresseClient AS AdresseClient_55, c2_.TelClient AS TelClient_56, c2_.Emailclient AS Emailclient_57, c2_.NomContactClient AS NomContactClient_58, c2_.LienSiteClient AS LienSiteClient_59, c2_.CodeComptable AS CodeComptable_60, t3_.IDTypeTravaux AS IDTypeTravaux_61, t3_.Libelle AS Libelle_62, t3_.ERentabilite AS ERentabilite_63, d4_.IDDetailsAppareilHorsContrat AS IDDetailsAppareilHorsContrat_64, d4_.adresse AS adresse_65, d4_.localisation AS localisation_66, d5_.IDDetailecheance AS IDDetailecheance_67, d5_.pourcentage AS pourcentage_68, d5_.Date AS Date_69, d0_.IDAscenseur AS IDAscenseur_70, d0_.IDTypeBordereaupu AS IDTypeBordereaupu_71, d0_.IDTypeTravaux AS IDTypeTravaux_72, d0_.IDFilechecksum AS IDFilechecksum_73, a1_.IDTypeVitessenominale AS IDTypeVitessenominale_74, a1_.IDFournisseur AS IDFournisseur_75, a1_.IDConstructeur AS IDConstructeur_76, a1_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_77, a1_.IDTypeSecteur AS IDTypeSecteur_78, a1_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_79, a1_.IDTypePortePaliere AS IDTypePortePaliere_80, a1_.IDTypeDeverrouillage AS IDTypeDeverrouillage_81, a1_.IDClientAscoriste AS IDClientAscoriste_82, a1_.IDTypeBatiment AS IDTypeBatiment_83, a1_.IDTypeOuverture AS IDTypeOuverture_84, a1_.IDTypeequipement AS IDTypeequipement_85, a1_.IDTypeDeplacement AS IDTypeDeplacement_86, a1_.IDTypeChargeencabine AS IDTypeChargeencabine_87, a1_.IDTypeService AS IDTypeService_88, a1_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_89, a1_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_90, a1_.IDAscensoriste AS IDAscensoriste_91, a1_.IDContrat AS IDContrat_92, c2_.IDUser AS IDUser_93, c2_.IDAscensoriste AS IDAscensoriste_94, d4_.IDDevistravauxparasc AS IDDevistravauxparasc_95, d5_.IDTypeEcheance AS IDTypeEcheance_96, d5_.IDDevistravauxparasc AS IDDevistravauxparasc_97 FROM Devistravauxparasc d0_ LEFT JOIN Ascenseur a1_ ON d0_.IDAscenseur = a1_.IDAscenseur LEFT JOIN ClientAscoriste c2_ ON a1_.IDClientAscoriste = c2_.IDClientAscoriste LEFT JOIN typetravaux t3_ ON d0_.IDTypeTravaux = t3_.IDTypeTravaux LEFT JOIN DetailsAppareilHorsContrat d4_ ON d0_.IDDevistravauxparasc = d4_.IDDevistravauxparasc LEFT JOIN detailecheance d5_ ON d0_.IDDevistravauxparasc = d5_.IDDevistravauxparasc WHERE d0_.IDAscenseur = ? ORDER BY d0_.datedevis DESC
Parameters: 
[
  "49"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(2.09%) 		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.90 ms
(1.37%) 		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 > ?)))
Parameters: 
[
  "2"
  1
  "2026-04-16 12:56:36"
  "2026-04-16 12:56:36"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(1.28%) 		3 
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: 
[
  "20"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.80%) 		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.52 ms
(0.79%) 		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: 
[
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.67%) 		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: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.62%) 		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: 
[
  2
  1
  "%ROLE_TECHNICIEN%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.56%) 		2 
SELECT COUNT(*) FROM Profil t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.46%) 		2 
SELECT COUNT(*) FROM Ascensoriste t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.44%) 		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.26 ms
(0.39%) 		1 
SELECT COUNT(c0_.IDCommande) AS sclr_0 FROM Commande c0_ WHERE c0_.IDAscensoriste = ? AND c0_.Status NOT IN (?, ?)
Parameters: 
[
  2
  "LIVREE"
  "ANNULEE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.39%) 		1 
SELECT COUNT(p0_.IDPanier) AS sclr_0 FROM Panier p0_ WHERE p0_.IDAscensoriste = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.35%) 		1 
SELECT t0.IDTypeSecteur AS IDTypeSecteur_1, t0.Libelle AS Libelle_2, t0.IDAscensoriste AS IDAscensoriste_3 FROM TypeSecteur t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.31%) 		1 
SELECT COUNT(*) FROM ClientAscoriste t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.29%) 		1 
SELECT COUNT(c0_.IDCommande) AS sclr_0 FROM Commande c0_ WHERE c0_.IDAscensoriste = ? AND c0_.Status NOT IN (?, ?, ?)
Parameters: 
[
  2
  "VALIDEE"
  "LIVREE"
  "ANNULEE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.27%) 		1 
SELECT COUNT(*) FROM Ascenseur t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.26%) 		1 
SELECT COUNT(*) FROM ClientAscoriste t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  2
]
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\Carnetmaintenance 1105
App\Entity\Historiquemarcheasc 609
App\Entity\Detailentretien 389
App\Entity\Signalerpanne 218
App\Entity\Ficheremiseenservice 218
App\Entity\Essaisphonie 183
App\Entity\Pvcabletraction 159
App\Entity\Detailspvparachute 78
App\Entity\Rapportbureaucontrole 75
App\Entity\Ascenseur 41
App\Entity\Groupepropriete 41
App\Entity\User 28
App\Entity\Typechargeencabine 9
App\Entity\Ascensoriste 8
App\Entity\Typevitessenominale 7
App\Entity\Typeouverture 5
App\Entity\Typedeplacement 4
App\Entity\Typelocalisationmachinerie 4
App\Entity\Profil 3
App\Entity\Typeconstructeur 3
App\Entity\Typesecteur 3
App\Entity\Marquedemanoeuvre 3
App\Entity\Clientascoriste 3
App\Entity\Typebatiment 2
App\Entity\Typeservice 2
App\Entity\Typecategoriebatiment 2
App\Entity\Detailtravaux 2
App\Entity\Typeportepaliere 1
App\Entity\Contrat 1
App\Entity\Typeproprietaire 1
App\Entity\Devistravauxparasc 1
App\Entity\Filechecksum 1
App\Entity\Typetva 1
App\Entity\Typeconditionpaiement 1
App\Entity\Etudesecurite 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\Typetravaux No errors.
App\Entity\DetailsAppareilHorsContrat No errors.
App\Entity\Detailecheance No errors.
App\Entity\Typebordereaupu No errors.
App\Entity\Filechecksum No errors.
App\Entity\Typeecheance No errors.
App\Entity\DetailsDevisTravauxParAsc No errors.
App\Entity\Planningtravauxparasc
  • The field App\Entity\Planningtravauxparasc#marchedansplanningascs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Marchedansplanningasc#planningtravauxparasc does not contain the required 'inversedBy: "marchedansplanningascs"' attribute.
  • The field App\Entity\Planningtravauxparasc#avancements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Avancementtravaux#planningtravauxparasc does not contain the required 'inversedBy: "avancements"' attribute.
  • The field App\Entity\Planningtravauxparasc#etatlieuxposttravauxascs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Etatlieuxposttravauxasc#planningtravauxparasc does not contain the required 'inversedBy: "etatlieuxposttravauxascs"' attribute.
App\Entity\Comparaisonchoix No errors.
App\Entity\HistoriqueStatusDevistravauxparasc 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.
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.