Symfony Profiler

Query Metrics

114 Database Queries

21 Different statements

84.13 ms Query time

26 Invalid entities

3212 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

36.91 ms
(43.87%)

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

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;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	App\Service\AscenseurDevisService->getDataForDevis (line 171)
6	App\Controller\Admin\Devis\AnalysedevisController->index (line 36)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

31.26 ms
(37.15%)

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

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

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 = 49 ORDER BY t0.DateVisite DESC;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 237)
9	App\Entity\Ascenseur->getCarnetmaintenancesentretien (line 1273)
10	Twig\Extension\CoreExtension->getAttribute (line 1909)
11	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7::block_body (line 1199)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 498)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
26	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 197)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

6.55 ms
(7.78%)

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

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

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
5	Doctrine\ORM\UnitOfWork->createEntity (line 2457)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
10	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
11	Doctrine\ORM\AbstractQuery->execute (line 886)
12	Doctrine\ORM\AbstractQuery->getResult (line 688)
13	App\Service\AscenseurDevisService->findAscenseurForDevis (line 89)
14	App\Service\AscenseurDevisService->getDataForDevis (line 130)
15	App\Controller\Admin\Devis\AnalysedevisController->index (line 36)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.78 ms
(2.11%)

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:55:27"
  "2026-04-16 12:55:27"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '2' AND c1_.Valide = 1 AND c1_.DateContrat <= '2026-04-16 12:55:27' AND ((c1_.resilier = 0 OR (c1_.resilier = 1 AND c1_.DateResiliation > '2026-04-16 12:55:27')));

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Service\AscenseurDevisService->findAscenseurForDevis (line 89)
9	App\Service\AscenseurDevisService->getDataForDevis (line 130)
10	App\Controller\Admin\Devis\AnalysedevisController->index (line 36)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 197)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.41 ms
(1.67%)

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:

View formatted query View runnable query Explain query View query backtrace

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

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 = 4 AND t0.NOT_Lu = 0 ORDER BY t0.NOT_DateCreation DESC;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	App\Service\NotificationTwigService->getNotifications (line 24)
6	Twig\Extension\CoreExtension->getAttribute (line 1909)
7	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc::doDisplay (line 574)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.38 ms
(1.64%)

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

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

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 = '20' AND t0.Valide = 1;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	App\Service\DatabaseStateService->getMissingSteps (line 86)
6	App\Service\DatabaseStateService->getDatabaseState (line 30)
7	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc->doDisplay (line 51)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.88 ms
(1.05%)

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:

View formatted query View runnable query Explain query View query backtrace

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

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 = 1 AND t0.EstActive = 1;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
6	App\Service\UserTwigService->getUsers (line 18)
7	Twig\Extension\CoreExtension->getAttribute (line 1909)
8	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc::doDisplay (line 295)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
23	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.50 ms
(0.59%)

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

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

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

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
9	Doctrine\ORM\PersistentCollection->count (line 391)
10	count (line 103)
11	App\Service\DatabaseStateService::getMissingSteps (line 103)
12	App\Service\DatabaseStateService->getDatabaseState (line 30)
13	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc->doDisplay (line 51)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
28	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 197)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.42 ms
(0.50%)

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

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

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

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	App\Service\AscenseurDevisService->getDataForDevis (line 174)
6	App\Controller\Admin\Devis\AnalysedevisController->index (line 36)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.39 ms
(0.46%)

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

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 ?

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 = 2 AND u0_.EstActive = 1 AND u0_.roles LIKE '%ROLE_TECHNICIEN%';

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Service\AscenseurDevisService->getTechnicienascensoriste (line 277)
9	App\Service\AscenseurDevisService->getDataForDevis (line 181)
10	App\Controller\Admin\Devis\AnalysedevisController->index (line 36)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 197)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.38 ms
(0.45%)

SELECT t0.IDDevistravauxparasc AS IDDevistravauxparasc_1, t0.datedevis AS datedevis_2, t0.numero AS numero_3, t0.numOS AS numOS_4, t0.affairesuivipar AS affairesuivipar_5, t0.Telpro AS Telpro_6, t0.Mailpro AS Mailpro_7, t0.tva AS tva_8, t0.Validite AS Validite_9, t0.ConditionPayment AS ConditionPayment_10, t0.total AS total_11, t0.totalTTC AS totalTTC_12, t0.Estvalide AS Estvalide_13, t0.parIA AS parIA_14, t0.AppareilHorsContrat AS AppareilHorsContrat_15, t0.devisFile AS devisFile_16, t0.Texteaccopagnement AS Texteaccopagnement_17, t0.FichierOs AS FichierOs_18, t0.NoteInformation AS NoteInformation_19, t0.datevalidation AS datevalidation_20, t0.Status AS Status_21, t0.DecisionToken AS DecisionToken_22, t0.typeFacturation AS typeFacturation_23, t0.IDAscenseur AS IDAscenseur_24, t0.IDTypeBordereaupu AS IDTypeBordereaupu_25, t0.IDTypeTravaux AS IDTypeTravaux_26, t0.IDFilechecksum AS IDFilechecksum_27 FROM Devistravauxparasc t0 WHERE t0.IDAscenseur = ?

