Symfony Profiler

[
  "route" => "api_calendar_verify_license"
  "route_parameters" => [
    "_route" => "api_calendar_verify_license"
    "_controller" => "App\Controller\ApiKey\CalendarApiKeyController::verifyLicense"
  ]
  "request_uri" => "https://braxen.pl/api/calendar/verify-license"
  "method" => "POST"
]

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

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

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

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

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "programigo_braxen"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "programigo_braxen"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3, t0.usage_last_date AS usage_last_date_4, t0.api_key AS api_key_5, t0.is_active AS is_active_6, t0.expiration_date AS expiration_date_7, t0.description AS description_8, t0.domain AS domain_9, t0.user_id AS user_id_10 FROM calendar_api_key t0 WHERE t0.api_key = ? AND t0.is_active = ? LIMIT 1"
  "params" => [
    1 => "VP5kaUsOB1zgkxfUSE9TVbDnKWye275Cwtzzu3JhVpYc2o3ecyVqS8FdxGn9sm8QecrqXTmivUsp4tHxb2ptEwI3f/cjBFGkl4KUUpN59VUQPrWiXIIC+WUACafAEdcuv2lBcMZebxOuDgUJdGll3EHzStVnlo/AKZEIDlSwU+pXB1lSALxRELdQt2CtwlVU"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#525
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#675
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.trader_light_subscription_id AS trader_light_subscription_id_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.status AS status_4, s0_.start_date AS start_date_5, s0_.end_date AS end_date_6, s0_.cancelled_at AS cancelled_at_7, s0_.cancellation_reason AS cancellation_reason_8, s0_.sms_used AS sms_used_9, s0_.emails_used AS emails_used_10, s0_.auto_renew AS auto_renew_11, s0_.autopay_order_id AS autopay_order_id_12, s0_.autopay_remote_id AS autopay_remote_id_13, s0_.payment_data AS payment_data_14, s0_.limits_reset_at AS limits_reset_at_15, s0_.user_id AS user_id_16, s0_.plan_id AS plan_id_17 FROM subscription s0_ INNER JOIN subscription_plan s1_ ON s0_.plan_id = s1_.id WHERE s0_.user_id = ? AND s0_.status IN (?, ?) AND s1_.plan_type = ? AND (s0_.end_date IS NULL OR s0_.end_date > ?) ORDER BY s0_.created_at DESC LIMIT 1"
  "params" => [
    1 => 1
    2 => "active"
    3 => "cancelled"
    4 => "calendar"
    5 => "2025-12-15 16:14:47"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#523
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#525
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#525}
    4 => Doctrine\DBAL\ParameterType {#525}
    5 => Doctrine\DBAL\ParameterType {#525}
  ]
]

[
  "sql" => "UPDATE calendar_api_key SET usage_last_date = ? WHERE id = ?"
  "params" => [
    1 => "2025-12-15 16:14:47"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#525
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#523
      +name: "INTEGER"
    }
  ]
]

[
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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\Mercure\EventSubscriber\SetCookieSubscriber::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"
]