GET https://dev.talm.bio/tar/1

Query Metrics

13 Database Queries
6 Different statements
41.12 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 7.71 ms
SELECT t0.id AS id_1, t0.min_received_date AS min_received_date_2, t0.tar_status_id AS tar_status_id_3 FROM tar t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 3.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tar_status t0 WHERE t0.id = ?
Parameters:
[
  21
]
3 3.94 ms
SELECT t0.id AS id_1, t0.date_assigned AS date_assigned_2, t0.person_id AS person_id_3, t0.tar_id AS tar_id_4, t0.tar_role_id AS tar_role_id_5, t0.author_id AS author_id_6 FROM tar_role_assignment t0 WHERE t0.tar_id = ?
Parameters:
[
  1
]
4 3.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.phone AS phone_5, t0.date_created AS date_created_6, t0.company_id AS company_id_7, t0.invited_by_id AS invited_by_id_8 FROM person t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 2.94 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tar_role t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 2.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.phone AS phone_5, t0.date_created AS date_created_6, t0.company_id AS company_id_7, t0.invited_by_id AS invited_by_id_8 FROM person t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 2.51 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tar_role t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 2.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.phone AS phone_5, t0.date_created AS date_created_6, t0.company_id AS company_id_7, t0.invited_by_id AS invited_by_id_8 FROM person t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 2.08 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tar_role t0 WHERE t0.id = ?
Parameters:
[
  3
]
10 3.47 ms
SELECT t0.id AS id_1, t0.date_added AS date_added_2, t0.comment AS comment_3, t0.tar_id AS tar_id_4, t0.tar_status_id AS tar_status_id_5, t0.author_id AS author_id_6, t0.file_collection_id AS file_collection_id_7 FROM tar_status_history t0 WHERE t0.tar_id = ?
Parameters:
[
  1
]
11 2.13 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tar_status t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 2.17 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tar_status t0 WHERE t0.id = ?
Parameters:
[
  11
]
13 2.08 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tar_status t0 WHERE t0.id = ?
Parameters:
[
  22
]

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\TarStatusHistory 5
App\Entity\TarStatus 4
App\Entity\TarRoleAssignment 3
App\Entity\Person 3
App\Entity\TarRole 3
App\Entity\Tar 1
App\Entity\Company 1