GET https://local-cite.eryon.eu/fr-fr/project

Query Metrics

13 Database Queries
6 Different statements
4.87 ms Query time
0 Invalid entities
58 Managed entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_auth_code AS email_auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile_phone AS mobile_phone_9, t0.totp_secret AS totp_secret_10, t0.status AS status_11, t0.reference AS reference_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.81 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.reference AS reference_5, p0_.customer_reference AS customer_reference_6, p0_.parsing_success_rate AS parsing_success_rate_7, p0_.parsed_documents_count AS parsed_documents_count_8, p0_.created_by_id AS created_by_id_9, p0_.domain_id AS domain_id_10, p0_.type_id AS type_id_11, p0_.pathology_id AS pathology_id_12 FROM project p0_ WHERE p0_.status <> ? ORDER BY p0_.created_at DESC
Parameters:
[
  "finished"
]
3 0.65 ms
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = ? ORDER BY n0_.created_at DESC LIMIT 2
Parameters:
[
  1
]
4 0.36 ms
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = ? AND n0_.status = ? ORDER BY n0_.created_at DESC
Parameters:
[
  1
  "unread"
]
5 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
Parameters:
[
  7
]
7 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = ?
Parameters:
[
  5
]
8 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
9 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = ?
Parameters:
[
  8
]
10 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
Parameters:
[
  2
]
11 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
Parameters:
[
  3
]
12 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
Parameters:
[
  4
]
13 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
Parameters:
[
  5
]

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\Document 24
App\Entity\Notification 19
App\Entity\Project 6
App\Entity\User 3
App\Entity\ProjectType 3
App\Entity\Pathology 2
App\Entity\DocumentCategory 1