Symfony Profiler

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.IDTypeVisite AS IDTypeVisite_8,
  t0.IDTypeStatutASC AS IDTypeStatutASC_9,
  t0.NotifEnvoye AS NotifEnvoye_10,
  t0.IDAscenseur AS IDAscenseur_11,
  t0.IDTechnicien AS IDTechnicien_12,
  t0.IDDetailEntretien AS IDDetailEntretien_13,
  t0.IDEssaisPhonie AS IDEssaisPhonie_14,
  t0.IDPVCableTraction AS IDPVCableTraction_15,
  t0.IDDetailsPVParachute AS IDDetailsPVParachute_16,
  t0.IDDetailtravaux AS IDDetailtravaux_17,
  t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18,
  t0.IDSignalerPanne AS IDSignalerPanne_19,
  t0.IDEtudeSecurite AS IDEtudeSecurite_20,
  t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21,
  t0.IDFicheRemiseService AS IDFicheRemiseService_22
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.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = 49 ORDER BY t0.DateVisite DESC;

SELECT
  t0.IDDetailEntretien AS IDDetailEntretien_1,
  t0.RapportEntretien AS RapportEntretien_2,
  t0.NiveauCondamne AS NiveauCondamne_3,
  t0.MotifNiveauCondamne AS MotifNiveauCondamne_4,
  t0.ChecklistFait AS ChecklistFait_5,
  t0.IDPeriode AS IDPeriode_6,
  t0.IDTypeNiveauCondamne AS IDTypeNiveauCondamne_7,
  t8.IDCarnetMaintenance AS IDCarnetMaintenance_9,
  t8.DateVisite AS DateVisite_10,
  t8.HeureArrivee AS HeureArrivee_11,
  t8.HeureDepart AS HeureDepart_12,
  t8.DateProchainVisite AS DateProchainVisite_13,
  t8.DateDerniereVisite AS DateDerniereVisite_14,
  t8.EtatAjour AS EtatAjour_15,
  t8.IDTypeVisite AS IDTypeVisite_16,
  t8.IDTypeStatutASC AS IDTypeStatutASC_17,
  t8.NotifEnvoye AS NotifEnvoye_18,
  t8.IDAscenseur AS IDAscenseur_19,
  t8.IDTechnicien AS IDTechnicien_20,
  t8.IDDetailEntretien AS IDDetailEntretien_21,
  t8.IDEssaisPhonie AS IDEssaisPhonie_22,
  t8.IDPVCableTraction AS IDPVCableTraction_23,
  t8.IDDetailsPVParachute AS IDDetailsPVParachute_24,
  t8.IDDetailtravaux AS IDDetailtravaux_25,
  t8.IDRapportBureaucontrole AS IDRapportBureaucontrole_26,
  t8.IDSignalerPanne AS IDSignalerPanne_27,
  t8.IDEtudeSecurite AS IDEtudeSecurite_28,
  t8.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_29,
  t8.IDFicheRemiseService AS IDFicheRemiseService_30
FROM
  detailentretien t0
  LEFT JOIN CarnetMaintenance t8 ON t8.IDDetailEntretien = t0.IDDetailEntretien
WHERE
  t0.IDDetailEntretien = ?