Parameters:

[
  "49"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDDevistravauxparasc AS IDDevistravauxparasc_1,
  t0.datedevis AS datedevis_2,
  t0.numero AS numero_3,
  t0.numOS AS numOS_4,
  t0.affairesuivipar AS affairesuivipar_5,
  t0.Telpro AS Telpro_6,
  t0.Mailpro AS Mailpro_7,
  t0.tva AS tva_8,
  t0.Validite AS Validite_9,
  t0.ConditionPayment AS ConditionPayment_10,
  t0.total AS total_11,
  t0.totalTTC AS totalTTC_12,
  t0.Estvalide AS Estvalide_13,
  t0.parIA AS parIA_14,
  t0.AppareilHorsContrat AS AppareilHorsContrat_15,
  t0.devisFile AS devisFile_16,
  t0.Texteaccopagnement AS Texteaccopagnement_17,
  t0.FichierOs AS FichierOs_18,
  t0.NoteInformation AS NoteInformation_19,
  t0.datevalidation AS datevalidation_20,
  t0.Status AS Status_21,
  t0.DecisionToken AS DecisionToken_22,
  t0.typeFacturation AS typeFacturation_23,
  t0.IDAscenseur AS IDAscenseur_24,
  t0.IDTypeBordereaupu AS IDTypeBordereaupu_25,
  t0.IDTypeTravaux AS IDTypeTravaux_26,
  t0.IDFilechecksum AS IDFilechecksum_27
FROM
  Devistravauxparasc t0
WHERE
  t0.IDAscenseur = ?

SELECT t0.IDDevistravauxparasc AS IDDevistravauxparasc_1, t0.datedevis AS datedevis_2, t0.numero AS numero_3, t0.numOS AS numOS_4, t0.affairesuivipar AS affairesuivipar_5, t0.Telpro AS Telpro_6, t0.Mailpro AS Mailpro_7, t0.tva AS tva_8, t0.Validite AS Validite_9, t0.ConditionPayment AS ConditionPayment_10, t0.total AS total_11, t0.totalTTC AS totalTTC_12, t0.Estvalide AS Estvalide_13, t0.parIA AS parIA_14, t0.AppareilHorsContrat AS AppareilHorsContrat_15, t0.devisFile AS devisFile_16, t0.Texteaccopagnement AS Texteaccopagnement_17, t0.FichierOs AS FichierOs_18, t0.NoteInformation AS NoteInformation_19, t0.datevalidation AS datevalidation_20, t0.Status AS Status_21, t0.DecisionToken AS DecisionToken_22, t0.typeFacturation AS typeFacturation_23, t0.IDAscenseur AS IDAscenseur_24, t0.IDTypeBordereaupu AS IDTypeBordereaupu_25, t0.IDTypeTravaux AS IDTypeTravaux_26, t0.IDFilechecksum AS IDFilechecksum_27 FROM Devistravauxparasc t0 WHERE t0.IDAscenseur = '49';

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	App\Controller\Admin\Devis\AnalysedevisController->index (line 37)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.35 ms
(0.42%)

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

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;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\EntityManager->find (line 366)
6	Doctrine\ORM\EntityRepository->find (line 86)
7	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
9	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 197)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.32 ms
(0.39%)

SELECT COUNT(*) FROM Profil t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  Profil t0

SELECT COUNT(*) FROM Profil t0;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Connection->query (line 45)
2	Doctrine\DBAL\Connection->executeQuery (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
4	Doctrine\ORM\EntityRepository->count (line 140)
5	App\Service\DatabaseStateService->getDatabaseState (line 25)
6	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc->doDisplay (line 51)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
21	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 197)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.28 ms
(0.33%)

SELECT COUNT(*) FROM Ascensoriste t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  Ascensoriste t0

SELECT COUNT(*) FROM Ascensoriste t0;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Connection->query (line 45)
2	Doctrine\DBAL\Connection->executeQuery (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
4	Doctrine\ORM\EntityRepository->count (line 140)
5	App\Service\DatabaseStateService->getDatabaseState (line 26)
6	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc->doDisplay (line 51)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
21	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 197)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.22 ms
(0.26%)

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

SELECT
  COUNT(c0_.IDCommande) AS sclr_0
FROM
  Commande c0_
