GET https://www.masterdesk.ch/document/download/full/11606

Query Metrics

6 Database Queries
6 Different statements
1.81 ms Query time
0 Invalid entities
129 Managed entities

Queries

Group similar statements

# Time Info
1 0.37 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.otp_secret AS otp_secret_6, t0.primary_realm_id AS primary_realm_id_7 FROM fos_user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.27 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.display_name AS display_name_4, t0.document_date AS document_date_5, t0.status AS status_6, t0.attributes AS attributes_7, t0.realm_id AS realm_id_8 FROM document t0 WHERE t0.id = ?
Parameters:
[
  "11606"
]
3 0.33 ms
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.page_number AS page_number_3, t0.document_id AS document_id_4, t0.page_id AS page_id_5 FROM document_page t0 WHERE t0.document_id = ?
Parameters:
[
  11606
]
4 0.24 ms
SELECT t0.id AS id_1, t0.page_number AS page_number_2, t0.text AS text_3, t0.width AS width_4, t0.height AS height_5, t0.file_id AS file_id_6 FROM page t0 WHERE t0.id = ?
Parameters:
[
  108432
]
5 0.34 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.color AS color_5, t0.icon AS icon_6, t0.icon_color AS icon_color_7, t0.parent_id AS parent_id_8, t0.realm_id AS realm_id_9 FROM tag t0 INNER JOIN document_tag ON t0.id = document_tag.tag_id WHERE document_tag.document_id = ?
Parameters:
[
  11606
]
6 0.25 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.original_filename AS original_filename_4, t0.name AS name_5, t0.filetype AS filetype_6, t0.batch AS batch_7, t0.box AS box_8, t0.hash AS hash_9, t0.filesize AS filesize_10, t0.file_path AS file_path_11, t0.status AS status_12, t0.realm_id AS realm_id_13 FROM file t0 WHERE t0.id = ?
Parameters:
[
  11612
]

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\DocumentPage 62
App\Entity\Page 62
App\Entity\User 1
App\Entity\Document 1
App\Entity\Realm 1
App\Entity\File 1
App\Entity\Tag 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Realm No errors.
App\Entity\BaseEntity No errors.
App\Entity\Document No errors.
App\Entity\Tag No errors.
App\Entity\DocumentPage No errors.
App\Entity\ExtraInformation No errors.
App\Entity\Page No errors.
App\Entity\File No errors.