SELECT t0.IDDetailEntretien AS IDDetailEntretien_1, t0.RapportEntretien AS RapportEntretien_2, t0.NiveauCondamne AS NiveauCondamne_3, t0.MotifNiveauCondamne AS MotifNiveauCondamne_4, t0.ChecklistFait AS ChecklistFait_5, t0.IDPeriode AS IDPeriode_6, t0.IDTypeNiveauCondamne AS IDTypeNiveauCondamne_7, t8.IDCarnetMaintenance AS IDCarnetMaintenance_9, t8.DateVisite AS DateVisite_10, t8.HeureArrivee AS HeureArrivee_11, t8.HeureDepart AS HeureDepart_12, t8.DateProchainVisite AS DateProchainVisite_13, t8.DateDerniereVisite AS DateDerniereVisite_14, t8.EtatAjour AS EtatAjour_15, t8.IDTypeVisite AS IDTypeVisite_16, t8.IDTypeStatutASC AS IDTypeStatutASC_17, t8.NotifEnvoye AS NotifEnvoye_18, t8.IDAscenseur AS IDAscenseur_19, t8.IDTechnicien AS IDTechnicien_20, t8.IDDetailEntretien AS IDDetailEntretien_21, t8.IDEssaisPhonie AS IDEssaisPhonie_22, t8.IDPVCableTraction AS IDPVCableTraction_23, t8.IDDetailsPVParachute AS IDDetailsPVParachute_24, t8.IDDetailtravaux AS IDDetailtravaux_25, t8.IDRapportBureaucontrole AS IDRapportBureaucontrole_26, t8.IDSignalerPanne AS IDSignalerPanne_27, t8.IDEtudeSecurite AS IDEtudeSecurite_28, t8.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_29, t8.IDFicheRemiseService AS IDFicheRemiseService_30 FROM detailentretien t0 LEFT JOIN CarnetMaintenance t8 ON t8.IDDetailEntretien = t0.IDDetailEntretien WHERE t0.IDDetailEntretien = '541';

SELECT
  t0.IDPieceParEntretien AS IDPieceParEntretien_1,
  t0.DatePiece AS DatePiece_2,
  t0.DateRemplacement AS DateRemplacement_3,
  t0.Devis AS Devis_4,
  t0.EntreDansCadreContrat AS EntreDansCadreContrat_5,
  t0.photo AS photo_6,
  t0.PieceRemplace AS PieceRemplace_7,
  t0.IDPieceAscenseur AS IDPieceAscenseur_8,
  t0.IDDetailEntretien AS IDDetailEntretien_9
FROM
  pieceparentretien t0
WHERE
  t0.IDDetailEntretien = ?

SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = 541;

SELECT
  t0.IDSignalerPanne AS IDSignalerPanne_1,
  t0.Libelle AS Libelle_2,
  t0.RapportInterventionPanne AS RapportInterventionPanne_3,
  t0.HeureAppel AS HeureAppel_4,
  t0.NiveauCondamne AS NiveauCondamne_5,
  t0.MotifNiveauCondamne AS MotifNiveauCondamne_6,
  t0.IDTypeNiveauBoiteBouton AS IDTypeNiveauBoiteBouton_7,
  t0.IDTypeoriginepanne AS IDTypeoriginepanne_8,
  t9.IDCarnetMaintenance AS IDCarnetMaintenance_10,
  t9.DateVisite AS DateVisite_11,
  t9.HeureArrivee AS HeureArrivee_12,
  t9.HeureDepart AS HeureDepart_13,
  t9.DateProchainVisite AS DateProchainVisite_14,
  t9.DateDerniereVisite AS DateDerniereVisite_15,
  t9.EtatAjour AS EtatAjour_16,
  t9.IDTypeVisite AS IDTypeVisite_17,
  t9.IDTypeStatutASC AS IDTypeStatutASC_18,
  t9.NotifEnvoye AS NotifEnvoye_19,
  t9.IDAscenseur AS IDAscenseur_20,
  t9.IDTechnicien AS IDTechnicien_21,
  t9.IDDetailEntretien AS IDDetailEntretien_22,
  t9.IDEssaisPhonie AS IDEssaisPhonie_23,
  t9.IDPVCableTraction AS IDPVCableTraction_24,
  t9.IDDetailsPVParachute AS IDDetailsPVParachute_25,
  t9.IDDetailtravaux AS IDDetailtravaux_26,
  t9.IDRapportBureaucontrole AS IDRapportBureaucontrole_27,
  t9.IDSignalerPanne AS IDSignalerPanne_28,
  t9.IDEtudeSecurite AS IDEtudeSecurite_29,
  t9.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_30,
  t9.IDFicheRemiseService AS IDFicheRemiseService_31,
  t0.IDInformationpanne AS IDInformationpanne_32
