1
0.53 ms
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 ; Copy
2
0.90 ms
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:56:36 "
"2026-04-16 12:56:36 "
]
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 > ?
)
)
)Copy
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:56:36' AND ((c1_ . resilier = 0 OR (c1_ . resilier = 1 AND c1_ . DateResiliation > '2026-04-16 12:56:36' ))); Copy
3
0.37 ms
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 ; Copy
4
0.17 ms
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 = 50 ; Copy
5
0.16 ms
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 = 51 ; Copy
6
0.12 ms
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 = 52 ; Copy
7
0.11 ms
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 = 55 ; Copy
8
0.15 ms
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 = 56 ; Copy
9
0.12 ms
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 = 57 ; Copy
10
0.10 ms
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 = 58 ; Copy
11
0.11 ms
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 = 59 ; Copy
12
0.13 ms
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 = 60 ; Copy
13
0.11 ms
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 = 61 ; Copy
14
0.10 ms
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 = 62 ; Copy
15
0.14 ms
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 = 63 ; Copy
16
0.12 ms
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 = 64 ; Copy
17
0.12 ms
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 = 65 ; Copy
18
0.12 ms
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 = 66 ; Copy
19
0.10 ms
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 = 67 ; Copy
20
0.10 ms
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 = 68 ; Copy
21
0.11 ms
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 = 69 ; Copy
22
0.12 ms
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 = 70 ; Copy
23
0.14 ms
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 = 71 ; Copy
24
0.17 ms
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 = 72 ; Copy
25
0.12 ms
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 = 73 ; Copy
26
0.12 ms
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 = 74 ; Copy
27
0.16 ms
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 = 75 ; Copy
28
0.16 ms
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 = 76 ; Copy
29
0.17 ms
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 = 77 ; Copy
30
0.14 ms
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 = 78 ; Copy
31
0.14 ms
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 = 79 ; Copy
32
0.19 ms
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 = 80 ; Copy
33
0.15 ms
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 = 81 ; Copy
34
0.17 ms
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 = 82 ; Copy
35
0.18 ms
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 = 83 ; Copy
36
0.16 ms
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 = 84 ; Copy
37
0.16 ms
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 = 85 ; Copy
38
0.14 ms
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 = 86 ; Copy
39
0.16 ms
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 = 87 ; Copy
40
0.14 ms
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 = 88 ; Copy
41
0.14 ms
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 = 89 ; Copy
42
0.41 ms
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 = 90 ; Copy
43
0.15 ms
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 = 91 ; Copy
44
0.27 ms
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 ; Copy
45
0.26 ms
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 ; Copy
46
0.23 ms
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 ; Copy
47
0.41 ms
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% "
]
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%' ; Copy
48
2.14 ms
SELECT DISTINCT d0_ . IDDevistravauxparasc AS IDDevistravauxparasc_0 , d0_ . datedevis AS datedevis_1 , d0_ . numero AS numero_2 , d0_ . numOS AS numOS_3 , d0_ . affairesuivipar AS affairesuivipar_4 , d0_ . Telpro AS Telpro_5 , d0_ . Mailpro AS Mailpro_6 , d0_ . tva AS tva_7 , d0_ . Validite AS Validite_8 , d0_ . ConditionPayment AS ConditionPayment_9 , d0_ . total AS total_10 , d0_ . totalTTC AS totalTTC_11 , d0_ . Estvalide AS Estvalide_12 , d0_ . parIA AS parIA_13 , d0_ . AppareilHorsContrat AS AppareilHorsContrat_14 , d0_ . devisFile AS devisFile_15 , d0_ . Texteaccopagnement AS Texteaccopagnement_16 , d0_ . FichierOs AS FichierOs_17 , d0_ . NoteInformation AS NoteInformation_18 , d0_ . datevalidation AS datevalidation_19 , d0_ . Status AS Status_20 , d0_ . DecisionToken AS DecisionToken_21 , d0_ . typeFacturation AS typeFacturation_22 , a1_ . IDAscenseur AS IDAscenseur_23 , a1_ . NumAppareilASC AS NumAppareilASC_24 , a1_ . residenceASC AS residenceASC_25 , a1_ . AdresseInstallationASC AS AdresseInstallationASC_26 , a1_ . MarquageCE AS MarquageCE_27 , a1_ . LocalisationASC AS LocalisationASC_28 , a1_ . ConstructeurASC AS ConstructeurASC_29 , a1_ . ChargeEnCabine AS ChargeEnCabine_30 , a1_ . NbrPersonne AS NbrPersonne_31 , a1_ . DeplacementASC AS DeplacementASC_32 , a1_ . AnneeConstructionASC AS AnneeConstructionASC_33 , a1_ . PrixContrat AS PrixContrat_34 , a1_ . AbonnementGsm AS AbonnementGsm_35 , a1_ . NbNiveauASC AS NbNiveauASC_36 , a1_ . PortePalCoupeFeuASC AS PortePalCoupeFeuASC_37 , a1_ . loichatel AS loichatel_38 , a1_ . GardienASC AS GardienASC_39 , a1_ . PositionSerrure AS PositionSerrure_40 , a1_ . NumAffaire AS NumAffaire_41 , a1_ . QRCodeASC AS QRCodeASC_42 , a1_ . QRCodeFile AS QRCodeFile_43 , a1_ . ContactSurSite AS ContactSurSite_44 , a1_ . NumeroContactSurSite AS NumeroContactSurSite_45 , a1_ . EmailContactSurSite AS EmailContactSurSite_46 , a1_ . IDVille AS IDVille_47 , a1_ . CP AS CP_48 , a1_ . CoffreAcle AS CoffreAcle_49 , a1_ . Autre AS Autre_50 , c2_ . IDClientAscoriste AS IDClientAscoriste_51 , c2_ . RefClient AS RefClient_52 , c2_ . NomClient AS NomClient_53 , c2_ . EstActif AS EstActif_54 , c2_ . AdresseClient AS AdresseClient_55 , c2_ . TelClient AS TelClient_56 , c2_ . Emailclient AS Emailclient_57 , c2_ . NomContactClient AS NomContactClient_58 , c2_ . LienSiteClient AS LienSiteClient_59 , c2_ . CodeComptable AS CodeComptable_60 , t3_ . IDTypeTravaux AS IDTypeTravaux_61 , t3_ . Libelle AS Libelle_62 , t3_ . ERentabilite AS ERentabilite_63 , d4_ . IDDetailsAppareilHorsContrat AS IDDetailsAppareilHorsContrat_64 , d4_ . adresse AS adresse_65 , d4_ . localisation AS localisation_66 , d5_ . IDDetailecheance AS IDDetailecheance_67 , d5_ . pourcentage AS pourcentage_68 , d5_ . Date AS Date_69 , d0_ . IDAscenseur AS IDAscenseur_70 , d0_ . IDTypeBordereaupu AS IDTypeBordereaupu_71 , d0_ . IDTypeTravaux AS IDTypeTravaux_72 , d0_ . IDFilechecksum AS IDFilechecksum_73 , a1_ . IDTypeVitessenominale AS IDTypeVitessenominale_74 , a1_ . IDFournisseur AS IDFournisseur_75 , a1_ . IDConstructeur AS IDConstructeur_76 , a1_ . IDTypeMarqueSerrure AS IDTypeMarqueSerrure_77 , a1_ . IDTypeSecteur AS IDTypeSecteur_78 , a1_ . IDMarquedemanoeuvre AS IDMarquedemanoeuvre_79 , a1_ . IDTypePortePaliere AS IDTypePortePaliere_80 , a1_ . IDTypeDeverrouillage AS IDTypeDeverrouillage_81 , a1_ . IDClientAscoriste AS IDClientAscoriste_82 , a1_ . IDTypeBatiment AS IDTypeBatiment_83 , a1_ . IDTypeOuverture AS IDTypeOuverture_84 , a1_ . IDTypeequipement AS IDTypeequipement_85 , a1_ . IDTypeDeplacement AS IDTypeDeplacement_86 , a1_ . IDTypeChargeencabine AS IDTypeChargeencabine_87 , a1_ . IDTypeService AS IDTypeService_88 , a1_ . IDTypeCategorieBatiment AS IDTypeCategorieBatiment_89 , a1_ . IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_90 , a1_ . IDAscensoriste AS IDAscensoriste_91 , a1_ . IDContrat AS IDContrat_92 , c2_ . IDUser AS IDUser_93 , c2_ . IDAscensoriste AS IDAscensoriste_94 , d4_ . IDDevistravauxparasc AS IDDevistravauxparasc_95 , d5_ . IDTypeEcheance AS IDTypeEcheance_96 , d5_ . IDDevistravauxparasc AS IDDevistravauxparasc_97 FROM Devistravauxparasc d0_ LEFT JOIN Ascenseur a1_ ON d0_ . IDAscenseur = a1_ . IDAscenseur LEFT JOIN ClientAscoriste c2_ ON a1_ . IDClientAscoriste = c2_ . IDClientAscoriste LEFT JOIN typetravaux t3_ ON d0_ . IDTypeTravaux = t3_ . IDTypeTravaux LEFT JOIN DetailsAppareilHorsContrat d4_ ON d0_ . IDDevistravauxparasc = d4_ . IDDevistravauxparasc LEFT JOIN detailecheance d5_ ON d0_ . IDDevistravauxparasc = d5_ . IDDevistravauxparasc WHERE d0_ . IDAscenseur = ? ORDER BY d0_ . datedevis DESC
SELECT
DISTINCT d0_ . IDDevistravauxparasc AS IDDevistravauxparasc_0 ,
d0_ . datedevis AS datedevis_1 ,
d0_ . numero AS numero_2 ,
d0_ . numOS AS numOS_3 ,
d0_ . affairesuivipar AS affairesuivipar_4 ,
d0_ . Telpro AS Telpro_5 ,
d0_ . Mailpro AS Mailpro_6 ,
d0_ . tva AS tva_7 ,
d0_ . Validite AS Validite_8 ,
d0_ . ConditionPayment AS ConditionPayment_9 ,
d0_ . total AS total_10 ,
d0_ . totalTTC AS totalTTC_11 ,
d0_ . Estvalide AS Estvalide_12 ,
d0_ . parIA AS parIA_13 ,
d0_ . AppareilHorsContrat AS AppareilHorsContrat_14 ,
d0_ . devisFile AS devisFile_15 ,
d0_ . Texteaccopagnement AS Texteaccopagnement_16 ,
d0_ . FichierOs AS FichierOs_17 ,
d0_ . NoteInformation AS NoteInformation_18 ,
d0_ . datevalidation AS datevalidation_19 ,
d0_ . Status AS Status_20 ,
d0_ . DecisionToken AS DecisionToken_21 ,
d0_ . typeFacturation AS typeFacturation_22 ,
a1_ . IDAscenseur AS IDAscenseur_23 ,
a1_ . NumAppareilASC AS NumAppareilASC_24 ,
a1_ . residenceASC AS residenceASC_25 ,
a1_ . AdresseInstallationASC AS AdresseInstallationASC_26 ,
a1_ . MarquageCE AS MarquageCE_27 ,
a1_ . LocalisationASC AS LocalisationASC_28 ,
a1_ . ConstructeurASC AS ConstructeurASC_29 ,
a1_ . ChargeEnCabine AS ChargeEnCabine_30 ,
a1_ . NbrPersonne AS NbrPersonne_31 ,
a1_ . DeplacementASC AS DeplacementASC_32 ,
a1_ . AnneeConstructionASC AS AnneeConstructionASC_33 ,
a1_ . PrixContrat AS PrixContrat_34 ,
a1_ . AbonnementGsm AS AbonnementGsm_35 ,
a1_ . NbNiveauASC AS NbNiveauASC_36 ,
a1_ . PortePalCoupeFeuASC AS PortePalCoupeFeuASC_37 ,
a1_ . loichatel AS loichatel_38 ,
a1_ . GardienASC AS GardienASC_39 ,
a1_ . PositionSerrure AS PositionSerrure_40 ,
a1_ . NumAffaire AS NumAffaire_41 ,
a1_ . QRCodeASC AS QRCodeASC_42 ,
a1_ . QRCodeFile AS QRCodeFile_43 ,
a1_ . ContactSurSite AS ContactSurSite_44 ,
a1_ . NumeroContactSurSite AS NumeroContactSurSite_45 ,
a1_ . EmailContactSurSite AS EmailContactSurSite_46 ,
a1_ . IDVille AS IDVille_47 ,
a1_ . CP AS CP_48 ,
a1_ . CoffreAcle AS CoffreAcle_49 ,
a1_ . Autre AS Autre_50 ,
c2_ . IDClientAscoriste AS IDClientAscoriste_51 ,
c2_ . RefClient AS RefClient_52 ,
c2_ . NomClient AS NomClient_53 ,
c2_ . EstActif AS EstActif_54 ,
c2_ . AdresseClient AS AdresseClient_55 ,
c2_ . TelClient AS TelClient_56 ,
c2_ . Emailclient AS Emailclient_57 ,
c2_ . NomContactClient AS NomContactClient_58 ,
c2_ . LienSiteClient AS LienSiteClient_59 ,
c2_ . CodeComptable AS CodeComptable_60 ,
t3_ . IDTypeTravaux AS IDTypeTravaux_61 ,
t3_ . Libelle AS Libelle_62 ,
t3_ . ERentabilite AS ERentabilite_63 ,
d4_ . IDDetailsAppareilHorsContrat AS IDDetailsAppareilHorsContrat_64 ,
d4_ . adresse AS adresse_65 ,
d4_ . localisation AS localisation_66 ,
d5_ . IDDetailecheance AS IDDetailecheance_67 ,
d5_ . pourcentage AS pourcentage_68 ,
d5_ . Date AS Date_69 ,
d0_ . IDAscenseur AS IDAscenseur_70 ,
d0_ . IDTypeBordereaupu AS IDTypeBordereaupu_71 ,
d0_ . IDTypeTravaux AS IDTypeTravaux_72 ,
d0_ . IDFilechecksum AS IDFilechecksum_73 ,
a1_ . IDTypeVitessenominale AS IDTypeVitessenominale_74 ,
a1_ . IDFournisseur AS IDFournisseur_75 ,
a1_ . IDConstructeur AS IDConstructeur_76 ,
a1_ . IDTypeMarqueSerrure AS IDTypeMarqueSerrure_77 ,
a1_ . IDTypeSecteur AS IDTypeSecteur_78 ,
a1_ . IDMarquedemanoeuvre AS IDMarquedemanoeuvre_79 ,
a1_ . IDTypePortePaliere AS IDTypePortePaliere_80 ,
a1_ . IDTypeDeverrouillage AS IDTypeDeverrouillage_81 ,
a1_ . IDClientAscoriste AS IDClientAscoriste_82 ,
a1_ . IDTypeBatiment AS IDTypeBatiment_83 ,
a1_ . IDTypeOuverture AS IDTypeOuverture_84 ,
a1_ . IDTypeequipement AS IDTypeequipement_85 ,
a1_ . IDTypeDeplacement AS IDTypeDeplacement_86 ,
a1_ . IDTypeChargeencabine AS IDTypeChargeencabine_87 ,
a1_ . IDTypeService AS IDTypeService_88 ,
a1_ . IDTypeCategorieBatiment AS IDTypeCategorieBatiment_89 ,
a1_ . IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_90 ,
a1_ . IDAscensoriste AS IDAscensoriste_91 ,
a1_ . IDContrat AS IDContrat_92 ,
c2_ . IDUser AS IDUser_93 ,
c2_ . IDAscensoriste AS IDAscensoriste_94 ,
d4_ . IDDevistravauxparasc AS IDDevistravauxparasc_95 ,
d5_ . IDTypeEcheance AS IDTypeEcheance_96 ,
d5_ . IDDevistravauxparasc AS IDDevistravauxparasc_97
FROM
Devistravauxparasc d0_
LEFT JOIN Ascenseur a1_ ON d0_ . IDAscenseur = a1_ . IDAscenseur
LEFT JOIN ClientAscoriste c2_ ON a1_ . IDClientAscoriste = c2_ . IDClientAscoriste
LEFT JOIN typetravaux t3_ ON d0_ . IDTypeTravaux = t3_ . IDTypeTravaux
LEFT JOIN DetailsAppareilHorsContrat d4_ ON d0_ . IDDevistravauxparasc = d4_ . IDDevistravauxparasc
LEFT JOIN detailecheance d5_ ON d0_ . IDDevistravauxparasc = d5_ . IDDevistravauxparasc
WHERE
d0_ . IDAscenseur = ?
ORDER BY
d0_ . datedevis DESC Copy
SELECT DISTINCT d0_ . IDDevistravauxparasc AS IDDevistravauxparasc_0 , d0_ . datedevis AS datedevis_1 , d0_ . numero AS numero_2 , d0_ . numOS AS numOS_3 , d0_ . affairesuivipar AS affairesuivipar_4 , d0_ . Telpro AS Telpro_5 , d0_ . Mailpro AS Mailpro_6 , d0_ . tva AS tva_7 , d0_ . Validite AS Validite_8 , d0_ . ConditionPayment AS ConditionPayment_9 , d0_ . total AS total_10 , d0_ . totalTTC AS totalTTC_11 , d0_ . Estvalide AS Estvalide_12 , d0_ . parIA AS parIA_13 , d0_ . AppareilHorsContrat AS AppareilHorsContrat_14 , d0_ . devisFile AS devisFile_15 , d0_ . Texteaccopagnement AS Texteaccopagnement_16 , d0_ . FichierOs AS FichierOs_17 , d0_ . NoteInformation AS NoteInformation_18 , d0_ . datevalidation AS datevalidation_19 , d0_ . Status AS Status_20 , d0_ . DecisionToken AS DecisionToken_21 , d0_ . typeFacturation AS typeFacturation_22 , a1_ . IDAscenseur AS IDAscenseur_23 , a1_ . NumAppareilASC AS NumAppareilASC_24 , a1_ . residenceASC AS residenceASC_25 , a1_ . AdresseInstallationASC AS AdresseInstallationASC_26 , a1_ . MarquageCE AS MarquageCE_27 , a1_ . LocalisationASC AS LocalisationASC_28 , a1_ . ConstructeurASC AS ConstructeurASC_29 , a1_ . ChargeEnCabine AS ChargeEnCabine_30 , a1_ . NbrPersonne AS NbrPersonne_31 , a1_ . DeplacementASC AS DeplacementASC_32 , a1_ . AnneeConstructionASC AS AnneeConstructionASC_33 , a1_ . PrixContrat AS PrixContrat_34 , a1_ . AbonnementGsm AS AbonnementGsm_35 , a1_ . NbNiveauASC AS NbNiveauASC_36 , a1_ . PortePalCoupeFeuASC AS PortePalCoupeFeuASC_37 , a1_ . loichatel AS loichatel_38 , a1_ . GardienASC AS GardienASC_39 , a1_ . PositionSerrure AS PositionSerrure_40 , a1_ . NumAffaire AS NumAffaire_41 , a1_ . QRCodeASC AS QRCodeASC_42 , a1_ . QRCodeFile AS QRCodeFile_43 , a1_ . ContactSurSite AS ContactSurSite_44 , a1_ . NumeroContactSurSite AS NumeroContactSurSite_45 , a1_ . EmailContactSurSite AS EmailContactSurSite_46 , a1_ . IDVille AS IDVille_47 , a1_ . CP AS CP_48 , a1_ . CoffreAcle AS CoffreAcle_49 , a1_ . Autre AS Autre_50 , c2_ . IDClientAscoriste AS IDClientAscoriste_51 , c2_ . RefClient AS RefClient_52 , c2_ . NomClient AS NomClient_53 , c2_ . EstActif AS EstActif_54 , c2_ . AdresseClient AS AdresseClient_55 , c2_ . TelClient AS TelClient_56 , c2_ . Emailclient AS Emailclient_57 , c2_ . NomContactClient AS NomContactClient_58 , c2_ . LienSiteClient AS LienSiteClient_59 , c2_ . CodeComptable AS CodeComptable_60 , t3_ . IDTypeTravaux AS IDTypeTravaux_61 , t3_ . Libelle AS Libelle_62 , t3_ . ERentabilite AS ERentabilite_63 , d4_ . IDDetailsAppareilHorsContrat AS IDDetailsAppareilHorsContrat_64 , d4_ . adresse AS adresse_65 , d4_ . localisation AS localisation_66 , d5_ . IDDetailecheance AS IDDetailecheance_67 , d5_ . pourcentage AS pourcentage_68 , d5_ . Date AS Date_69 , d0_ . IDAscenseur AS IDAscenseur_70 , d0_ . IDTypeBordereaupu AS IDTypeBordereaupu_71 , d0_ . IDTypeTravaux AS IDTypeTravaux_72 , d0_ . IDFilechecksum AS IDFilechecksum_73 , a1_ . IDTypeVitessenominale AS IDTypeVitessenominale_74 , a1_ . IDFournisseur AS IDFournisseur_75 , a1_ . IDConstructeur AS IDConstructeur_76 , a1_ . IDTypeMarqueSerrure AS IDTypeMarqueSerrure_77 , a1_ . IDTypeSecteur AS IDTypeSecteur_78 , a1_ . IDMarquedemanoeuvre AS IDMarquedemanoeuvre_79 , a1_ . IDTypePortePaliere AS IDTypePortePaliere_80 , a1_ . IDTypeDeverrouillage AS IDTypeDeverrouillage_81 , a1_ . IDClientAscoriste AS IDClientAscoriste_82 , a1_ . IDTypeBatiment AS IDTypeBatiment_83 , a1_ . IDTypeOuverture AS IDTypeOuverture_84 , a1_ . IDTypeequipement AS IDTypeequipement_85 , a1_ . IDTypeDeplacement AS IDTypeDeplacement_86 , a1_ . IDTypeChargeencabine AS IDTypeChargeencabine_87 , a1_ . IDTypeService AS IDTypeService_88 , a1_ . IDTypeCategorieBatiment AS IDTypeCategorieBatiment_89 , a1_ . IDTypeLocalisationMachinerie AS IDTypeLocalisationMachinerie_90 , a1_ . IDAscensoriste AS IDAscensoriste_91 , a1_ . IDContrat AS IDContrat_92 , c2_ . IDUser AS IDUser_93 , c2_ . IDAscensoriste AS IDAscensoriste_94 , d4_ . IDDevistravauxparasc AS IDDevistravauxparasc_95 , d5_ . IDTypeEcheance AS IDTypeEcheance_96 , d5_ . IDDevistravauxparasc AS IDDevistravauxparasc_97 FROM Devistravauxparasc d0_ LEFT JOIN Ascenseur a1_ ON d0_ . IDAscenseur = a1_ . IDAscenseur LEFT JOIN ClientAscoriste c2_ ON a1_ . IDClientAscoriste = c2_ . IDClientAscoriste LEFT JOIN typetravaux t3_ ON d0_ . IDTypeTravaux = t3_ . IDTypeTravaux LEFT JOIN DetailsAppareilHorsContrat d4_ ON d0_ . IDDevistravauxparasc = d4_ . IDDevistravauxparasc LEFT JOIN detailecheance d5_ ON d0_ . IDDevistravauxparasc = d5_ . IDDevistravauxparasc WHERE d0_ . IDAscenseur = '49' ORDER BY d0_ . datedevis DESC ; Copy
49
0.25 ms
SELECT COUNT (* ) FROM Profil t0
SELECT COUNT (* ) FROM Profil t0 ; Copy
50
0.17 ms
SELECT COUNT (* ) FROM Ascensoriste t0
SELECT COUNT (* ) FROM Ascensoriste t0 ; Copy
51
0.20 ms
SELECT COUNT (* ) FROM ClientAscoriste t0
SELECT COUNT (* ) FROM ClientAscoriste t0 ; Copy
52
0.18 ms
SELECT COUNT (* ) FROM Ascenseur t0
SELECT COUNT (* ) FROM Ascenseur t0 ; Copy
53
0.12 ms
SELECT COUNT (* ) FROM Profil t0
SELECT COUNT (* ) FROM Profil t0 ; Copy
54
0.13 ms
SELECT COUNT (* ) FROM Ascensoriste t0
SELECT COUNT (* ) FROM Ascensoriste t0 ; Copy
55
0.17 ms
SELECT COUNT (* ) FROM ClientAscoriste t0 WHERE t0 . IDAscensoriste = ?
SELECT COUNT (* ) FROM ClientAscoriste t0 WHERE t0 . IDAscensoriste = 2 ; Copy
56
0.18 ms
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 ; Copy
57
0.29 ms
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 ; Copy
58
0.29 ms
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 = '32' AND t0 . Valide = 1 ; Copy
59
0.26 ms
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 = '33' AND t0 . Valide = 1 ; Copy
60
0.52 ms
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 = ? Copy
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 ; Copy
61
0.79 ms
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 ; Copy
62
0.28 ms
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 = '1' ; Copy
63
0.48 ms
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 = '6' ; Copy
64
0.38 ms
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' ; Copy
65
2.06 ms
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 = '17' ; Copy
66
5.91 ms
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 = '18' ; Copy
67
0.21 ms
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 = '19' ; Copy
68
0.20 ms
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 = '20' ; Copy
69
0.58 ms
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 ; Copy
70
0.26 ms
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 ; Copy
71
0.26 ms
SELECT COUNT (c0_ . IDCommande ) AS sclr_0 FROM Commande c0_ WHERE c0_ . IDAscensoriste = ? AND c0_ . Status NOT IN (? , ? )
Parameters :
[
2
"LIVREE "
"ANNULEE "
]
SELECT COUNT (c0_ . IDCommande ) AS sclr_0 FROM Commande c0_ WHERE c0_ . IDAscensoriste = 2 AND c0_ . Status NOT IN ('LIVREE' , 'ANNULEE' ); Copy
72
0.19 ms
SELECT COUNT (c0_ . IDCommande ) AS sclr_0 FROM Commande c0_ WHERE c0_ . IDAscensoriste = ? AND c0_ . Status NOT IN (? , ? , ? )
Parameters :
[
2
"VALIDEE "
"LIVREE "
"ANNULEE "
]
SELECT COUNT (c0_ . IDCommande ) AS sclr_0 FROM Commande c0_ WHERE c0_ . IDAscensoriste = 2 AND c0_ . Status NOT IN ('VALIDEE' , 'LIVREE' , 'ANNULEE' ); Copy
73
0.29 ms
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 ; Copy
74
0.58 ms
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 ; Copy
75
1.00 ms
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 = 50 ORDER BY t0 . DateVisite DESC ; Copy
76
2.50 ms
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 = 51 ORDER BY t0 . DateVisite DESC ; Copy
77
1.66 ms
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 = 52 ORDER BY t0 . DateVisite DESC ; Copy
78
2.62 ms
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 = 55 ORDER BY t0 . DateVisite DESC ; Copy
79
2.51 ms
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 = 56 ORDER BY t0 . DateVisite DESC ; Copy
80
1.25 ms
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 = 57 ORDER BY t0 . DateVisite DESC ; Copy
81
0.41 ms
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 = 58 ORDER BY t0 . DateVisite DESC ; Copy
82
0.40 ms
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 = 59 ORDER BY t0 . DateVisite DESC ; Copy
83
0.30 ms
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 = 60 ORDER BY t0 . DateVisite DESC ; Copy
84
0.36 ms
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 = 61 ORDER BY t0 . DateVisite DESC ; Copy
85
0.29 ms
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 = 62 ORDER BY t0 . DateVisite DESC ; Copy
86
0.37 ms
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 = 63 ORDER BY t0 . DateVisite DESC ; Copy
87
0.38 ms
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 = 64 ORDER BY t0 . DateVisite DESC ; Copy
88
0.31 ms
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 = 65 ORDER BY t0 . DateVisite DESC ; Copy
89
0.33 ms
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 = 66 ORDER BY t0 . DateVisite DESC ; Copy
90
0.40 ms
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 = 67 ORDER BY t0 . DateVisite DESC ; Copy
91
0.45 ms
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 = 68 ORDER BY t0 . DateVisite DESC ; Copy
92
3.27 ms
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 = 69 ORDER BY t0 . DateVisite DESC ; Copy
93
0.47 ms
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 = 70 ORDER BY t0 . DateVisite DESC ; Copy
94
0.42 ms
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 = 71 ORDER BY t0 . DateVisite DESC ; Copy
95
0.40 ms
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 = 72 ORDER BY t0 . DateVisite DESC ; Copy
96
0.41 ms
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 = 73 ORDER BY t0 . DateVisite DESC ; Copy
97
0.49 ms
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 = 74 ORDER BY t0 . DateVisite DESC ; Copy
98
10.64 ms
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 = 75 ORDER BY t0 . DateVisite DESC ; Copy
99
0.33 ms
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 = 76 ORDER BY t0 . DateVisite DESC ; Copy
100
0.31 ms
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 = 77 ORDER BY t0 . DateVisite DESC ; Copy
101
0.33 ms
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 = 78 ORDER BY t0 . DateVisite DESC ; Copy
102
0.29 ms
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 = 79 ORDER BY t0 . DateVisite DESC ; Copy
103
0.31 ms
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 = 80 ORDER BY t0 . DateVisite DESC ; Copy
104
2.57 ms
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 = 81 ORDER BY t0 . DateVisite DESC ; Copy
105
0.43 ms
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 = 82 ORDER BY t0 . DateVisite DESC ; Copy
106
0.36 ms
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 = 83 ORDER BY t0 . DateVisite DESC ; Copy
107
0.42 ms
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 = 84 ORDER BY t0 . DateVisite DESC ; Copy
108
0.40 ms
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 = 85 ORDER BY t0 . DateVisite DESC ; Copy
109
0.41 ms
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 = 86 ORDER BY t0 . DateVisite DESC ; Copy
110
0.34 ms
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 = 87 ORDER BY t0 . DateVisite DESC ; Copy
111
0.40 ms
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 = 88 ORDER BY t0 . DateVisite DESC ; Copy
112
0.39 ms
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 = 89 ORDER BY t0 . DateVisite DESC ; Copy
113
0.32 ms
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 = 90 ORDER BY t0 . DateVisite DESC ; Copy
114
0.31 ms
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 = 91 ORDER BY t0 . DateVisite DESC ; Copy