Symfony Profiler

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

Query Metrics

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.last_name AS last_name_5, u0_.first_name AS first_name_6, u0_.street AS street_7, u0_.house_number AS house_number_8, u0_.box_number AS box_number_9, u0_.postal_code AS postal_code_10, u0_.city AS city_11, u0_.country AS country_12, u0_.phone_number AS phone_number_13, u0_.locale AS locale_14, u0_.is_verified AS is_verified_15, u0_.is_approved AS is_approved_16, u0_.is_active AS is_active_17, u0_.is_first_super_admin AS is_first_super_admin_18, u0_.email_verified_at AS email_verified_at_19, u0_.approved_at AS approved_at_20, u0_.created_at AS created_at_21, u0_.last_login_at AS last_login_at_22, u0_.birth_date AS birth_date_23, u0_.profile_photo AS profile_photo_24, u0_.latitude AS latitude_25, u0_.longitude AS longitude_26 FROM `user` u0_ WHERE u0_.roles LIKE ? ORDER BY u0_.last_name ASC

[
  "%ROLE_SUPER_ADMIN%"
]

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.username AS username_2,
  u0_.roles AS roles_3,
  u0_.password AS password_4,
  u0_.last_name AS last_name_5,
  u0_.first_name AS first_name_6,
  u0_.street AS street_7,
  u0_.house_number AS house_number_8,
  u0_.box_number AS box_number_9,
  u0_.postal_code AS postal_code_10,
  u0_.city AS city_11,
  u0_.country AS country_12,
  u0_.phone_number AS phone_number_13,
  u0_.locale AS locale_14,
  u0_.is_verified AS is_verified_15,
  u0_.is_approved AS is_approved_16,
  u0_.is_active AS is_active_17,
  u0_.is_first_super_admin AS is_first_super_admin_18,
  u0_.email_verified_at AS email_verified_at_19,
  u0_.approved_at AS approved_at_20,
  u0_.created_at AS created_at_21,
  u0_.last_login_at AS last_login_at_22,
  u0_.birth_date AS birth_date_23,
  u0_.profile_photo AS profile_photo_24,
  u0_.latitude AS latitude_25,
  u0_.longitude AS longitude_26
FROM
  `user` u0_
WHERE
  u0_.roles LIKE ?
ORDER BY
  u0_.last_name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.last_name AS last_name_5, u0_.first_name AS first_name_6, u0_.street AS street_7, u0_.house_number AS house_number_8, u0_.box_number AS box_number_9, u0_.postal_code AS postal_code_10, u0_.city AS city_11, u0_.country AS country_12, u0_.phone_number AS phone_number_13, u0_.locale AS locale_14, u0_.is_verified AS is_verified_15, u0_.is_approved AS is_approved_16, u0_.is_active AS is_active_17, u0_.is_first_super_admin AS is_first_super_admin_18, u0_.email_verified_at AS email_verified_at_19, u0_.approved_at AS approved_at_20, u0_.created_at AS created_at_21, u0_.last_login_at AS last_login_at_22, u0_.birth_date AS birth_date_23, u0_.profile_photo AS profile_photo_24, u0_.latitude AS latitude_25, u0_.longitude AS longitude_26 FROM `user` u0_ WHERE u0_.roles LIKE '%ROLE_SUPER_ADMIN%' ORDER BY u0_.last_name ASC;

SELECT t0.id AS id_1, t0.md5 AS md5_2, t0.sha1 AS sha1_3, t0.sha224 AS sha224_4, t0.sha256 AS sha256_5, t0.sha384 AS sha384_6, t0.sha512 AS sha512_7, t0.sha3 AS sha3_8, t0.bcrypt AS bcrypt_9, t0.scrypt AS scrypt_10, t0.argon2 AS argon2_11, t0.argon2i AS argon2i_12, t0.argon2d AS argon2d_13, t0.argon2id AS argon2id_14, t0.pbkdf2 AS pbkdf2_15, t0.whirlpool AS whirlpool_16, t0.ntlm AS ntlm_17, t0.blowfish AS blowfish_18, t0.crypt AS crypt_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.user_id AS user_id_22 FROM hash_storage t0 WHERE t0.user_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.md5 AS md5_2,
  t0.sha1 AS sha1_3,
  t0.sha224 AS sha224_4,
  t0.sha256 AS sha256_5,
  t0.sha384 AS sha384_6,
  t0.sha512 AS sha512_7,
  t0.sha3 AS sha3_8,
  t0.bcrypt AS bcrypt_9,
  t0.scrypt AS scrypt_10,
  t0.argon2 AS argon2_11,
  t0.argon2i AS argon2i_12,
  t0.argon2d AS argon2d_13,
  t0.argon2id AS argon2id_14,
  t0.pbkdf2 AS pbkdf2_15,
  t0.whirlpool AS whirlpool_16,
  t0.ntlm AS ntlm_17,
  t0.blowfish AS blowfish_18,
  t0.crypt AS crypt_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.user_id AS user_id_22