FROM
  SignalerPanne t0
  LEFT JOIN CarnetMaintenance t9 ON t9.IDSignalerPanne = t0.IDSignalerPanne
WHERE
  t0.IDSignalerPanne = ?

SELECT t0.IDSignalerPanne AS IDSignalerPanne_1, t0.Libelle AS Libelle_2, t0.RapportInterventionPanne AS RapportInterventionPanne_3, t0.HeureAppel AS HeureAppel_4, t0.NiveauCondamne AS NiveauCondamne_5, t0.MotifNiveauCondamne AS MotifNiveauCondamne_6, t0.IDTypeNiveauBoiteBouton AS IDTypeNiveauBoiteBouton_7, t0.IDTypeoriginepanne AS IDTypeoriginepanne_8, t9.IDCarnetMaintenance AS IDCarnetMaintenance_10, t9.DateVisite AS DateVisite_11, t9.HeureArrivee AS HeureArrivee_12, t9.HeureDepart AS HeureDepart_13, t9.DateProchainVisite AS DateProchainVisite_14, t9.DateDerniereVisite AS DateDerniereVisite_15, t9.EtatAjour AS EtatAjour_16, t9.IDTypeVisite AS IDTypeVisite_17, t9.IDTypeStatutASC AS IDTypeStatutASC_18, t9.NotifEnvoye AS NotifEnvoye_19, t9.IDAscenseur AS IDAscenseur_20, t9.IDTechnicien AS IDTechnicien_21, t9.IDDetailEntretien AS IDDetailEntretien_22, t9.IDEssaisPhonie AS IDEssaisPhonie_23, t9.IDPVCableTraction AS IDPVCableTraction_24, t9.IDDetailsPVParachute AS IDDetailsPVParachute_25, t9.IDDetailtravaux AS IDDetailtravaux_26, t9.IDRapportBureaucontrole AS IDRapportBureaucontrole_27, t9.IDSignalerPanne AS IDSignalerPanne_28, t9.IDEtudeSecurite AS IDEtudeSecurite_29, t9.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_30, t9.IDFicheRemiseService AS IDFicheRemiseService_31, t0.IDInformationpanne AS IDInformationpanne_32 FROM SignalerPanne t0 LEFT JOIN CarnetMaintenance t9 ON t9.IDSignalerPanne = t0.IDSignalerPanne WHERE t0.IDSignalerPanne = '323';

SELECT
  t0.IDPieceParPanne AS IDPieceParPanne_1,
  t0.DatePiece AS DatePiece_2,
  t0.DateRemplacement AS DateRemplacement_3,
  t0.Devis AS Devis_4,
  t0.EntreDansCadreContrat AS EntreDansCadreContrat_5,
  t0.photo AS photo_6,
  t0.PieceRemplace AS PieceRemplace_7,
  t0.IDPieceAscenseur AS IDPieceAscenseur_8,
  t0.IDSignalerPanne AS IDSignalerPanne_9
FROM
  pieceparpanne t0
WHERE
  t0.IDSignalerPanne = ?

SELECT t0.IDPieceParPanne AS IDPieceParPanne_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDSignalerPanne AS IDSignalerPanne_9 FROM pieceparpanne t0 WHERE t0.IDSignalerPanne = 323;

