Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.EstActive AS EstActive_5,
  t0.NomPrenom AS NomPrenom_6,
  t0.Tel AS Tel_7,
  t0.Adresse AS Adresse_8,
  t0.Pays AS Pays_9,
  t0.IDVille AS IDVille_10,
  t0.isAdmin AS isAdmin_11,
  t0.IDProfil AS IDProfil_12,
  t0.IDAscensoriste AS IDAscensoriste_13
FROM
  user t0
WHERE
  t0.id = ?

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

SELECT
  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 > ?
      )
    )
  )
  AND a0_.NumAppareilASC LIKE ?
  AND a0_.IDTypeSecteur = ?

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 = '9' AND c1_.Valide = 1 AND c1_.DateContrat <= '2026-04-07 16:22:16' AND ((c1_.resilier = 0 OR (c1_.resilier = 1 AND c1_.DateResiliation > '2026-04-07 16:22:16'))) AND a0_.NumAppareilASC LIKE '%610356%' AND a0_.IDTypeSecteur = '66';

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

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

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.IDAscenseur = '220';

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

SELECT
  t0.IDFournisseur AS IDFournisseur_1,
  t0.NomFournisseur AS NomFournisseur_2,
  t0.TelFournisseur AS TelFournisseur_3,
  t0.EmailFournisseur AS EmailFournisseur_4,
  t0.AdresseFournisseur AS AdresseFournisseur_5,
  t0.SiteWebFournisseur AS SiteWebFournisseur_6,
  t0.RefFournisseur AS RefFournisseur_7,
  t0.NomContactFournisseur AS NomContactFournisseur_8,
  t0.IDAscensoriste AS IDAscensoriste_9
FROM
  Fournisseur t0
WHERE
  t0.IDAscensoriste IN (?)

SELECT t0.IDFournisseur AS IDFournisseur_1, t0.NomFournisseur AS NomFournisseur_2, t0.TelFournisseur AS TelFournisseur_3, t0.EmailFournisseur AS EmailFournisseur_4, t0.AdresseFournisseur AS AdresseFournisseur_5, t0.SiteWebFournisseur AS SiteWebFournisseur_6, t0.RefFournisseur AS RefFournisseur_7, t0.NomContactFournisseur AS NomContactFournisseur_8, t0.IDAscensoriste AS IDAscensoriste_9 FROM Fournisseur t0 WHERE t0.IDAscensoriste IN ('9');

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

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

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

SELECT
  c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0,
  c0_.DateVisite AS DateVisite_1,
  c0_.HeureArrivee AS HeureArrivee_2,
  c0_.HeureDepart AS HeureDepart_3,
  c0_.DateProchainVisite AS DateProchainVisite_4,
  c0_.DateDerniereVisite AS DateDerniereVisite_5,
  c0_.EtatAjour AS EtatAjour_6,
  c0_.MarcheDegrade AS MarcheDegrade_7,
  c0_.EtablirDevis AS EtablirDevis_8,
  c0_.AssistanceTechnique AS AssistanceTechnique_9,
  c0_.IDTypeVisite AS IDTypeVisite_10,
  c0_.IDTypeStatutASC AS IDTypeStatutASC_11,
  c0_.NotifEnvoye AS NotifEnvoye_12,
  c0_.IDAscenseur AS IDAscenseur_13,
  c0_.IDTechnicien AS IDTechnicien_14,
  c0_.IDDetailEntretien AS IDDetailEntretien_15,
  c0_.IDEssaisPhonie AS IDEssaisPhonie_16,
  c0_.IDPVCableTraction AS IDPVCableTraction_17,
  c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18,
  c0_.IDDetailtravaux AS IDDetailtravaux_19,
  c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20,
  c0_.IDSignalerPanne AS IDSignalerPanne_21,
  c0_.IDEtudeSecurite AS IDEtudeSecurite_22,
  c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23,
  c0_.IDFicheRemiseService AS IDFicheRemiseService_24
FROM
  CarnetMaintenance c0_
