https://dev.causepilot.com/_profiler/33a639?connection=default&page=explain&panel=db&query=9

n/a

Request

GET Parameters

Key Value
connection
"default"
page
"explain"
panel
"db"
query
"9"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"web_profiler.controller.profiler::panelAction"
_firewall_context
"security.firewall.map.context.main"
_remove_csp_headers
true
_route
"_profiler"
_route_params
[
  "token" => "33a639"
]
_security_firewall_run
"_security_main"
_stopwatch_token
"233c75"
token
"33a639"

Request Headers

Header Value
accept
"*/*"
accept-encoding
"gzip, br"
cdn-loop
"cloudflare; loops=1"
cf-connecting-ip
"20.171.207.230"
cf-ipcountry
"US"
cf-ray
"994d646ecb3883d5-ATL"
cf-visitor
"{"scheme":"https"}"
connection
"Keep-Alive"
cookie
"PHPSESSID=jvaqqrvmgkbmoip0u2i7kspk23"
from
"gptbot(at)openai.com"
host
"dev.causepilot.com"
user-agent
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
x-forwarded-for
"20.171.207.230"
x-forwarded-proto
"https"
x-openai-host-hash
"721179955"
x-php-ob-level
"1"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
access-control-allow-credentials
"true"
access-control-allow-headers
"Origin, Content-Type, Accept, Authorization, X-Custom-Auth"
access-control-allow-methods
"POST, GET, PUT, DELETE, PATCH, OPTIONS"
access-control-allow-origin
[
  null
]
cache-control
"no-cache, private"
content-type
"text/html; charset=UTF-8"
date
"Sun, 26 Oct 2025 22:29:25 GMT"
vary
"Origin"
x-debug-exception
"Notice%3A%20SessionHandler%3A%3Agc%28%29%3A%20ps_files_cleanup_dir%3A%20opendir%28%2Fvar%2Flib%2Fphp%2Fsessions%29%20failed%3A%20Permission%20denied%20%2813%29"
x-debug-exception-file
"%2Fvar%2Fwww%2Fcausepilot%2Fvendor%2Fsymfony%2Fhttp-foundation%2FSession%2FStorage%2FHandler%2FStrictSessionHandler.php:116"
x-debug-token
"e73194"
x-debug-token-link
"https://dev.causepilot.com/_profiler/a32520"
x-previous-debug-token
"a32520"
x-robots-tag
"noindex"

Cookies

Request Cookies

Key Value
PHPSESSID
"jvaqqrvmgkbmoip0u2i7kspk23"

Response Cookies

No response cookies

Session

Session Metadata

Key Value
Created
"Sun, 26 Oct 25 22:29:05 +0000"
Last used
"Sun, 26 Oct 25 22:29:23 +0000"
Lifetime
0

Session Attributes

Attribute Value
_csrf/https-organization
"hy-yBSf0lLxxStQaUa4O1pBOqmaPhH1Aj23TeyhXbtY"

Session Usage

0 Usages
Stateless check enabled

