https://design.berufsreise-dev.at/graphql/

Query Metrics

3 Database Queries
3 Different statements
6.36 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.94 ms
(77.76%)
1
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"
]
0.87 ms
(13.77%)
1
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"
]
0.54 ms
(8.48%)
1
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.