WHERE
  (
    (
      c0_.DateVisite >= ?
      AND c0_.DateVisite <= ?
    )
    OR (
      c0_.DateProchainVisite >= ?
      AND c0_.DateProchainVisite <= ?
    )
  )
  AND c0_.IDAscenseur = ?
  AND c0_.IDTypeVisite = ?
ORDER BY
  c0_.DateVisite DESC

SELECT c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0, c0_.DateVisite AS DateVisite_1, c0_.HeureArrivee AS HeureArrivee_2, c0_.HeureDepart AS HeureDepart_3, c0_.DateProchainVisite AS DateProchainVisite_4, c0_.DateDerniereVisite AS DateDerniereVisite_5, c0_.EtatAjour AS EtatAjour_6, c0_.MarcheDegrade AS MarcheDegrade_7, c0_.EtablirDevis AS EtablirDevis_8, c0_.AssistanceTechnique AS AssistanceTechnique_9, c0_.IDTypeVisite AS IDTypeVisite_10, c0_.IDTypeStatutASC AS IDTypeStatutASC_11, c0_.NotifEnvoye AS NotifEnvoye_12, c0_.IDAscenseur AS IDAscenseur_13, c0_.IDTechnicien AS IDTechnicien_14, c0_.IDDetailEntretien AS IDDetailEntretien_15, c0_.IDEssaisPhonie AS IDEssaisPhonie_16, c0_.IDPVCableTraction AS IDPVCableTraction_17, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18, c0_.IDDetailtravaux AS IDDetailtravaux_19, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20, c0_.IDSignalerPanne AS IDSignalerPanne_21, c0_.IDEtudeSecurite AS IDEtudeSecurite_22, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23, c0_.IDFicheRemiseService AS IDFicheRemiseService_24 FROM CarnetMaintenance c0_ WHERE ((c0_.DateVisite >= '2026-01-01 00:00:00' AND c0_.DateVisite <= '2026-12-31 23:59:59') OR (c0_.DateProchainVisite >= '2026-01-01 00:00:00' AND c0_.DateProchainVisite <= '2026-12-31 23:59:59')) AND c0_.IDAscenseur = 212 AND c0_.IDTypeVisite = 'ENTRETIEN' ORDER BY c0_.DateVisite DESC;

SELECT
  c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0,
  c0_.DateVisite AS DateVisite_1,
  c0_.HeureArrivee AS HeureArrivee_2,
  c0_.HeureDepart AS HeureDepart_3,
  c0_.DateProchainVisite AS DateProchainVisite_4,
  c0_.DateDerniereVisite AS DateDerniereVisite_5,
  c0_.EtatAjour AS EtatAjour_6,
  c0_.MarcheDegrade AS MarcheDegrade_7,
  c0_.EtablirDevis AS EtablirDevis_8,
  c0_.AssistanceTechnique AS AssistanceTechnique_9,
  c0_.IDTypeVisite AS IDTypeVisite_10,
  c0_.IDTypeStatutASC AS IDTypeStatutASC_11,
  c0_.NotifEnvoye AS NotifEnvoye_12,
  c0_.IDAscenseur AS IDAscenseur_13,
  c0_.IDTechnicien AS IDTechnicien_14,
  c0_.IDDetailEntretien AS IDDetailEntretien_15,
  c0_.IDEssaisPhonie AS IDEssaisPhonie_16,
  c0_.IDPVCableTraction AS IDPVCableTraction_17,
  c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18,
  c0_.IDDetailtravaux AS IDDetailtravaux_19,
  c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20,
  c0_.IDSignalerPanne AS IDSignalerPanne_21,
  c0_.IDEtudeSecurite AS IDEtudeSecurite_22,
  c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23,
  c0_.IDFicheRemiseService AS IDFicheRemiseService_24
FROM
  CarnetMaintenance c0_
WHERE
  c0_.IDAscenseur = ?
  AND c0_.IDTypeVisite = ?
ORDER BY
  c0_.DateVisite DESC
LIMIT
  1

