https://dev.app-talaria.eu/

Query Metrics

9 Database Queries
9 Different statements
3.11 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.77 ms
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:
[]
2 0.41 ms
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
]
3 0.32 ms
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:
[]
4 0.34 ms
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
]
5 0.30 ms
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
]
6 0.32 ms
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
]
7 0.27 ms
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
]
8 0.21 ms
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:
[]
9 0.18 ms
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.