GET https://os2display.koege.dk/v2/screens/01JJS2TMZWZM74XAZYS2QYTQT2

Query Metrics

6 Database Queries
6 Different statements
1.98 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.created_by AS created_by_5, t0.modified_by AS modified_by_6, t0.provider_id AS provider_id_7, t0.email AS email_8, t0.full_name AS full_name_9, t0.password AS password_10, t0.provider AS provider_11, t0.user_type AS user_type_12 FROM user t0 WHERE t0.provider_id = ? LIMIT 1
Parameters:
[
  "01JJS2TMZWZM74XAZYS2QYTQT2"
]
2 0.28 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.created_by AS created_by_5, t0.modified_by AS modified_by_6, t0.username AS username_7, t0.roles AS roles_8, t0.tenant_id AS tenant_id_9, t0.screen_id AS screen_id_10 FROM screen_user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "01JJS2TMZWZM74XAZYS2QYTQT2"
]
3 0.35 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.created_by AS created_by_5, t0.modified_by AS modified_by_6, t0.size AS size_7, t0.resolution AS resolution_8, t0.orientation AS orientation_9, t0.location AS location_10, t0.enable_color_scheme_change AS enable_color_scheme_change_11, t0.title AS title_12, t0.description AS description_13, t0.changed AS changed_14, t0.relations_checksum AS relations_checksum_15, t0.tenant_id AS tenant_id_16, t0.screen_layout_id AS screen_layout_id_17, t18.id AS id_19, t18.version AS version_20, t18.created_at AS created_at_21, t18.modified_at AS modified_at_22, t18.created_by AS created_by_23, t18.modified_by AS modified_by_24, t18.username AS username_25, t18.roles AS roles_26, t18.tenant_id AS tenant_id_27, t18.screen_id AS screen_id_28 FROM screen t0 LEFT JOIN screen_user t18 ON t18.screen_id = t0.id WHERE t0.id = ?
Parameters:
[
  b"\x01”²-Süý\x0EN«þȯí_B"
]
4 0.28 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.created_by AS created_by_5, t0.modified_by AS modified_by_6, t0.tenant_key AS tenant_key_7, t0.fallback_image_url AS fallback_image_url_8, t0.title AS title_9, t0.description AS description_10 FROM tenant t0 WHERE t0.id = ?
Parameters:
[
  b"\x01”’ë{(u^È„¥FÝ‹\x04\n"
]
5 0.33 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.created_by AS created_by_5, t0.modified_by AS modified_by_6, t0.grid_rows AS grid_rows_7, t0.grid_columns AS grid_columns_8, t0.title AS title_9, t0.description AS description_10, t0.changed AS changed_11, t0.relations_checksum AS relations_checksum_12 FROM screen_layout t0 WHERE t0.id = ?
Parameters:
[
  b"\x01}=E,.¿®@]Àaüjís"
]
6 0.36 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.created_by AS created_by_5, t0.modified_by AS modified_by_6, t0.title AS title_7, t0.grid_area AS grid_area_8, t0.type AS type_9, t0.changed AS changed_10, t0.relations_checksum AS relations_checksum_11, t0.screen_layout_id AS screen_layout_id_12 FROM screen_layout_regions t0 WHERE t0.screen_layout_id = ?
Parameters:
[
  b"\x01}=E,.¿®@]Àaüjís"
]

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.