SELECT c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0, c0_.DateVisite AS DateVisite_1, c0_.HeureArrivee AS HeureArrivee_2, c0_.HeureDepart AS HeureDepart_3, c0_.DateProchainVisite AS DateProchainVisite_4, c0_.DateDerniereVisite AS DateDerniereVisite_5, c0_.EtatAjour AS EtatAjour_6, c0_.MarcheDegrade AS MarcheDegrade_7, c0_.EtablirDevis AS EtablirDevis_8, c0_.AssistanceTechnique AS AssistanceTechnique_9, c0_.IDTypeVisite AS IDTypeVisite_10, c0_.IDTypeStatutASC AS IDTypeStatutASC_11, c0_.NotifEnvoye AS NotifEnvoye_12, c0_.IDAscenseur AS IDAscenseur_13, c0_.IDTechnicien AS IDTechnicien_14, c0_.IDDetailEntretien AS IDDetailEntretien_15, c0_.IDEssaisPhonie AS IDEssaisPhonie_16, c0_.IDPVCableTraction AS IDPVCableTraction_17, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18, c0_.IDDetailtravaux AS IDDetailtravaux_19, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20, c0_.IDSignalerPanne AS IDSignalerPanne_21, c0_.IDEtudeSecurite AS IDEtudeSecurite_22, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23, c0_.IDFicheRemiseService AS IDFicheRemiseService_24 FROM CarnetMaintenance c0_ WHERE c0_.IDAscenseur = 212 AND c0_.IDTypeVisite = 'ENTRETIEN' ORDER BY c0_.DateVisite DESC LIMIT 1;

SELECT
  c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0,
  c0_.DateVisite AS DateVisite_1,
  c0_.HeureArrivee AS HeureArrivee_2,
  c0_.HeureDepart AS HeureDepart_3,
  c0_.DateProchainVisite AS DateProchainVisite_4,
  c0_.DateDerniereVisite AS DateDerniereVisite_5,
  c0_.EtatAjour AS EtatAjour_6,
  c0_.MarcheDegrade AS MarcheDegrade_7,
  c0_.EtablirDevis AS EtablirDevis_8,
  c0_.AssistanceTechnique AS AssistanceTechnique_9,
  c0_.IDTypeVisite AS IDTypeVisite_10,
  c0_.IDTypeStatutASC AS IDTypeStatutASC_11,
  c0_.NotifEnvoye AS NotifEnvoye_12,
  c0_.IDAscenseur AS IDAscenseur_13,
  c0_.IDTechnicien AS IDTechnicien_14,
  c0_.IDDetailEntretien AS IDDetailEntretien_15,
  c0_.IDEssaisPhonie AS IDEssaisPhonie_16,
  c0_.IDPVCableTraction AS IDPVCableTraction_17,
  c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18,
  c0_.IDDetailtravaux AS IDDetailtravaux_19,
  c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20,
  c0_.IDSignalerPanne AS IDSignalerPanne_21,
  c0_.IDEtudeSecurite AS IDEtudeSecurite_22,
  c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23,
  c0_.IDFicheRemiseService AS IDFicheRemiseService_24
FROM
  CarnetMaintenance c0_
WHERE
  c0_.IDAscenseur = ?
  AND c0_.IDTypeVisite = ?
ORDER BY
  c0_.DateVisite DESC
LIMIT
  1

SELECT c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0, c0_.DateVisite AS DateVisite_1, c0_.HeureArrivee AS HeureArrivee_2, c0_.HeureDepart AS HeureDepart_3, c0_.DateProchainVisite AS DateProchainVisite_4, c0_.DateDerniereVisite AS DateDerniereVisite_5, c0_.EtatAjour AS EtatAjour_6, c0_.MarcheDegrade AS MarcheDegrade_7, c0_.EtablirDevis AS EtablirDevis_8, c0_.AssistanceTechnique AS AssistanceTechnique_9, c0_.IDTypeVisite AS IDTypeVisite_10, c0_.IDTypeStatutASC AS IDTypeStatutASC_11, c0_.NotifEnvoye AS NotifEnvoye_12, c0_.IDAscenseur AS IDAscenseur_13, c0_.IDTechnicien AS IDTechnicien_14, c0_.IDDetailEntretien AS IDDetailEntretien_15, c0_.IDEssaisPhonie AS IDEssaisPhonie_16, c0_.IDPVCableTraction AS IDPVCableTraction_17, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18, c0_.IDDetailtravaux AS IDDetailtravaux_19, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20, c0_.IDSignalerPanne AS IDSignalerPanne_21, c0_.IDEtudeSecurite AS IDEtudeSecurite_22, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23, c0_.IDFicheRemiseService AS IDFicheRemiseService_24 FROM CarnetMaintenance c0_ WHERE c0_.IDAscenseur = 212 AND c0_.IDTypeVisite = 'CONTROLE_CABLE' ORDER BY c0_.DateVisite DESC LIMIT 1;