SELECT
  t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_1,
  t0.DossierTechnique AS DossierTechnique_2,
  t0.CarneEntretien AS CarneEntretien_3,
  t0.EtudeSecurite AS EtudeSecurite_4,
  t0.PVcable AS PVcable_5,
  t0.PVparachute AS PVparachute_6,
  t0.RapportAnnuel AS RapportAnnuel_7,
  t0.DeclarationConformite AS DeclarationConformite_8,
  t0.FichierRapport AS FichierRapport_9,
  t0.EtatNegatif AS EtatNegatif_10,
  t0.EtatPositif AS EtatPositif_11,
  t0.NBreservealever AS NBreservealever_12,
  t0.NBreserveleve AS NBreserveleve_13,
  t0.IDTypeReserveALever AS IDTypeReserveALever_14,
  t0.IDTypeControle AS IDTypeControle_15,
  t16.IDCarnetMaintenance AS IDCarnetMaintenance_17,
  t16.DateVisite AS DateVisite_18,
  t16.HeureArrivee AS HeureArrivee_19,
  t16.HeureDepart AS HeureDepart_20,
  t16.DateProchainVisite AS DateProchainVisite_21,
  t16.DateDerniereVisite AS DateDerniereVisite_22,
  t16.EtatAjour AS EtatAjour_23,
  t16.IDTypeVisite AS IDTypeVisite_24,
  t16.IDTypeStatutASC AS IDTypeStatutASC_25,
  t16.NotifEnvoye AS NotifEnvoye_26,
  t16.IDAscenseur AS IDAscenseur_27,
  t16.IDTechnicien AS IDTechnicien_28,
  t16.IDDetailEntretien AS IDDetailEntretien_29,
  t16.IDEssaisPhonie AS IDEssaisPhonie_30,
  t16.IDPVCableTraction AS IDPVCableTraction_31,
  t16.IDDetailsPVParachute AS IDDetailsPVParachute_32,
  t16.IDDetailtravaux AS IDDetailtravaux_33,
  t16.IDRapportBureaucontrole AS IDRapportBureaucontrole_34,
  t16.IDSignalerPanne AS IDSignalerPanne_35,
  t16.IDEtudeSecurite AS IDEtudeSecurite_36,
  t16.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_37,
  t16.IDFicheRemiseService AS IDFicheRemiseService_38
FROM
  rapportbureaucontrole t0
  LEFT JOIN CarnetMaintenance t16 ON t16.IDRapportBureaucontrole = t0.IDRapportBureaucontrole
WHERE
  t0.IDRapportBureaucontrole = ?

SELECT t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_1, t0.DossierTechnique AS DossierTechnique_2, t0.CarneEntretien AS CarneEntretien_3, t0.EtudeSecurite AS EtudeSecurite_4, t0.PVcable AS PVcable_5, t0.PVparachute AS PVparachute_6, t0.RapportAnnuel AS RapportAnnuel_7, t0.DeclarationConformite AS DeclarationConformite_8, t0.FichierRapport AS FichierRapport_9, t0.EtatNegatif AS EtatNegatif_10, t0.EtatPositif AS EtatPositif_11, t0.NBreservealever AS NBreservealever_12, t0.NBreserveleve AS NBreserveleve_13, t0.IDTypeReserveALever AS IDTypeReserveALever_14, t0.IDTypeControle AS IDTypeControle_15, t16.IDCarnetMaintenance AS IDCarnetMaintenance_17, t16.DateVisite AS DateVisite_18, t16.HeureArrivee AS HeureArrivee_19, t16.HeureDepart AS HeureDepart_20, t16.DateProchainVisite AS DateProchainVisite_21, t16.DateDerniereVisite AS DateDerniereVisite_22, t16.EtatAjour AS EtatAjour_23, t16.IDTypeVisite AS IDTypeVisite_24, t16.IDTypeStatutASC AS IDTypeStatutASC_25, t16.NotifEnvoye AS NotifEnvoye_26, t16.IDAscenseur AS IDAscenseur_27, t16.IDTechnicien AS IDTechnicien_28, t16.IDDetailEntretien AS IDDetailEntretien_29, t16.IDEssaisPhonie AS IDEssaisPhonie_30, t16.IDPVCableTraction AS IDPVCableTraction_31, t16.IDDetailsPVParachute AS IDDetailsPVParachute_32, t16.IDDetailtravaux AS IDDetailtravaux_33, t16.IDRapportBureaucontrole AS IDRapportBureaucontrole_34, t16.IDSignalerPanne AS IDSignalerPanne_35, t16.IDEtudeSecurite AS IDEtudeSecurite_36, t16.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_37, t16.IDFicheRemiseService AS IDFicheRemiseService_38 FROM rapportbureaucontrole t0 LEFT JOIN CarnetMaintenance t16 ON t16.IDRapportBureaucontrole = t0.IDRapportBureaucontrole WHERE t0.IDRapportBureaucontrole = '76';

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;

