Symfony Profiler

[
  "route" => "_api_/commandes_get_collection"
  "route_parameters" => [
    "_route" => "_api_/commandes_get_collection"
    "_controller" => "api_platform.action.placeholder"
    "_stateless" => null
    "_api_resource_class" => "App\Entity\Commande"
    "_api_operation_name" => "_api_/commandes_get_collection"
    "_format" => null
  ]
  "request_uri" => "https://remy.bestt.fr/api/commandes?etat=EV&idBestt=0"
  "method" => "GET"
]

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

[
  "firewall_name" => "api"
  "authenticator" => "App\Security\JWTAuthenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\JsonLoginAuthenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\JsonLoginAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "remy"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "remy"
    "serverVersion" => "mariadb-10.11.7"
    "charset" => "UTF8"
  ]
]

[
  "sql" => "SELECT t0.id_user AS id_user_1, t0.user_name AS user_name_2, t0.mail AS mail_3, t0.roles AS roles_4, t0.password AS password_5, t0.actif AS actif_6, t0.date_creation AS date_creation_7, t0.date_desactivation AS date_desactivation_8, t0.photo_profil AS photo_profil_9, t0.reset_token AS reset_token_10, t0.actif_token AS actif_token_11, t0.recent AS recent_12, t0.last_login AS last_login_13, t0.nombre_connexions AS nombre_connexions_14, t0.modified_push_subscription AS modified_push_subscription_15, t0.is_allowed_to_switch AS is_allowed_to_switch_16, t0.cree_dans_bestt AS cree_dans_bestt_17, t0.id_salarie AS id_salarie_18, t0.id_permanent AS id_permanent_19, t0.id_contact AS id_contact_20 FROM user t0 WHERE t0.user_name = ? LIMIT 1"
  "params" => [
    1 => "1234-8572afc2c42a4019bd4826e8383bb635"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1096
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id_agence AS id_agence_1, t0.mail AS mail_2, t0.telephone AS telephone_3, t0.adresse_1 AS adresse_1_4, t0.adresse_2 AS adresse_2_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.img_logo AS img_logo_8, t0.site_web AS site_web_9, t0.siret AS siret_10, t0.date_creation AS date_creation_11, t0.raison_sociale AS raison_sociale_12, t0.uuid AS uuid_13, t0.password AS password_14, t0.stylesheet AS stylesheet_15, t0.gestion_reglement AS gestion_reglement_16, t0.traitement_journalier AS traitement_journalier_17, t0.traitement_horaire AS traitement_horaire_18, t0.url_bestt_net AS url_bestt_net_19, t0.message_client AS message_client_20, t0.message_salarie AS message_salarie_21, t0.b_acomptes AS b_acomptes_22, t0.b_paies AS b_paies_23, t0.b_contrats_salarie AS b_contrats_salarie_24, t0.b_contrats_client AS b_contrats_client_25, t0.b_factures AS b_factures_26, t0.b_rh_client AS b_rh_client_27, t0.b_rh_salarie AS b_rh_salarie_28, t0.b_sl_docs AS b_sl_docs_29, t0.b_cl_docs AS b_cl_docs_30, t0.b_dpae AS b_dpae_31, t0.msa AS msa_32, t0.mail_client_releves AS mail_client_releves_33, t0.b_commande_salaire AS b_commande_salaire_34, t0.b_planning_client AS b_planning_client_35, t0.b_etat_facture_client AS b_etat_facture_client_36, t0.b_offres_salaries AS b_offres_salaries_37, t0.id_groupe AS id_groupe_38, t0.mail_agence_id AS mail_agence_id_39 FROM agence t0 WHERE t0.uuid = ? LIMIT 1"
  "params" => [
    1 => "1234-8572afc2c42a4019bd4826e8383bb635"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1096
      +name: "STRING"
    }
  ]
]

[
  "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\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" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#1275
    -user: App\Entity\Agence {#1279 …}
    -roleNames: [
      "ROLE_AGENCE"
    ]
    -attributes: []
    -firewallName: "api"
  }
  "authenticator" => "App\Security\JWTAuthenticator"
]

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

[
  "authenticator" => "App\Security\JWTAuthenticator"
]

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

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

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelRequest"
]

