POST https://arcadeapp.fr/a/activites/bureaucontrole/new

Response
303 See Other
Browse referrer URL
IP
90.121.18.136
Profiled on
Token
29bd5a

Query Metrics

117 Database Queries
27 Different statements
36.09 ms Query time
21 Invalid entities
1184 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
18.12 ms
(50.20%) 		78 
SELECT t0.IDTypeSecteur AS IDTypeSecteur_1, t0.Libelle AS Libelle_2, t0.ZoneGeoJson AS ZoneGeoJson_3, t0.CodeCouleur AS CodeCouleur_4, t0.IDAscensoriste AS IDAscensoriste_5 FROM TypeSecteur t0 INNER JOIN user_typesecteur ON t0.IDTypeSecteur = user_typesecteur.typesecteur_id WHERE user_typesecteur.user_id = ?
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query    View query backtrace
4.40 ms
(12.20%) 		1 
SELECT a0_.IDAscenseur AS IDAscenseur_0, a0_.NumAppareilASC AS NumAppareilASC_1, a0_.residenceASC AS residenceASC_2, a0_.AdresseInstallationASC AS AdresseInstallationASC_3, a0_.MarquageCE AS MarquageCE_4, a0_.LocalisationASC AS LocalisationASC_5, a0_.ConstructeurASC AS ConstructeurASC_6, a0_.ChargeEnCabine AS ChargeEnCabine_7, a0_.NbrPersonne AS NbrPersonne_8, a0_.DeplacementASC AS DeplacementASC_9, a0_.AnneeConstructionASC AS AnneeConstructionASC_10, a0_.PrixContrat AS PrixContrat_11, a0_.AbonnementGsm AS AbonnementGsm_12, a0_.SousTotalHT AS SousTotalHT_13, a0_.TVAContrat AS TVAContrat_14, a0_.TotalTTC AS TotalTTC_15, a0_.RevisionPrixContrat AS RevisionPrixContrat_16, a0_.NbNiveauASC AS NbNiveauASC_17, a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_18, a0_.loichatel AS loichatel_19, a0_.GardienASC AS GardienASC_20, a0_.PositionSerrure AS PositionSerrure_21, a0_.NumAffaire AS NumAffaire_22, a0_.QRCodeASC AS QRCodeASC_23, a0_.QRCodeFile AS QRCodeFile_24, a0_.ContactSurSite AS ContactSurSite_25, a0_.NumeroContactSurSite AS NumeroContactSurSite_26, a0_.EmailContactSurSite AS EmailContactSurSite_27, a0_.PortableContactSurSite AS PortableContactSurSite_28, a0_.NomGestionnaire AS NomGestionnaire_29, a0_.NumGestionnaire AS NumGestionnaire_30, a0_.MailGestionnaire AS MailGestionnaire_31, a0_.NomRespCopropriete AS NomRespCopropriete_32, a0_.ContactRespCopropriete AS ContactRespCopropriete_33, a0_.PortableRespCopropriete AS PortableRespCopropriete_34, a0_.EmailRespCopropriete AS EmailRespCopropriete_35, a0_.IDVille AS IDVille_36, a0_.CP AS CP_37, a0_.Latitude AS Latitude_38, a0_.Longitude AS Longitude_39, a0_.CoffreAcle AS CoffreAcle_40, a0_.Autre AS Autre_41, a0_.IDTypeVitessenominale AS IDTypeVitessenominale_42, a0_.IDFournisseur AS IDFournisseur_43, a0_.IDConstructeur AS IDConstructeur_44, a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_45, a0_.IDTypeSecteur AS IDTypeSecteur_46, a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_47, a0_.IDTypePortePaliere AS IDTypePortePaliere_48, a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_49, a0_.IDClientAscoriste AS IDClientAscoriste_50, a0_.IDTypeBatiment AS IDTypeBatiment_51, a0_.IDTypeOuverture AS IDTypeOuverture_52, a0_.IDTypeequipement AS IDTypeequipement_53, a0_.IDTypeDeplacement AS IDTypeDeplacement_54, a0_.IDTypeChargeencabine AS IDTypeChargeencabine_55, a0_.IDTypeService AS IDTypeService_56, a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_57, a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_58, a0_.IDAscensoriste AS IDAscensoriste_59, a0_.IDContrat AS IDContrat_60 FROM Ascenseur a0_ INNER JOIN Contrat c1_ ON a0_.IDContrat = c1_.IDContrat WHERE a0_.IDAscensoriste = ? AND c1_.Valide = ? AND a0_.NumAppareilASC LIKE ?
Parameters: 
[
  "17"
  1
  "%141087%"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.78 ms
(4.94%) 		1 
SELECT t0.IDClientAscoriste AS IDClientAscoriste_1, t0.RefClient AS RefClient_2, t0.NomClient AS NomClient_3, t0.EstActif AS EstActif_4, t0.AdresseClient AS AdresseClient_5, t0.TelClient AS TelClient_6, t0.Emailclient AS Emailclient_7, t0.NomContactClient AS NomContactClient_8, t0.LienSiteClient AS LienSiteClient_9, t0.CodeComptable AS CodeComptable_10, t0.EnvoiEmailActive AS EnvoiEmailActive_11, t0.IDUser AS IDUser_12, t0.IDAscensoriste AS IDAscensoriste_13 FROM ClientAscoriste t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(3.79%) 		1 
SELECT a0_.IDAscenseur AS IDAscenseur_0, a0_.NumAppareilASC AS NumAppareilASC_1, a0_.residenceASC AS residenceASC_2, a0_.AdresseInstallationASC AS AdresseInstallationASC_3, a0_.MarquageCE AS MarquageCE_4, a0_.LocalisationASC AS LocalisationASC_5, a0_.ConstructeurASC AS ConstructeurASC_6, a0_.ChargeEnCabine AS ChargeEnCabine_7, a0_.NbrPersonne AS NbrPersonne_8, a0_.DeplacementASC AS DeplacementASC_9, a0_.AnneeConstructionASC AS AnneeConstructionASC_10, a0_.PrixContrat AS PrixContrat_11, a0_.AbonnementGsm AS AbonnementGsm_12, a0_.SousTotalHT AS SousTotalHT_13, a0_.TVAContrat AS TVAContrat_14, a0_.TotalTTC AS TotalTTC_15, a0_.RevisionPrixContrat AS RevisionPrixContrat_16, a0_.NbNiveauASC AS NbNiveauASC_17, a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_18, a0_.loichatel AS loichatel_19, a0_.GardienASC AS GardienASC_20, a0_.PositionSerrure AS PositionSerrure_21, a0_.NumAffaire AS NumAffaire_22, a0_.QRCodeASC AS QRCodeASC_23, a0_.QRCodeFile AS QRCodeFile_24, a0_.ContactSurSite AS ContactSurSite_25, a0_.NumeroContactSurSite AS NumeroContactSurSite_26, a0_.EmailContactSurSite AS EmailContactSurSite_27, a0_.PortableContactSurSite AS PortableContactSurSite_28, a0_.NomGestionnaire AS NomGestionnaire_29, a0_.NumGestionnaire AS NumGestionnaire_30, a0_.MailGestionnaire AS MailGestionnaire_31, a0_.NomRespCopropriete AS NomRespCopropriete_32, a0_.ContactRespCopropriete AS ContactRespCopropriete_33, a0_.PortableRespCopropriete AS PortableRespCopropriete_34, a0_.EmailRespCopropriete AS EmailRespCopropriete_35, a0_.IDVille AS IDVille_36, a0_.CP AS CP_37, a0_.Latitude AS Latitude_38, a0_.Longitude AS Longitude_39, a0_.CoffreAcle AS CoffreAcle_40, a0_.Autre AS Autre_41, a0_.IDTypeVitessenominale AS IDTypeVitessenominale_42, a0_.IDFournisseur AS IDFournisseur_43, a0_.IDConstructeur AS IDConstructeur_44, a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_45, a0_.IDTypeSecteur AS IDTypeSecteur_46, a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_47, a0_.IDTypePortePaliere AS IDTypePortePaliere_48, a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_49, a0_.IDClientAscoriste AS IDClientAscoriste_50, a0_.IDTypeBatiment AS IDTypeBatiment_51, a0_.IDTypeOuverture AS IDTypeOuverture_52, a0_.IDTypeequipement AS IDTypeequipement_53, a0_.IDTypeDeplacement AS IDTypeDeplacement_54, a0_.IDTypeChargeencabine AS IDTypeChargeencabine_55, a0_.IDTypeService AS IDTypeService_56, a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_57, a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_58, a0_.IDAscensoriste AS IDAscensoriste_59, a0_.IDContrat AS IDContrat_60 FROM Ascenseur a0_ INNER JOIN Contrat c1_ ON a0_.IDContrat = c1_.IDContrat WHERE a0_.IDAscensoriste = ? AND c1_.Valide = ? LIMIT 1
Parameters: 
[
  17
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(2.03%) 		4 
INSERT INTO reservedansrapportbureaucontrole (Description, EstLevee, MisArretDemande, ChargeMianteneur, PrevoirDevis, reserveContester, notificationTechnicien, notificationReparateur, NotificationDestinataire, photo, DateLeveReserve, IDFicheReserve, IDRapportBureaucontrole) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  """
    Eclairage :\n
    Un ou plusieurs points lumineux ne fonctionnent pas : remplacer les ampoules ou tubes fluo défectueux.
    """
  0
  0
  1
  0
  0
  1
  0
  "TECHNICIEN_SECTEUR"
  "[]"
  null
  null
  "530"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(1.98%) 		2 
SELECT t0.IDScoreAscenseur AS IDScoreAscenseur_1, t0.CoefficherntCart AS CoefficherntCart_2, t0.CapaciteCibleTechnicien AS CapaciteCibleTechnicien_3, t0.ChargeSecteurAvant AS ChargeSecteurAvant_4, t0.ChargeSecteurApres AS ChargeSecteurApres_5, t0.DateDebutCalcule AS DateDebutCalcule_6, t0.ModeCalculScore AS ModeCalculScore_7, t0.IDAscenseur AS IDAscenseur_8, t0.IDScoringTypeFrequenceMaintenance AS IDScoringTypeFrequenceMaintenance_9, t0.IDTypeScoreModeCalculeTempsAnnuel AS IDTypeScoreModeCalculeTempsAnnuel_10, t0.IDTypescoretypebatiment AS IDTypescoretypebatiment_11, t0.IDTypescorenombreniveau AS IDTypescorenombreniveau_12, t0.IDTypescorefrequenceintervention AS IDTypescorefrequenceintervention_13, t0.IDTypescoreetatappareil AS IDTypescoreetatappareil_14, t0.IDTypeScoreSourceDonnee AS IDTypeScoreSourceDonnee_15, t0.IDTypeScoreModeCalcule AS IDTypeScoreModeCalcule_16, t0.IDTypeScoreUsageScore AS IDTypeScoreUsageScore_17, t0.IDTypeScoreAffectationSecteur AS IDTypeScoreAffectationSecteur_18, t0.IDTypeScoreFamilleEquipement AS IDTypeScoreFamilleEquipement_19, t0.IDTypeScoreRisqueglobal AS IDTypeScoreRisqueglobal_20, t0.IDTypescorechargecapacite AS IDTypescorechargecapacite_21 FROM ScoreAscenseur t0 WHERE t0.IDAscenseur = ?
Parameters: 
[
  376
]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(1.84%) 		3 
SELECT t0.IDPushToken AS IDPushToken_1, t0.Token AS Token_2, t0.user_id AS user_id_3 FROM PushToken t0 WHERE t0.user_id = ?
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(1.75%) 		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_.PhotoProfil AS PhotoProfil_9, u0_.IDVille AS IDVille_10, u0_.isAdmin AS isAdmin_11, u0_.Dateentrer AS Dateentrer_12, u0_.Telurgence AS Telurgence_13, u0_.IDProfil AS IDProfil_14, u0_.IDAscensoriste AS IDAscensoriste_15, u0_.TypeExperience AS TypeExperience_16 FROM user u0_ WHERE u0_.IDAscensoriste = ? AND u0_.EstActive = ? AND u0_.roles LIKE ?
Parameters: 
[
  17
  1
  "%ROLE_TECHNICIEN%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.67%) 		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_.PhotoProfil AS PhotoProfil_9, u0_.IDVille AS IDVille_10, u0_.isAdmin AS isAdmin_11, u0_.Dateentrer AS Dateentrer_12, u0_.Telurgence AS Telurgence_13, u0_.IDProfil AS IDProfil_14, u0_.IDAscensoriste AS IDAscensoriste_15, u0_.TypeExperience AS TypeExperience_16 FROM user u0_ INNER JOIN Profil p1_ ON u0_.IDProfil = p1_.IDProfil WHERE u0_.IDAscensoriste = ? AND u0_.EstActive = ? AND p1_.IDProfil = ? ORDER BY u0_.NomPrenom ASC
Parameters: 
[
  17
  1
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(1.56%) 		3 
INSERT INTO Notification (NOT_Titre, NOT_Rubrique, NOT_Text, NOT_Type, NOT_TargetId, NOT_Urgence, NOT_TypeAlert, NOT_Lu, NOT_DateCreation, user_id, IDNotificationContent, IDAscenseur) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  null
  null
  null
  null
  null
  null
  null
  0
  "2026-07-27 08:45:21"
  94
  "4732"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(1.50%) 		1 
SELECT t0.IDTypeSecteur AS IDTypeSecteur_1, t0.Libelle AS Libelle_2, t0.ZoneGeoJson AS ZoneGeoJson_3, t0.CodeCouleur AS CodeCouleur_4, t0.IDAscensoriste AS IDAscensoriste_5 FROM TypeSecteur t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.45%) 		1 
SELECT s0_.IDsalarier AS IDsalarier_0, s0_.EstActif AS EstActif_1, s0_.Matricule AS Matricule_2, s0_.Badge AS Badge_3, s0_.PhotoProfil AS PhotoProfil_4, s0_.Nom AS Nom_5, s0_.Prenom AS Prenom_6, s0_.Adresse AS Adresse_7, s0_.Tel AS Tel_8, s0_.Email AS Email_9, s0_.Metier AS Metier_10, s0_.Equipe AS Equipe_11, s0_.Site AS Site_12, s0_.IDAscensoriste AS IDAscensoriste_13, s0_.IDTypeUtilisateur AS IDTypeUtilisateur_14, s0_.IDEquipe AS IDEquipe_15, s0_.IDTypeSecteur AS IDTypeSecteur_16, s0_.IDUtilisateur AS IDUtilisateur_17 FROM Salarier s0_ WHERE s0_.IDAscensoriste = ? AND ((s0_.EstActif = ? OR s0_.EstActif IS NULL)) ORDER BY s0_.Nom ASC, s0_.Prenom ASC
Parameters: 
[
  17
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(1.40%) 		1 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.PhotoProfil AS PhotoProfil_10, t0.IDVille AS IDVille_11, t0.isAdmin AS isAdmin_12, t0.Dateentrer AS Dateentrer_13, t0.Telurgence AS Telurgence_14, t0.IDProfil AS IDProfil_15, t0.IDAscensoriste AS IDAscensoriste_16, t0.TypeExperience AS TypeExperience_17 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(1.37%) 		2 
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: 
[
  "17"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.33%) 		2 
SELECT t0.IDGroupePropriete AS IDGroupePropriete_1, t0.Libelle AS Libelle_2, t0.NbMembre AS NbMembre_3, t0.IDTypeProprietaire AS IDTypeProprietaire_4, t0.IDAscenseur AS IDAscenseur_5 FROM GroupePropriete t0 WHERE t0.IDAscenseur = ?
Parameters: 
[
  376
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.32%) 		1 
INSERT INTO CarnetMaintenance (DateVisite, HeureArrivee, HeureDepart, DateProchainVisite, DateDerniereVisite, EtatAjour, MarcheDegrade, EtablirDevis, AssistanceTechnique, IDTypeVisite, IDTypeStatutASC, NotifEnvoye, viafichier, IDAscenseur, IDTechnicien, IDDetailEntretien, IDEssaisPhonie, IDPVCableTraction, IDDetailsPVParachute, IDDetailtravaux, IDRapportBureaucontrole, IDSignalerPanne, IDEtudeSecurite, IDHistoriqueMarcheASC, IDFicheRemiseService) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "2026-07-27"
  null
  null
  null
  null
  1
  0
  0
  0
  "BUREAU_CONTROLE"
  null
  ""
  0
  "885"
  674
  null
  null
  null
  null
  null
  "530"
  null
  null
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(1.28%) 		2 
SELECT t0.IDFacturationAscenseur AS IDFacturationAscenseur_1, t0.IDAscenseur AS IDAscenseur_2, t0.IDTypeFactureStructure AS IDTypeFactureStructure_3, t0.IDTypeFacturePeriodicite AS IDTypeFacturePeriodicite_4, t0.IDTypeFactureEcheance AS IDTypeFactureEcheance_5, t0.IDTypeParametreFacturation AS IDTypeParametreFacturation_6, t0.IDTypeFactureLogicielComptabilite AS IDTypeFactureLogicielComptabilite_7, t0.IDTypeFacturationGratuite AS IDTypeFacturationGratuite_8, t0.IDTypeFacturePaiementOption AS IDTypeFacturePaiementOption_9 FROM FacturationAscenseur t0 WHERE t0.IDAscenseur = ?
Parameters: 
[
  376
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(1.17%) 		1 
SELECT s0_.IDsalarier AS IDsalarier_0, s0_.EstActif AS EstActif_1, s0_.Matricule AS Matricule_2, s0_.Badge AS Badge_3, s0_.PhotoProfil AS PhotoProfil_4, s0_.Nom AS Nom_5, s0_.Prenom AS Prenom_6, s0_.Adresse AS Adresse_7, s0_.Tel AS Tel_8, s0_.Email AS Email_9, s0_.Metier AS Metier_10, s0_.Equipe AS Equipe_11, s0_.Site AS Site_12, s0_.IDAscensoriste AS IDAscensoriste_13, s0_.IDTypeUtilisateur AS IDTypeUtilisateur_14, s0_.IDEquipe AS IDEquipe_15, s0_.IDTypeSecteur AS IDTypeSecteur_16, s0_.IDUtilisateur AS IDUtilisateur_17 FROM Salarier s0_ WHERE s0_.IDAscensoriste = ? AND s0_.IDTypeSecteur = ? AND ((s0_.EstActif = ? OR s0_.EstActif IS NULL)) ORDER BY s0_.Nom ASC, s0_.Prenom ASC LIMIT 1
Parameters: 
[
  17
  "80"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(1.10%) 		1 
SELECT t0_.IDTypeControle AS IDTypeControle_0, t0_.Libelle AS Libelle_1 FROM typecontrole t0_ WHERE t0_.IDTypeControle IN (?)
Parameters: 
[
  "4"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(1.09%) 		1 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.PhotoProfil AS PhotoProfil_10, t0.IDVille AS IDVille_11, t0.isAdmin AS isAdmin_12, t0.Dateentrer AS Dateentrer_13, t0.Telurgence AS Telurgence_14, t0.IDProfil AS IDProfil_15, t0.IDAscensoriste AS IDAscensoriste_16, t0.TypeExperience AS TypeExperience_17 FROM user t0 WHERE t0.IDAscensoriste = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.83%) 		1 
INSERT INTO rapportbureaucontrole (DossierTechnique, CarneEntretien, EtudeSecurite, PVcable, PVparachute, RapportAnnuel, DeclarationConformite, ConformeEcheance2010, ConformeEcheance2014, NotificationEcheance2010, NotificationEcheance2014, FichierRapport, EtatNegatif, EtatPositif, NBreservealever, NBreserveleve, IDTypeReserveALever, IDTypeControle) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  0
  1
  1
  0
  0
  0
  "Non"
  1
  1
  null
  null
  "/upload/rapports/Rue-LAURISTON-Esc-D-84-Rue-LAURISTON-75116-PARIS-RMP-6a671aa1aaed6.pdf"
  40
  60
  4
  0
  null
  "4"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.83%) 		2 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.77%) 		1 
INSERT INTO NotificationContent (NOT_Titre, NOT_Rubrique, NOT_Text, NOT_Type, NOT_TargetId, NOT_Urgence, NOT_TypeAlert, NOT_DateCreation, IDAscenseur) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "Nouveau rapport bureau de contrôle créé"
  "Maintenance"
  "La maintenance de l'ascenseur 141087 (84  RUE LAURISTON) a été créé."
  "manual_creation"
  12990
  "normale"
  "autre"
  "2026-07-27 08:45:21"
  "885"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(0.68%) 		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: 
[
  "17"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.64%) 		1 
SELECT t0.IDProfil AS IDProfil_1, t0.PL_Libelle AS PL_Libelle_2, t0.DroitAcces AS DroitAcces_3, t0.roles AS roles_4, t0.isDeletable AS isDeletable_5, t0.IDTypeUtilisateur AS IDTypeUtilisateur_6 FROM Profil t0 WHERE t0.IDProfil = ?
Parameters: 
[
  "2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.63%) 		1 
INSERT INTO planningrapportbureaucontrole (datelimite, dateprochainvisite, daterelance, dateDevis, dateDevisEnAttente, dateDevisValide, dateAssistance, dateAssistanceEnAttente, dateAssistanceValide, datePieceCommander, datePieceCommanderEnAttente, datePieceCommanderValide, IDRapportBureaucontrole, IDTechnicien, IDsalarier) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "2026-11-24 00:00:00"
  "2026-11-24 00:00:00"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "530"
  666
  "59"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.63%) 		2 
"COMMIT"
Parameters: 
[]
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\Clientascoriste 995
App\Entity\User 78
App\Entity\Salarier 44
App\Entity\Typesecteur 21
App\Entity\Profil 6
App\Entity\Typeutilisateur 4
App\Entity\Reservedansrapportbureaucontrole 4
App\Entity\Notification 3
App\Entity\Ascenseur 2
App\Entity\Typevitessenominale 2
App\Entity\Marquedemanoeuvre 2
App\Entity\Typeequipement 2
App\Entity\Typechargeencabine 2
App\Entity\Typecategoriebatiment 2
App\Entity\Contrat 2
App\Entity\Ascensoriste 1
App\Entity\Typeconstructeur 1
App\Entity\Typeportepaliere 1
App\Entity\Typeouverture 1
App\Entity\Typedeplacement 1
App\Entity\Typeservice 1
App\Entity\Typelocalisationmachinerie 1
App\Entity\Groupepropriete 1
App\Entity\Typeproprietaire 1
App\Entity\Typecontrole 1
App\Entity\Rapportbureaucontrole 1
App\Entity\Carnetmaintenance 1
App\Entity\Planningrapportbureaucontrole 1
App\Entity\PushToken 1
App\Entity\NotificationContent 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Profil No errors.
App\Entity\Ascensoriste No errors.
App\Entity\Scoring\TypeExperienceTechnicien No errors.
App\Entity\PushToken No errors.
App\Entity\Notification No errors.
App\Entity\Typesecteur No errors.
App\Entity\Typecompetence No errors.
App\Entity\Typehabilitation No errors.
App\Entity\Typepermis No errors.
App\Entity\Documentuser No errors.
App\Entity\Avancementtravaux
  • The field App\Entity\Avancementtravaux#avancementOperations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AvancementOperation#avancementtravaux does not contain the required 'inversedBy: "avancementOperations"' attribute.
  • The field App\Entity\Avancementtravaux#travauxRealises is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Travauxrealisedansavancement#avancementtravaux does not contain the required 'inversedBy: "travauxRealises"' attribute.
  • The field App\Entity\Avancementtravaux#travauxPrevus is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Travauxprevudansavancement#avancementtravaux does not contain the required 'inversedBy: "travauxPrevus"' attribute.
  • The field App\Entity\Avancementtravaux#pointsBloquants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pointbloquantdansavancement#avancementtravaux does not contain the required 'inversedBy: "pointsBloquants"' attribute.
App\Entity\Ascenseur
  • The field App\Entity\Ascenseur#carnetmaintenances is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Carnetmaintenance#idascenseur does not contain the required 'inversedBy: "carnetmaintenances"' attribute.
App\Entity\Fournisseur
  • The field App\Entity\Fournisseur#piecesdetachees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Piecesdetachees#idfournisseur does not contain the required 'inversedBy: "piecesdetachees"' attribute.
App\Entity\Clientascoriste No errors.
App\Entity\Typeoperationmaintenance No errors.
App\Entity\Abonnement No errors.
App\Entity\Salarier No errors.
App\Entity\Contrat No errors.
App\Entity\Lemarche No errors.
App\Entity\Typevitessenominale No errors.
App\Entity\Typeconstructeur No errors.
App\Entity\Typemarqueserrure No errors.
App\Entity\Marquedemanoeuvre No errors.
App\Entity\Typeportepaliere No errors.
App\Entity\Typedeverrouillage No errors.
App\Entity\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\Scoring\ScoreAscenseur No errors.
App\Entity\Scoring\TypescoretypefrequenceMaintenance No errors.
App\Entity\Scoring\TypeScoreModeCalculeTempsAnnuel No errors.
App\Entity\Scoring\Typescoretypebatiment No errors.
App\Entity\Scoring\Typescorenombreniveau No errors.
App\Entity\Scoring\Typescorefrequenceintervention No errors.
App\Entity\Scoring\Typescoreetatappareil No errors.
App\Entity\Scoring\TypeScoreSourceDonnee No errors.
App\Entity\Scoring\TypeScoreModeCalcule No errors.
App\Entity\Scoring\TypeScoreUsageScore No errors.
App\Entity\Scoring\TypeScoreAffectationSecteur No errors.
App\Entity\Scoring\TypeScoreFamilleEquipement No errors.
App\Entity\Scoring\TypeScoreRisqueglobal No errors.
App\Entity\Scoring\TypeScoreChargeCapacite No errors.
App\Entity\Facturation\FacturationAscenseur No errors.
App\Entity\Facturation\TypeFactureStructure No errors.
App\Entity\Facturation\TypeFacturePeriodicite No errors.
App\Entity\Facturation\TypeFactureEcheance No errors.
App\Entity\Facturation\TypeParametreFacturation No errors.
App\Entity\Facturation\TypeFactureLogicielCompable No errors.
App\Entity\Facturation\TypeFacturationGratuite No errors.
App\Entity\Facturation\TypeFacturePaiementOption No errors.
App\Entity\Accessursite No errors.
App\Entity\Armoiremanoeuvre No errors.
App\Entity\Attelage
  • The field App\Entity\Attelage#detailpouliemoufflage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Detailpouliemoufflage#idattelage does not contain the required 'inversedBy: "detailpouliemoufflage"' attribute.
  • The field App\Entity\Attelage#machineriehautedansattelage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Machineriehautedansattelage#idattelage does not contain the required 'inversedBy: "machineriehautedansattelage"' attribute.
  • The field App\Entity\Attelage#machineriebassedansattelage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Machineriebassedansattelage#idattelage does not contain the required 'inversedBy: "machineriebassedansattelage"' attribute.
App\Entity\Boiteboutonequipement
  • The field App\Entity\Boiteboutonequipement#idniveaudansboitebouton is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Niveaudansboitebouton#idboiteboutonequipement does not contain the required 'inversedBy: "idniveaudansboitebouton"' attribute.
App\Entity\Cabineequipement
  • The field App\Entity\Cabineequipement#maincourantesdanscabineequipement is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Maincourantdanscabine#idcabineequipement does not contain the required 'inversedBy: "maincourantesdanscabineequipement"' attribute.
  • The field App\Entity\Cabineequipement#vitragesdanscabineequipement is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Vitragedanscabine#idcabineequipement does not contain the required 'inversedBy: "vitragesdanscabineequipement"' attribute.
App\Entity\Cuvette No errors.
App\Entity\Gaine
  • The field App\Entity\Gaine#idniveaudansgaine is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Niveaudansgaine#idgaine does not contain the required 'inversedBy: "idniveaudansgaine"' attribute.
  • The field App\Entity\Gaine#idceinturedansgaine is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ceinturedansgaine#idgaine does not contain the required 'inversedBy: "idceinturedansgaine"' attribute.
  • The field App\Entity\Gaine#dimensionsdansgaine is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Dimensiondansgaine#idgaine does not contain the required 'inversedBy: "dimensionsdansgaine"' attribute.
App\Entity\Groupetraction
  • The field App\Entity\Groupetraction#infoimplantations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Infoimplantation#idgroupetraction does not contain the required 'inversedBy: "infoimplantations"' attribute.
App\Entity\Limiteurvitesse
  • The field App\Entity\Limiteurvitesse#guide is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Guide#idlimiteurvitesse does not contain the required 'inversedBy: "guide"' attribute.
App\Entity\Pendentifs No errors.
App\Entity\Portecabineoperateur No errors.
App\Entity\Portepaliere
  • The field App\Entity\Portepaliere#idniveaudansportepaliere is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Niveaudansportepaliere#idportepaliere does not contain the required 'inversedBy: "idniveaudansportepaliere"' attribute.
App\Entity\Telephoneurgence No errors.
App\Entity\Accesmachineriepoulie No errors.
App\Entity\Carnetmaintenance No errors.
App\Entity\Devistravauxparasc No errors.
App\Entity\Etatlieuxposttravauxasc No errors.
App\Entity\Noteinformation No errors.
App\Entity\Partitionparascenseur
  • The field App\Entity\Partitionparascenseur#images is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ImagePartitionAudit#partitionParAscenseur does not contain the required 'inversedBy: "images"' attribute.
App\Entity\Groupepropriete No errors.
App\Entity\Typeproprietaire No errors.
App\Entity\Controlleseasc No errors.
App\Entity\Optiontarification No errors.
App\Entity\RevisionPrixHistorique No errors.
App\Entity\Typeutilisateur No errors.
App\Entity\Equipe No errors.
App\Entity\Typecontrole No errors.
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\Reservedansrapportbureaucontrole No errors.
App\Entity\Planningrapportbureaucontrole No errors.
App\Entity\Emailrelanceducarnet No errors.
App\Entity\PhotoCarnetMaintenance No errors.
App\Entity\Typereservealever 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\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\Fichereserve
  • The field App\Entity\Fichereserve#reserve is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Reservedansrapportbureaucontrole#fichereserve does not contain the required 'inversedBy: "reserve"' attribute.
App\Entity\NotificationContent No errors.