Session not used.

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
ACTIVE_CAMPAIGN_TOKEN
"32bf6dd19dbff7758e643566ff51fd0fd4d8e410c7c3d87014e33ff37e670ee871bc55f2"
ACTIVE_CAMPAIGN_URL
"https://causepilot.api-us1.com/api/3"
AMAZON_ACCESS_KEY
"AKIAI47P2JAQDLKH2HJA"
AMAZON_ACCESS_SECRET
"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"
AMAZON_APPLICATION_NAME
"Bidcoz - Localhost"
AMAZON_CLIENT_ID
"amzn1.application-oa2-client.100e2ef1f0cb436396b3e39feca4c67d"
AMAZON_CLIENT_SECRET
"587e07a6f95bca3266997fefde4053137881e6f4e6db61f35ac668b5927499ec"
AMAZON_S3_IMAGE_BUCKET
"cp-dev-images"
AMAZON_S3_KEY
""
AMAZON_S3_PDF_BUCKET
"cp-dev-pdfs"
AMAZON_S3_REGION
"us-east-2"
AMAZON_S3_SECRET
""
AMAZON_SELLER_ID
"A2JS9NMZ40E5GG"
APP_DEBUG
"1"
APP_ENV
"dev"
APP_SECRET
"c4f4857f745a64130245c64512a1710b"
BITLY_ACCESS_TOKEN
""
CORS_ALLOW_ORIGIN
"^https?://(localhost|127\.0\.0\.1)(:[0-9]+)?$"
CORS_ORIGINS_1
"dev.causepilot.com"
DATABASE_URL
"mysql://causepilot:[email protected]:3306/causepilot?serverVersion=8&charset=utf8mb4"
DEFAULT_SERVICE_FEES_CAP
"1997"
FRESHDESK_DOMAIN_ADMIN
"bidcoz.freshdesk.com"
FRESHDESK_DOMAIN_USER
"bidcoz.freshdesk.com"
FRESHDESK_SCHEME
"http"
FRESHDESK_SECRET
""
GLOBAL_FLIGHT_ID
"1676"
HOST
"dev.causepilot.com"
KINDFUL_CLIENT_ID
""
KINDFUL_CLIENT_SECRET
""
KINDFUL_URL
"https://app-playground.kindful.com"
MAILCHIMP_API_KEY
"dc304e5ff2e01986de1579d4e853d1a7-us12"
MAILCHIMP_DRY_RUN
"0"
MAILCHIMP_ONBOARDING_AUDIENCE_LIST_ID
"de3e8a0457"
MAILCHIMP_SERVER_PREFIX
"us12"
MAILER_FROM
"[email protected]"
MAILER_URL
"smtp://localhost:25?encryption=&auth_mode="
MANDRILL_KEY
"xxxx"
MESSENGER_TRANSPORT_DSN
"doctrine://default?auto_setup=0"
MYSQL_PASSWORD
"causepilot"
MYSQL_ROOT_PASSWORD
"ChangeSeymourChangeMe"
MYSQL_USER
"causepilot"
PHP_IDE_CONFIG
"serverName=docker"
RECAPTCHA3_ENABLED
"1"
RECAPTCHA3_KEY
"6LednREqAAAAALIsHweMT4EGC9rvpfetEGzq7LyY"
RECAPTCHA3_SECRET
"6LednREqAAAAAOaT4i8zJQqUWugv7t0zxf6av_AB"
SENTRY_DSN
"https://1aa3336f97d949f0a51d5aed30e5e10e@o4504181509324800.ingest.sentry.io/4504283296890880"
STRIPE_CLIENT_ID
"ca_758tgzppesscmthWwosFVBn0GQzM71Qe"
STRIPE_PUBLISHABLE_KEY
"pk_test_D4ezrqeDxoOkoKpgm0EOpmCF"
STRIPE_SECRET_KEY
"sk_test_jCkT95JoHr1IfUE8Hb6mBRNB"
TWILLIO_FROM
""
TWILLIO_SID
""
TWILLIO_TOKEN
""
WKHTMLTOIMAGE_PATH
"/usr/bin/xvfb-run /usr/bin/wkhtmltoimage"
WKHTMLTOPDF_PATH
"/usr/bin/xvfb-run /usr/bin/wkhtmltopdf"
XDEBUG_CONFIG
"remote_host=host.docker.internal remote_port=9000"

Defined as regular env variables