WHERE
  c0_.IDAscensoriste = ?
  AND c0_.Status NOT IN (?, ?)

SELECT COUNT(c0_.IDCommande) AS sclr_0 FROM Commande c0_ WHERE c0_.IDAscensoriste = 2 AND c0_.Status NOT IN ('LIVREE', 'ANNULEE');

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Service\CommandeTwigService->getCommandeEnCoursCount (line 48)
10	Twig\Extension\CoreExtension->getAttribute (line 1909)
11	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc::doDisplay (line 522)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
26	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 197)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.22 ms
(0.26%)

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

SELECT
  COUNT(c0_.IDCommande) AS sclr_0
FROM
  Commande c0_
WHERE
  c0_.IDAscensoriste = ?
  AND c0_.Status NOT IN (?, ?, ?)

SELECT COUNT(c0_.IDCommande) AS sclr_0 FROM Commande c0_ WHERE c0_.IDAscensoriste = 2 AND c0_.Status NOT IN ('VALIDEE', 'LIVREE', 'ANNULEE');

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Service\CommandeTwigService->getCommandeNonValideeCount (line 68)
10	Twig\Extension\CoreExtension->getAttribute (line 1909)
11	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc::doDisplay (line 525)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
26	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 197)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.20 ms
(0.24%)

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

SELECT
  t0.IDTypeSecteur AS IDTypeSecteur_1,
  t0.Libelle AS Libelle_2,
  t0.IDAscensoriste AS IDAscensoriste_3
FROM
  TypeSecteur t0
WHERE
  t0.IDAscensoriste = ?

SELECT t0.IDTypeSecteur AS IDTypeSecteur_1, t0.Libelle AS Libelle_2, t0.IDAscensoriste AS IDAscensoriste_3 FROM TypeSecteur t0 WHERE t0.IDAscensoriste = 2;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	App\Service\AscenseurDevisService->getDataForDevis (line 177)
6	App\Controller\Admin\Devis\AnalysedevisController->index (line 36)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.20 ms
(0.24%)

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

SELECT
  COUNT(p0_.IDPanier) AS sclr_0
FROM
  Panier p0_
WHERE
  p0_.IDAscensoriste = ?

SELECT COUNT(p0_.IDPanier) AS sclr_0 FROM Panier p0_ WHERE p0_.IDAscensoriste = 2;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Service\PanierTwigService->getPanierCount (line 35)
10	Twig\Extension\CoreExtension->getAttribute (line 1909)
11	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc::doDisplay (line 493)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
26	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 197)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.18 ms
(0.21%)

SELECT COUNT(*) FROM ClientAscoriste t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  ClientAscoriste t0

SELECT COUNT(*) FROM ClientAscoriste t0;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Connection->query (line 45)
2	Doctrine\DBAL\Connection->executeQuery (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
4	Doctrine\ORM\EntityRepository->count (line 140)
5	App\Service\DatabaseStateService->getDatabaseState (line 27)
6	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc->doDisplay (line 51)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
21	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 197)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.17 ms
(0.20%)

SELECT COUNT(*) FROM Ascenseur t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  Ascenseur t0

SELECT COUNT(*) FROM Ascenseur t0;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Connection->query (line 45)
2	Doctrine\DBAL\Connection->executeQuery (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
4	Doctrine\ORM\EntityRepository->count (line 140)
5	App\Service\DatabaseStateService->getDatabaseState (line 28)
6	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc->doDisplay (line 51)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
21	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 197)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.16 ms
(0.19%)

SELECT COUNT(*) FROM ClientAscoriste t0 WHERE t0.IDAscensoriste = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  ClientAscoriste t0
WHERE
  t0.IDAscensoriste = ?

SELECT COUNT(*) FROM ClientAscoriste t0 WHERE t0.IDAscensoriste = 2;

#	File/Call
1	Inspector\Symfony\Bundle\Doctrine\Middleware\V3\Statement->execute (line 49)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
4	Doctrine\ORM\EntityRepository->count (line 140)
5	App\Service\DatabaseStateService->getMissingSteps (line 66)
6	App\Service\DatabaseStateService->getDatabaseState (line 30)
7	__TwigTemplate_db406086ae67e311f3ae86a4da41dfbc->doDisplay (line 51)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_1d957e9fb21e074c4bc393e9aae625fa->doDisplay (line 471)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_041b5cc9826c44efed3f0bb3d7d5aaa7->doDisplay (line 65)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b313f9a3c258089418e43df1e4efd868->doDisplay (line 70)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Admin\Devis\AnalysedevisController->index (line 41)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

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\Typebordereaupu	No errors.
App\Entity\Typetravaux	No errors.
App\Entity\Filechecksum	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\Detailecheance	No errors.
App\Entity\DetailsAppareilHorsContrat	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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping