Query Metrics
9
Database Queries
9
Different statements
3.15 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.65 ms (20.70%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.active AS active_2, p0_.drive_url AS drive_url_3, p0_.token AS token_4, p0_.client_id AS client_id_5, p0_.favorite_org_tag_id AS favorite_org_tag_id_6, p0_.favorite_type_tag_id AS favorite_type_tag_id_7 FROM project p0_ WHERE p0_.active = 1
Parameters:
[] |
|
0.43 ms (13.51%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.created_at AS created_at_6, u0_.archived AS archived_7 FROM user u0_ WHERE u0_.archived = ?
Parameters:
[
0
]
|
|
0.35 ms (11.04%) |
1 |
SELECT t0_.name AS name_0, t0_.date AS date_1, p1_.name AS name_2, t0_.id AS id_3 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id WHERE t0_.date = ? AND t0_.finished = 0 AND t0_.user_affected_id = ?
Parameters:
[ "2026-08-18" null ] |
|
0.34 ms (10.94%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.color AS color_4 FROM client t0
Parameters:
[] |
|
0.34 ms (10.94%) |
1 |
SELECT t0_.name AS name_0, t0_.date AS date_1, p1_.name AS name_2, t0_.id AS id_3 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id WHERE (t0_.date = ? OR t0_.date = ? OR t0_.date = ?) AND t0_.finished = 0 AND t0_.user_affected_id = ?
Parameters:
[ "2026-08-19" "2026-08-20" "2026-08-21" null ] |
|
0.29 ms (9.29%) |
1 |
SELECT t0_.name AS name_0, t0_.date AS date_1, p1_.name AS name_2 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id WHERE t0_.user_affected_id = ?
Parameters:
[
null
]
|
|
0.28 ms (9.03%) |
1 |
SELECT t0_.name AS name_0, t0_.date AS date_1, p1_.name AS name_2, t0_.id AS id_3 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id WHERE t0_.date < ? AND t0_.finished = 0 AND t0_.user_affected_id = ?
Parameters:
[ "2026-08-18" null ] |
|
0.23 ms (7.39%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.color AS color_4 FROM tag_org t0
Parameters:
[] |
|
0.23 ms (7.17%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.color AS color_4 FROM tag_type t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| oikonomos | doctrine.dbal.oikonomos_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Project | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\TagOrg | No errors. |
| App\Entity\TagType | No errors. |
| App\Entity\Time | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Absence | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\ClosureClient | No errors. |
| App\Entity\Task | No errors. |