Symfony Profiler

[
  "route" => "app_formateur_polyvalent_offres_en_attente"
  "route_parameters" => [
    "_route" => "app_formateur_polyvalent_offres_en_attente"
    "_controller" => "App\Controller\User\FormateurPolyvalentController::offresEnAttente"
  ]
  "request_uri" => "https://remplacement.bxl.lire-et-ecrire.be/formateur-polyvalent/offres-en-attente"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "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" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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" => "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" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\RememberMeToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "1a09nw.myd.infomaniak.com"
    "port" => null
    "user" => "1a09nw_bxlleerem"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "1a09nw_bxl_lee_remplac"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "faddoul.elghazi@lire-et-ecrire.be"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

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

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

[
  "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" => "ContainerYhCI34b\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_archived AS is_archived_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.genre_id AS genre_id_7, t0.fonction_id AS fonction_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t11.id AS id_12, t11.email AS email_13, t11.gsm AS gsm_14, t11.roles AS roles_15, t11.password AS password_16, t11.heures_decimal AS heures_decimal_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.is_active AS is_active_20, t11.personnel_id AS personnel_id_21 FROM personnel t0 LEFT JOIN user t11 ON t11.personnel_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM fonction t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0 FROM offre o0_ LEFT JOIN postuler_offre p1_ ON o0_.id = p1_.offre_id AND (p1_.is_annuler = 0 OR p1_.is_annuler IS NULL) WHERE ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) AND o0_.date >= ? AND (o0_.date BETWEEN ? AND ?) AND p1_.id IS NULL ORDER BY o0_.date ASC, o0_.heure_debut ASC LIMIT 20"
  "params" => [
    1 => "2026-04-12 00:00:00"
    2 => "2025-09-01"
    3 => "2026-08-31"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ LEFT JOIN postuler_offre p1_ ON o0_.id = p1_.offre_id AND (p1_.is_annuler = 0 OR p1_.is_annuler IS NULL) WHERE ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) AND o0_.date >= ? AND (o0_.date BETWEEN ? AND ?) AND p1_.id IS NULL"
  "params" => [
    1 => "2026-04-12 00:00:00"
    2 => "2025-09-01"
    3 => "2026-08-31"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.heure_debut AS heure_debut_2, o0_.heure_fin AS heure_fin_3, o0_.is_annuler AS is_annuler_4, o0_.motifs_annuler AS motifs_annuler_5, o0_.commentaire AS commentaire_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.reference_groupe AS reference_groupe_9, o0_.id_groupe AS id_groupe_10, o0_.niveau AS niveau_11, c1_.id AS id_12, c1_.label AS label_13, c1_.created_at AS created_at_14, c1_.updated_at AS updated_at_15, c1_.is_active AS is_active_16, p2_.id AS id_17, p2_.first_name AS first_name_18, p2_.last_name AS last_name_19, p2_.is_archived AS is_archived_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, l3_.id AS id_23, l3_.label AS label_24, l3_.siege_address AS siege_address_25, l3_.cours_address AS cours_address_26, l3_.contact AS contact_27, l3_.is_lee AS is_lee_28, l3_.created_at AS created_at_29, l3_.updated_at AS updated_at_30, m4_.id AS id_31, m4_.label AS label_32, m4_.created_at AS created_at_33, m4_.updated_at AS updated_at_34, p5_.id AS id_35, p5_.commentaire AS commentaire_36, p5_.is_annuler AS is_annuler_37, p5_.raison_annulation AS raison_annulation_38, p5_.created_at AS created_at_39, p5_.updated_at AS updated_at_40, p6_.id AS id_41, p6_.first_name AS first_name_42, p6_.last_name AS last_name_43, p6_.is_archived AS is_archived_44, p6_.created_at AS created_at_45, p6_.updated_at AS updated_at_46, o0_.created_by_id AS created_by_id_47, o0_.updated_by_id AS updated_by_id_48, o0_.centre_alpha_id AS centre_alpha_id_49, o0_.formateur_titulaire_id AS formateur_titulaire_id_50, o0_.lieu_id AS lieu_id_51, o0_.motif_remplacement_id AS motif_remplacement_id_52, c1_.created_by_id AS created_by_id_53, c1_.updated_by_id AS updated_by_id_54, p2_.genre_id AS genre_id_55, p2_.fonction_id AS fonction_id_56, p2_.created_by_id AS created_by_id_57, p2_.updated_by_id AS updated_by_id_58, l3_.created_by_id AS created_by_id_59, l3_.updated_by_id AS updated_by_id_60, m4_.created_by_id AS created_by_id_61, m4_.updated_by_id AS updated_by_id_62, p5_.offre_id AS offre_id_63, p5_.formateur_polyvalent_id AS formateur_polyvalent_id_64, p5_.created_by_id AS created_by_id_65, p5_.updated_by_id AS updated_by_id_66, p6_.genre_id AS genre_id_67, p6_.fonction_id AS fonction_id_68, p6_.created_by_id AS created_by_id_69, p6_.updated_by_id AS updated_by_id_70 FROM offre o0_ LEFT JOIN centre_alpha c1_ ON o0_.centre_alpha_id = c1_.id LEFT JOIN personnel p2_ ON o0_.formateur_titulaire_id = p2_.id LEFT JOIN lieu_formation l3_ ON o0_.lieu_id = l3_.id LEFT JOIN motif_absence m4_ ON o0_.motif_remplacement_id = m4_.id LEFT JOIN postuler_offre p5_ ON o0_.id = p5_.offre_id LEFT JOIN personnel p6_ ON p5_.formateur_polyvalent_id = p6_.id WHERE o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.date ASC, o0_.heure_debut ASC"
  "params" => [
    1 => 325
    2 => 326
    3 => 295
    4 => 296
    5 => 297
    6 => 301
    7 => 298
    8 => 154
    9 => 302
    10 => 299
    11 => 303
    12 => 300
    13 => 304
    14 => 117
    15 => 153
    16 => 305
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?"
  "params" => [
    1 => 33
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?"
  "params" => [
    1 => 31
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.gsm AS gsm_3, t0.roles AS roles_4, t0.password AS password_5, t0.heures_decimal AS heures_decimal_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.personnel_id AS personnel_id_10 FROM user t0 WHERE t0.personnel_id = ?"
  "params" => [
    1 => 73
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT o0_.niveau AS niveau_0 FROM offre o0_ LEFT JOIN postuler_offre p1_ ON o0_.id = p1_.offre_id AND (p1_.is_annuler = 0 OR p1_.is_annuler IS NULL) WHERE ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) AND o0_.date >= ? AND (o0_.date BETWEEN ? AND ?) AND p1_.id IS NULL AND o0_.niveau IS NOT NULL AND o0_.niveau <> '' ORDER BY o0_.niveau ASC"
  "params" => [
    1 => "2026-04-12 00:00:00"
    2 => "2025-09-01"
    3 => "2026-08-31"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2 FROM offre o1_ INNER JOIN personnel p0_ ON o1_.formateur_titulaire_id = p0_.id LEFT JOIN postuler_offre p2_ ON o1_.id = p2_.offre_id AND (p2_.is_annuler = 0 OR p2_.is_annuler IS NULL) WHERE ((o1_.is_annuler IS NULL OR o1_.is_annuler = 0)) AND o1_.date >= ? AND (o1_.date BETWEEN ? AND ?) AND p2_.id IS NULL ORDER BY p0_.last_name ASC, p0_.first_name ASC"
  "params" => [
    1 => "2026-04-12 00:00:00"
    2 => "2025-09-01"
    3 => "2026-08-31"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT o0_.id_groupe AS id_groupe_0 FROM offre o0_ LEFT JOIN postuler_offre p1_ ON o0_.id = p1_.offre_id AND (p1_.is_annuler = 0 OR p1_.is_annuler IS NULL) WHERE ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) AND o0_.date >= ? AND (o0_.date BETWEEN ? AND ?) AND p1_.id IS NULL ORDER BY o0_.id_groupe ASC"
  "params" => [
    1 => "2026-04-12 00:00:00"
    2 => "2025-09-01"
    3 => "2026-08-31"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_coordo AS is_coordo_2, t0.user_id AS user_id_3, t0.centre_id AS centre_id_4 FROM user_centre_autorisation t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

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

[
  "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" => "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"
]