Query Metrics
6
Database Queries
6
Different statements
1.98 ms
Query time
0
Invalid entities
Queries
#▲ | 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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\AbstractBaseEntity | No errors. |
App\Entity\User | No errors. |
App\Entity\Tenant\AbstractTenantScopedEntity | No errors. |
App\Entity\ScreenUser | No errors. |
App\Entity\Tenant | No errors. |
App\Entity\Tenant\Screen | No errors. |
App\Entity\ScreenLayout | No errors. |
App\Entity\Tenant\ScreenCampaign | No errors. |
App\Entity\Tenant\PlaylistScreenRegion | No errors. |
App\Entity\Tenant\ScreenGroup | No errors. |
App\Entity\UserRoleTenant | No errors. |
App\Entity\ScreenLayoutRegions | No errors. |