Symfony Profiler

[
  "route" => "cron_newsletters_run"
  "route_parameters" => [
    "_route" => "cron_newsletters_run"
    "_controller" => "App\Controller\Cron\CronController::runNewsletters"
    "tenantCode" => "vguimaraes"
  ]
  "request_uri" => "http://dev.sosadvanced.pt/cron/newsletters/run/vguimaraes?limit=200"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

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

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

[
  "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\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" => "App\EventSubscriber\CompanySessionSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\MultiTenant\KernelTenantSubscriber::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\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container1vSOkbD\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "db"
    "port" => 3306
    "user" => "sconsult_db_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "sconsult_db_sy_plataforma"
    "serverVersion" => "8.0.36"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.db_host AS db_host_3, t0.db_port AS db_port_4, t0.db_name AS db_name_5, t0.db_user AS db_user_6, t0.db_password AS db_password_7, t0.db_charset AS db_charset_8, t0.company_id AS company_id_9 FROM tenant t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "vguimaraes"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "db"
    "port" => 3306
    "dbname" => "sconsult_db_sy_vguimaraes"
    "user" => "sconsult_db_user"
    "password" => "<redacted>"
    "charset" => "utf8mb4"
    "serverVersion" => "mariadb-11.4.7"
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.nome AS nome_1, n0_.data_envio AS data_envio_2, n0_.estado AS estado_3, n0_.conteudo AS conteudo_4, n0_.assunto AS assunto_5, n0_.config AS config_6, n0_.created_by AS created_by_7, n0_.created_at AS created_at_8, n0_.updated_by AS updated_by_9, n0_.updated_at AS updated_at_10, n0_.id_audiencia AS id_audiencia_11 FROM newsletter_campaign n0_ WHERE n0_.estado = ? AND (n0_.data_envio IS NOT NULL AND n0_.data_envio <= ?)"
  "params" => [
    1 => "agendado"
    2 => "2026-01-13 02:10:14"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.nome AS nome_1, n0_.data_envio AS data_envio_2, n0_.estado AS estado_3, n0_.conteudo AS conteudo_4, n0_.assunto AS assunto_5, n0_.config AS config_6, n0_.created_by AS created_by_7, n0_.created_at AS created_at_8, n0_.updated_by AS updated_by_9, n0_.updated_at AS updated_at_10, n0_.id_audiencia AS id_audiencia_11 FROM newsletter_campaign n0_ WHERE n0_.estado IN (?, ?) AND (n0_.data_envio IS NOT NULL AND n0_.data_envio <= ?)"
  "params" => [
    1 => "a_enviar"
    2 => "a enviar"
    3 => "2026-01-13 02:10:14"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT id FROM newsletter_campaign WHERE estado IN ('a_enviar', 'a enviar')"
]

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