Symfony Profiler

[
  "route" => "_api_/ascenseurs/carnets/dashboard_get"
  "route_parameters" => [
    "_route" => "_api_/ascenseurs/carnets/dashboard_get"
    "_controller" => "App\Controller\Api\Dashboard\GetDashboardController"
    "_stateless" => false
    "_api_resource_class" => "App\Entity\Carnetmaintenance"
    "_api_operation_name" => "_api_/ascenseurs/carnets/dashboard_get"
    "_format" => null
  ]
  "request_uri" => "https://arcadeapp.fr/api/ascenseurs/carnets/dashboard?idascensoriste=2"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u693649296_adminarcade"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u693649296_adminarcade"
    "serverVersion" => "mariadb-10.4.27"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.EstActive AS EstActive_5, t0.NomPrenom AS NomPrenom_6, t0.Tel AS Tel_7, t0.Adresse AS Adresse_8, t0.Pays AS Pays_9, t0.IDVille AS IDVille_10, t0.isAdmin AS isAdmin_11, t0.IDProfil AS IDProfil_12, t0.IDAscensoriste AS IDAscensoriste_13 FROM user t0 WHERE t0.username = ? LIMIT 1"
  "params" => [
    1 => "adminarcade@yopmail.com"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#7366
    -user: App\Entity\User {#7241 …}
    -roleNames: [
      "ROLE_SUPER_ADMIN"
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NjAwOTA1NDUsImV4cCI6MTc2MDE3Njk0NSwicm9sZXMiOlsiUk9MRV9TVVBFUl9BRE1JTiIsIlJPTEVfVVNFUiJdLCJ1c2VybmFtZSI6ImFkbWluYXJjYWRlQHlvcG1haWwuY29tIn0.dJQeLmA18_T1oN7JW8J4Sov76y8hurWPOVRekGHdL17nfKKUWYhIbTP-cpIWqJZ-q9sGN-qjelBQVvo3ONb4g91nfB4xHMtPbwJE9P9oFAWLTW188uau2urLD6IzSOUiGHtQNit8KOQzxHbPqn_IS9P9DLN7_L4gNjhCgLUTa9OsNZGVVvUox2mt42v0a_Cu7p4BTlTZKOMzedaVnLyv9pl9VdgDVQaGGJFYa0KEo9zwd08D1_NT8M71WzSwCbW5XeqdY_MKKOyBAdJSQSTT552OPK9Sf_afqDtR2hW6jmmYw1k6YhvCyLRUnaBRbdBfcopKP4T1Ll0KjTk4he3uAw"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Inspector\Symfony\Bundle\Listeners\KernelEventsSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Inspector\Symfony\Bundle\Listeners\KernelEventsSubscriber::setAuthUserInfo"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\ClearSearchParamsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\ParametrageSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Inspector\Symfony\Bundle\Listeners\KernelEventsSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventListener\AppRequestListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventListener\TableVideListner::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Inspector\Symfony\Bundle\Listeners\KernelEventsSubscriber::onKernelPreControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerAMrGUM4\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Inspector\Symfony\Bundle\Listeners\KernelEventsSubscriber::onKernelPostControllerArguments"
]

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

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

[
  "sql" => "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 = ?"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 58
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 63
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 65
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 66
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 67
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 68
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 69
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 70
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 72
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 73
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 74
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 75
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 76
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 77
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 78
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 79
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 80
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 81
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 82
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 83
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 84
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 85
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 86
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 87
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 88
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 89
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 90
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 91
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 2
  ]
]

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

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 541
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 540
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 469
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 341
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 339
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 300
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 299
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParPanne AS IDPieceParPanne_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDSignalerPanne AS IDSignalerPanne_9 FROM pieceparpanne t0 WHERE t0.IDSignalerPanne = ?"
  "params" => [
    1 => 323
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParPanne AS IDPieceParPanne_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDSignalerPanne AS IDSignalerPanne_9 FROM pieceparpanne t0 WHERE t0.IDSignalerPanne = ?"
  "params" => [
    1 => 196
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParPanne AS IDPieceParPanne_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDSignalerPanne AS IDSignalerPanne_9 FROM pieceparpanne t0 WHERE t0.IDSignalerPanne = ?"
  "params" => [
    1 => 241
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParPanne AS IDPieceParPanne_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDSignalerPanne AS IDSignalerPanne_9 FROM pieceparpanne t0 WHERE t0.IDSignalerPanne = ?"
  "params" => [
    1 => 194
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParPanne AS IDPieceParPanne_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDSignalerPanne AS IDSignalerPanne_9 FROM pieceparpanne t0 WHERE t0.IDSignalerPanne = ?"
  "params" => [
    1 => 175
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.IDCarnetMaintenance AS IDCarnetMaintenance_1, t0.DateVisite AS DateVisite_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureDepart AS HeureDepart_4, t0.DateProchainVisite AS DateProchainVisite_5, t0.DateDerniereVisite AS DateDerniereVisite_6, t0.EtatAjour AS EtatAjour_7, t0.IDTypeVisite AS IDTypeVisite_8, t0.IDTypeStatutASC AS IDTypeStatutASC_9, t0.NotifEnvoye AS NotifEnvoye_10, t0.IDAscenseur AS IDAscenseur_11, t0.IDTechnicien AS IDTechnicien_12, t0.IDDetailEntretien AS IDDetailEntretien_13, t0.IDEssaisPhonie AS IDEssaisPhonie_14, t0.IDPVCableTraction AS IDPVCableTraction_15, t0.IDDetailsPVParachute AS IDDetailsPVParachute_16, t0.IDDetailtravaux AS IDDetailtravaux_17, t0.IDRapportBureaucontrole AS IDRapportBureaucontrole_18, t0.IDSignalerPanne AS IDSignalerPanne_19, t0.IDEtudeSecurite AS IDEtudeSecurite_20, t0.IDHistoriqueMarcheASC AS IDHistoriqueMarcheASC_21, t0.IDFicheRemiseService AS IDFicheRemiseService_22 FROM CarnetMaintenance t0 WHERE t0.IDAscenseur = ? ORDER BY t0.DateVisite DESC"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 2
  ]
]

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

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 544
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 468
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 342
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 307
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 306
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.IDPieceParEntretien AS IDPieceParEntretien_1, t0.DatePiece AS DatePiece_2, t0.DateRemplacement AS DateRemplacement_3, t0.Devis AS Devis_4, t0.EntreDansCadreContrat AS EntreDansCadreContrat_5, t0.photo AS photo_6, t0.PieceRemplace AS PieceRemplace_7, t0.IDPieceAscenseur AS IDPieceAscenseur_8, t0.IDDetailEntretien AS IDDetailEntretien_9 FROM pieceparentretien t0 WHERE t0.IDDetailEntretien = ?"
  "params" => [
    1 => 305
  ]
  "types" => [
    1 => 2
  ]
]

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