GET https://arcadeapp.fr/chatbot/modules

Query Metrics

8 Database Queries
8 Different statements
2.66 ms Query time
11 Invalid entities
21 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.86 ms
(32.25%)
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
]
0.36 ms
(13.69%)
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
]
0.29 ms
(10.97%)
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:
[
  376
]
0.28 ms
(10.68%)
1
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
]
0.23 ms
(8.72%)
1
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"
]
0.22 ms
(8.16%)
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"
]
0.21 ms
(7.82%)
1
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
]
0.21 ms
(7.71%)
1
SELECT t0.id AS id_1, t0.thread_id AS thread_id_2, t0.messages AS messages_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM chat_history t0 WHERE t0.thread_id = ? LIMIT 1
Parameters:
[
  "user_94"
]

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\User 1
App\Entity\Profil 1
App\Entity\Ascensoriste 1
App\Entity\ChatHistory 1
App\Entity\Ascenseur 1
App\Entity\Typevitessenominale 1
App\Entity\Typeconstructeur 1
App\Entity\Typesecteur 1
App\Entity\Marquedemanoeuvre 1
App\Entity\Typeportepaliere 1
App\Entity\Clientascoriste 1
App\Entity\Typeouverture 1
App\Entity\Typeequipement 1
App\Entity\Typedeplacement 1
App\Entity\Typechargeencabine 1
App\Entity\Typeservice 1
App\Entity\Typecategoriebatiment 1
App\Entity\Typelocalisationmachinerie 1
App\Entity\Contrat 1
App\Entity\Groupepropriete 1
App\Entity\Typeproprietaire 1

Entities Mapping

Class Mapping errors
App\Entity\ChatHistory No 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.