POST https://maus.rathgeb.at/ajax/loading/request

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 0.07 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:
[
  38
]
2 0.12 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:
[
  38
]
3 32.58 ms
SELECT lr.* FROM loading_request lr WHERE lr.mouse_id = ? AND lr.state = 10 AND (lr.processed_timestamp IS NULL OR TIMESTAMPDIFF(SECOND, processed_timestamp, CURRENT_TIMESTAMP) > 120) ORDER BY timestamp ASC LIMIT 1
Parameters:
[
  2
]

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\LoadingRequest No errors.
App\Entity\Driver No errors.
App\Entity\Mouse No errors.
App\Entity\Farmer No errors.
App\Entity\Field No errors.
App\Entity\Target No errors.