[
  "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\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::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" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "App\Listener\RememberMeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

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

[
  "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" => "Container1cDI1WF\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

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

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

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

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

[
  "sql" => "SELECT c0_.id_commande AS id_commande_0, c0_.salaire_horaire_brut AS salaire_horaire_brut_1, c0_.duree_hebdo AS duree_hebdo_2, c0_.statut_cadre AS statut_cadre_3, c0_.date_debut AS date_debut_4, c0_.date_fin AS date_fin_5, c0_.quantite AS quantite_6, c0_.etat AS etat_7, c0_.adresse_1 AS adresse_1_8, c0_.adresse_2 AS adresse_2_9, c0_.ville AS ville_10, c0_.code_postal AS code_postal_11, c0_.adresse_client AS adresse_client_12, c0_.justification AS justification_13, c0_.remplacement_nom AS remplacement_nom_14, c0_.remplacement_prenom AS remplacement_prenom_15, c0_.date_heure_creation AS date_heure_creation_16, c0_.date_heure_modification AS date_heure_modification_17, c0_.date_heure_annulation AS date_heure_annulation_18, c0_.qualification AS qualification_19, c0_.id_bestt AS id_bestt_20, c0_.titre AS titre_21, c0_.commentaire AS commentaire_22, c0_.import AS import_23, c0_.nombre_documents AS nombre_documents_24, c0_.salaries AS salaries_25, c0_.commande_planning AS commande_planning_26, c0_.confirmation_client AS confirmation_client_27, c0_.demande_profils_agence AS demande_profils_agence_28, c0_.traite AS traite_29, c0_.horaire_travail AS horaire_travail_30, c0_.id_contact AS id_contact_31, c0_.id_client AS id_client_32, c0_.id_agence AS id_agence_33, c0_.id_motif_recours AS id_motif_recours_34, c0_.id_lieu_mission AS id_lieu_mission_35, c0_.id_permanent AS id_permanent_36 FROM commande c0_ WHERE c0_.id_agence = ? AND c0_.id_bestt = ? AND c0_.etat = ? ORDER BY c0_.id_commande ASC LIMIT 30"
  "params" => [
    1 => 10
    2 => "0"
    3 => "EV"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1096
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1096}
  ]
]

[
  "sql" => "SELECT t0.id_contact AS id_contact_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.sexe AS sexe_4, t0.telephone_1 AS telephone_1_5, t0.telephone_2 AS telephone_2_6, t0.mail AS mail_7, t0.nouvelle_entree AS nouvelle_entree_8, t0.edited AS edited_9, t0.nouvelle_photo AS nouvelle_photo_10, t0.id_client AS id_client_11, t12.id_user AS id_user_13, t12.user_name AS user_name_14, t12.mail AS mail_15, t12.roles AS roles_16, t12.password AS password_17, t12.actif AS actif_18, t12.date_creation AS date_creation_19, t12.date_desactivation AS date_desactivation_20, t12.photo_profil AS photo_profil_21, t12.reset_token AS reset_token_22, t12.actif_token AS actif_token_23, t12.recent AS recent_24, t12.last_login AS last_login_25, t12.nombre_connexions AS nombre_connexions_26, t12.modified_push_subscription AS modified_push_subscription_27, t12.is_allowed_to_switch AS is_allowed_to_switch_28, t12.cree_dans_bestt AS cree_dans_bestt_29, t12.id_salarie AS id_salarie_30, t12.id_permanent AS id_permanent_31, t12.id_contact AS id_contact_32 FROM contact t0 LEFT JOIN user t12 ON t12.id_contact = t0.id_contact WHERE t0.id_contact = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_motif_recours AS id_motif_recours_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM motif_recours t0 WHERE t0.id_motif_recours = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_creation AS date_creation_3, t0.doc_path AS doc_path_4, t0.id_agence AS id_agence_5, t0.id_client AS id_client_6, t0.id_commande AS id_commande_7 FROM document t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_document_demande AS id_document_demande_1, t0.type AS type_2, t0.etat AS etat_3, t0.numero_bestt AS numero_bestt_4, t0.date_heure_creation AS date_heure_creation_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.id_bestt_salarie AS id_bestt_salarie_8, t0.id_bestt_client AS id_bestt_client_9, t0.id_bestt_permanent AS id_bestt_permanent_10, t0.id_client AS id_client_11, t0.id_contact AS id_contact_12, t0.id_salarie AS id_salarie_13, t0.id_agence AS id_agence_14, t0.id_permanent AS id_permanent_15, t0.id_commande AS id_commande_16 FROM document_demande t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_client AS id_client_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.adresse_1 AS adresse_1_4, t0.adresse_2 AS adresse_2_5, t0.code_postal AS code_postal_6, t0.telephone_1 AS telephone_1_7, t0.mail AS mail_8, t0.ville AS ville_9, t0.duree_hebdo AS duree_hebdo_10 FROM client t0 WHERE t0.id_client = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_agence_client AS id_agence_client_1, t0.id_bestt AS id_bestt_2, t0.is_be_sign AS is_be_sign_3, t0.actif AS actif_4, t0.id_client AS id_client_5, t0.id_agence AS id_agence_6 FROM agence_client t0 WHERE t0.id_client = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_creation AS date_creation_3, t0.doc_path AS doc_path_4, t0.id_agence AS id_agence_5, t0.id_client AS id_client_6, t0.id_commande AS id_commande_7 FROM document t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_document_demande AS id_document_demande_1, t0.type AS type_2, t0.etat AS etat_3, t0.numero_bestt AS numero_bestt_4, t0.date_heure_creation AS date_heure_creation_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.id_bestt_salarie AS id_bestt_salarie_8, t0.id_bestt_client AS id_bestt_client_9, t0.id_bestt_permanent AS id_bestt_permanent_10, t0.id_client AS id_client_11, t0.id_contact AS id_contact_12, t0.id_salarie AS id_salarie_13, t0.id_agence AS id_agence_14, t0.id_permanent AS id_permanent_15, t0.id_commande AS id_commande_16 FROM document_demande t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_client AS id_client_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.adresse_1 AS adresse_1_4, t0.adresse_2 AS adresse_2_5, t0.code_postal AS code_postal_6, t0.telephone_1 AS telephone_1_7, t0.mail AS mail_8, t0.ville AS ville_9, t0.duree_hebdo AS duree_hebdo_10 FROM client t0 WHERE t0.id_client = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_agence_client AS id_agence_client_1, t0.id_bestt AS id_bestt_2, t0.is_be_sign AS is_be_sign_3, t0.actif AS actif_4, t0.id_client AS id_client_5, t0.id_agence AS id_agence_6 FROM agence_client t0 WHERE t0.id_client = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_motif_recours AS id_motif_recours_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM motif_recours t0 WHERE t0.id_motif_recours = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_creation AS date_creation_3, t0.doc_path AS doc_path_4, t0.id_agence AS id_agence_5, t0.id_client AS id_client_6, t0.id_commande AS id_commande_7 FROM document t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_document_demande AS id_document_demande_1, t0.type AS type_2, t0.etat AS etat_3, t0.numero_bestt AS numero_bestt_4, t0.date_heure_creation AS date_heure_creation_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.id_bestt_salarie AS id_bestt_salarie_8, t0.id_bestt_client AS id_bestt_client_9, t0.id_bestt_permanent AS id_bestt_permanent_10, t0.id_client AS id_client_11, t0.id_contact AS id_contact_12, t0.id_salarie AS id_salarie_13, t0.id_agence AS id_agence_14, t0.id_permanent AS id_permanent_15, t0.id_commande AS id_commande_16 FROM document_demande t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_creation AS date_creation_3, t0.doc_path AS doc_path_4, t0.id_agence AS id_agence_5, t0.id_client AS id_client_6, t0.id_commande AS id_commande_7 FROM document t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id_document_demande AS id_document_demande_1, t0.type AS type_2, t0.etat AS etat_3, t0.numero_bestt AS numero_bestt_4, t0.date_heure_creation AS date_heure_creation_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.id_bestt_salarie AS id_bestt_salarie_8, t0.id_bestt_client AS id_bestt_client_9, t0.id_bestt_permanent AS id_bestt_permanent_10, t0.id_client AS id_client_11, t0.id_contact AS id_contact_12, t0.id_salarie AS id_salarie_13, t0.id_agence AS id_agence_14, t0.id_permanent AS id_permanent_15, t0.id_commande AS id_commande_16 FROM document_demande t0 WHERE t0.id_commande = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1087
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\ValidateListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "App\EventSubscriber\SetAgenceEventSubscriber::addAgence"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\WriteListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "App\EventSubscriber\ApiResponseEventSubscriber::sendResponse"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\SerializeListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "Symfony\Bridge\Twig\EventListener\TemplateAttributeListener::onKernelView"
]

[
  "sql" => "INSERT INTO log_api (agence, url, method, http_code, data, resultat, date_reception) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 10
    2 => "https://remy.bestt.fr/api/commandes?etat=EV&idBestt=0"
    3 => "GET"
    4 => 200
    5 => ""
    6 => "[{"id":"1","dureeHebdo":"39.00","statutCadre":1,"dateDebut":"2025-07-31T00:00:00+00:00","dateFin":"2025-08-31T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"2 RUE ROBERT KELLER","adresse2":"","ville":"PONT-SAINTE-MARIE","codePostal":"10150","adresseClient":true,"justification":"Va \u00e0 la plage","remplacementNom":"Poljack","remplacementPrenom":"Pierre","dateHeureCreation":"2025-06-24T13:52:05+00:00","qualification":"DIRECTEUR GENERAL","idBestt":0,"contact":{"id":1,"client":"\/api\/clients\/1"},"titre":"DIRECTEUR GENERAL","motif":{"id":2,"code":"01","libelle":"Remplacement d'un salari\u00e9"},"import":false,"documents":[],"documentDemandes":[],"nombreDocuments":0,"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"horaireTravail":[]},{"id":"2","statutCadre":0,"dateDebut":"2025-07-15T00:00:00+00:00","dateFin":"2025-08-04T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"rue emile zola","adresse2":"","ville":"Amiens","codePostal":"80000","adresseClient":true,"remplacementNom":"Legrand","remplacementPrenom":"Remy","dateHeureCreation":"2025-07-07T08:04:01+00:00","qualification":"DeveloppeurWeb","idBestt":0,"contact":{"id":1,"client":"\/api\/clients\/1"},"client":{"id":2,"agenceClients":[[]]},"titre":"DeveloppeurWeb(saisie par l'agence)","motif":{"id":2,"code":"01","libelle":"Remplacement d'un salari\u00e9"},"import":false,"documents":[],"documentDemandes":[],"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"permanent":"\/api\/permanents\/1","horaireTravail":{"lu":[],"ma":[],"me":[],"je":[],"ve":[],"sa":[],"di":[]}},{"id":"4","statutCadre":0,"dateDebut":"2025-11-26T00:00:00+00:00","dateFin":"2025-11-28T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"2 RUE ROBERT KELLER","adresse2":"","ville":"PONT-SAINTE-MARIE","codePostal":"10150","adresseClient":true,"dateHeureCreation":"2025-11-24T11:32:45+00:00","qualification":"magasinier","idBestt":0,"client":{"id":1,"agenceClients":[{"idBestt":194217733930356951}]},"titre":"magasinier(saisie par l'agence)","motif":{"id":1,"code":"02","libelle":"Accroissement temporaire"},"import":false,"documents":[],"documentDemandes":[],"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"permanent":"\/api\/permanents\/1","horaireTravail":{"lu":[],"ma":[],"me":[],"je":[],"ve":[],"sa":[],"di":[]}},{"id":"5","statutCadre":0,"dateDebut":"2026-01-26T00:00:00+00:00","dateFin":"2026-04-27T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"rue emile zola","adresse2":"","ville":"Amiens","codePostal":"80000","adresseClient":true,"dateHeureCreation":"2026-01-19T11:05:21+00:00","qualification":"Designer Web","idBestt":0,"client":{"id":2,"agenceClients":[[]]},"titre":"Designer Web(saisie par l'agence)","motif":{"id":1,"code":"02","libelle":"Accroissement temporaire"},"import":false,"documents":[],"documentDemandes":[],"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"permanent":"\/api\/permanents\/1","horaireTravail":{"lu":[{"de":"09:00","a":"18:00"}],"ma":[{"de":"09:00","a":"18:00"}],"me":[{"de":"09:00","a":"18:00"}],"je":[{"de":"09:00","a":"18:00"}],"ve":[{"de":"09:00","a":"18:00"}],"sa":[],"di":[]}}]"
    7 => "2026-02-19 15:33:03"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1096
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1096}
    3 => Doctrine\DBAL\ParameterType {#1096}
    4 => Doctrine\DBAL\ParameterType {#1096}
    5 => Doctrine\DBAL\ParameterType {#1096}
    6 => Doctrine\DBAL\ParameterType {#1096}
    7 => Doctrine\DBAL\ParameterType {#1096}
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentTypeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ReferrerPolicyListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventSubscriber\ApiResponseEventSubscriber::logApi"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ClickjackingListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

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

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

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

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