SELECT
  c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0,
  c0_.DateVisite AS DateVisite_1,
  c0_.HeureArrivee AS HeureArrivee_2,
  c0_.HeureDepart AS HeureDepart_3,
  c0_.DateProchainVisite AS DateProchainVisite_4,
  c0_.DateDerniereVisite AS DateDerniereVisite_5,
  c0_.EtatAjour AS EtatAjour_6,
  c0_.MarcheDegrade AS MarcheDegrade_7,
  c0_.EtablirDevis AS EtablirDevis_8,
  c0_.AssistanceTechnique AS AssistanceTechnique_9,
  c0_.IDTypeVisite AS IDTypeVisite_10,
  c0_.IDTypeStatutASC AS IDTypeStatutASC_11,
  c0_.NotifEnvoye AS NotifEnvoye_12,
  c0_.IDAscenseur AS IDAscenseur_13,
  c0_.IDTechnicien AS IDTechnicien_14,
  c0_.IDDetailEntretien AS IDDetailEntretien_15,
  c0_.IDEssaisPhonie AS IDEssaisPhonie_16,
  c0_.IDPVCableTraction AS IDPVCableTraction_17,
  c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18,
  c0_.IDDetailtravaux AS IDDetailtravaux_19,
  c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20,
  c0_.IDSignalerPanne AS IDSignalerPanne_21,
  c0_.IDEtudeSecurite AS IDEtudeSecurite_22,
  c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23,
  c0_.IDFicheRemiseService AS IDFicheRemiseService_24
FROM
  CarnetMaintenance c0_
WHERE
  c0_.IDAscenseur = ?
  AND c0_.IDTypeVisite = ?
ORDER BY
  c0_.DateVisite DESC
LIMIT
  1

SELECT c0_.IDCarnetMaintenance AS IDCarnetMaintenance_0, c0_.DateVisite AS DateVisite_1, c0_.HeureArrivee AS HeureArrivee_2, c0_.HeureDepart AS HeureDepart_3, c0_.DateProchainVisite AS DateProchainVisite_4, c0_.DateDerniereVisite AS DateDerniereVisite_5, c0_.EtatAjour AS EtatAjour_6, c0_.MarcheDegrade AS MarcheDegrade_7, c0_.EtablirDevis AS EtablirDevis_8, c0_.AssistanceTechnique AS AssistanceTechnique_9, c0_.IDTypeVisite AS IDTypeVisite_10, c0_.IDTypeStatutASC AS IDTypeStatutASC_11, c0_.NotifEnvoye AS NotifEnvoye_12, c0_.IDAscenseur AS IDAscenseur_13, c0_.IDTechnicien AS IDTechnicien_14, c0_.IDDetailEntretien AS IDDetailEntretien_15, c0_.IDEssaisPhonie AS IDEssaisPhonie_16, c0_.IDPVCableTraction AS IDPVCableTraction_17, c0_.IDDetailsPVParachute AS IDDetailsPVParachute_18, c0_.IDDetailtravaux AS IDDetailtravaux_19, c0_.IDRapportBureaucontrole AS IDRapportBureaucontrole_20, c0_.IDSignalerPanne AS IDSignalerPanne_21, c0_.IDEtudeSecurite AS IDEtudeSecurite_22, c0_.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_23, c0_.IDFicheRemiseService AS IDFicheRemiseService_24 FROM CarnetMaintenance c0_ WHERE c0_.IDAscenseur = 212 AND c0_.IDTypeVisite = 'CONTROLE_PARACHUTE' ORDER BY c0_.DateVisite DESC LIMIT 1;