Query Metrics
3
Database Queries
3
Different statements
6.36 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.94 ms |
SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.created_at AS created_at_3, t0.school_class_id AS school_class_id_4 FROM school_class_client t0 WHERE t0.client_id = ? LIMIT 1
Parameters:
[
"sc-1974-client-P75VQ"
]
|
2 | 0.87 ms |
SELECT g0_.id AS id_0, g0_.start_at AS start_at_1, g0_.end_at AS end_at_2, g0_.pause_at AS pause_at_3, g0_.duration AS duration_4, g0_.created_at AS created_at_5, g0_.school_class_id AS school_class_id_6 FROM game_timer g0_ LEFT JOIN school_class s1_ ON g0_.school_class_id = s1_.id WHERE s1_.id = ? AND g0_.start_at <= ? AND ? <= g0_.end_at ORDER BY g0_.created_at DESC LIMIT 1
Parameters:
[ 1974 "2024-11-18 15:41:17" "2024-11-18 15:41:17" ] |
3 | 0.54 ms |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.category_letter AS category_letter_3, t0.is_active AS is_active_4 FROM game_category t0 WHERE t0.is_active = ? ORDER BY t0.id ASC
Parameters:
[
1
]
|
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\SchoolClassClient | No errors. |
App\Entity\SchoolClass | No errors. |
App\Entity\GameTimer | No errors. |
App\Entity\GameCategory | No errors. |