SELECT
  a0_.IDAscenseur AS IDAscenseur_0,
  a0_.NumAppareilASC AS NumAppareilASC_1,
  a0_.residenceASC AS residenceASC_2,
  a0_.AdresseInstallationASC AS AdresseInstallationASC_3,
  a0_.LocalisationASC AS LocalisationASC_4,
  a0_.ConstructeurASC AS ConstructeurASC_5,
  a0_.ChargeEnCabine AS ChargeEnCabine_6,
  a0_.NbrPersonne AS NbrPersonne_7,
  a0_.DeplacementASC AS DeplacementASC_8,
  a0_.AnneeConstructionASC AS AnneeConstructionASC_9,
  a0_.PrixContrat AS PrixContrat_10,
  a0_.AbonnementGsm AS AbonnementGsm_11,
  a0_.NbNiveauASC AS NbNiveauASC_12,
  a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_13,
  a0_.loichatel AS loichatel_14,
  a0_.GardienASC AS GardienASC_15,
  a0_.PositionSerrure AS PositionSerrure_16,
  a0_.NumAffaire AS NumAffaire_17,
  a0_.QRCodeASC AS QRCodeASC_18,
  a0_.QRCodeFile AS QRCodeFile_19,
  a0_.ContactSurSite AS ContactSurSite_20,
  a0_.NumeroContactSurSite AS NumeroContactSurSite_21,
  a0_.EmailContactSurSite AS EmailContactSurSite_22,
  a0_.IDVille AS IDVille_23,
  a0_.CP AS CP_24,
  a0_.CoffreAcle AS CoffreAcle_25,
  a0_.Autre AS Autre_26,
  a0_.IDTypeVitessenominale AS IDTypeVitessenominale_27,
  a0_.IDFournisseur AS IDFournisseur_28,
  a0_.IDConstructeur AS IDConstructeur_29,
  a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_30,
  a0_.IDTypeSecteur AS IDTypeSecteur_31,
  a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_32,
  a0_.IDTypePortePaliere AS IDTypePortePaliere_33,
  a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_34,
  a0_.IDClientAscoriste AS IDClientAscoriste_35,
  a0_.IDTypeBatiment AS IDTypeBatiment_36,
  a0_.IDTypeOuverture AS IDTypeOuverture_37,
  a0_.IDTypeAscenseur AS IDTypeAscenseur_38,
  a0_.IDTypeDeplacement AS IDTypeDeplacement_39,
  a0_.IDTypeChargeencabine AS IDTypeChargeencabine_40,
  a0_.IDTypeService AS IDTypeService_41,
  a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_42,
  a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_43,
  a0_.IDAscensoriste AS IDAscensoriste_44,
  a0_.IDContrat AS IDContrat_45
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_.LocalisationASC AS LocalisationASC_4, a0_.ConstructeurASC AS ConstructeurASC_5, a0_.ChargeEnCabine AS ChargeEnCabine_6, a0_.NbrPersonne AS NbrPersonne_7, a0_.DeplacementASC AS DeplacementASC_8, a0_.AnneeConstructionASC AS AnneeConstructionASC_9, a0_.PrixContrat AS PrixContrat_10, a0_.AbonnementGsm AS AbonnementGsm_11, a0_.NbNiveauASC AS NbNiveauASC_12, a0_.PortePalCoupeFeuASC AS PortePalCoupeFeuASC_13, a0_.loichatel AS loichatel_14, a0_.GardienASC AS GardienASC_15, a0_.PositionSerrure AS PositionSerrure_16, a0_.NumAffaire AS NumAffaire_17, a0_.QRCodeASC AS QRCodeASC_18, a0_.QRCodeFile AS QRCodeFile_19, a0_.ContactSurSite AS ContactSurSite_20, a0_.NumeroContactSurSite AS NumeroContactSurSite_21, a0_.EmailContactSurSite AS EmailContactSurSite_22, a0_.IDVille AS IDVille_23, a0_.CP AS CP_24, a0_.CoffreAcle AS CoffreAcle_25, a0_.Autre AS Autre_26, a0_.IDTypeVitessenominale AS IDTypeVitessenominale_27, a0_.IDFournisseur AS IDFournisseur_28, a0_.IDConstructeur AS IDConstructeur_29, a0_.IDTypeMarqueSerrure AS IDTypeMarqueSerrure_30, a0_.IDTypeSecteur AS IDTypeSecteur_31, a0_.IDMarquedemanoeuvre AS IDMarquedemanoeuvre_32, a0_.IDTypePortePaliere AS IDTypePortePaliere_33, a0_.IDTypeDeverrouillage AS IDTypeDeverrouillage_34, a0_.IDClientAscoriste AS IDClientAscoriste_35, a0_.IDTypeBatiment AS IDTypeBatiment_36, a0_.IDTypeOuverture AS IDTypeOuverture_37, a0_.IDTypeAscenseur AS IDTypeAscenseur_38, a0_.IDTypeDeplacement AS IDTypeDeplacement_39, a0_.IDTypeChargeencabine AS IDTypeChargeencabine_40, a0_.IDTypeService AS IDTypeService_41, a0_.IDTypeCategorieBatiment AS IDTypeCategorieBatiment_42, a0_.IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_43, a0_.IDAscensoriste AS IDAscensoriste_44, a0_.IDContrat AS IDContrat_45 FROM Ascenseur a0_ INNER JOIN Contrat c1_ ON a0_.IDContrat = c1_.IDContrat WHERE a0_.IDAscensoriste = 2 AND c1_.Valide = 1 AND c1_.DateContrat <= '2025-10-10 10:02:59' AND ((c1_.resilier = 0 OR (c1_.resilier = 1 AND c1_.DateResiliation > '2025-10-10 10:02:59')));

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.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.IDVille AS IDVille_10, t0.isAdmin AS isAdmin_11, t0.IDProfil AS IDProfil_12, t0.IDAscensoriste AS IDAscensoriste_13 FROM user t0 WHERE t0.username = 'adminarcade@yopmail.com' LIMIT 1;