Key Value
CONTEXT_DOCUMENT_ROOT
"/var/www/causepilot/public"
CONTEXT_PREFIX
""
DOCUMENT_ROOT
"/var/www/causepilot/public"
GATEWAY_INTERFACE
"CGI/1.1"
HTTPS
"on"
HTTP_ACCEPT
"*/*"
HTTP_ACCEPT_ENCODING
"gzip, br"
HTTP_CDN_LOOP
"cloudflare; loops=1"
HTTP_CF_CONNECTING_IP
"20.171.207.230"
HTTP_CF_IPCOUNTRY
"US"
HTTP_CF_RAY
"994d646ecb3883d5-ATL"
HTTP_CF_VISITOR
"{"scheme":"https"}"
HTTP_CONNECTION
"Keep-Alive"
HTTP_COOKIE
"PHPSESSID=jvaqqrvmgkbmoip0u2i7kspk23"
HTTP_FROM
"gptbot(at)openai.com"
HTTP_HOST
"dev.causepilot.com"
HTTP_USER_AGENT
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
HTTP_X_FORWARDED_FOR
"20.171.207.230"
HTTP_X_FORWARDED_PROTO
"https"
HTTP_X_OPENAI_HOST_HASH
"721179955"
PATH
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF
"/index.php"
QUERY_STRING
"connection=default&page=explain&panel=db&query=9"
REDIRECT_HTTPS
"on"
REDIRECT_QUERY_STRING
"connection=default&page=explain&panel=db&query=9"
REDIRECT_SSL_TLS_SNI
"dev.causepilot.com"
REDIRECT_STATUS
"200"
REDIRECT_URL
"/_profiler/33a639"
REMOTE_ADDR
"172.71.30.39"
REMOTE_PORT
"13667"
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"https"
REQUEST_TIME
1761517764
REQUEST_TIME_FLOAT
1761517764.9613
REQUEST_URI
"/_profiler/33a639?connection=default&page=explain&panel=db&query=9"
SCRIPT_FILENAME
"/var/www/causepilot/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"45.79.201.148"
SERVER_ADMIN
"webmaster@localhost"
SERVER_NAME
"dev.causepilot.com"
SERVER_PORT
"443"
SERVER_PROTOCOL
"HTTP/1.1"
SERVER_SIGNATURE
"<address>Apache/2.4.29 (Ubuntu) Server at dev.causepilot.com Port 443</address>\n"
SERVER_SOFTWARE
"Apache/2.4.29 (Ubuntu)"
SSL_TLS_SNI
"dev.causepilot.com"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_DEBUG,APP_SECRET,HOST,DATABASE_URL,MAILER_URL,MAILER_FROM,MYSQL_ROOT_PASSWORD,MYSQL_USER,MYSQL_PASSWORD,CORS_ALLOW_ORIGIN,WKHTMLTOPDF_PATH,WKHTMLTOIMAGE_PATH,PHP_IDE_CONFIG,XDEBUG_CONFIG,ACTIVE_CAMPAIGN_TOKEN,ACTIVE_CAMPAIGN_URL,AMAZON_S3_REGION,AMAZON_S3_KEY,AMAZON_S3_SECRET,AMAZON_S3_IMAGE_BUCKET,AMAZON_S3_PDF_BUCKET,AMAZON_CLIENT_ID,AMAZON_CLIENT_SECRET,AMAZON_SELLER_ID,AMAZON_ACCESS_KEY,AMAZON_ACCESS_SECRET,AMAZON_APPLICATION_NAME,STRIPE_SECRET_KEY,STRIPE_PUBLISHABLE_KEY,STRIPE_CLIENT_ID,TWILLIO_SID,TWILLIO_TOKEN,TWILLIO_FROM,MANDRILL_KEY,CORS_ORIGINS_1,KINDFUL_URL,KINDFUL_CLIENT_ID,KINDFUL_CLIENT_SECRET,BITLY_ACCESS_TOKEN,MAILCHIMP_API_KEY,MAILCHIMP_SERVER_PREFIX,MAILCHIMP_ONBOARDING_AUDIENCE_LIST_ID,MAILCHIMP_DRY_RUN,FRESHDESK_SCHEME,FRESHDESK_DOMAIN_USER,FRESHDESK_DOMAIN_ADMIN,FRESHDESK_SECRET,SENTRY_DSN,GLOBAL_FLIGHT_ID,MESSENGER_TRANSPORT_DSN,RECAPTCHA3_KEY,RECAPTCHA3_SECRET,RECAPTCHA3_ENABLED,DEFAULT_SERVICE_FEES_CAP"

Sub Requests 1

ErrorController (token = a32520)

