Symfony Profiler

[
  "route" => "app_oauth_googlecallback"
  "route_parameters" => [
    "_route" => "app_oauth_googlecallback"
    "domain" => "-dev.swisskustomfaktory.ch"
    "_controller" => "App\Controller\OAuthController::googleCallback"
  ]
  "request_uri" => "https://webapp-dev.swisskustomfaktory.ch/oauth/google/callback?authuser=1&code=4%2F0AUJR-x5rj93Z5Fk36Qfh_ZcSEOc11y1lbECILNgNgM0llGpZcqjeJTaszULPH0yNjFFXYQ&hd=bacad.ch&prompt=none&scope=email%20profile%20openid%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile&state=3fbe82665a46a31bffe3246b5451c90d"
  "method" => "GET"
]

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

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

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

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

[
  "sub" => "108139709336153486649"
  "name" => "Jonathan Luthi"
  "given_name" => "Jonathan"
  "family_name" => "Luthi"
  "picture" => "https://lh3.googleusercontent.com/a/ACg8ocKhsFIkyj0n7ZCtTwOQhg2lZISolk79CPVRGPS6Q0wVkjac_eY=s96-c"
  "email" => "jonathan.luthi@bacad.ch"
  "email_verified" => true
  "hd" => "bacad.ch"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "8.0.40"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "skf_webapp"
  ]
]

[
  "sql" => "SELECT u0_.username AS username_0, u0_.email AS email_1, u0_.password AS password_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.gender AS gender_5, u0_.birthdate AS birthdate_6, u0_.origin_place AS origin_place_7, u0_.phone AS phone_8, u0_.phone_alternate AS phone_alternate_9, u0_.telegram_chat_id AS telegram_chat_id_10, u0_.avatar_name AS avatar_name_11, u0_.fonction AS fonction_12, u0_.roles AS roles_13, u0_.privileges AS privileges_14, u0_.locale AS locale_15, u0_.timezone AS timezone_16, u0_.authenticator_name AS authenticator_name_17, u0_.authenticator_user_id AS authenticator_user_id_18, u0_.confirmation_token AS confirmation_token_19, u0_.newsletter_subscribed AS newsletter_subscribed_20, u0_.observation AS observation_21, u0_.motorcycles AS motorcycles_22, u0_.password_updated_at AS password_updated_at_23, u0_.must_change_password AS must_change_password_24, u0_.logged_in_at AS logged_in_at_25, u0_.bad_customer AS bad_customer_26, u0_.disabled AS disabled_27, u0_.id AS id_28, u0_.created_at AS created_at_29, u0_.updated_at AS updated_at_30, u0_.deleted_at AS deleted_at_31, u0_.creator_id AS creator_id_32, u0_.modifier_id AS modifier_id_33, u0_.e_shop_id AS e_shop_id_34, a1_.id AS id_35, a1_.name AS name_36, a1_.type AS type_37, a1_.email AS email_38, a1_.phone AS phone_39, a1_.phone_alternate AS phone_alternate_40, a1_.url AS url_41, a1_.image AS image_42, a1_.locale AS locale_43, a1_.timezone AS timezone_44, a1_.observation AS observation_45, a1_.bad_customer AS bad_customer_46, a1_.disabled AS disabled_47, a1_.created_at AS created_at_48, a1_.updated_at AS updated_at_49, a1_.deleted_at AS deleted_at_50, a1_.creator_id AS creator_id_51, a1_.modifier_id AS modifier_id_52, u2_.id AS id_53, u2_.name AS name_54, u2_.description AS description_55, u2_.disabled AS disabled_56, u2_.created_at AS created_at_57, u2_.updated_at AS updated_at_58, u2_.deleted_at AS deleted_at_59, u2_.creator_id AS creator_id_60, u2_.modifier_id AS modifier_id_61, u2_.e_shop_id AS e_shop_id_62, t3_.name AS name_63, t3_.text_color AS text_color_64, t3_.background_color AS background_color_65, t3_.icon AS icon_66, t3_.id AS id_67, t3_.created_at AS created_at_68, t3_.updated_at AS updated_at_69, t3_.deleted_at AS deleted_at_70, t3_.creator_id AS creator_id_71, t3_.modifier_id AS modifier_id_72, u0_.account_id AS account_id_73, a1_.address_invoice_id AS address_invoice_id_74, a1_.address_delivery_id AS address_delivery_id_75 FROM `user` u0_ LEFT JOIN account a1_ ON u0_.account_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN user_user_group u4_ ON u0_.id = u4_.user_id LEFT JOIN user_group u2_ ON u2_.id = u4_.user_group_id AND (u2_.deleted_at IS NULL) LEFT JOIN user_tag u5_ ON u0_.id = u5_.user_id LEFT JOIN tag t3_ ON t3_.id = u5_.tag_id AND (t3_.deleted_at IS NULL) WHERE (u0_.authenticator_name = ? AND u0_.authenticator_user_id = ?) AND (u0_.deleted_at IS NULL) ORDER BY u0_.lastname ASC, u0_.firstname ASC, u2_.name ASC"
  "params" => [
    1 => "google"
    2 => "108139709336153486649"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#857
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#857}
  ]
]

[
  "sql" => "UPDATE `user` SET logged_in_at = ?, updated_at = ? WHERE id = ?"
  "params" => [
    1 => "2025-05-20 05:25:04"
    2 => "2025-05-20 05:25:04"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#857
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#857}
    3 => Doctrine\DBAL\ParameterType {#994
      +name: "INTEGER"
    }
  ]
]

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

[
  "sql" => "UPDATE user SET logged_in_at=UTC_TIMESTAMP() WHERE id=1"
]

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

[
  "event" => "security.authentication.success"
  "listener" => "App\EventListener\KernelSubscriber::onAuthenticationSuccess"
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#2253
    -user: App\Entity\User {#985 …}
    -roleNames: [
      "ROLE_USER"
      "ROLE_SUPER_ADMIN"
    ]
    -attributes: []
    -firewallName: "main"
  }
  "authenticator" => "App\Security\GoogleAuthenticator"
]

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

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

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

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\KernelSubscriber::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" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "key" => "_security_main"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\KernelSubscriber::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" => "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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