SELECT
  t0.IDAscensoriste AS IDAscensoriste_1,
  t0.Logo AS Logo_2,
  t0.Nom AS Nom_3,
  t0.Email AS Email_4,
  t0.TelContact AS TelContact_5,
  t0.NomContact AS NomContact_6,
  t0.CP AS CP_7,
  t0.Type AS Type_8,
  t0.Adresse AS Adresse_9,
  t0.IDVille AS IDVille_10,
  t0.EstActif AS EstActif_11,
  t0.Pays AS Pays_12,
  t0.TauxHoraire AS TauxHoraire_13,
  t0.TempsDeplacement AS TempsDeplacement_14,
  t0.AugmentationPrixOpParAn AS AugmentationPrixOpParAn_15
FROM
  Ascensoriste t0
WHERE
  t0.IDAscensoriste = ?

SELECT t0.IDAscensoriste AS IDAscensoriste_1, t0.Logo AS Logo_2, t0.Nom AS Nom_3, t0.Email AS Email_4, t0.TelContact AS TelContact_5, t0.NomContact AS NomContact_6, t0.CP AS CP_7, t0.Type AS Type_8, t0.Adresse AS Adresse_9, t0.IDVille AS IDVille_10, t0.EstActif AS EstActif_11, t0.Pays AS Pays_12, t0.TauxHoraire AS TauxHoraire_13, t0.TempsDeplacement AS TempsDeplacement_14, t0.AugmentationPrixOpParAn AS AugmentationPrixOpParAn_15 FROM Ascensoriste t0 WHERE t0.IDAscensoriste = '2';