Symfony Profiler

[
  "route" => "app_presence_index"
  "route_parameters" => [
    "_route" => "app_presence_index"
    "_controller" => "App\Controller\PresenceController::index"
  ]
  "request_uri" => "http://gpi.datm.tech/presence/"
  "method" => "GET"
]

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

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "db"
    "port" => 5432
    "user" => "gpinformatique"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "gpinformatique"
    "serverVersion" => "15"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.device_id AS device_id_7, t0.enable_device_check AS enable_device_check_8, t9.id AS id_10, t9.matricule AS matricule_11, t9.nom AS nom_12, t9.prenom AS prenom_13, t9.tel AS tel_14, t9.create_at AS create_at_15, t9.update_at AS update_at_16, t9.salaire AS salaire_17, t9.salaire_restant AS salaire_restant_18, t9.agence_id AS agence_id_19, t9.user_id AS user_id_20, t0.role_id AS role_id_21, t0.role_profile_id AS role_profile_id_22 FROM "user" t0 LEFT JOIN employe t9 ON t9.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "joketog@yahoo.fr"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::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"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.logo AS logo_2, t0.address AS address_3, t0.phone1 AS phone1_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.email AS email_7, t0.domain_name AS domain_name_8, t0.penalite AS penalite_9 FROM gpi t0 ORDER BY t0.created_at DESC LIMIT 1"
]

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

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

[
  "sql" => "SELECT m0_.id AS id_0, m0_.debut AS debut_1, m0_.fin AS fin_2, m0_.created_at AS created_at_3, m0_.updated_at AS updated_at_4, m0_.valide AS valide_5, m0_.user_id AS user_id_6, m0_.agence_id AS agence_id_7 FROM mission m0_ WHERE (m0_.debut <= ? OR m0_.fin >= ?) AND m0_.user_id = ? ORDER BY m0_.created_at DESC LIMIT 1"
  "params" => [
    1 => "2026-06-15"
    2 => "2026-06-15"
    3 => 11
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.ip_adresse AS ip_adresse_2, p0_.penalite AS penalite_3, p0_.saved_at AS saved_at_4, p0_.est_present AS est_present_5, p0_.motif_retard AS motif_retard_6, p0_.checkout_at AS checkout_at_7, p0_.salaire_restant AS salaire_restant_8, p0_.agent_id AS agent_id_9, p0_.agence_id AS agence_id_10 FROM presence p0_ WHERE p0_.created_at >= ? AND p0_.created_at <= ? AND p0_.agent_id = 11 AND p0_.est_present = 'o' ORDER BY p0_.created_at DESC"
  "params" => [
    1 => "2026-06-15 00:00:00"
    2 => "2026-06-15 23:59:59"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.departement AS departement_2, a0_.ville AS ville_3, a0_.pays AS pays_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.plage_ip AS plage_ip_7, a0_.device_hmac AS device_hmac_8 FROM agence a0_ ORDER BY a0_.nom ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.logo AS logo_2, t0.address AS address_3, t0.phone1 AS phone1_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.email AS email_7, t0.domain_name AS domain_name_8, t0.penalite AS penalite_9 FROM gpi t0 ORDER BY t0.created_at DESC LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.logo AS logo_2, t0.address AS address_3, t0.phone1 AS phone1_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.email AS email_7, t0.domain_name AS domain_name_8, t0.penalite AS penalite_9 FROM gpi t0 ORDER BY t0.created_at DESC LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abbrev AS abbrev_3, t0.accepte_ticket AS accepte_ticket_4, t0.heure_limite_arrive AS heure_limite_arrive_5, t0.ignorer_penalite AS ignorer_penalite_6, t0.manage_ticket AS manage_ticket_7, t0.role_id AS role_id_8 FROM role_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM notification t0 WHERE t0.receiver_id = ? AND t0.seen_at IS NULL"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM notification t0 WHERE t0.receiver_id = ? AND t0.seen_at IS NULL"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.target AS target_4, t0.seen_at AS seen_at_5, t0.object_id AS object_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.extra AS extra_9, t0.path AS path_10, t0.receiver_id AS receiver_id_11 FROM notification t0 WHERE t0.receiver_id = ? ORDER BY t0.seen_at DESC, t0.created_at DESC LIMIT 3"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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\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"
]