FROM
  hash_storage t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.md5 AS md5_2, t0.sha1 AS sha1_3, t0.sha224 AS sha224_4, t0.sha256 AS sha256_5, t0.sha384 AS sha384_6, t0.sha512 AS sha512_7, t0.sha3 AS sha3_8, t0.bcrypt AS bcrypt_9, t0.scrypt AS scrypt_10, t0.argon2 AS argon2_11, t0.argon2i AS argon2i_12, t0.argon2d AS argon2d_13, t0.argon2id AS argon2id_14, t0.pbkdf2 AS pbkdf2_15, t0.whirlpool AS whirlpool_16, t0.ntlm AS ntlm_17, t0.blowfish AS blowfish_18, t0.crypt AS crypt_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.user_id AS user_id_22 FROM hash_storage t0 WHERE t0.user_id = 1;

SELECT t0.id AS id_1, t0.necessary_cookies AS necessary_cookies_2, t0.preference_cookies AS preference_cookies_3, t0.statistics_cookies AS statistics_cookies_4, t0.marketing_cookies AS marketing_cookies_5, t0.geolocation_enabled AS geolocation_enabled_6, t0.geolocation_enabled_at AS geolocation_enabled_at_7, t0.terms_accepted AS terms_accepted_8, t0.terms_accepted_at AS terms_accepted_at_9, t0.cookie_preferences_updated_at AS cookie_preferences_updated_at_10, t0.created_at AS created_at_11, t0.user_id AS user_id_12 FROM `user_consent` t0 WHERE t0.user_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.necessary_cookies AS necessary_cookies_2,
  t0.preference_cookies AS preference_cookies_3,
  t0.statistics_cookies AS statistics_cookies_4,
  t0.marketing_cookies AS marketing_cookies_5,
  t0.geolocation_enabled AS geolocation_enabled_6,
  t0.geolocation_enabled_at AS geolocation_enabled_at_7,
  t0.terms_accepted AS terms_accepted_8,
  t0.terms_accepted_at AS terms_accepted_at_9,
  t0.cookie_preferences_updated_at AS cookie_preferences_updated_at_10,
  t0.created_at AS created_at_11,
  t0.user_id AS user_id_12
FROM
  `user_consent` t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.necessary_cookies AS necessary_cookies_2, t0.preference_cookies AS preference_cookies_3, t0.statistics_cookies AS statistics_cookies_4, t0.marketing_cookies AS marketing_cookies_5, t0.geolocation_enabled AS geolocation_enabled_6, t0.geolocation_enabled_at AS geolocation_enabled_at_7, t0.terms_accepted AS terms_accepted_8, t0.terms_accepted_at AS terms_accepted_at_9, t0.cookie_preferences_updated_at AS cookie_preferences_updated_at_10, t0.created_at AS created_at_11, t0.user_id AS user_id_12 FROM `user_consent` t0 WHERE t0.user_id = 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SAVEPOINT DOCTRINE_2

[]

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO audit_log (action, details, ip_address, user_agent, created_at, type, device_brand, device_model, os_name, os_version, browser_name, browser_version, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "http_error_404"
  """
    404: Not Found\n
    \n
    URL: /dist/js/bootstrap.bundle.min.js\n
    Method: GET\n
    \n
    Exception: Symfony\Component\HttpKernel\Exception\NotFoundHttpException\n
    Message: No route found for "GET https://server.dmqode.be/dist/js/bootstrap.bundle.min.js"\n
    File: /var/www/server/user-management-system/vendor/symfony/http-kernel/EventListener/RouterListener.php (line 149)\n
    \n
    Request Headers:\n
    accept: */*\n
    user-agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\n
    accept-encoding: gzip, br, zstd, deflate\n
    host: server.dmqode.be\n
    x-php-ob-level: 1\n
    \n
    Full User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
    """
  "216.73.216.165"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "2026-02-12 08:15:22"
  "error"
  "Spider"
  "Desktop"
  "Unknown"
  "Unknown"
  "ClaudeBot"
  "1.0"
  1
]

INSERT INTO audit_log (
  action, details, ip_address, user_agent,
  created_at, type, device_brand, device_model,
  os_name, os_version, browser_name,
  browser_version, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit_log (action, details, ip_address, user_agent, created_at, type, device_brand, device_model, os_name, os_version, browser_name, browser_version, user_id) VALUES ('http_error_404', '404: Not Found

URL: /dist/js/bootstrap.bundle.min.js
Method: GET

Exception: Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException
Message: No route found for \"GET https://server.dmqode.be/dist/js/bootstrap.bundle.min.js\"
File: /var/www/server/user-management-system/vendor/symfony/http-kernel/EventListener/RouterListener.php (line 149)

Request Headers:
accept: */*
user-agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept-encoding: gzip, br, zstd, deflate
host: server.dmqode.be
x-php-ob-level: 1

Full User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '216.73.216.165', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2026-02-12 08:15:22', 'error', 'Spider', 'Desktop', 'Unknown', 'Unknown', 'ClaudeBot', '1.0', 1);

UPDATE `user` SET latitude = ?, longitude = ? WHERE id = ?

[
  50.8661601
  4.3977835
  1
]

UPDATE
  `user`
SET
  latitude = ?,
  longitude = ?
WHERE
  id = ?

UPDATE `user` SET latitude = 50.8661601, longitude = 4.3977835 WHERE id = 1;

RELEASE SAVEPOINT DOCTRINE_2

[]

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

"COMMIT"

[]

"COMMIT"

"COMMIT";