POST https://maus.rathgeb.at/ajax/chat/load

Query Metrics

3 Database Queries
3 Different statements
0.33 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.08 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.full_name AS full_name_4, t0.password AS password_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
  58
]
2 0.14 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.mouse_id AS mouse_id_3 FROM mouse_to_user t0 WHERE t0.user_id = ?
Parameters:
[
  58
]
3 0.10 ms
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.subject AS subject_2, m0_.message AS message_3, m0_.sender_sign AS sender_sign_4, m0_.type AS type_5, m0_.timestamp AS timestamp_6, m0_.message_read AS message_read_7, m0_.mouse_id AS mouse_id_8 FROM message m0_ WHERE m0_.mouse_id IN (?) AND (((m0_.message_read = 0) OR (m0_.message_read IS NULL))) AND (((m0_.type = ?) OR (m0_.type = ?))) ORDER BY m0_.timestamp ASC
Parameters:
[
  25
  "TTM"
  "ATM"
]

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\User 1
App\Entity\MouseToUser 1
App\Entity\Mouse 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\MouseToUser No errors.
App\Entity\StationToUser No errors.
App\Entity\Loading No errors.
App\Entity\Message No errors.
App\Entity\Mouse No errors.