Key Value
_controller
"error_controller"
_stopwatch_token
"a55e83"
exception
ErrorException {#1316
  #message: "Notice: SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13)"
  #code: 0
  #file: "/var/www/causepilot/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php"
  #line: 116
  #severity: E_NOTICE
  trace: {
    /var/www/causepilot/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php:116 {
      Symfony\Component\HttpFoundation\Session\Storage\Handler\StrictSessionHandler->gc($maxlifetime) …
      › {    return $this->handler->gc($maxlifetime);}
    }
    /var/www/causepilot/vendor/symfony/http-foundation/Session/Storage/Proxy/SessionHandlerProxy.php:91 {
      Symfony\Component\HttpFoundation\Session\Storage\Proxy\SessionHandlerProxy->gc($maxlifetime) …
      › {    return $this->handler->gc($maxlifetime);}
    }
    Symfony\Component\HttpFoundation\Session\Storage\Proxy\SessionHandlerProxy->gc() {}
    /var/www/causepilot/vendor/symfony/http-foundation/Session/Storage/NativeSessionStorage.php:185 {
      Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage->start() …
      › // ok to try and start the sessionif (!session_start()) {    throw new \RuntimeException('Failed to start the session.');
    }
    /var/www/causepilot/vendor/symfony/http-foundation/Session/Storage/NativeSessionStorage.php:352 {
      Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage->getBag(string $name) …
      › } elseif (!$this->started) {    $this->start();}
    }
    /var/www/causepilot/vendor/symfony/http-foundation/Session/Session.php:261 {
      Symfony\Component\HttpFoundation\Session\Session->getBag(string $name) …
      › {    $bag = $this->storage->getBag($name);}
    /var/www/causepilot/vendor/symfony/http-foundation/Session/Session.php:283 {
      Symfony\Component\HttpFoundation\Session\Session->getAttributeBag(): AttributeBagInterface …
      › {    return $this->getBag($this->attributeName);}
    }
    /var/www/causepilot/vendor/symfony/http-foundation/Session/Session.php:77 {
      Symfony\Component\HttpFoundation\Session\Session->get(string $name, $default = null) …
      › {    return $this->getAttributeBag()->get($name, $default);}
    }
    /var/www/causepilot/vendor/symfony/security-http/Firewall/ContextListener.php:106 {
      Symfony\Component\Security\Http\Firewall\ContextListener->authenticate(RequestEvent $event) …
      › $sessionId = $request->cookies->all()[$session->getName()] ?? null;$token = $session->get($this->sessionKey);}
    /var/www/causepilot/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php:49 {
      Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate(RequestEvent $event) …
      › try {    $ret = $this->listener->authenticate($event);} catch (LazyResponseException $e) {
    }
    /var/www/causepilot/vendor/symfony/security-http/Firewall/AbstractListener.php:26 {
      Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke(RequestEvent $event) …
      › if (false !== $this->supports($event->getRequest())) {    $this->authenticate($event);}
    }
    /var/www/causepilot/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php:80 {
      Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners(RequestEvent $event, iterable $listeners) …
      › $wrappedListener = $listener instanceof FirewallListenerInterface ? new WrappedLazyListener($listener) : new WrappedListener($listener);$wrappedListener($event);$wrappedListeners[] = $wrappedListener->getInfo();
    }
    /var/www/causepilot/vendor/symfony/security-http/Firewall.php:92 {
      Symfony\Component\Security\Http\Firewall->onKernelRequest(RequestEvent $event) …
      › 
      ›     $this->callListeners($event, $authenticationListeners());}
    }
    /var/www/causepilot/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118 {
      Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
      › try {    ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);} finally {
    }
    /var/www/causepilot/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }    $listener($event, $eventName, $this);}
    }
    /var/www/causepilot/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
      Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
      › if ($listeners) {    $this->callListeners($listeners, $eventName, $event);}
    }
    /var/www/causepilot/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154 {
      Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
      › try {    $this->dispatcher->dispatch($event, $eventName);} finally {
    }
    /var/www/causepilot/vendor/symfony/http-kernel/HttpKernel.php:139 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › $event = new RequestEvent($this, $request, $type);$this->dispatcher->dispatch($event, KernelEvents::REQUEST);}
    /var/www/causepilot/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {    return $this->handleRaw($request, $type);} catch (\Exception $e) {
    }
    /var/www/causepilot/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {    return $this->getHttpKernel()->handle($request, $type, $catch);} finally {
    }
    /var/www/causepilot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {    $response = $this->kernel->handle($this->request);    $response->send();
    }
    /var/www/causepilot/vendor/autoload_runtime.php:35 {
      require_once …
      ›         ->getRunner($app)        ->run());
    }
    /var/www/causepilot/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';arguments: {
        "/var/www/causepilot/vendor/autoload_runtime.php"
      }
    }
  }
}
logger
Symfony\Bridge\Monolog\Logger {#575 …5}