Symfony Profiler

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

Log Messages

"app_api_otp_request_verify"

[
  "route" => "app_api_otp_request_verify"
  "route_parameters" => [
    "_route" => "app_api_otp_request_verify"
    "_controller" => "App\Controller\Api\OtpRequestController::verify"
    "token" => "d5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353"
  ]
  "request_uri" => "https://api.madex.mg/api/v1/otp/request/verify/d5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353"
  "method" => "POST"
]

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "ua6fa9.myd.infomaniak.com"
  "port" => null
  "user" => "ua6fa9_madex"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "ua6fa9_madex"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "ua6fa9.myd.infomaniak.com"
    "port" => null
    "user" => "ua6fa9_madex"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ua6fa9_madex"
    "charset" => "utf8mb4"
  ]
]

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

"SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.otp_code AS otp_code_4, t0.token AS token_5, t0.created_at AS created_at_6, t0.expires_at AS expires_at_7, t0.is_verified AS is_verified_8, t0.attempt AS attempt_9 FROM otp_request t0 WHERE t0.token = ? LIMIT 1"

[
  1 => "d5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.otp_code AS otp_code_4, t0.token AS token_5, t0.created_at AS created_at_6, t0.expires_at AS expires_at_7, t0.is_verified AS is_verified_8, t0.attempt AS attempt_9 FROM otp_request t0 WHERE t0.token = ? LIMIT 1"
  "params" => [
    1 => "d5afdbb17552aed24d3efcdefb568936c7997f52c722dc8c2940586280361353"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1451
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connection_at AS last_connection_at_9, t0.last_activity_at AS last_activity_at_10, t0.utilisateur_role_id AS utilisateur_role_id_11 FROM utilisateur t0 WHERE t0.username = ? LIMIT 1"

[
  1 => "340000001"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connection_at AS last_connection_at_9, t0.last_activity_at AS last_activity_at_10, t0.utilisateur_role_id AS utilisateur_role_id_11 FROM utilisateur t0 WHERE t0.username = ? LIMIT 1"
  "params" => [
    1 => "340000001"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1451
      +name: "STRING"
    }
  ]
]

"SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1"

[
  1 => "1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606"
]

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

[
  "sql" => "SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1"
  "params" => [
    1 => "1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1451
      +name: "STRING"
    }
  ]
]

"INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)"

[
  1 => "1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606"
  2 => "340000001"
  3 => "2026-10-08 13:35:43"
]

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

[
  "sql" => "INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)"
  "params" => [
    1 => "1b2284c0c980c60fba4851f2208670ac92461c7c213d8cf62a652b0e1f41dcbffa4285a999d110869a6001c0fafebdfc71d0022c631b301bd7059fb569944606"
    2 => "340000001"
    3 => "2026-10-08 13:35:43"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1451
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1451}
    3 => Doctrine\DBAL\ParameterType {#1451}
  ]
]

"UPDATE otp_request SET is_verified = ? WHERE id = ?"

[
  1 => 1
  2 => 7
]

[
  1 => Doctrine\DBAL\ParameterType {#1374
    +name: "BOOLEAN"
  }
  2 => Doctrine\DBAL\ParameterType {#1449
    +name: "INTEGER"
  }
]

[
  "sql" => "UPDATE otp_request SET is_verified = ? WHERE id = ?"
  "params" => [
    1 => 1
    2 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1374
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1449
      +name: "INTEGER"
    }
  ]
]

"UPDATE utilisateur SET last_connection_at = ?, updated_at = ? WHERE id = ?"

[
  1 => "2026-09-08 13:35:43"
  2 => "2026-09-08 13:35:43"
  3 => 2
]

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

[
  "sql" => "UPDATE utilisateur SET last_connection_at = ?, updated_at = ? WHERE id = ?"
  "params" => [
    1 => "2026-09-08 13:35:43"
    2 => "2026-09-08 13:35:43"
    3 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1451
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1451}
    3 => Doctrine\DBAL\ParameterType {#1449
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM utilisateur_role t0 WHERE t0.id = ?"

[
  1 => 2
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM utilisateur_role t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1449
      +name: "INTEGER"
    }
  ]
]