Symfony Profiler

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 = ?

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 = 94;

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

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 = 'user_94' LIMIT 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,
  t0.IDModeledevisDefaut AS IDModeledevisDefaut_18
FROM
  Ascensoriste t0
WHERE
  t0.IDAscensoriste = ?

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

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

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

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

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

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

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

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

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

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

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