Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.tenant_id AS tenant_id_7, t0.last_connection AS last_connection_8, t0.created_at AS created_at_9, t0.created_by AS created_by_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12 FROM dte_backend.users t0 WHERE t0.id = ?

[
  1494
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.tenant_id AS tenant_id_7,
  t0.last_connection AS last_connection_8,
  t0.created_at AS created_at_9,
  t0.created_by AS created_by_10,
  t0.is_active AS is_active_11,
  t0.is_verified AS is_verified_12
FROM
  dte_backend.users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.tenant_id AS tenant_id_7, t0.last_connection AS last_connection_8, t0.created_at AS created_at_9, t0.created_by AS created_by_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12 FROM dte_backend.users t0 WHERE t0.id = 1494;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE dte_backend.users SET last_connection = ? WHERE id = ?

[
  "2026-09-23 13:44:26"
  1494
]

UPDATE
  dte_backend.users
SET
  last_connection = ?
WHERE
  id = ?

UPDATE dte_backend.users SET last_connection = '2026-09-23 13:44:26' WHERE id = 1494;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO dte_backend.connection_logs (ip_address, session_id, user_dbid, controller, request, creation_date) VALUES (?, ?, ?, ?, ?, ?)

[
  "94.110.233.220, 193.191.247.240, 10.89.1.1"
  "e98ef622215b58141d4b224c31dd0269"
  1494
  "App\Controller\HomeController::getHomepageData"
  "{}"
  "2026-09-23 13:44:26"
]

INSERT INTO dte_backend.connection_logs (
  ip_address, session_id, user_dbid,
  controller, request, creation_date
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO dte_backend.connection_logs (ip_address, session_id, user_dbid, controller, request, creation_date) VALUES ('94.110.233.220, 193.191.247.240, 10.89.1.1', 'e98ef622215b58141d4b224c31dd0269', 1494, 'App\\Controller\\HomeController::getHomepageData', '{}', '2026-09-23 13:44:26');

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT * FROM dte_backend.tenants WHERE id = ?

[
  1000226
]

SELECT
  *
FROM
  dte_backend.tenants
WHERE
  id = ?

SELECT * FROM dte_backend.tenants WHERE id = 1000226;

SELECT * FROM dte_backend.tenants_projects
    JOIN dte_backend.projects ON projects.id = tenants_projects.project_id
    WHERE tenant_id = ?

[
  1000226
]

SELECT
  *
FROM
  dte_backend.tenants_projects
  JOIN dte_backend.projects ON projects.id = tenants_projects.project_id
WHERE
  tenant_id = ?

SELECT * FROM dte_backend.tenants_projects
    JOIN dte_backend.projects ON projects.id = tenants_projects.project_id
    WHERE tenant_id = 1000226;

SELECT COUNT(*) as messages_count, passed
        FROM dte_backend.messages
        JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
        WHERE tenants.id = :tenant_id
          AND project_id = :project_id
        GROUP BY passed

[
  "tenant_id" => 1000226
  "project_id" => 12
]

SELECT
  COUNT(*) as messages_count,
  passed
FROM
  dte_backend.messages
  JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
WHERE
  tenants.id = :tenant_id
  AND project_id = :project_id
GROUP BY
  passed

SELECT COUNT(*) as messages_count, passed
        FROM dte_backend.messages
        JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
        WHERE tenants.id = 1000226
          AND project_id = 12
        GROUP BY passed
        ;

SELECT COUNT(*) as testgroups_count
            FROM dte_backend.test_groups
            WHERE project_id = :project_id

[
  "project_id" => 12
]

SELECT
  COUNT(*) as testgroups_count
FROM
  dte_backend.test_groups
WHERE
  project_id = :project_id

SELECT COUNT(*) as testgroups_count
            FROM dte_backend.test_groups
            WHERE project_id = 12
        ;

SELECT MAX(messages.date) AS last_message_date
            FROM dte_backend.messages
            JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
            WHERE tenants.id = :tenant_id
            AND project_id = :project_id

[
  "tenant_id" => 1000226
  "project_id" => 12
]

SELECT
  MAX(messages.date) AS last_message_date
FROM
  dte_backend.messages
  JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
WHERE
  tenants.id = :tenant_id
  AND project_id = :project_id

SELECT MAX(messages.date) AS last_message_date
            FROM dte_backend.messages
            JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
            WHERE tenants.id = 1000226
            AND project_id = 12
        ;

SELECT COUNT(*) as messages_count, passed
        FROM dte_backend.messages
        JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
        WHERE tenants.id = :tenant_id
          AND project_id = :project_id
        GROUP BY passed

[
  "tenant_id" => 1000226
  "project_id" => 15
]

SELECT
  COUNT(*) as messages_count,
  passed
FROM
  dte_backend.messages
  JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
WHERE
  tenants.id = :tenant_id
  AND project_id = :project_id
GROUP BY
  passed

SELECT COUNT(*) as messages_count, passed
        FROM dte_backend.messages
        JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
        WHERE tenants.id = 1000226
          AND project_id = 15
        GROUP BY passed
        ;

SELECT COUNT(*) as testgroups_count
            FROM dte_backend.test_groups
            WHERE project_id = :project_id

[
  "project_id" => 15
]

SELECT
  COUNT(*) as testgroups_count
FROM
  dte_backend.test_groups
WHERE
  project_id = :project_id

SELECT COUNT(*) as testgroups_count
            FROM dte_backend.test_groups
            WHERE project_id = 15
        ;

SELECT MAX(messages.date) AS last_message_date
            FROM dte_backend.messages
            JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
            WHERE tenants.id = :tenant_id
            AND project_id = :project_id

[
  "tenant_id" => 1000226
  "project_id" => 15
]

SELECT
  MAX(messages.date) AS last_message_date
FROM
  dte_backend.messages
  JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
WHERE
  tenants.id = :tenant_id
  AND project_id = :project_id

SELECT MAX(messages.date) AS last_message_date
            FROM dte_backend.messages
            JOIN dte_backend.tenants ON tenants.id = messages.tenant_id
            WHERE tenants.id = 1000226
            AND project_id = 15
        ;