Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Log Messages

"app_client_verify_run"

[
  "route" => "app_client_verify_run"
  "route_parameters" => [
    "_route" => "app_client_verify_run"
    "_controller" => "App\Controller\ClientAreaController::verifyRun"
  ]
  "request_uri" => "https://emailapi.rhvm.net/client/verify/run?email=uyen.ngo%40starrcompanies.com"
  "method" => "GET"
]

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

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

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

[
  "persistent" => false
  "driver" => "pdo_pgsql"
  "idle_connection_ttl" => 600
  "host" => "ep-bitter-snow-ab7i0d9l-pooler.eu-west-2.aws.neon.tech"
  "port" => null
  "user" => "Designer45014"
  "password" => "<redacted>"
  "driverOptions" => []
  "serverVersion" => "17"
  "defaultTableOptions" => []
  "dbname" => "odin"
  "sslmode" => "require"
  "channel_binding" => "require"
  "charset" => "utf8"
]

[
  "params" => [
    "persistent" => false
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "ep-bitter-snow-ab7i0d9l-pooler.eu-west-2.aws.neon.tech"
    "port" => null
    "user" => "Designer45014"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "17"
    "defaultTableOptions" => []
    "dbname" => "odin"
    "sslmode" => "require"
    "channel_binding" => "require"
    "charset" => "utf8"
  ]
]

"SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.api_key AS api_key_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.status AS status_13, t11.current_period_start AS current_period_start_14, t11.current_period_end AS current_period_end_15, t11.verifications_used_this_period AS verifications_used_this_period_16, t11.created_at AS created_at_17, t11.updated_at AS updated_at_18, t11.user_id AS user_id_19, t11.plan_id AS plan_id_20 FROM users t0 LEFT JOIN user_subscriptions t11 ON t11.user_id = t0.id WHERE t0.id = ?"

[
  1 => 2
]

[
  1 => Doctrine\DBAL\ParameterType {#849
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.api_key AS api_key_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.status AS status_13, t11.current_period_start AS current_period_start_14, t11.current_period_end AS current_period_end_15, t11.verifications_used_this_period AS verifications_used_this_period_16, t11.created_at AS created_at_17, t11.updated_at AS updated_at_18, t11.user_id AS user_id_19, t11.plan_id AS plan_id_20 FROM users t0 LEFT JOIN user_subscriptions t11 ON t11.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#849
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "brenda.huggett@icloud.com"
]

"Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"

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

"SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.monthly_price AS monthly_price_4, t0.monthly_verifications AS monthly_verifications_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.features AS features_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM plans t0 WHERE t0.id = ?"

[
  1 => 5
]

[
  1 => Doctrine\DBAL\ParameterType {#849
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.monthly_price AS monthly_price_4, t0.monthly_verifications AS monthly_verifications_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.features AS features_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM plans t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#849
      +name: "INTEGER"
    }
  ]
]

"SELECT SUM(c0_.credits_remaining) AS sclr_0 FROM credit_purchases c0_ WHERE c0_.user_id = ? AND c0_.credits_remaining > 0 AND (c0_.expires_at IS NULL OR c0_.expires_at > ?)"

[
  1 => 2
  2 => "2026-06-24 09:35:48"
]

[
  1 => Doctrine\DBAL\ParameterType {#849
    +name: "INTEGER"
  }
  2 => Doctrine\DBAL\ParameterType {#1035
    +name: "STRING"
  }
]

[
  "sql" => "SELECT SUM(c0_.credits_remaining) AS sclr_0 FROM credit_purchases c0_ WHERE c0_.user_id = ? AND c0_.credits_remaining > 0 AND (c0_.expires_at IS NULL OR c0_.expires_at > ?)"
  "params" => [
    1 => 2
    2 => "2026-06-24 09:35:48"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#849
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1035
      +name: "STRING"
    }
  ]
]

"INSERT INTO verification_results (email, status, score, domain, provider, checks, suggestion, verified_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"

[
  1 => "uyen.ngo@starrcompanies.com"
  2 => "valid"
  3 => 85
  4 => "starrcompanies.com"
  5 => null
  6 => "{"format":true,"domain":true,"nullMx":true,"mailRoute":true,"mx":true,"smtp":null,"disposable":true,"catchAll":null,"roleBased":true,"noReply":true,"freeProvider":false}"
  7 => null
  8 => "2026-06-24 09:35:48"
  9 => 2
]

[
  1 => Doctrine\DBAL\ParameterType {#1035
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#1035}
  3 => Doctrine\DBAL\ParameterType {#849
    +name: "INTEGER"
  }
  4 => Doctrine\DBAL\ParameterType {#1035}
  5 => Doctrine\DBAL\ParameterType {#1035}
  6 => Doctrine\DBAL\ParameterType {#1035}
  7 => Doctrine\DBAL\ParameterType {#1035}
  8 => Doctrine\DBAL\ParameterType {#1035}
  9 => Doctrine\DBAL\ParameterType {#849}
]

[
  "sql" => "INSERT INTO verification_results (email, status, score, domain, provider, checks, suggestion, verified_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "uyen.ngo@starrcompanies.com"
    2 => "valid"
    3 => 85
    4 => "starrcompanies.com"
    5 => null
    6 => "{"format":true,"domain":true,"nullMx":true,"mailRoute":true,"mx":true,"smtp":null,"disposable":true,"catchAll":null,"roleBased":true,"noReply":true,"freeProvider":false}"
    7 => null
    8 => "2026-06-24 09:35:48"
    9 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1035
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1035}
    3 => Doctrine\DBAL\ParameterType {#849
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#1035}
    5 => Doctrine\DBAL\ParameterType {#1035}
    6 => Doctrine\DBAL\ParameterType {#1035}
    7 => Doctrine\DBAL\ParameterType {#1035}
    8 => Doctrine\DBAL\ParameterType {#1035}
    9 => Doctrine\DBAL\ParameterType {#849}
  ]
]

"UPDATE user_subscriptions SET verifications_used_this_period = ?, updated_at = ? WHERE id = ?"

[
  1 => 636
  2 => "2026-06-24 09:35:48"
  3 => 2
]

[
  1 => Doctrine\DBAL\ParameterType {#849
    +name: "INTEGER"
  }
  2 => Doctrine\DBAL\ParameterType {#1035
    +name: "STRING"
  }
  3 => Doctrine\DBAL\ParameterType {#849}
]

[
  "sql" => "UPDATE user_subscriptions SET verifications_used_this_period = ?, updated_at = ? WHERE id = ?"
  "params" => [
    1 => 636
    2 => "2026-06-24 09:35:48"
    3 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#849
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1035
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#849}
  ]
]

[
  "key" => "_security_main"
]