GET https://pagodevia.adrien-pago-portfolio.fr/report

Query Metrics

7 Database Queries
7 Different statements
1.76 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.95 ms
(53.86%)
1
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.generated_prompt AS generated_prompt_4, t0_.git_branch AS git_branch_5, t0_.last_commit_sha AS last_commit_sha_6, t0_.last_checked_at AS last_checked_at_7, t0_.created_at AS created_at_8, p1_.id AS id_9, p1_.name AS name_10, p1_.description AS description_11, p1_.github_repo_url AS github_repo_url_12, p1_.status AS status_13, p1_.created_at AS created_at_14, a2_.id AS id_15, a2_.name AS name_16, a2_.role AS role_17, a2_.system_prompt AS system_prompt_18, a2_.execution_mode AS execution_mode_19, a2_.created_at AS created_at_20, t0_.project_id AS project_id_21, t0_.agent_id AS agent_id_22 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id WHERE t0_.status = ? ORDER BY t0_.last_checked_at DESC, t0_.created_at DESC
Parameters:
[
  "to_validate"
]
0.24 ms
(13.54%)
1
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.generated_prompt AS generated_prompt_4, t0_.git_branch AS git_branch_5, t0_.last_commit_sha AS last_commit_sha_6, t0_.last_checked_at AS last_checked_at_7, t0_.created_at AS created_at_8, p1_.id AS id_9, p1_.name AS name_10, p1_.description AS description_11, p1_.github_repo_url AS github_repo_url_12, p1_.status AS status_13, p1_.created_at AS created_at_14, a2_.id AS id_15, a2_.name AS name_16, a2_.role AS role_17, a2_.system_prompt AS system_prompt_18, a2_.execution_mode AS execution_mode_19, a2_.created_at AS created_at_20, t0_.project_id AS project_id_21, t0_.agent_id AS agent_id_22 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id ORDER BY t0_.last_checked_at DESC, t0_.created_at DESC LIMIT 10
Parameters:
[]
0.15 ms
(8.78%)
1
SELECT COUNT(p0_.id) AS sclr_0 FROM project p0_ WHERE p0_.status = ?
Parameters:
[
  "active"
]
0.14 ms
(8.16%)
1
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.generated_prompt AS generated_prompt_4, t0_.git_branch AS git_branch_5, t0_.last_commit_sha AS last_commit_sha_6, t0_.last_checked_at AS last_checked_at_7, t0_.created_at AS created_at_8, p1_.id AS id_9, p1_.name AS name_10, p1_.description AS description_11, p1_.github_repo_url AS github_repo_url_12, p1_.status AS status_13, p1_.created_at AS created_at_14, a2_.id AS id_15, a2_.name AS name_16, a2_.role AS role_17, a2_.system_prompt AS system_prompt_18, a2_.execution_mode AS execution_mode_19, a2_.created_at AS created_at_20, t0_.project_id AS project_id_21, t0_.agent_id AS agent_id_22 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id WHERE t0_.status = ? ORDER BY t0_.created_at DESC
Parameters:
[
  "todo"
]
0.11 ms
(6.07%)
1
SELECT t0_.status AS status_0, COUNT(t0_.id) AS sclr_1 FROM task t0_ GROUP BY t0_.status
Parameters:
[]
0.09 ms
(4.82%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.github_repo_url AS github_repo_url_3, p0_.status AS status_4, p0_.created_at AS created_at_5 FROM project p0_ WHERE p0_.status = ? ORDER BY p0_.created_at DESC
Parameters:
[
  "active"
]
0.08 ms
(4.76%)
1
SELECT t0_.project_id AS sclr_0, t0_.status AS status_1, COUNT(t0_.id) AS sclr_2 FROM task t0_ INNER JOIN project p1_ ON t0_.project_id = p1_.id WHERE p1_.status = ? GROUP BY t0_.project_id, t0_.status
Parameters:
[
  "active"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Project 2
App\Entity\Task 1
App\Entity\Agent 1

Entities Mapping

Class Mapping errors
App\Entity\Task No errors.
App\Entity\Project No errors.
App\Entity\Agent No errors.