Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 6
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

[
  4
]

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

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

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

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

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

SELECT DISTINCT t0_.IDTypeZoneoperation AS IDTypeZoneoperation_0, t0_.Libelle AS Libelle_1, t1_.IDTypeOperationmaintenance AS IDTypeOperationmaintenance_2, t1_.Libelle AS Libelle_3, t1_.ImagePath AS ImagePath_4, t1_.Numero AS Numero_5, t1_.PrixUnitMaindoeuvreHT AS PrixUnitMaindoeuvreHT_6, t1_.PrixUnitLaterielHT AS PrixUnitLaterielHT_7 FROM TypeBordereaupu t2_ INNER JOIN BordereauParTypeMaintenance b4_ ON t2_.IDTypeBordereaupu = b4_.typebordereaupu_id INNER JOIN TypeMarchemaintenance t3_ ON t3_.IDTypeMarchemaintenance = b4_.typemarchemaintenance_id INNER JOIN TypeZoneoperation t0_ ON t3_.IDTypeMarchemaintenance = t0_.IDTypeMarchemaintenance INNER JOIN TypeOperationmaintenance t1_ ON t0_.IDTypeZoneoperation = t1_.IDTypeZoneoperation WHERE t2_.IDTypeBordereaupu = ? AND t1_.IDAscensoriste = ? ORDER BY t0_.Libelle ASC

[
  "1"
  "2"
]

SELECT
  DISTINCT t0_.IDTypeZoneoperation AS IDTypeZoneoperation_0,
  t0_.Libelle AS Libelle_1,
  t1_.IDTypeOperationmaintenance AS IDTypeOperationmaintenance_2,
  t1_.Libelle AS Libelle_3,
  t1_.ImagePath AS ImagePath_4,
  t1_.Numero AS Numero_5,
  t1_.PrixUnitMaindoeuvreHT AS PrixUnitMaindoeuvreHT_6,
  t1_.PrixUnitLaterielHT AS PrixUnitLaterielHT_7
FROM
  TypeBordereaupu t2_
  INNER JOIN BordereauParTypeMaintenance b4_ ON t2_.IDTypeBordereaupu = b4_.typebordereaupu_id
  INNER JOIN TypeMarchemaintenance t3_ ON t3_.IDTypeMarchemaintenance = b4_.typemarchemaintenance_id
  INNER JOIN TypeZoneoperation t0_ ON t3_.IDTypeMarchemaintenance = t0_.IDTypeMarchemaintenance
  INNER JOIN TypeOperationmaintenance t1_ ON t0_.IDTypeZoneoperation = t1_.IDTypeZoneoperation
WHERE
  t2_.IDTypeBordereaupu = ?
  AND t1_.IDAscensoriste = ?
ORDER BY
  t0_.Libelle ASC

SELECT DISTINCT t0_.IDTypeZoneoperation AS IDTypeZoneoperation_0, t0_.Libelle AS Libelle_1, t1_.IDTypeOperationmaintenance AS IDTypeOperationmaintenance_2, t1_.Libelle AS Libelle_3, t1_.ImagePath AS ImagePath_4, t1_.Numero AS Numero_5, t1_.PrixUnitMaindoeuvreHT AS PrixUnitMaindoeuvreHT_6, t1_.PrixUnitLaterielHT AS PrixUnitLaterielHT_7 FROM TypeBordereaupu t2_ INNER JOIN BordereauParTypeMaintenance b4_ ON t2_.IDTypeBordereaupu = b4_.typebordereaupu_id INNER JOIN TypeMarchemaintenance t3_ ON t3_.IDTypeMarchemaintenance = b4_.typemarchemaintenance_id INNER JOIN TypeZoneoperation t0_ ON t3_.IDTypeMarchemaintenance = t0_.IDTypeMarchemaintenance INNER JOIN TypeOperationmaintenance t1_ ON t0_.IDTypeZoneoperation = t1_.IDTypeZoneoperation WHERE t2_.IDTypeBordereaupu = '1' AND t1_.IDAscensoriste = '2' ORDER BY t0_.Libelle ASC;